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.

相关帖文	回复	查看
Link attachments with wanted record and model 已解决 quickstart	1 4月 25	8037
✅Change the Account on Payments in Odoo quickstart	0 3月 25	1414
✅Change the Account on Payments in Odoo quickstart	1 3月 25	30
✅ Change the order date to the Old date quickstart	0 3月 25	1243
Plugin ALMA quickstart	3 9月 24	6302

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！