FrontAccounting forum — Statement printout sort order

Re: Statement printout sort order

2011-11-15T10:27:12Z

Thanks Joe,

That worked fine, I edited reporting/rep108.php
Line 49 $sql = " ORDER BY "TB_PREF "debtor_trans.reference";
and now my statements are sorted by invoice number.

For the past 10 years I have used MYOB and my customers are used to receiving statements sorted by invoice number, although I do agree that the historical balance method is the correct accounting procedure.

Cheers

Andrew

Re: Statement printout sort order

2011-11-14T21:35:28Z

The statement reports are printed in a historic balance manner. The oldest first and present both invoices, credit notes and payments.
If you want to change the sort order, then please do that in the routine getTransactions() in file /reporting/rep108.php.

/Joe

Statement printout sort order

2011-11-14T18:35:45Z

Ubuntu 11.10
frontaccounting_2.3.8

Statement printout sort order.

Hi Joe,

When printing statements I need the list of outstanding invoices to be sorted by Invoice Number as the primary key. It seems to to sort by time entered + date entered + invoice number. Can I change the sort order key by editing the php ?

Here is a link to a screenshot of a statement printout.

http://www.gtv9.com.au/statement.jpg

Thanks

Andrew