ANS-0774 · FINANCIAL REPORTING
How to Display Total On-Hand Inventory Value in NetSuite Reports
NetSuite users can accurately sum inventory item values by utilizing the 'Quantity On Hand: On Hand Value' field in custom reports.
Short answer
To display the total on-hand inventory value in NetSuite reports, use the 'Quantity On Hand: On Hand Value' field. While 'Inventory Item:Current On Hand Value' may not support grand totals, the 'Quantity On Hand: On Hand Value' field provides the same financial amounts and allows for summation at the bottom of report columns, ensuring accurate inventory valuation.
Scenario
Users attempting to create NetSuite reports that summarize the total value of inventory items may encounter an issue where the 'Inventory Item:Current On Hand Value' column does not display a grand total at the bottom. This prevents a quick overview of the cumulative on-hand inventory value directly within the report.
Solution
To successfully display the total on-hand inventory value in a NetSuite report, utilize the 'Quantity On Hand: On Hand Value' field instead of 'Inventory Item:Current On Hand Value'. The 'Quantity On Hand: On Hand Value' field provides the same financial amounts for individual inventory items and supports the display of a grand total at the bottom of the report column.To implement this:
Add the field 'Quantity On Hand: On Hand Value' to your report columns.
Ensure that the report's column settings are configured to show totals or summaries for this column, which will display the cumulative value at the bottom.
Expert NetSuite Support
Need help with this NetSuite issue?
Financial Reporting consulting and configuration support