From 2b58a999e31c48e47358d9c9e87b0f69849f029f Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Mon, 5 Feb 2018 23:34:23 +0100 Subject: [PATCH 1/1] Fixed a minor weird bug in QOH in inventory Planning Report --- reporting/rep302.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/reporting/rep302.php b/reporting/rep302.php index bfb515f1..cdfd0e9a 100644 --- a/reporting/rep302.php +++ b/reporting/rep302.php @@ -36,7 +36,7 @@ function getTransactions($category, $location) item.stock_id, item.description, item.inactive, IF(move.stock_id IS NULL, '', move.loc_code) AS loc_code, - SUM(IFNULL(move.stock_id, 0)) AS qty_on_hand + SUM(IF(move.stock_id IS NULL, 0, move.qty)) AS qty_on_hand FROM (".TB_PREF."stock_master item," .TB_PREF."stock_category category) LEFT JOIN ".TB_PREF."stock_moves move ON item.stock_id=move.stock_id -- 2.30.2