ITEM GRID SORTING LOGIC
On item grids, such as Payments, Contacts, Matters, Payment Distributions, Etc. There is a logic to the way the items pull up. You will notice that when you first access one of these grids that it shows the first 500 items followed by a 'Find All' button.
These grid results are sorted Alphabetically by 'Name'.
*Note* Your database may show different terminology for 'Name'
It should be noted, that this alphabetical sorting does use numeric alphabetical string logic. For example, if you have numbers in your Item Name, they will appear first and the numbers themselves will appear in numerical order, see the two examples below.
Example 1: The number 001 comes before 234 due to the 0 and the 2.
Example 2: You have 234, 5, 721 you will notice that due to the first digit, it goes in the order of 2, then 5, then 7.
*Note* This order stays the same even when 'Find All' is selected.