Update the Can be Fulfilled/Received Field on Service andNon-inventory Items Through CSV Import

Note: Once the particular item has been added to transactions, this setting cannot be changed.

 

To update the Can be Fulfilled/Received field on item records without any existing transactions, perform the following steps:



First part is to create an item search.

Note: Before proceeding, navigate to Home > Set Preferences > General tab > Defaults section and check Show Internal IDs.

     1. Navigate to Lists > Search > Saved Searches > New.
    
     2. Select Item.
    
     3. In the Criteria tab > Standard subtab, add required filters.
          For example:

·         Type is Non-Inventory Item

·         Can be Fulfilled is Yes (True)

     4. In the Results tab > Columns subtab, add the Can be Fulfilled field.
    
     5. Click Preview.
    
     6. Click Export - CSV.
    
     7. Save the CSV file.
    
    
Second part is to update the CSV file.

     1. Open the saved CSV file.
    
     2. In the Can be Fulfilled column, change the value to No.
    
     3. Save the changes.
    

Third part is to use the updated CSV file for import.

     1. In NetSuite, navigate to Setup > Import/Export > Import CSV Records.
    
     2. Select Items in the Import Type field.
    
     3. Select the Record Type (e.g. Non-inventory Item for Sale).
    
     4. Click Select.
    
     5. Locate the CSV file then click Open.
    
     6. Click Next.
    
     7. Select Add for Data Handling.
    
     8. Click Next.
    
     9. In the Field Mapping section, use the following:    

     

     10. Click Next.
    
     11. Provide an Import Map Name.
    
     12. Click Save & Run.

Note: Internal ID would be enough as an identifier for the Item Record. Display Name/Code Field is only necessary if you are to change the Display Name/Code field value.