- $result = get_bank_trans(null, null, payment_person_types::dimension(), $id);
+ $sql = "SELECT ".TB_PREF."gl_trans.*,".TB_PREF."chart_master.account_name FROM
+ ".TB_PREF."gl_trans,".TB_PREF."chart_master WHERE
+ ".TB_PREF."gl_trans.account = ".TB_PREF."chart_master.account_code AND
+ (dimension_id = $id OR dimension2_id = $id) ORDER BY account,tran_date";
+ $result = db_query($sql, "Transactions could not be calculated");