INVENTORY cONTROL

Enhanced inventory reporting insights

Inventory reports are excellent investigation tools, designed to provide you with insights into your stock levels and verify on-hand quantities.

The Inventory valuation report calculates the value and quantity of specific items in stock, and helps you monitor the cost of goods sold (COGS). When reviewing your report data, it's important to know that costs can change over time when there are differences in inventory purchase and sales prices. These differences display as variations between the summary and detail reporting areas on your valuation report. We've made a few improvements to help you analyze these differences.

What's changed

There are two standard sections on the Inventory valuation report, summary and detail. If summary and detail totals do not align, you may want to investigate. To help identify valuation fluctuations in a transaction period, you can customize the report to automatically calculate the total transaction value for a specific period.

Go to Inventory ControlAllValuation, and enable, Show transaction totals. With this option selected, the detail section of the report includes a Transaction totals line, to help you identify transactions where a valuation change might have occurred.

Inventory Valuation report displays additional totals for details area

To investigate any discrepancies, download a Running average cost report. This Inventory utilities report tracks variations in the cost of goods over a specific period of time (Inventory ControlSetupInventory utilitiesGL subledger reconciliation).

Permissions and other requirements

Subscription

Inventory Control

Regional availability
  • Australia

  • Canada

  • South Africa

  • United States

  • United Kingdom

User type

Business

Employee

Warehouse

Permissions

Inventory valuation: Run