I have automatic FIFO costing method enabled.
Lets say I made two Purchase Orders:
5 units for $1000
10 units for $2000
And now I need to make a Sale Order for 8 units.
I have a pricelist based directly on a cost of the products (for simplicity lets assume it is exactly cost without any margin).
With such pricelist order will have 8 units for just $1000 each. Instead of 5 units for $1000 and 3 units for $2000. In totals it is $8000 vs $11000.
Is there any way in Odoo to acctually use FIFO in this situation? Inside inventory management there is proper split between each lot (and correct units are taken from correct lot). But while evaluating cost it seems like it only takes the cost of a first lot.
Am I stuck with average cost (AVCO)?