X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fdb%2Fcustomers_db.inc;h=8d4239189443652a07e66c748b6929f4e2072f00;hb=9e61d0860639941a0aceace8f4c14ced1c635e7f;hp=3f16159e46ddc434fe45048405ca60005e89fab7;hpb=1e2812c2b5f87ffbf94793ceabbfbdbc7db9c9c1;p=fa-stable.git diff --git a/sales/includes/db/customers_db.inc b/sales/includes/db/customers_db.inc index 3f16159e..8d423918 100644 --- a/sales/includes/db/customers_db.inc +++ b/sales/includes/db/customers_db.inc @@ -97,7 +97,7 @@ function get_customer_details($customer_id, $to=null, $all=true) $sql .= " AND debtor.debtor_no = ".db_escape($customer_id); if (!$all) - $sql .= " AND ABS(trans.ov_amount + trans.ov_gst + trans.ov_freight + trans.ov_freight_tax + trans.ov_discount - trans.alloc) > ".FLOAT_COMP_DELTA; + $sql .= " AND ABS(trans.ov_amount) + trans.ov_gst + trans.ov_freight + trans.ov_freight_tax + trans.ov_discount - trans.alloc > ".FLOAT_COMP_DELTA; $sql .= " GROUP BY debtor.name, terms.terms,