X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=reporting%2Frep302.php;h=cdeae91dc7e4be8c7e5ca383afbdfa0a77635a25;hb=05d1e1fc65fe68645b540e06884db0e9f24b1a21;hp=75feef57e657d6cf1286dd100fbf1bfdcac86515;hpb=46c5f7a65a7659a44ae8254c63152074363d3987;p=fa-stable.git diff --git a/reporting/rep302.php b/reporting/rep302.php index 75feef57..cdeae91d 100644 --- a/reporting/rep302.php +++ b/reporting/rep302.php @@ -40,7 +40,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)