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.
Article ID: 130
Created: July 8, 2014
Last Updated: October 1, 2014
Online URL: https://counterpoint.knowledgebase.co/article.php?id=130