We have an issue as a result of Set Up Auto-Generated Numbers being "Updated" as warned, but ignored...."Record numbers for Entities, cannot be reverted back to names after update. If you check Update, a number is assigned to each existing record of that type, and the name is stored in the Company Name field.
Prior to this "Update" our Customer's "Name" field was empty & not visible. The "Company Name" field Is where we entered & stored the company name. The Customer ID field used the "ID" and appended the Company Name into the Customer ID field.
Standard Customer form with all fields Show = Yes
Before any changes while selecting a Customer for an invoice:
The ID, Parent:Company Name is visible in the suggested drop down list.
Before when Global searching by the customer's ID
After Set Up Auto-Generated Numbers = Allow Override & Update
We want to update the "Customer ID" field to display both the Customer ID and the Company Name.
We now have set the Set Up Auto-Generated Numbers to Allow Override.
We have tested .csv update to the Company Name field, hoping the Customer ID field would append the ID & the Company Name.
The result is the "Name" field is populated, which is appended to the ID in the Customer ID field. This "seems" ok but the reporting is now different.
Reporting Before Setup Auto-Numbering Update. The ID field returns only the numeric ID value.
After the Auto-Numbering Update and .csv import to the Company Name field, The ID field returns the numeric ID value & the Name/Company Name field .
After the Auto-Numbering Update and .csv import and selecting a Customer for an invoice:
The Company ID, Parent:Company Name is visible in the suggested drop down list.
I have read through Customer IDs showing instead of Customer Names and tested in my Dev environment but the Customer ID does not update to append the ID and Company Name. I tested this in my Development Environment (screen shot below)
Has anyone found a way to get the Customer ID to update/fix to the native NetSuite behavior, appending the ID and Company Name into the Customer ID field?
I think what would get me closest would be to .csv update the "Name" Field ID: altname but it is not available for .csv update.
Thanks.