Open Forum

  • 1.  Historic Inventory

    Posted Oct 19, 2021 03:22 PM
    Is there a way besides pulling inventory valuations to find historic inventory levels? For example, if I wanted to see how many units we had on 07/04/2020.

    ------------------------------
    Oliver Etherington
    Technivorm Moccamaster USA
    Portland OR
    ------------------------------


  • 2.  RE: Historic Inventory

    TOP CONTRIBUTOR
    Posted Oct 20, 2021 07:43 AM
    Depending on your version of NAV or BC, you can open the Item List, show the Quantity On Hand (alternately you can see this in the Item Card), and set a Limit Totals or Filter Totals by for date period you want (e.g. ..070420). This will use the Item Ledger Entries and provide you with the total on that date.

    ------------------------------
    Andrew Good
    President
    Liberty Grove Software
    Oakbrook Terrace IL
    ------------------------------



  • 3.  RE: Historic Inventory

    Posted Oct 21, 2021 08:50 AM
    Hi Oliver,
    The Inventory Valuation report will give you this information as will many other inventory related reports. Is there something you think is incorrect on that report related to this information?

    ------------------------------
    Crystal Tollison
    Innovia Consulting
    Onalaska WI
    ------------------------------



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