- $sql .= " GROUP BY t.$type_name, t.$trans_no_name";
- $sql .= " ORDER BY t.$trans_no_name";
+ // the ugly hack below is necessary to exclude old gl_trans records lasting after edition,
+ // otherwise old data transaction can be retrieved instead of current one.
+ if ($table_name==TB_PREF.'gl_trans')
+ $sql .= " AND t.`amount` <> 0";