Inventory Valuation Report

The Inventory Valuation Report (FrmInventoryValuationReport) shows the total value of your inventory at both cost and price across all locations. It is designed for financial reporting, insurance documentation, and end-of-period valuations. The report automatically excludes Service items (item type is not 1) and Virtual Kits (package type is not 1) so that only physically stocked items appear.

Accessing the Report

Navigate to Reports > Inventory Valuation from the main menu. This report requires either Management access or Accounting access (HasManagementAccess or HasAccountingAccess). Users without one of these permissions will not see the menu option.

Filters and Controls

The top of the report provides the following filters and buttons:

Detailed Report Mode

The Detailed mode is the default view. It displays one row per item per location with full breakdown information.

Grid Columns

Row Color-Coding

Rows are color-coded to highlight issues that may require attention:

These visual indicators make it easy to spot audit issues at a glance without reading every row.

Totals Panel

A fixed totals panel is displayed at the bottom of the report. This panel shows four aggregate values:

• Item Count -- Total number of distinct items in the report
• Total Quantity -- Sum of all stock quantities
• Total Cost -- Sum of all Total Cost values (quantity times cost)
• Total Price -- Sum of all Total Price values (quantity times price)

The totals are loaded first using a fast aggregate query so they appear immediately, even before all detail rows have loaded.

Virtual Scroll and Lazy Loading

For large inventories, the report uses virtual scrolling to load data in pages rather than all at once:

• Page Size: 100 rows per page (PAGE_SIZE = 100)
• VirtualMode: The grid operates in VirtualMode = true for efficient rendering
• Scroll Detection: The VirtualScrollManager detects when the user scrolls within 10 rows of the bottom of the currently loaded data
• Debounce: A 300ms debounce timer prevents rapid-fire page requests during fast scrolling
• Concurrency Protection: A SemaphoreSlim prevents multiple pages from loading simultaneously
• Progress Label: A label shows "X of Y Items" so you always know how much of the report has loaded

As you scroll down, additional pages load automatically in the background. The totals panel always shows the complete aggregate values regardless of how many rows have been loaded into the grid.

Summary Report Mode

Switching to Summary mode displays a single aggregated row instead of individual item rows:

• The row has a LightSteelBlue background with bold font
• It shows: location count, item count, total quantity, total price, and total cost
• The totals panel at the bottom is hidden in summary mode since the summary row contains all the same information

Summary mode is useful for a quick snapshot of total inventory value without the detail.

Audit Warnings Dialog

After the report finishes generating, if any audit issues are detected, an auto-close dialog appears. This dialog automatically closes after 30 seconds if not dismissed manually. It reports three categories of issues:

Negative Stock

Displays the count of items with negative quantities, the total negative quantity, and the cost impact. The warning explains: "This reduces your reported inventory value."

Missing Cost

Displays the count of items that have stock but a zero cost, the total quantity affected, and the price value of those items. The warning explains: "Your Total Cost is UNDERSTATED."

Disabled Items with Stock

Displays the count of disabled items that still have stock on hand and the stock value. The warning explains: "These items cannot be sold but count as assets."

These same audit notes are included in the print header as AUDIT NOTES when the report is printed, so the printed report always carries the warnings alongside the data.

Printing

When you click Print, the report checks whether all data has been loaded. If only some pages have been loaded, a prompt appears:

"Only X of Y items are loaded. Do you want to load all items before printing?"

You have three options:

• Yes -- Loads all remaining pages before printing. This ensures the printed report contains every item.
• No -- Prints only the currently loaded rows.
• Cancel -- Returns to the report without printing.

The print output creates a printable grid clone that preserves all color formatting from the on-screen report, plus a totals row at the bottom. The page format is portrait orientation on 8.5 x 11 inch paper.

When to Use This Report

• End-of-Period Valuation -- Run at month-end or year-end to capture the total value of inventory for financial statements
• Insurance Documentation -- Generate a valuation for insurance claims or renewal documentation showing what inventory is on hand and its value
• Audit Preparation -- Use the audit warnings to identify discrepancies before an external audit
• Variance Investigation -- Compare the valuation report totals against your accounting records to find differences

Related Articles

• Stock Quantities Report (Article 89) -- Shows stock quantities without financial values. Use the Valuation Report when you need cost and price totals.
• Making Stock Adjustments (Article 72) -- Use adjustments to fix variances and missing costs identified by the audit warnings in this report.