From 14e0807fc87e0096af43f414f98764a6f8c8a4a8 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Thu, 11 Feb 2021 08:59:50 +0100 Subject: [PATCH] Bug 5332: Rep709, Tax Report, Multiple entries for a sinle tax line. Fixed. --- reporting/rep709.php | 1 + 1 file changed, 1 insertion(+) diff --git a/reporting/rep709.php b/reporting/rep709.php index 9a4b2a52..36984ff2 100644 --- a/reporting/rep709.php +++ b/reporting/rep709.php @@ -44,6 +44,7 @@ function getTaxTransactions($from, $to) ON taxrec.tax_type_id=tt.id LEFT JOIN ".TB_PREF."gl_trans gl ON taxrec.trans_type=gl.type AND taxrec.trans_no=gl.type_no AND gl.amount<>0 AND + gl.amount=taxrec.amount AND (tt.purchasing_gl_code=gl.account OR tt.sales_gl_code=gl.account) LEFT JOIN ".TB_PREF."supp_trans strans ON taxrec.trans_no=strans.trans_no AND taxrec.trans_type=strans.type -- 2.30.2