- IF(ISNULL(supp.supp_name),
- IF(ISNULL(debt.name),
- IF(gl.person_type_id<>".PT_MISC.", gl.memo_, gl.person_id), debt.name),
- supp.supp_name) as name,
+ IF(taxrec.trans_type=".ST_BANKPAYMENT." OR taxrec.trans_type=".ST_BANKDEPOSIT.",
+ IF(gl.person_type_id<>".PT_MISC.", gl.memo_, gl.person_id),
+ IF(ISNULL(supp.supp_name), debt.name, supp.supp_name)) as name,