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.

Posted - July 8, 2014. This article has been viewed 1241 times.
Online URL: https://counterpoint.knowledgebase.co/article.php?id=130

Powered by PHPKB (Knowledge Base Software)