Hi GURUS,
I have an scenario where i would like to seek suggestion and advise from the Gurus:
** For your information, we are setting our item's Costing Method = "Group Average Cost".
During end of JANUARY 2026, we have created a Purchase and Item Receipt with below information:
- Quantity = 5
- Rate = $5 per unit
Once the Item Receipt is saved, it posted into Asset Account $25 in total. (Take note that we have not yet create Vendor Bill yet since vendor not yet issue bill to us)
In end of JANUARY 2026 too, we have also sell out the item to a customer with below information:
- Quantity = 1
- Selling Price = $15
Once the Item Fulfillment is saved, it posted into COGS Account $5 (Since the Average Cost is $5 now).
After that Finance Team went to close the period for JANUARY.
Now in the beginning of FEBRUARY, the Vendor issue the Bill and mentioned that "The cost should be $10 instead of $5 per unit". We have also created the Vendor Bill and the total amount $50 instead.
So we created an Inventory Adjustment to perform the Cost revaluation to adjust the Average Cost of the item from $5 to $10, this will reflect on the COGS if we have any new Sales created in FEBRUARY.
But what about the the Sales have been created in JANUARY and for the x1 quantity item that have been sold in JANUARY and posted to COGS with $5? Because it should be $10, but since Finance Team have closed the JANUARY period, we are not able to adjust the Item Receipt Rate, and Finance Team do not want us to edit the closed period too. Asset Account should have no issue since during Item Receipt it debit into Asset Account and during Item Fulfillment it credit out too, but the issue is on the COGS Account, which has debited with $5 only.
Hope to get some advise and suggestion for this scenario.
Thank you.