Announcements
No record found.
Does AX 2012 calculate inventory turnover, days on hand
*This post is locked for comments
HI CEI,
Can you please elaborate on your question? The information provided is not enough to understand your requirement.
Sure. Is there a report in AX that enables us to calculate inventory turn over from data in AX: Cost of goods sold/average inventory
Days on Hand: 365 or 360/inventory turnover.
These are KPI's that we use today.
Hi CEI,
There is no out of the box report for this. It can be customized. Then you can create graphs or reports based on available data.
as André said, you can create graphical Report with data. please try to create a report.
If you want to how to create such type of report please let us know.
Thanks,
Hello CEI,
If you are making use of the AX2012 cubes, then the inventory value cube might help. Please see here for the cube reference. technet.microsoft.com/.../jj710385.aspx
Other than that you try using Management Reporter to calculate those ratios based on pure financial data or create something yourself as Andre suggested.
Best regards,
Ludwig
Our end users had the same question, we used the form under Inventory management > Inquiries > Transactions > Transactions. Personalize to add the Physical date and Transaction type (i.e. PO, SO, Inventory journal, etc). We exported this to excel and you can run pivots off of it by item, model group, etc. Keep in mind it takes some transactions you might want to exclude like quarantine or movement journals if you only want to see strictly purchase and consumption.
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.
Joris dG 5
Andrew Jones a1x 2
GL-01081504-0 1
