Issue #23246:fix weight calculation

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

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