Hello,
We had a PO that we did not receive the shipping/freight charges for until after the units were used to fulfill an order. We have since gone in and added the charges as a landed cost on the inventory fulfillment - however, the P&L was not updated to reflect the appropriate COGS for that item, instead those landed costs were allocated to all remaining goods in stock. I'll try to breakdown the events below.
PO was issues for 1500 units of 6 different widgets.
All 9000 widgets were received
7,344 widgets were shipped out, invoiced and paid
We received the shipping/freight charges and bill for all 9000 widgets. The cost per unit of widget was higher than anticipated, and the shipping/freight was in addition.
I updated the original item receipt with the appropriate per unit cost of each widget, and added in the shipping/freight on a quantity basis under the landed cost tab.
I billed the item receipt for the same per unit cost given, and added a landed cost contra expense on the bill.
The P&L was not updated to reflect the change in COGS per unit. However, our current remaining inventory has increased from the $6.187 per unit to $11.45 average cost, appearing to have allocated the additional costs to the remaining units.
Is there a way to force the COGS to reflect back into the original fulfillment process and update previous months P&L?