A question on best practice for calculating Inventory Turns and GMROI (per Item, not class/location/account). - For both of these metrics, it's necessary to calculate the average inventory on hand over a period ( stocking units or $). I cannot find a record or ODBC view that will show me units on hand by date. Is that not something that Netsuite stores?

Let me know if you turn anything up. We are trying to do the same, but put it on the back burner because of some of these same issues.

@Noel B I checked a few of my usual "solution" places, haven't found anything. I'm thinking I'll end up going the custom route: Daily Inventory Snapshot record, stratify results by subsidiary, location, item; Custom MR Script to create the records; Debating going a custom portlet route to handle the reporting, or another custom record / MR script to handle the Turns/GMROI calculation and storing the results. Opinions?

I'm more in a Data Analysis role than a NetSuite Dev/Admin. So I am not even thinking on the side of making this an available custom field in NetSuite. Just wanted to see other ideas that I might be able to bring to the table. There is an Inventory Turns report native to NetSuite, so that might be a good starting point as they have a column for average inventory.

Netsuite doesn't store inventory data per sku per day. I believe your only option is to move the data daily into an external data store and run your reports from that.

Yeah, that is what we are doing. The downside is that we weren't pulling the average cost as well, just quantity numbers. We are looking for a way to back-fill all that daily history.