Return Item Without Following FIFO Rules

Question

Our system is set up to use FIFO for Costing Method and Automated for Inventory Valuation. Assume we have 10 items in stock at a cost of $1 each. We created a PO for another 10 items, applied the new cost of $10 each, and completed receiving. Realising the mistake, we attempted to return those 10 items at the higher cost price. We noticed Odoo returned the first 10 items that we had in stock instead of applying the return to the PO. This caused the cost of the existing goods to be at the $10 value.

Is this a bug in the system?
If not, what's the proper way to fix this issue without affecting the COGS and/or the Inventory Valuation?

Thank you!

Vashmitha V · Answer

Hello there,
Is this a bug in the system?
No, it's a default behaviour of Odoo. Default in the standard costing method, if you change the cost method to FIFO, delivery/purchase/MO/Return in all these, the cost of the product is in FIFO order

If not, what's the proper way to fix this issue without affecting the COGS and/or the Inventory Valuation?
Before returning those products, change the Costing method to LIFO in that product category.  And ensure the return order is validated, then change ba

İlgili Gönderiler	Cevaplar	Görünümler
Real Price - LIFO/FIFO Missing First Purchase? fifo cost real lifo	0 Ara 25	5032
Create multiple purchases, change settings in the product category, and the cost is not updated on the product sheet. Çözüldü purchase invoice automatic cost v18	1 Haz 25	773
What are the pros and cons of each of the different Inventory Costing methods? the most accurate? Çözüldü fifo inventory cost average actual	1 Eki 24	2795
Automated Inventory Valuation on Product Category Çözüldü fifo inventory cost landing v12	4 Mar 20	9858
Change Sign & Pay Button on Quotation E-mails v18	3 Kas 25	369

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!