Coming soon to ST-80 release.
Overview
The Inventory Valuation Snapshot report template provides accounting and operations teams with a historical view of their inventory value as of a specific date. The report’s cost columns remain fixed to the selected date, ensuring that the same total is returned whenever the report is run for that date. This supports accurate and consistent inventory valuation for month-end close.
Who uses this feature
Purchasing managers
Applies to all business types
Feature configuration
Account configuration is required to use this feature: the Purchasing and Inventory modules must both be enabled for the account. Please contact Technical Support for details.
Things to know
The existing Aggregate Inventory Stock report is unaffected by this release — its cost columns still always reflect current pricebook cost. Use Inventory Valuation Snapshot instead when you need a valuation that won't drift for a closed period.
There's no backfill: for a date before this feature shipped, or for an item that didn't exist yet on that date, the report falls back to showing current cost.
In this first version, only the cost and valuation columns are frozen as of your selected date. Descriptive item fields like Item Code and Description still show their current values even when you're viewing an older date.
Best practices
Run this report as part of your month-end close, and reconcile its total against the Inventory Asset account in your accounting system.
Rerun the report for the same past date at any point after — the total should stay the same. That consistency is the point of the report, and a good way to confirm a closed period hasn't drifted.
If you track serialized inventory, cross-check those items against current records rather than relying on this report's date filter for them — see the note above.
Use cases
A controller closes December's books, runs this report for 12/31, and files the result. In February, an auditor asks for the same figure — rerunning the report for 12/31 returns the same total, even though pricebook costs have since changed.
An operations team reconciles the Inventory Asset account on the balance sheet at each month-end close, using this report as the source of the inventory valuation figure.
Run the Inventory Valuation Snapshot report
Go to the navigation bar, click Reports then select All Reports.
On the All Reports screen, scroll down to the Inventory section and select Inventory Valuation Snapshot.
Use the Date field and the Inventory Location dropdown to create filters for your report. Setting As-of Date filter is required.
You can customize which columns you want to include. Click Edit Report to include or remove additional columns in the report and click Apply.
Click Run Report.
Review the results, which include Item Unit Cost, Total Item Cost, Quantity On Hand, Cost Method, and Snapshot Date — all as of the date you selected.
Filter and arrange the Inventory Valuation Snapshot report
You can customize how your report displays and add column filters to narrow down your results:
Interact with column headers to change how the report displays:
Drag a column header to change its order in the report.
Drag a column header and drop it on the bar above the report to group your results by that column. For example, if you drag the Item Type header, the results group by the items type.
Filter a column by clicking Filter
next to the column name.In the filter menu, use the dropdowns and fields to set how you want to filter the column. For example, if you only want to see only the items that have more that 3 items available in the inventory locations, add filter to the Quanitity Availble column. Select Is greater than and enter '3' in the next field.
Click Filter.
The table automatically updates, and the filter icon highlights to show that a filter was applied. To learn more, see Run, filter, and export reports.
To keep your filters and other settings for the next time you run the report, click Save Changes.
