When creating a Quotation with UOM of 48CS (48 Units) the margins is correct
CGA001-BK - $3.00 (sales $) / $1.00 (cost $)
1 48CS - $144.00 (48 * $3.00)
Margin = $96.00 ($144 - $48 = $96) which is correct in the Quotation.
When you confirm it to an SO (2nd Attachment)
The UoM did not carry over correctly and affects the SO price and the Financial Balance Sheet / Profit and Loss Statements.
The Margin is now $143.00 which is incorrect.
I think the math is [Unit Price - (Cost Price * UoM)]
$144.00 - ( $1 * 1 Unit) = $143.00
I believe it is taking the DEFAULT UOM and not the actual UOM of the QUOTE to make this calculation. This is a serious bug and need to corrected as soon as possible.
Hi,
The issue you described is a known Odoo bug related to margin calculation when using a sales UoM that is a multiple of the base UoM (such as 48CS = 48 units). Odoo correctly computes the margin on the quotation, multiplying both the sales price and cost by the UoM quantity. However, when the quotation is confirmed into a Sales Order, Odoo recalculates the margin using only the base UoM cost (1 unit), ignoring the sales UoM multiplier. This causes the Sales Order margin to be inflated and incorrect, which then affects accounting reports like Profit & Loss and COGS.
This is not a configuration problem but a functional bug present across several Odoo versions. The fix requires either an official Odoo patch or a custom override to ensure the margin formula multiplies cost × UoM quantity. Workarounds include computing margin only on the quotation, adding a custom calculated field that applies the correct formula, or reporting the issue directly to Odoo Support for a proper fix.
Hope it helps
If this is a known bug how come Odoo has not fix this as this is a big issue. Seems like an easy fix, I guess Odoo is not ready for mainstream yet.
Hi @Cybrosys Techno Solutions Pvt.Ltd - how does an incorrect margin calculation on a sales order affect COGS or the Profit & Loss? That really would be a serious problem.
You have to change the Inventory Valuation Costing Method to Standard.
FIFO / AVCO causes this issue.
Best Regards,
Nelson Yip
HSE USA, LLC
5832 E 61st Street
Commerce, CA 90040
P: 323-278-0888 x2122
F: 323-278-0999
nelson.yip@hseusa.com
https://www.hseusa.com
From: Santiago Amengual <notifications@mail.odoo.com>
Sent: Friday, November 21, 2025 6:26 PM
To: Nelson Yip <nelson.yip@hseusa.com>
Subject: UOM Margin Bug in when confirming Quotation to SO
CAUTION: This E-mail originated from outside the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
I'm having the same problem, how can I fix it? ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
View Forum Post
UOM Margin Bug in when confirming Quotation to SO
I'm having the same problem, how can I fix it?
--
Santiago Amengual