From: Joe Hunt Date: Thu, 11 Feb 2021 07:59:50 +0000 (+0100) Subject: Bug 5332: Rep709, Tax Report, Multiple entries for a sinle tax line. Fixed. X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=14e0807fc87e0096af43f414f98764a6f8c8a4a8 Bug 5332: Rep709, Tax Report, Multiple entries for a sinle tax line. Fixed. --- 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