In this part, we will discuss the most import parameter: inventory value report ID. You can go to Inventory management/Setup/Costing/inventory value reports to create IDs. (In AX 2009, the menu path is Inventory management/Setup/inventory value). You can create different IDs for different reporting requirement. For example, you can create the report only showing the total financial amount for financial staff and create a report only showing physical inventory for warehouse management staff.
When you try to create a inventory value report Id, you need to deal with a lot of parameters. Below are the explanations and best practice when using these parameter.
For the columns of financial position, you can only tick ‘inventory’ if you want to reconcile the inventory value with inventory G/L accounts balance. Or you can only tick ‘WIP’, if you want to reconcile the WIP value with WIP G/L accounts balance.
If you tick the ‘WIP’ option, only the physical quantities and amounts of inventory in WIP status will show in the report. In WIP status means production orders that have been picked or reported finished but not ended.
Please enable the option ’print cumulative account values for comparison’, if you want the G/L accounts balance showing in the report. By doing this, you don’t need to check the trail balance.
After you enable this option, you need to fill in the G/L account you want to reconcile.
For the ‘Inventory dimensions’ area, you can select the dimensions that you want to show in the report. Please be noted that only the dimensions that have ‘financial inventory’ option enabled can be showed in the report, otherwise you will only see blank columns. For more information, you can check this
The ‘Summarize’ option is ticked when you only want check the total inventory quantity and inventory amount. If it’s not ticked, the report will show both physical and inventory financial values.
The ‘Included not posted to ledger’ option is not recommended to ticked because those transactions that never post to G/L should not be included when you doing the inventory reconciliation.
The ‘Average Unit Cost’ option is suggested to be ticked if you want to check the average unit cost. The ‘Average Unit Cost’ is just a simple calculation: total quantity divided by the total amount.
The ‘Print Total’ option can only be ticked when the ‘summarize’ option is not ticked. The report will show additional two columns for the total quantity of inventory physical and financial quantities and the total amount of inventory physical and financial amounts.
The ‘Resource ID’ mostly means the item number.
The ‘Resource Group’ mostly mean item group.
If either ‘Resource ID’ or ‘Resource Group’ are not ticked, you will only see a total inventory value based on the inventory dimensions you selected.
The option ‘Detail Level’ enable the user to select different view of the report. If you want to view the report per transactions, you can select transactions. Otherwise, please select ‘total’. Please be noticed that there might be slow performance issue f you are trying to view a large volume of data on ‘transactions’ level
The option ‘Include beginning balance’ is only available when you select ‘transactions’ in detail level option.
Note: There is a known issue that incorrect figure will show in the report if the from and to date are the same day and the option ‘Include beginning balance’ is ticked. Please do not use in this way.
How to use inventory value report: part 1
How to use inventory value report: part 3
How to use inventory value report: part 4