Issue #23246:fix weight calculation

diff --git a/foundation-database/public/tables/metasql/quoteItems-list.mql b/foundation-database/public/tables/metasql/quoteItems-list.mql
index f253f7c..ddd5678 100644 (file)
--- a/foundation-database/public/tables/metasql/quoteItems-list.mql
+++ b/foundation-database/public/tables/metasql/quoteItems-list.mql
@@ -30,8 +30,8 @@ SELECT quitem_id,
        CASE WHEN (quitem_custpn != '') THEN quitem_custpn
             ELSE item_number
        END AS item_number_cust,
-       (quitem_qtyord / quitem_qty_invuomratio * item_prodweight) AS prodweight,
-       (quitem_qtyord / quitem_qty_invuomratio * item_packweight) AS packweight,
+       (quitem_qtyord * quitem_qty_invuomratio * item_prodweight) AS prodweight,
+       (quitem_qtyord * quitem_qty_invuomratio * item_packweight) AS packweight,
        itemsite_qtyonhand,
        'qty' AS coitem_qtyord_xtnumericrole,
        'qty' AS qtyshipped_xtnumericrole,
@@ -51,4 +51,4 @@ SELECT quitem_id,
    AND   (quitem_qty_uom_id=quom.uom_id)
    AND   (quitem_price_uom_id=puom.uom_id)
    AND   (quitem_quhead_id=<? value("quhead_id") ?>) )
-ORDER BY quitem_linenumber;
+ORDER BY quitem_linenumber;
\ No newline at end of file

diff --git a/foundation-database/public/tables/metasql/salesOrderItems-list.mql b/foundation-database/public/tables/metasql/salesOrderItems-list.mql
index ba274e2..440525c 100644 (file)
--- a/foundation-database/public/tables/metasql/salesOrderItems-list.mql
+++ b/foundation-database/public/tables/metasql/salesOrderItems-list.mql
@@ -17,7 +17,7 @@ SELECT coitem_id, coitem_altid, groupby,
        formatSalesPrice(coitem_price) AS f_price,
        formatSalesPrice(coitem_custprice) AS f_custprice,
        formatPrcnt(discountfromcust / 100) AS f_discountfromcust,
-       formatQty(coitem_qtyord) AS f_qtyord, 
+       formatQty(coitem_qtyord) AS f_qtyord,
        CASE WHEN (qtyshipped > 0.0) THEN formatQty(qtyshipped) ELSE NULL END AS f_qtyshipped,
        CASE WHEN (qtyshipped > 0.0) THEN formatQty(balance) ELSE NULL END AS f_balance,
        CASE WHEN (qtyatshipping > 0.0) THEN formatQty(qtyatshipping) ELSE NULL END AS f_qtyatshipping,
@@ -86,8 +86,8 @@ SELECT coitem_id,
             ELSE item_descrip2
        END AS item_descrip2_cust,
        formatitemsitebarcode(itemsite_id) AS item_barcode,
-       (coitem_qtyord / coitem_qty_invuomratio * item_prodweight) AS prodweight,
-       (coitem_qtyord / coitem_qty_invuomratio * item_packweight) AS packweight,
+       (coitem_qtyord * coitem_qty_invuomratio * item_prodweight) AS prodweight,
+       (coitem_qtyord * coitem_qty_invuomratio * item_packweight) AS packweight,
        coitem_status, coitem_firm,
        getSoitemStatus(coitem_id) AS enhanced_status,
        quom.uom_name AS qty_uom, puom.uom_name AS price_uom,
@@ -153,4 +153,4 @@ SELECT coitem_id,
 <? endif?>
 
 ) AS data
-ORDER BY coitem_linenumber, coitem_subnumber;
+ORDER BY coitem_linenumber, coitem_subnumber;
\ No newline at end of file