Inventory Quantity and Value for a given date

The Inventory tab on the Product Information window includes a current snapshot of the inventory quantities and value.  The On Hand quantity includes all posted transactions, but does not allow for displaying the inventory “as of” a given date.

5-27-2016 12-52-55 PM

The Inventory Valuation report can be back-dated to include the On Hand quantity, Avg Cost and Value for any given date.

  1. Select Inventory Reports from the Inventory main menu
    5-27-2016 12-55-18 PM
  2. The Inventory Valuation report is located in the Warehouse folder
    5-27-2016 12-56-16 PM
  3. Adjust the As Of Date and click Preview to view the results
    5-27-2016 12-57-12 PM
  4. Review the On Hand, Avg Cost and Value from the back-dated Inventory Valuation report.
    5-27-2016 12-58-08 PM
Posted in Inventory - Last modified on May 27, 2016Eva Rhees
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.