Inventory Valuation (report)
The Inventory Valuation report shows:
- The beginning balance (quantity and value) based on a starting date you specify.
- The closing balance based on an ending date you specify entered.
You can also find decreases and increases in quantity and value in the period.
If you use expected cost posting, you can choose to include expected costs that reconcile to your inventory (interim) accounts.
The value in the Cost Posted to G/L column should equal the value in the Ending Date Value column. If it isn't, it's because you didn't run Post Inventory Cost to G/L.
Depending on settings on the Inventory Posting Setup page, you can run the report with different location filters and compare inventory posting group totals to the related G/L Accounts to ensure that your inventory subledger balances with the general ledger inventory balance sheet accounts.
Tip
To ensure that the report is up-to-date, we recommend that you run the Adjust Cost - Item Entries batch job before you generate this report.
Note
This report isn't available in the US, Canada, and Mexico. Instead, use the localized version of the Inventory Valuation (10139) report.
Use cases
Financial analysts use the report to:
- Reconcile the inventory subledger to inventory accounts in the general ledger at the end of each period.
- Analyze the changes to expected costs posted during the period and reconcile them with inventory accounts in the general ledger.
- Determine the value of on-hand inventory for financial reporting.
Inventory managers use the report to:
- Analyze inventory valuation for selected items to ensure that it's accurate.
- Determine the value of on-hand inventory for planning purposes.
- Monitor changes to expected costs posted during a period to identify discrepancies.
Supply chain managers use the report to:
- Analyze the inventory valuation for selected items to ensure adequate inventory levels.
- Determine the value of on-hand inventory for planning purposes. For example, to ensure that their inventory can meet customer demand.
- Monitor changes to expected costs posted during the period to identify discrepancies and take corrective action if necessary
Try the report
Try the report here: Inventory Valuation
Tip
If you press CTRL and choose the report link, the report opens in a new browser tab. This allows you to stay on this page while you explore the report in the other browser tab.
See also
Inventory and warehouse report overview
Ad hoc analysis of inventory data
Inventory analytics overview