Announcements
No record found.
Hi,
Is there a monthly report usage per month as we currently use the inventory transaction and do pivot table to find this information.
Thanks,
Ray
*This post is locked for comments
Hello Ray,
What do you mean by "usage per month"? Is it the inventory turnover, average duration that items are located in a certain warehouse, total issue costs, etc.?
Ludwig
We use this type of info to see how many we have used per month in order to set our minimum on hands as well as re-order quantities. E.G. 20 used per month we will maintain 2 months worth (40) and re-order 1 months worth (20).
You can try whether the inventory aging Report give you that Information? (Inventory-Reports-Status-Physical inventory - inventory aging). Other than that I can only think of the inventory value cube that might give you this Information.
Hope this helps,
Hi Ludwig,
We use those two reports but the question is how can we get the inventory cube, can you send me the details on that.
Probably check the following site for some additional Details
technet.microsoft.com/.../jj710385.aspx
Best regards,
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
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
