How to set up the calculation method of inventory costing when PO is not invoiced

How to set up the calculation method of inventory costing when faced below situations:

  • 06/19/2017, receipt the inventory in PO with 100 quantities, physical cost amount is 1.000.000 VND
  • 06/22/2017, receipt the inventory in PO with 50 quantities, physical cost amount is 1.500.000 VND
  • 06/26/2017, move out the inventory in Movement journal with 120 quantities, physical cost amount is 1.999.999,98 VND
  • 06/27/2017, move in the inventory in Movement journal with 20 quantities, physical cost amount is 333.333,33 VND
  • 06/28/2017, receipt the inventory in PO with 50 quantities, physical cost amount is 1.000.000 VND
  • 06/28/2017, move out the inventory in Movement journal with 60 quantities, physical cost amount is 1.100.000 VND
  • 06/29/2017, move out the inventory in Movement journal with 10 quantities, physical cost amount is 183.333,34 VND

 

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:

  • In journal num MAE-000281: cost amount = 120 * 15.909,09 = 1.909.090,91
  • In journal num MAE-000283: cost amount = 60 * 15.909,09 = 954.545,45
  • In journal num MAE-000284: cost amount = 10 * 15.909,09 = 159.090,91

 

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.

  • angiemo315
    • 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.

Related
Recommended