Hello, I am trying to get an accurate inventory turns report out of our
AX3.0 install. I am developing this report outside of AX using SRSS and
am having issues building the report.
If i run a query against the inventsum table without specifying a date,
my inventory quantities match with the system. If i try to filter by
date I get in consistent results.
I've looked at the InventGroupPhys report in the AOT and see the
calculations they're using to arrive at the quantities however I dont
see how they're specifying a historical date.
Could someone tell me which date field to filter by and in which table?
Thanks, Bill
