Hello all,
In my organization sales are entered throughout the month and a subsequent purchase invoice is entered on the 30th of that month but the document is dated and posted as at the 1st. Also, the purchase cost may differ from the previous cost and as BC expects it will calculate cost of sales (COS) based on the last cost.
So when our invoice is entered month end and dated the 1st at a different price, BC understandably pulls the last unit cost which is expected.
This month, the invoice is entered at $3/unit but this was the incorrect price and a purchase credit memo was done to correct this invoice and the actual value of $4/unit was entered, however BC is still using the 3/unit even though it was credited, due to the fact I am assuming that inventory would be in negative at this point and this purchase cost would apply to all invoices.
How can I correct the COS, get my COS up from 3/unit to 4/unit?
I have tried the Application Worksheet, but can't seem to get the entries to unapply from the Invoice that was credited and apply them to the new invoice with the correct price. At the moment my COS is understated.
Apologies for the long drawn out explanation, please advise if any further information would help.
Version: US Business Central 19.1 (Plat 19.0.31889.32155 + App 19.1.31886.32186)
Thank you.
