When the model group that is assigned to an item is configured to include the physical value of the item, the on-hand cost price in Microsoft Dynamics AX 4.0 is calculated by using the modulus value of the following fields: Note In this situation, the on-hand cost price is calculated differently in Microsoft Dynamics AX 4.0 than it is in Microsoft Dynamics AX 3.0. This article describes how the on-hand cost price calculation is calculated in Microsoft Dynamics AX 4.0 when the model group that is assigned to an item is configured to include the physical value of the item. I try to copy and paste the article that I read from partnersource: I have fact that MS have change the way of calculation in the costing in AX 4.0.

I am using the same way of entering the transaction. I am just wondering why in AX 4.0 the average cost was different. If the item had been sold between 5 January and 14 January, it would have been picked at a value of $15.00.īy the above example it seems 11 i s the right answer for Axapta 3.0. We would sell this one piece at $20 (average cost price) and we have left two pieces on hand with a posted value of $40 and an average cost price of $20. Now we have three pieces on hand with a posted value of $60.00 ($10 + $20 + $30) and an average cost price of $20 ($60 / 3). On 15 January, on more item is purchased for a cost price of $30.00. Now, the On-hand inventory level is two pieces with a posted value of $30.00 and an average cost price of $15.00. On 5 January, one more item is purchased for a cost price of $20.00.

The On-hand inventory level is one piece, with a posted value of $10.00 and an average cost price of $10.00. On 1 January, one item is purchased for a cost price of $10.00. (Total Financial Cost Amount / Total)/Total I do not have much idea of Axapta 4.0.But in Axapta 3.0 the logic of calculating Average cost is :

Noteplan 3.0