In this part, we will discuss the columns’ meaning showing in the inventory value report after you create the inventory value report ID. For how to set up the inventory value report ID, please click here.
In AX, there are two import conceptions, financial updated and physical updated. Financial updated means the inventory transactions are already invoiced (For production orders, it’s production order end.). Physical updated means the inventory transactions are not invoice but received or shipped. (For production order, it means material picked or production order report as finished). After understanding the two concepts, it will be easy to understand the below columns.
Inventory: Financial Quantity – the quantity that are financially updated.
Inventory: Financial Amount –the amount value of inventory that are financially updated.
Inventory: Physical Quantity Posted – the quantity that are physical updated.
Inventory: Physical Amount Posted – the amount value of inventory that are physical updated.
Inventory: Physical Quantity Not Posted –the quantity that has inventory transactions but not posted to the GL. For example, you have item model group which has the options ‘post physical inventory’ and ‘post financial inventory’ disabled. Then you have an item which linked to this item group. Then you have a purchase order, you receive it and invoice it. Then if you check the inventory value report for this item, you will see the quantity and the value in this purchase order are actually under the column ‘Inventory: Physical Quantity Not Posted’ and ‘Inventory: Physical Amount Not Posted’
Inventory: Physical Amount Not Posted – please do not include this amount when you do the inventory reconciliation because this amount is not post into G/L.
Inventory: Quantity –the total quantity of all the qty columns in the report.
Inventory: Amount – the total quantity of all the amount columns in the report. Like the note above, please do not use this column to do the inventory reconciliation if you have the ‘Inventory: Physical Amount Not Posted’ showed in the report. You need to exclude ‘Inventory: Physical Amount Not Posted’ from the total amount.
Average unit cost – total amount divided by total quantity.
How to use inventory value report: part 1
How to use inventory value report: part 2
How to use inventory value report: part 4
We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!