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

Related Posts	Replies	Views
Real Price - LIFO/FIFO Missing First Purchase? fifo cost real lifo	0 दिस॰ 25	5032
Create multiple purchases, change settings in the product category, and the cost is not updated on the product sheet. Solved purchase invoice automatic cost v18	1 जून 25	772
What are the pros and cons of each of the different Inventory Costing methods? the most accurate? Solved fifo inventory cost average actual	1 अक्तू॰ 24	2795
Automated Inventory Valuation on Product Category Solved fifo inventory cost landing v12	4 मार्च 20	9858
Change Sign & Pay Button on Quotation E-mails v18	3 नव॰ 25	367

This question has been flagged

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