From 7e68ebdd53aecb5431d4f68863b414a12fe2d285 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Wed, 3 Jun 2009 08:33:56 +0000 Subject: [PATCH] Small bug (qoh) --- reporting/rep303.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/reporting/rep303.php b/reporting/rep303.php index 5cd6860..19be2ee 100644 --- a/reporting/rep303.php +++ b/reporting/rep303.php @@ -36,7 +36,7 @@ function getTransactions($category, $location) ".TB_PREF."stock_master.stock_id, ".TB_PREF."stock_master.description, IF(".TB_PREF."stock_moves.stock_id IS NULL, '', ".TB_PREF."stock_moves.loc_code) AS loc_code, - SUM(IF(".TB_PREF."stock_moves.stock_id IS NULL,0,".TB_PREF."stock_moves.qty)) AS qty_on_hand + SUM(IF(".TB_PREF."stock_moves.stock_id IS NULL,0,".TB_PREF."stock_moves.qty)) AS QtyOnHand FROM (".TB_PREF."stock_master, ".TB_PREF."stock_category) LEFT JOIN ".TB_PREF."stock_moves ON -- 2.30.2