From 42e879a5705903e5f92a1cdb801403d99afadcf2 Mon Sep 17 00:00:00 2001 From: Joe Date: Mon, 3 Jul 2023 10:20:31 +0200 Subject: [PATCH] Bug 5709: Opening Bal. is calculated incorrectly in supplier balance. Fixed. --- reporting/rep201.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/reporting/rep201.php b/reporting/rep201.php index 00c48d5b..21fea412 100644 --- a/reporting/rep201.php +++ b/reporting/rep201.php @@ -38,10 +38,10 @@ function get_open_balance($supplier_id, $to) $sql .= "SUM(IF(t.type != ".ST_SUPPINVOICE." AND NOT(t.type IN (".ST_JOURNAL." , ".ST_BANKDEPOSIT.") AND t.ov_amount>0), abs(t.ov_amount + t.ov_gst + t.ov_discount) * -1, 0)) AS credits,"; - $sql .= "SUM(IF(t.type != ".ST_SUPPINVOICE." AND NOT(t.type IN (".ST_JOURNAL." , ".ST_BANKDEPOSIT.")), t.alloc * -1, t.alloc)) + $sql .= "SUM(IF(t.type != ".ST_SUPPINVOICE." AND NOT(t.type IN (".ST_JOURNAL." , ".ST_BANKDEPOSIT.") AND t.ov_amount>0), t.alloc * -1, t.alloc)) AS Allocated,"; - $sql .= "SUM(IF(t.type = ".ST_SUPPINVOICE.", 1, -1) * + $sql .= "SUM(IF(t.type = ".ST_SUPPINVOICE." OR (t.type IN (".ST_JOURNAL." , ".ST_BANKDEPOSIT.") AND t.ov_amount>0), 1, -1) * (abs(t.ov_amount + t.ov_gst + t.ov_discount) - abs(t.alloc))) AS OutStanding FROM ".TB_PREF."supp_trans t WHERE t.supplier_id = ".db_escape($supplier_id); -- 2.30.2