Issue #23415:apply price uom ratio to unit cost

diff --git a/foundation-database/public/tables/metasql/quoteItems-list.mql b/foundation-database/public/tables/metasql/quoteItems-list.mql
index ddd5678..2c31a83 100644 (file)
--- a/foundation-database/public/tables/metasql/quoteItems-list.mql
+++ b/foundation-database/public/tables/metasql/quoteItems-list.mql
@@ -23,7 +23,7 @@ SELECT quitem_id,
        END AS discountfromcust,
        quitem_unitcost AS coitem_unitcost,
        ROUND((quitem_qtyord * quitem_qty_invuomratio) *
-             ((quitem_price / quitem_price_invuomratio) - quitem_unitcost),2) AS margin,
+             ((quitem_price / quitem_price_invuomratio) - (quitem_unitcost / quitem_price_invuomratio)),2) AS margin,
        CASE WHEN (quitem_price = 0.0) THEN 100.0
             ELSE ((quitem_price - quitem_unitcost) / quitem_price)
        END AS marginpercent,

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,