[bsullivan]

We changed to auto generated numbers for our customer records because I needed to have duplicate company names. We now have some customer records with names, some with short numbers, and some with long 10 digit numbers. Is there a way to change these to all short numbers. We have about 120,000 records.
This is a cached copy. Click here to see the original post.

[torin@aminian.com]

I would export all of your existing customers and set their customer ID’s in excel. Re-import the customer records to set their new ID’s then turn on auto-generated numbers and start the sequence from the next highest number.

[bsullivan]

I tried this on a small set of records and it doesn’t work.

[torin@aminian.com]

Do you have the allow override checkbox checked under setup>company>auto-generated numbers?

[bsullivan]

Yes, the override checkbox is checked but it has no effect . I can do this on our vendors records with no problem but not on customer records. By the way you said to turn on auto-generated numbers after the re-import but you can’t have the override checkbox checked when auto-generated numbers is off.

[torin@aminian.com]

That’s strange that you are unable to set the customer ID via CSV import. Make sure that you are mapping the fields: internal ID and customer ID during the import.

I should have been more clear in my response. You do not need to actually turn auto-generated numbers on after setting the customer ID’s for your current customer records. But after setting the customer ID’s you do need to set the initial number and click save on that page.

[bsullivan]

I have tried re-importing new IDs with both auto-generated off and auto-generated on with the override box checked. I don’t get any errors but the IDs never change.

[bsullivan]

So do we have to live with this strange assortment of ID’s?

[torin@aminian.com]

This should not be an issue for you as I have done this before and just recently tested it. Use suite answer article 41339 to double check the steps you are taking. I would get in contact with NetSuite support and tell them you think you’ve found a defect. Walk them through the steps you are taking and once they see that it does not work they should file a defect.

[bsullivan]

The steps in the SA article are very simple. This works for vendors but not for customers in our account for some some reason. I’ll try it again tonight when everyone is logged out.

[Author]

Posts