Calculation of Inventory Turns

Posts: 1
Joined: Tue Apr 07, 2015 11:06 am

Calculation of Inventory Turns

Postby seanct » Wed Apr 08, 2015 1:25 pm

How is inventory turns calculated in the inventory cube? Some items show inventory turns in the trillions. Just looking to get an idea of how accurate this information might be.


Posts: 63
Joined: Fri Dec 05, 2014 7:59 am

Re: Calculation of Inventory Turns

Postby JasonT » Mon Apr 13, 2015 11:36 am

Hi Sean.

Inventory turnovers are normally calculated by either Sales/Inventory or COGS/Average Inventory. You mention the term Inventory Cube which makes me think you are referring to the Jet Data Manager which uses the latter formula "COGS 365 Days"/"Average Value" in the standard cube. If your returned value looks incorrect then I would start by checking those two measures to see if they are correct. You may also have a customized data cube so you may want to check the formulas in your measures of that cube.

If you are still stuck, try posting this to the Enterprise section of the community site to see if you can get more Enterprise users feedback.


Return to “Data Views for MS Dynamics NAV”

Who is online

Users browsing this forum: No registered users and 1 guest