Open Forum

Expand all | Collapse all

Average Days in Inventory

  • 1.  Average Days in Inventory

    Posted Nov 30, 2018 02:59 PM
    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
    ------------------------------


  • 2.  RE: Average Days in Inventory

    Posted Dec 05, 2018 03:18 PM
    Edited by Sandeep C Dec 05, 2018 03:19 PM
    Hi @Colan Witt

    Not sure if GP has anything built-in, but you could probably run something base on the SQL you may wanna check (SQL Script). You can modify the script to Calculate Avg Days.




    ------------------------------
    Sandeep C
    SQL DBA
    Chase Petroleum Services
    Artesia NM
    ------------------------------



  • 3.  RE: Average Days in Inventory

    GOLD CONTRIBUTOR
    Posted Dec 05, 2018 08:59 PM
    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
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role