Open Forum

Expand all | Collapse all

Inventory turnover

Jump to Best Answer
  • 1.  Inventory turnover

    Posted Nov 29, 2018 11:32 AM
    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 Nov 30, 2018 11:25 AM
    Edited by Beat Bucher Dec 03, 2018 09:27 AM
    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)
    ------------------------------



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