 Posted 6/8/2011 8:46:23 AM
|
|
|
|
Hi, Thankfully not having this problem yet, but it is sure to come up sooner than we think. Currently running Interprise 5.1 with AspDotNetStorefront. I know that SalesOrderCode, CustomerCode, and ItemCode are all nvarchar(30), but they are auto-populated using a format of SO-000000 (or CUST-000000, or ITEM-000000) - in other words, all have only six digits for uniqueness. I know there are other such fields as well, like Invoices, etc. Right now, my client's site is doing about 80 thousand orders per year (including tests, failures and so on), with probably 100 thousand customer records per year, and this number is growing.
So I'm wondering, what is going to happen at , for instance, order number 1 million? The db field clearly has room for more characters, but what is the internal logic for generating the codes? Will the digits potion jump to 7 or more digits? Should I be worried about this? Anyone gotten there yet? (I assume so).
Thanks,
Ian
|
|
|
Posted 6/8/2011 12:11:23 PM
|
|
|
|
| Ian, None of our customers have gone over the limit with the six characters but you can change this to be greater than six. First thing I would do is make a copy of your data as a testing dataset. I would do some testing in the test database before doing this into your live system. Go to System Manager -> Utilities -> Setup -> Auto Numbering. From there select the customer tab, inventory tab, etc. All the tables that get auto generated numbers exist on this form. Locate the table you wish to update and update the 'Number Width' column (should be sitting at six). You can go as high as nine in this field (will receive a warning if you go higher). Once the changes are in place, remember to save your changes. Log out of IS and back into IS so the cache is reset (even if you arent using web services). Realize that now the numbers could look like SO-000000000 so the new numbers will start to show up on the bottom. Again please test this first before applying it to your real database. Hope this helps.
BJ Dimes
Software Development & Support Engineer
DimeSoft Business Solutions, Inc.
Interprise Suite Plugins
Interprise Suite Blog
|
|
|
Posted 7/29/2011 8:38:43 AM
|
|
|
|
|
|
|
|
