Issue #23416:apply price uom ratio to unit cost

diff --git a/foundation-database/public/functions/calcquoteamt.sql b/foundation-database/public/functions/calcquoteamt.sql
index 4bb78e2..0d5783f 100644 (file)
--- a/foundation-database/public/functions/calcquoteamt.sql
+++ b/foundation-database/public/functions/calcquoteamt.sql
@@ -30,7 +30,7 @@ BEGIN
   SELECT COALESCE(SUM(ROUND((quitem_qtyord * quitem_qty_invuomratio) *
                             (quitem_price / quitem_price_invuomratio), 2)), 0.0),
          COALESCE(SUM(ROUND((quitem_qtyord * quitem_qty_invuomratio) *
-                            quitem_unitcost, 2)), 0.0)
+                            (quitem_unitcost / quitem_price_invuomratio), 2)), 0.0)
          INTO _subtotal, _cost
   FROM quitem
   WHERE (quitem_quhead_id=pQuheadid);

diff --git a/foundation-database/public/functions/calcsalesorderamt.sql b/foundation-database/public/functions/calcsalesorderamt.sql
index 886c44c..5e792f3 100644 (file)
--- a/foundation-database/public/functions/calcsalesorderamt.sql
+++ b/foundation-database/public/functions/calcsalesorderamt.sql
@@ -33,7 +33,7 @@ BEGIN
   SELECT COALESCE(SUM(ROUND((coitem_qtyord * coitem_qty_invuomratio) *
                             (coitem_price / coitem_price_invuomratio), 2)), 0.0),
          COALESCE(SUM(ROUND((coitem_qtyord * coitem_qty_invuomratio) *
-                            coitem_unitcost, 2)), 0.0)
+                            (coitem_unitcost / coitem_price_invuomratio), 2)), 0.0)
          INTO _subtotal, _cost
   FROM coitem
   WHERE (coitem_cohead_id=pCoheadid)