Issue #23246:fix weight calculation

[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 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