0004161: g/l inquiry person/item displays number instead of person. Fixed. Rerun.
authorJoe Hunt <joe.hunt.consulting@gmail.com>
Fri, 27 Apr 2018 13:41:23 +0000 (15:41 +0200)
committerJoe Hunt <joe.hunt.consulting@gmail.com>
Fri, 27 Apr 2018 13:41:23 +0000 (15:41 +0200)
gl/includes/db/gl_db_trans.inc

index a96ff6f511e11e87e54e3396a5c1080b3aa1dc78..db34a5eeb8f20f206e87df7e1336979ec034cc57 100644 (file)
@@ -133,7 +133,6 @@ function get_gl_transactions($from_date, $to_date, $trans_no=0,
 
                        LEFT JOIN ".TB_PREF."bank_trans bt ON bt.type=gl.type AND bt.trans_no=gl.type_no AND bt.amount!=0
                                 AND (bt.person_id != '' AND !ISNULL(bt.person_id))
-                                AND bt.person_type_id=gl.person_type_id AND bt.person_id=gl.person_id
 
                        LEFT JOIN ".TB_PREF."journal j ON j.type=gl.type AND j.trans_no=gl.type_no
                        LEFT JOIN ".TB_PREF."audit_trail a ON a.type=gl.type AND a.trans_no=gl.type_no AND NOT ISNULL(gl_seq)