ORDER BY trans_date,".TB_PREF."bank_trans.id";
return db_query($sql,"The transactions for '$account' could not be retrieved");
ORDER BY trans_date,".TB_PREF."bank_trans.id";
return db_query($sql,"The transactions for '$account' could not be retrieved");
- $cols = array(0, 90, 110, 170, 225, 270, 350, 400, 460, 520);
+ $cols = array(0, 90, 110, 170, 225, 350, 400, 460, 520);
- $aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'right', 'right', 'right');
+ $aligns = array('left', 'left', 'left', 'left', 'left', 'right', 'right', 'right');
- $headers = array(_('Type'), _('#'), _('Reference'), _('Date'), _('Type'), _('Person/Item'),
+ $headers = array(_('Type'), _('#'), _('Reference'), _('Date'), _('Person/Item'),
_('Debit'), _('Credit'), _('Balance'));
$account = get_bank_account($acc);
_('Debit'), _('Credit'), _('Balance'));
$account = get_bank_account($acc);
$rep->TextCol(1, 2, $myrow['trans_no']);
$rep->TextCol(2, 3, $myrow['ref']);
$rep->TextCol(3, 4, sql2date($myrow["trans_date"]));
$rep->TextCol(1, 2, $myrow['trans_no']);
$rep->TextCol(2, 3, $myrow['ref']);
$rep->TextCol(3, 4, sql2date($myrow["trans_date"]));
- $rep->TextCol(4, 5, $myrow['BankTransType']);
- $rep->TextCol(5, 6, payment_person_types::person_name($myrow["person_type_id"],$myrow["person_id"], false));
+ $rep->TextCol(4, 5, payment_person_types::person_name($myrow["person_type_id"],$myrow["person_id"], false));
- $rep->TextCol(6, 7, number_format2(abs($myrow['amount']), $dec));
+ $rep->TextCol(5, 6, number_format2(abs($myrow['amount']), $dec));
- $rep->TextCol(7, 8, number_format2(abs($myrow['amount']), $dec));
- $rep->TextCol(8, 9, number_format2($total, $dec));
+ $rep->TextCol(6, 7, number_format2(abs($myrow['amount']), $dec));
+ $rep->TextCol(7, 8, number_format2($total, $dec));