SCENARIO

The user wants to change the Custom Form of an Item Record via CSV Import.

SOLUTION

Changing the custom form of existing Item Records via CSV Import is still not possible in NetSuite. As a workaround, the following may be performed:

1. Select your preferred Custom Entry Form e.g. Inventory Part form
2. Ensure that the Store Form With Record checkbox is ticked
3. Perform aCSV Importthat will:
   • Add a new field that does not exist on this form and update this field with a value via CSV Import; OR
   • Update the value of at least one existing field in this form e.g. Description

NOTE: Changing the Form on the Advanced Option and just mapping the Internal ID will not make the workaround work successfully. You have to update a value on at least one existing or new field in the item record to make it work.

To perform the CSV Import:

1. Create a CSV file with the items' Internal ID and Description(slightly make a change on their descriptions)
2. Go toSetup>Import/Export>Import CSV Records
3. On theScan & Upload CSV File> set:
   • Import Type: Item
   • Record Type: Inventory Part (or as applicable)
4. ClickSelect> upload CSVfile created.
5. ClickNext.
6. OnImport Options>Data Handling> selectUpdate
7. ClickAdvanced Options > on Custom Form field > select the custom form you would like these items to use moving forward.
8. ClickNext.
9. OnField Mapping> Map your Excel Internal ID with Netsuite Item: Internal ID and Description with Item: Description.
10. ClickNext.
11. Enter anImportMapName.
12. ClickSave & Run.

Result: The process above should be able to update the existing Custom Form used by the Item Records.