Finding warehouse quantity and value for a given date.

The product window's Inventory tab includes current information. The Inventory Valuation report can show post data based on a specified As Of 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