- generate the report in sales and inventory report for Superga and Lush, check the data in the generated report, create a script to extract the data and compare the data between MySQL and JDA for checking if the data is tally, as per checking. 
- the data is not tally, create a script a script that will extract the data in JDA per date and compare the data in extracted data in MySQL per date to find in what date the variance is.
- copied all the data in excel for Jimmy and team checking of the findings.
- generate the report for transfer in/out summary report and transfer in/out per SKU report for checking of the output in the report and compare the data in JDA
- as per checking, no report generated in Pentaho
- check the stored procedure of the report and check script used for each report for checking of the cause of the no data retrieve,