...
But as of the time of the Sales Invoice posting the opening ACP (at the beginning of the month) has been deducted from the stock, the system is making the equation during month-end closing and deducting the actual item cost for this sale. It's taking all stock balances during the month and calculates ACP, i.e. Total qty=10(opening qty on December 1st)+5(Purchase during the December)=15, total balance = 100+50+10 100AED (opening balance on December 1st)+ 50 AED (Purchase during the December)+10 AED (additional expense on purchase) = 160 AED. ACP = 10,66666667 AED.
As during the sales document posting only 50 AED (10 AED per item) was deducted, the system should equalize this cost, i.e. Cost correction = (10.66666667*5) - 50 = 3.333333 AED:
And the ACP changed accordingly , 110 - 3.33 = 106.67/10 = 10.67 AED:
...