Small bug (qoh)
[fa-stable.git] / reporting / rep303.php
index 5cd686032face020576f5e320f4dd595e9036e41..19be2ee92030cfad74174ec82f216ba87c04c4f7 100644 (file)
@@ -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