Invoice before Delivery Leads to COGS/inventory valuation discrepancies

[derekwolfson]

Impacted versions: 17.0

Steps to reproduce:
Create Inventory of an Item -- set price at $10 and increase stock by 1 -- set price at $5 increase stock by 1 -- so now have two stock -- one at $10 and one at $5

Set FIFO inventory valuation

Create SO for 2x units of stock and then create invoice/validate invoice BEFORE validating the delivery

This will make COGS entries of $20 since price of next unit is $10 -- this is fine because how is Odoo supposed to know actual COGS without a stock movement?

Now Validate the delivery and check COGS again -- it is still $20 as the journal entries did not update.

Now set Invoice to draft and repost it. COGS is now $15 since the delivery is logged properly.

Current behavior:
COGS is wrong if you don't set to draft and repost invoice after delivery.

Expected behavior:
Automatic update of COGS upon validation of a delivery.

I understand the logic behind the workflow here -- but there really needs to be something that "corrects" Odoo's best guess at COGS once a delivery/inventory movement is done. That is the true "cost of goods sold".

We can obviously set the invoice control rule to "delivered quantities" and use down payments to get prepayments -- but this doesn't work in e-Commerce as those sales go straight to fully invoiced/paid even though the delivery is still pending.

Video/Screenshot link (optional):

Support ticket number submitted via odoo.com/help (optional):