Bug 5332: Rep709, Tax Report, Multiple entries for a sinle tax line. Fixed.
authorJoe Hunt <joe.hunt.consulting@gmail.com>
Thu, 11 Feb 2021 07:59:50 +0000 (08:59 +0100)
committerJoe Hunt <joe.hunt.consulting@gmail.com>
Thu, 11 Feb 2021 07:59:50 +0000 (08:59 +0100)
reporting/rep709.php

index 9a4b2a5259a0e88ff6a32ce85e27042617be27a7..36984ff290ef43903e3c1e963ec24f59b0e84c37 100644 (file)
@@ -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