Hi there,
My client wants to switch from an excel based inventory handling to Odoo 13 CE . They currently track their products in excel the following way:
| Product | Received price | Margin | Selling price |
| Gadget 1 | 10 USD | 10% | 11 USD |
To make this work in Odoo, I did the following setup:
- Added "Gadget" with a a selling price of 11 USD, left the cost to 0 USD
- Switched the inventory valuation policy of Gadget's product category to FIFO
- Created a PO for 100 Gadgets for 10 USD each
- Received the products
- The inventory valuation displays that the current inventory has a value of 1000 USD. So far so good
- I create a sale order for 20 pieces with 11 USD each
- The Margin on the SO is 220 USD because the cost of the product is 0. In reality, it should be 20 USD.
- Of course, I can ship and invoice the SO, but the margin will still be 220 USD.
The FIFO price on the product form is 0 BEFORE I ship it because - as the description says - the price will only be updated after it is shipped out.
This kind of approach will produce incorrect margin values. Is there any way to correct this?
I have two questions.
1. Did you have any on hand quantity before changing the costing method?
2. Did you assign the product category to the product before making the purchase order?
I tried it with an existing product that had no stock move previously and also tried it with a brand new product. I don't think it's a question of whether the product or the product category exists or not, or if the category had FIFO set or not.