Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

Inventory turnover

Jump to Best Answer
  • 1.  Inventory turnover

    Posted 12 days ago
    How to Calculate inventory turn over in GP? Is there any SQL Script for it?

    ------------------------------
    Thanks.
    Sandeep
    ------------------------------


  • 2.  RE: Inventory turnover
    Best Answer

    GPUG ALL STAR
    Posted 11 days ago
    Edited by Beat Bucher 8 days ago
    Hi @Sandeep C
    Not sure if GP has anything built-in, but you could probably run something base on the existing SQL Views that are provided out-of-the-box :
    [InventorySalesSummaryPeriod_History]
    [InventoryTransactions]
    ​​
    And use them in PowerBI to draw a nice dashboard..
    @Victoria Yudin does also have a few custom SQL views around Inventory you may wanna check..

    PS: turns out GP has a built-in Inventory Turnover report :  Inventory >> Reports >> Analysis >> New or Modify button

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    ------------------------------