Reference numbers sort as text instead of numbers in bank/cash transactions

Under Cash Transactions and Bank Transactions tabs, the reference column is sorted as text rather than numbers.

For example, instead of 1 - 2 - 4 - 10 for an ascending sort, you get:


By contrast, in the Sales Invoices tab, the same sequence sorts as numbers:


I have not checked other places where this problem might exist.

EDIT: After further thought, it occurs to me this might be by design, to allow sorting of references if alpha characters are included. This could be important for bank transactions, since the user has no control over a bank’s reference content.


Fixed in the latest version (18.1.93). A few other tabs were suffering from the same issue so it’s there fixed as well.

1 Like