FrontAccounting forum — Sorting of Expense Accounts Alphabetically

Re: Sorting of Expense Accounts Alphabetically

null@example.com (apmuthu) — Sat, 03 May 2025 23:30:02 +0000

That will be in reporting/rep707.php.

The relevant code is:

function print_profit_and_loss_statement()

The loop is in line 288 within which the elements will need to be alphabetically arranged:

while ($accounttype=db_fetch($typeresult))

Line 273:

$classresult = get_account_classes(false, 0);

too could be checked out.

The lines 40-41 in function display_type

    $result = get_gl_accounts(null, null, $type);    
    while ($account=db_fetch($result))

may need to be sorted for your needs.

A modified version of the rep707.php could be made into an extension to serve your needs. Anyone game?

Re: Sorting of Expense Accounts Alphabetically

null@example.com (seahawk) — Sat, 03 May 2025 16:47:14 +0000

In the Profit and Loss report under General Ledger.

It is normally sorted according to the account number instead of the account name. Account name order in the Expenses just makes it easier to find information to complete the company's Tax return.

It is still grouped by the Classes/Groups/Account, depending on your setup.

Re: Sorting of Expense Accounts Alphabetically

null@example.com (apmuthu) — Fri, 02 May 2025 21:55:03 +0000

Where? In the report? Which report?
Will this sort affect groups' child entries?

Sorting of Expense Accounts Alphabetically

null@example.com (seahawk) — Thu, 01 May 2025 19:45:39 +0000

Is there a way that one can sort the Expense Accounts Alphabetically instead of Account Numbers?