Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
NetSuite Admin Tip | Update Field Type for Existing Custom Field
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:
In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the most out of their NetSuite journey. Click here for more details.