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.

Powiązane posty	Odpowiedzi	Widoki
Link attachments with wanted record and model Rozwiązane quickstart	1 kwi 25	7749
✅Change the Account on Payments in Odoo quickstart	0 mar 25	1311
✅Change the Account on Payments in Odoo quickstart	1 mar 25	30
✅ Change the order date to the Old date quickstart	0 mar 25	1164
Plugin ALMA quickstart	3 wrz 24	5697

To pytanie dostało ostrzeżenie

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