From 9d1d76d261b048bba60d1e35f2b6d3a233a8c94e Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Mon, 18 Jan 2010 22:53:22 +0000 Subject: [PATCH] Demand was calculated double from Sales Quotation. Should be 0 --- CHANGELOG.txt | 3 +++ includes/db/manufacturing_db.inc | 3 ++- 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/CHANGELOG.txt b/CHANGELOG.txt index 2d22026..285978b 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -19,6 +19,9 @@ Legend: ! -> Note $ -> Affected files +18-Jan-2010 Joe Hunt +# Demand was calculated double from Sales Quotation. Should be 0. +$ /includes/db/manufacturing_db.inc # A back link was still in Bank Transfer. $ /gl/bank_transfer.php diff --git a/includes/db/manufacturing_db.inc b/includes/db/manufacturing_db.inc index 31fb3ec..ca1841d 100644 --- a/includes/db/manufacturing_db.inc +++ b/includes/db/manufacturing_db.inc @@ -17,7 +17,8 @@ function get_demand_qty($stock_id, $location) FROM ".TB_PREF."sales_order_details, ".TB_PREF."sales_orders WHERE ".TB_PREF."sales_order_details.order_no=" - .TB_PREF."sales_orders.order_no AND "; + .TB_PREF."sales_orders.order_no AND ".TB_PREF."sales_orders.trans_type=".ST_SALESORDER." AND + ".TB_PREF."sales_orders.trans_type=".TB_PREF."sales_order_details.trans_type AND "; if ($location != "") $sql .= TB_PREF."sales_orders.from_stk_loc =".db_escape($location)." AND "; $sql .= TB_PREF."sales_order_details.stk_code = ".db_escape($stock_id); -- 2.30.2