X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep303.php;h=a7beebc1988b1ba5b0a39a83b44acc6a18be8b63;hb=758eda4e8cef6af76516199636f64415150b6da3;hp=d9904bfc101b368d51663183b24f306e65438e1d;hpb=46c5f7a65a7659a44ae8254c63152074363d3987;p=fa-stable.git diff --git a/reporting/rep303.php b/reporting/rep303.php index d9904bfc..a7beebc1 100644 --- a/reporting/rep303.php +++ b/reporting/rep303.php @@ -41,7 +41,7 @@ function getTransactions($category, $location) FROM (".TB_PREF."stock_master, ".TB_PREF."stock_category) LEFT JOIN ".TB_PREF."stock_moves ON - (".TB_PREF."stock_master.stock_id=".TB_PREF."stock_moves.stock_id OR ".TB_PREF."stock_master.stock_id IS NULL) + (".TB_PREF."stock_master.stock_id=".TB_PREF."stock_moves.stock_id) WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND (".TB_PREF."stock_master.mb_flag='B' OR ".TB_PREF."stock_master.mb_flag='M')"; if ($category != 0)