Our client would like to be able to have the customer numbers sorted sequntially instead of literally. For example, he would like customer number L960 to appear before customer L1467. Mas sorts literally with L1467 showing first.
by: Barbara K. | over a year ago | General Enhancements
Comments
I believe the only way is to pad the three digit customer numbers with a zero. This can be done with change utility but may be exceptionally slow if you have a lot of customers.
Another approach is to use the Sort Field which could be loaded pretty easily with Visual Integrator. the Sort field is available most reports and it can be used in lookups as well.