How to set up the calculation method of inventory costing when faced below situations:
According to Vietnam Accounting System, the unit price of inventory issued calculated based on:
unit price of inventory issue = (1.000.000 + 1.500.000 + 1.000.000 + 333.333,33) / (100 + 50 + 50 + 20) = 15.909,09
this unit price will apply for all inventory issued with hightlighted is yellow, thus, cost amount of inventory issued is:
But the Dynamics AX system calculated cost amount not correct with result is calculated above.
We’ve set up inventory model group is Weighted average as the below.
Please help us in this case.
06/26/2017, move out the inventory in Movement journal with 120 quantities, physical cost amount is 1.999.999,98 VND
In case of weighted average, the system calculates the cost price by using the available onhand quantity and financial cost amount (you can also setup to include physical value - you have already done that)
At the time of issue on 26th, there are only two receipts and the system considers them in calculating the cost price.