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
The Unposted Sales Analysis report includes holds and quotes.
Viewed 1601 times since Mon, Jun 22, 2015
Some AntiVirus applications are known to cause issues
Viewed 239 times since Mon, Nov 9, 2020
Does NCR Counterpoint support WIC?
Viewed 1344 times since Mon, Feb 22, 2016
List of available filters for lookups
Viewed 1613 times since Tue, Jul 1, 2014
Error: Points cannot be redeemed attempting to use a Loyalty Program Pay Code
Viewed 2669 times since Mon, Aug 24, 2015