Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!