From f11c9c79c03710fa081caa53c2c754d8de04c922 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Sat, 16 Jun 2018 07:47:23 +0200 Subject: [PATCH] Report Aged Supplier Analysis, Show Also Allocated = No. SQL Problem fixed. --- purchasing/includes/db/suppliers_db.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/purchasing/includes/db/suppliers_db.inc b/purchasing/includes/db/suppliers_db.inc index 2125e6a5..d66c89fc 100644 --- a/purchasing/includes/db/suppliers_db.inc +++ b/purchasing/includes/db/suppliers_db.inc @@ -93,7 +93,7 @@ function get_supplier_details($supplier_id, $to=null, $all=true) else $value = "IF (trans.type=".ST_SUPPINVOICE." OR trans.type=".ST_BANKDEPOSIT." OR (trans.type=".ST_JOURNAL." AND (trans.ov_amount + trans.ov_gst + trans.ov_discount)>0), 1, -1)* - ABS(trans.ov_amount + trans.ov_gst + trans.ov_discount) - trans.alloc)"; + ABS(trans.ov_amount + trans.ov_gst + trans.ov_discount) - trans.alloc"; $due = "IF (trans.type=".ST_SUPPINVOICE." OR trans.type=".ST_SUPPCREDIT.",trans.due_date,trans.tran_date)"; $sql = "SELECT supp.supp_name, supp.curr_code, ".TB_PREF."payment_terms.terms, -- 2.30.2