I try to generate the other reports to check if they will have the same onhand quantity as what I generated in the Sell-Thru. As per checking, they don't have the same onhand quantity, but what I did get in the other report is the same on hand in JDA.
I raised this to Jovie and give me the table where to query the Sell-Thru "gnTempSellThruInvBal", I query the token assigned for the said brand and got the same figures in the report. Jovie also said that the script might be different in Per Location Inventory by SKU versus the Sell-Thru report. I Will generate a new report and email it to Ms. Arlene to verify if the figure in the report are correct.