- generate the report for transfer in/out summary report and transfer in/out per SKU report for Superga and Lush 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,
- check is the table for transfer has a data, check the script for transfer in summary report
- compare the data in MySQL with JDA if tally, as per checking data is not tally
- check if where is the variance
- Check the data in MySQL for PO and compare it in JDA for the sales and inventory report.
- as per checking, the data for Superga and Lush is not tally with JDA, check if what is the cause of the variance and plot it into excel.