Issue #23415:apply price uom ratio to unit cost

[xtuple] / foundation-database / public / tables / metasql / salesOrderItems-list.mql

diff --git a/foundation-database/public/tables/metasql/salesOrderItems-list.mql b/foundation-database/public/tables/metasql/salesOrderItems-list.mql
index 440525c..d73ca25 100644 (file)
--- a/foundation-database/public/tables/metasql/salesOrderItems-list.mql
+++ b/foundation-database/public/tables/metasql/salesOrderItems-list.mql
@@ -99,7 +99,7 @@ SELECT coitem_id,
        END AS discountfromcust,
        coitem_unitcost,
        ROUND((coitem_qtyord * coitem_qty_invuomratio) *
-             ((coitem_price / coitem_price_invuomratio) - coitem_unitcost),2) AS margin,
+             ((coitem_price / coitem_price_invuomratio) - (coitem_unitcost / coitem_price_invuomratio)),2) AS margin,
        CASE WHEN (coitem_price = 0.0) THEN 100.0
             ELSE ((coitem_price - coitem_unitcost) / coitem_price)
        END AS marginpercent,