CSV import to update check box in vendor records

Requirement: Client wants create a check box in vendor record and it should be checked only for specified vendors.

solution: We need to create CSV file with vendors internal ID and name.This list includes those specified vendors whose check box needs to be marked.

  1. Navigate to Setup Import/Export Import CSV Records
  2. Import Type: Select Relationships
  3. Record Type: Select vendors
  4. Click Select
    Note: Select CSV file. 
  5. Click Next
  6. Data Handling: 
  7. Update: Enter Bullet
  8. Click Next
  9. Field Mapping: Name,Internal ID,
  10. NetSuite Fields: Click Individual(select Check box field name)
  11. Click Pencil icon
  12. Yes: Enter Bullet
  13. Click Done
  14. Click Next 
  15. Import Map Name: Enter Import Map Name
  16. Click Save & Run

Leave a comment

Your email address will not be published. Required fields are marked *