A user identifies the need to improve data accuracy in a business form or record. For example, in an invoice record the custom field was originally set to Free-Form Text, which allowed inconsistent or incorrect entries. To enhance data consistency and ensure only numerical values are entered, the user updates the Field Type to Decimal Number. However, when updating the field via the Field setup all existing data on that field will be lost.
In order to prevent this, a workaround you may do is to use CSV Import. You can follow steps below:
A. Export the values of Custom Transaction Body Field using CSV Export:
1. Navigate to Transactions > Sales > Sales Orders > List
2. View: Select Default
3. Click Customize View
4. Search Title: <Enter your Search Title here>
5. Click Results
6. Field: <Select desired custom Transaction Body Field>
7. Click Save
8. CSV icon: Click Export – CSV
B. Change Field Type of the Custom Transaction Body Field:
1.Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields
2. Custom Transaction Body Field > Edit
3. Type: <Select Preferred Type>
4. Click Save
C. Review the values in the CSV Import file so they match the new Field Type:
1.Open the exported CSV file from Step 1.A
2. On the column with the custom Transaction Body Field for which the Field Type changed, change the values so they match Field Type from Step 3.B
Before:
After:
3. Save the changes
D. Perform CSV Import to import the values for the affected Custom Transaction Body Field:
1.Navigate to Setup > Import/Export > Import CSV Records
2. Import Type: Select Transactions
3. Record Type: Select Sales Order
4. Click Select... button and choose the file that was exported in step A.8
5. Click Next
6. Choose Update
7. Click Next
8. In the list of fields to be mapped, click at X next to all the fields except:
- Internal ID
- <Custom Transaction Body Field that you changed the Field Type for>
9. Click Next
10. Click Run
Result:
The custom field type is now changed without losing its existing values.
To our members! Have any of you given this customization a whirl? Don’t keep your thoughts to yourself—spill the beans! Your insights could be a game-changer for us and our fellow experts.
You can also check out the following SuiteAnswers on CSV Import for Custom Fields:
SuiteAnswer 68537: Update Sales Rep Field on Customer Record Using CSV Import
SuiteAnswer 34303: Update Field with Leading Zeros via CSV Import
We value your input! Share your thoughts or experiences in the comments or join the conversation in the NetSuite Admin Corner. Let’s continue this journey of learning together!