Checked the concern raised by John regarding the discrepancy with regarding on_hand and oh_cost versus JDA and IAS.
Asked assistance from Jovie for the script of the two reports generated by John, as per checking the two reports only get the data on the same table. Tried to generate the Inventory report and query the Lacoste idept in JDA to validate if there are discrepancies, as per checking there is no discrepancy in the report. Emailed John asking when he generated the reports. John emailed back that this is now as they already fix the floating inventory in JDA with the help of Ms. Arlene.