Item / Customer numbers are not sorted in proper numeric order

Home » Categories » NCR Counterpoint » Point of Sale

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.

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Does NCR Counterpoint support WIC?
Viewed 1397 times since Mon, Feb 22, 2016
What causes cost corrections to be created in Counterpoint?
Viewed 1574 times since Thu, Mar 14, 2019
"ErrorMessage=ACCOUNT ONLY SUPPORTS ENCRYPTED OR TOKENIZED DATA" when using a Bluefin device
Viewed 700 times since Wed, Oct 30, 2019
Ticket date is outside allowable range error when posting tickets
Viewed 2065 times since Mon, Jan 7, 2019
8.5 - OLE error ######## in Ticket Entry/TSTE, or when editing TSTE codes
Viewed 1571 times since Wed, Jun 27, 2018