X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep301.php;h=57350d8c31793bf021643af01d983d92ee69ff5f;hb=d4c7f6c430d861a4c27f7734e285852e248a5a9a;hp=5d04754bc85286030f305c890bbfbdd0dadbfadb;hpb=a9f8bc40287ef12f16ad863d4acb1af3d18643b6;p=fa-stable.git diff --git a/reporting/rep301.php b/reporting/rep301.php index 5d04754b..57350d8c 100644 --- a/reporting/rep301.php +++ b/reporting/rep301.php @@ -91,6 +91,7 @@ function getTransactions($category, $location, $date) { $date = date2sql($date); + $dec = user_qty_dec(); $sql = "SELECT item.category_id, category.description AS cat_description, item.stock_id, @@ -117,7 +118,7 @@ function getTransactions($category, $location, $date) $sql .= "move.loc_code, "; $sql .= "item.stock_id, item.description - HAVING ROUND(SUM(move.qty), units.decimals) != 0"; + HAVING ROUND(SUM(move.qty), IF(units.decimals <> -1, units.decimals, $dec)) != 0"; if ($category != 0) $sql .= " AND item.category_id = ".db_escape($category); if ($location != 'all')