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
Some AntiVirus applications are known to cause issues
Viewed 1002 times since Mon, Nov 9, 2020
List of available filters for lookups
Viewed 1854 times since Tue, Jul 1, 2014
The Unposted Sales Analysis report includes holds and quotes.
Viewed 1869 times since Mon, Jun 22, 2015
"ErrorMessage=ACCOUNT ONLY SUPPORTS ENCRYPTED OR TOKENIZED DATA" when using a Bluefin device
Viewed 1094 times since Wed, Oct 30, 2019
Error attempting to print / preview from Counterpoint: Not Implemented
Viewed 2249 times since Thu, Sep 28, 2017