• From: Australia, Sydney
  • Registered: 09/25/2011
  • Posts: 26

Topic: Statement printout sort order

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Statement printout sort order

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

3 Reply by andrew1136 (edited by andrew1136 11/15/2011 10:31:02 am)

  • From: Australia, Sydney
  • Registered: 09/25/2011
  • Posts: 26

Re: Statement printout sort order

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