Colan,
I think a better start to calculating the average days on hand would be to start with the following SQL script by Mahmoud. You can find the SQL script here.
https://community.dynamics.com/gp/b/dynamicsgpessentials/archive/2018/05/13/historical-inventory-aging-report-finally. This SQL script will give you all of your open cost layer with the days on hand for each layer. You could easily put this data into a pivot table to average the days by inventory item. One gotcha with the SQL script, it only provides the most recent receipt date of the inventory item so if you have a lot of inventory item movements between sites then the calculation of total days on hand won't be accurate.
------------------------------
Barry Crowell
Senior Business Consultant
KTL Solutions, Inc
Frederick MD
------------------------------
Original Message:
Sent: 11-30-2018 02:58 PM
From: Colan Witt
Subject: Average Days in Inventory
Is there a report in GP2013 that will give me average days in inventory by item? It would also be nice to know how long we have carried an item.
------------------------------
Colan Witt
Accounting Manager
Pheasants Forever, Inc.
St. Paul MN
------------------------------