The Inventory value report storage report in D365FO can be utilized to analyse both physical and financial inventory values and reconcile your Inventory values with General ledger. This report can be exported in various formats or can be printed as an interactive page in D365FO.
Scenario:
As part of the month end closing procedure, Sonya needs to reconcile Inventory with General ledger at the end of each month. She needs to extract the balances of the Inventory accounts and then reconcile the extracted balances to the trial balance. Sonya uses the inventory value report storage which enables her to pinpoint discrepancies if any. Let us see how Sonya uses D365FO to complete her month end tasks efficiently.
Configure Inventory value report – The inventory value report needs to be configured based on your requirement. You can define the details that need to show in the columns and the rows.
Define Report ID
- Navigate to Cost management> Inventory accounting policies setup> Inventory value reports.
- Click New to create a new Inventory value report
- Enter ID and Name
Define Report criteria
- Under the General section, select a Date interval, Range and Dimension Set

Configure columns
- In the Columns fast tab, in the Financial Position group, select Inventory to view the Inventory values. Similarly, you can mark the WIP, Deferred COGS, COGS to view these values and then reconcile them to General ledger.
Mark the Profit and Loss toggle to view the financial amount that was posted to the profit and loss account for inventory.
- Under the Compare on-hand inventory value to cumulative accounting values group, mark the Print cumulative account values for comparison to add an additional column in the report that will display the general ledger balance for the account.
- Under Inventory Dimensions, select the dimensions that you want to see on the report.
- To view the inventory values by Item and Item group, mark the View button under Resource ID and Resource group.

Configure report rows
- Within the Rows fast tab, the Material button is marked by default. If you need to additionally view the Labor costs, Indirect costs or Direct outsourcing costs of WIP then mark the Labor, Indirect cost and Direct outsourcing buttons.
- You can choose to view the report by total or by transaction details. Under Detail level, select one of the two options. When you select Transaction details, you can choose to view beginning balances as well by selecting the Include beginning balance button.

Generate Inventory value report storage report.
Now that the Inventory value report has been configured, you can use this report definition to generate and store the Inventory value report storage report.
- Navigate to Cost management> Inquiries and reports> Inventory value report storage.
- Click New. Enter the report identifier in the Name field. Select the report definition that you created earlier in the ID field. Click Ok.

3. Click on the View details button to view the generated report.
Reconcile with General ledger.
The generated Inventory value report can be reconciled with the Trial balance in D365FO with ease. You can get creative with the available filters and options to reconcile the inventory value with General ledger. Listed below is just one to match the balances.
- Print the trial balance in D365FO for the same period or date interval as the inventory value report storage.
- Make note of the inventory account number that you would like to reconcile. Here I am reconciling account 140200. The item groups that use account 140200 are Audio, CarAudio and TV&Video.
- In the Inventory value report storage report, you can add a filter on the Resource group column i.e the item group to display item groups Audio, CarAudio and TV&Video.
- You can then compare the Inventory value with the inventory account balance for the period.
With that we come to the end of this blog. Hope this writeup helps you with the Inventory value report storage functionality.