X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep303.php;fp=reporting%2Frep303.php;h=19be2ee92030cfad74174ec82f216ba87c04c4f7;hb=e33db854ddfc552d5c9107da2c0cbd8e178bcc11;hp=5cd686032face020576f5e320f4dd595e9036e41;hpb=83e9c286c92b366b482a0bffc6de8fe0fa5b390e;p=fa-stable.git diff --git a/reporting/rep303.php b/reporting/rep303.php index 5cd68603..19be2ee9 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