No price difference posting
lets say we have a material with moving average price of 3$ and 100 pcs. in stock.
Now, someone creates a PO for 100pcs. with a wrong price of 10$ each. GR is posted, moving average price is now far too high: ((3$ * 100)+(10$ * 100))/200 = 6.50$.
Then there are some goods issues, so that the stock is only 5 pcs. and stock value 32,50$.
Now, the invoice arrives, with the correct price of 3$ each.
So there should be a stock credit entry of 70$. Unfortunatelly, stock value is only 32,50$.
In my view the price difference account should be used in this case. But in our system there is a error message saying that the moving average price is going to be negative and thus preventing posting the invoice.
Does anyone have an idea, why the price difference account is not used here?
Pls note that while doing GRN the inventory account was debited with $ 1000
Now if you are doing invoince only for $ 300. Hence the difference of $ 700 will proportionately hit both inventory and PRD account with the ratio of $ 35 (Inventory) and $ 665 (PRD). This is because the existing stock was only 5 which could not able to cover invoince quantity of 100. Hence the ratio is 95:5
Since the existing MAP is $ 32.5, there is a difference of $ 2.5
Hence the system is throwing the negative MAP error.
I hope you are clear now.