Let's analyze this table for import as an example:
|Disney||Donald||Duckfirstname.lastname@example.org||123 Main Street||Orlando||Florida||
|Universal||Harry||Potteremail@example.com||905 Young Street||Orlando||FL||US||Net 30|
|Mi6||James||Bondfirstname.lastname@example.org||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 ...