FrontAccounting forum — Statement printout sort order

Re: Statement printout sort order

null@example.com (andrew1136) — Tue, 15 Nov 2011 10:27:12 +0000

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

null@example.com (joe) — Mon, 14 Nov 2011 21:35:28 +0000

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

null@example.com (andrew1136) — Mon, 14 Nov 2011 18:35:45 +0000

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