Let's analyze this table for import as an example:
|Disney||Donald||Duckemail@example.com||123 Main Street||Orlando||Florida||
|Universal||Harry||Potterfirstname.lastname@example.org||905 Young Street||Orlando||FL||US||Net 30|
|Mi6||James||Bondemail@example.com||100 Church Street||London||UK||Net 60|
|N/A||Katy||Perry||kphotmail.com||102 7th Ave||New York||NY||USA||Net 15|
The values in the country field need to be changed:
- United States is named three different ways and these need to be changed to the value in NetSuite, which is United States.
- UK has been set up in NetSuite as United Kingdom, so the source data needs to be ...