- check the generated report, as per checking the all the on hand has 0 value which some should have an on hand. - modified the sell thru script and add SKU field for checking of the SKU, also check the data in JDA to get sample SKU that has an on-hand (4650408)
- check the SKU in SQL to see if the data is the same with JDA, as per checking the data is tally with JDA.
- check the script to check if why there is no on-hand extracted
- modify the script for adding the extraction of data in invbal to extract the data.
- generate the reports for checking if the modifications applied