From 5cbd008c99134d5c107dc4a3f87c6c11e47a1092 Mon Sep 17 00:00:00 2001 From: Greg Pazo Date: Sat, 12 Apr 2014 00:07:33 -0400 Subject: [PATCH] Issue #23246:fix weight calculation --- .../public/tables/metasql/quoteItems-list.mql | 6 +++--- .../public/tables/metasql/salesOrderItems-list.mql | 8 ++++---- 2 files changed, 7 insertions(+), 7 deletions(-) diff --git a/foundation-database/public/tables/metasql/quoteItems-list.mql b/foundation-database/public/tables/metasql/quoteItems-list.mql index f253f7c91..ddd56786e 100644 --- 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=) ) -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 ba274e21c..440525c3d 100644 --- 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, ) AS data -ORDER BY coitem_linenumber, coitem_subnumber; +ORDER BY coitem_linenumber, coitem_subnumber; \ No newline at end of file -- 2.39.2