How can my quantity be zero but my inventory valuation be positive ? And how to change it ?

Question

I bought eighteen products for 100, and sold them for free. In my inventory valuation report, even if I have zero products, the value is still 100. The valuation method for the product category of this product is set to FIFO.

How can I change that, and avoid this problem in the future ?

Michael Dijkstra (mdj) · Answer

Hi, It is possible that you in the past had a higher price for a product through the inventory valuation, and then sold it/removed it when it had a lower valuation.

Hugo Baivier (hba) · Answer

Hi Ivan, No the categories are set to FIFO and manual. But the valuation problem seem to happen only for certain products.  I also checked on a runbot a product with the same configuration and the valuation changed correctly back to zero when I sold the products for free.
I would like to be able to be able to correct the values in the inventory valuation report.

Ivan Aragon (ifr) · Answer

Hi Hugo, are you using combination of costing method FIFO + inventory valuation Automated? I think FIFO and AVCO only work with automated inventory valuation and Standard price for manual inventory valuation, try to check that. Best regards.

Related Posts	Replies	Views
Link attachments with wanted record and model Solved quickstart	1 Apr 25	7760
✅Change the Account on Payments in Odoo quickstart	0 Mar 25	1314
✅Change the Account on Payments in Odoo quickstart	1 Mar 25	30
✅ Change the order date to the Old date quickstart	0 Mar 25	1165
Plugin ALMA quickstart	3 Sep 24	5726

This question has been flagged

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