Sorting out Column by number. ascending I get 100, 101… and descending 99,98… would be nice if it was sorted from 1-125. thanks [11] [22]

I understood what was being said. But everywhere I looked in the program, numbers sorted as numbers. That’s why I asked @cometomama where the example came from. What Code column on what report is being sorted? I don’t doubt it’s happening, I just don’t know where.

As far as I can see, it’s the code column in the Customers listing. Which is alpha numeric in order to give the user the possibility to also use letters. For instance R999. So the best solution is to use it at such. Change the number format. So 1 should become 001 when 999 is your highest number.

My example was created using the Inventory Items code field.

[image] Brucanna: A more permanent fix would be to convert the field to being numeric instead of alpha. My mistake, I assumed he was using a custom field somewhere.

This is happening with the Reference # field in Cash Transactions now. [manager6]

What are you saying is happening? Manager sorts that screen based on date first and reference number second. What do you think is wrong? Or do you think anything is wrong?

the screenshot shows @Eagle5 trying to sort the reference number # . note the upward arrow beside it. but looks like the reference number is programmed as text and not numbers.

If you are suggesting that because the arrow points up the reference numbers should be in opposite order, you are raising an issue that was discussed a year or two ago on the forum. You can find conflicting references and standards on web and application design as to whether an upwards pointing arro…

i believe the issue is as simple as the numbers not arranged properly in ascending or descending order. i checked with the Cash Transactions tab and it does actually appear to be sorted as text. its not sorted as 1 - 2 - 3. instead 1 - 10 - 100 - 1000.

OK. The problem is that @Eagle5 ’s example does not actually illustrate the problem, because 1 - 10 - 100 - 1000 is in numerical order. But you are correct. Under Cash Transactions, the reference column is sorted as text. Instead of 1 - 2 - 4 - 10, you get: [48%20PM] Sales Invoices, however, sorts …

Sort by Number

Tut April 12, 2018, 1:33pm 19

Update your software, @cometomama. This was addressed in v 18.1.93: Reference numbers sort as text instead of numbers in bank/cash transactions.

Topic		Replies	Views
Numeric Sorting of references	8	598	January 16, 2019
Sort function does not work properly	19	818	November 27, 2021
Wrong behavior of the reference field	20	794	October 29, 2022
Suggestion for additional custom field types	18	2185	July 31, 2018
Reference Number Sorting	6	844	November 15, 2022

Sort by Number

Related topics