SO Number Series re-order

Our customer’s number series was set up as SOxxxx. When the customer hit SO9999, the number of course incremented to SO10000. Now these SO’s float to the top of any list. Is there a way to continue this progression, or to start a new number series so the latest sales orders will appear at the bottom of the list?

Hi, Either you can add suffix (like A,B…) in the existing No. Series or you can create a new no. series.

Hi, Suffix the number series with something after or from the the alphabet ‘S’. This should work!!! Regards Akshay

hi, Either have to rename all existing old Order, Shipped and Invoiced records or have to start with new series otherwise uniqueness of records not be available and can not create same no. better to use new Series with some series. Regards Rakesh

Placing a dash in the number series worked fine, and made it a little more logical. So SO10001 was changed to SO-10001. This moved the line items to the bottom. However, this did not change it on the live install. We tested on a a Navision database, the client is on SQL. Obviously this makes a difference?

quote:


Originally posted by Hub Gilbert
Placing a dash in the number series worked fine, and made it a little more logical. So SO10001 was changed to SO-10001. This moved the line items to the bottom. However, this did not change it on the live install. We tested on a a Navision database, the client is on SQL. Obviously this makes a difference?


SQL has a different Sort Order to Native ! [V]