How Is it Possible to achieve Current Inventory and As On Date Inventory in WMS WebReports Gen2
Summary:
I want to develop a report, Where I could show Current Inventory, and As on Date Inventory. Like If i run report Today and want to check inventory status 15days back, then it must show me Current Inventory status (qty of an item) and How much it was at 15days back.
Content (please ensure you mask any confidential information):
Example:
Today is 30-11-2024 and Total Current qty for an item let say X is 100, and it was 50 at (20-11-2024), Customer needs report which show both, How much he currently have and how much it was in back dates. Although I've figured out Total In and Out qty in back dates from Inventory history. But In that case I'm lacking to get Current qty till current date.Because Whenever we run report for As on Date ( which is Inventory History create ts to get Total In bound and Out Bound from Inventort), how we will get Total Current