Microsoft Dynamics AX (Archived)

Does AX 2012 calculate inventory turnover, days on hand

(0) Share

Report

Posted on by Community Member

Does AX 2012 calculate inventory turnover, days on hand

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (0)

Report

HI CEI,

Can you please elaborate on your question? The information provided is not enough to understand your requirement.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi CEI,

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,

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

DAX_ajsqd2 269 on at

Like (0)

Report

Hi CEI,

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.

Was this reply helpful? Yes No