Skip to Content

Item / Customer numbers are not sorted in proper numeric order

Summary:

Item and Customer numbers are not sorted in a proper numeric order.

Cause:

This is correct behavior.

Solution:

This is an alphanumeric column, so it will not be sorted in proper numeric order. NCR Counterpoint uses SQL to sort the column, for example:
11
112
113
12
122
123
13

As a workaround, the items or customers can be renumbered (using the Renumber utility) so that there is a leading zero if front of the number, for example:   011, 012, 013, 113 etc.  This will allow numbering to appear in correct, ascending order.

Item / Customer numbers are not sorted in proper numeric order
  • COMMENT