Announcements
No record found.
Hello. Can anyone help me with a SQL select to get a qty on hand on a particular date. Thanks.
*This post is locked for comments
Hi,
The standard reports in AX are using the table InventSum which contains an actual physical on-hand. For a date calculation the Inventory transactions between reporting date and current date are used to define a delta that should be considered.
There would be an option to summarize the InventTrans table, but this table might have a huge amount of records. Performance wise this might be not the best solution. For that reason, standard AX reports are using the first described option.
You can do this using the standard Inventory Value report or the Inventory Value cube. Have you looked at those?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
