Odoo CE 17, self hosted
We use BOMs to develop quotes for custom products we build. The problem we are experiencing is that BOM's use the Cost field for each product to compute a final BOM cost. If the prices we pay were static that would be OK, but they are not. I don't want to build a quote that reflects discounted prices I may have gotten on previous purchases.
I have tried using Standard pricing as opposed to FIFO or AVG, but that just messes with our inventory valuation and COGS.
I think what I want is a standard cost list that BOMs would use instead of the Cost field on each product.
I want to know if I am looking at this correctly and if there is a capability of Odoo17 to help with this or if I am going to need customization.