Sorting Client IDs by True Numeric Order

When I click on Open a Client in Accounts Receivable, I get a list of all clients in our system, but their client IDs are not in true numeric order. For example, client IDs 18, 2, 20, 202774, and 21 are consecutive numbers when I sort by Client ID. It would be great if these numbers were in counting order, where 9 is not at the end of the list but in the ninth position.

  • Guest
  • Apr 7 2021
  • Needs review
  • Attach files