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

Powiązane posty	Odpowiedzi	Widoki
Real Price - LIFO/FIFO Missing First Purchase? fifo cost real lifo	0 gru 25	5032
Create multiple purchases, change settings in the product category, and the cost is not updated on the product sheet. Rozwiązane purchase invoice automatic cost v18	1 cze 25	772
What are the pros and cons of each of the different Inventory Costing methods? the most accurate? Rozwiązane fifo inventory cost average actual	1 paź 24	2795
Automated Inventory Valuation on Product Category Rozwiązane fifo inventory cost landing v12	4 mar 20	9858
Change Sign & Pay Button on Quotation E-mails v18	3 lis 25	367

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!