Hello,
I'm missing something and have invested countless hours repeating myself in slightly different ways trying to import a purchased company/contact list.
1. I imported the companies (Customer Auto Number was on). Each company connected one contact during this import.
2. I tried importing the contacts separately using the company name to match the records. The company names should match as it was the same file used for both imports. This did not work.
3. I tried turning off the Auto Number thinking it was changing the company names. This did not work either.
Was the mistake made importing the Company/Customer names with Auto Number?
The error I'm getting is: "Invalid Company reference key"
Something is causing the exact same company name used in the same list to not match up properly in NS to compliment the Key need to bind the records.
It's 12,055 records I can't exactly copy and paste matching Internal ID's.
I'm thinking I'll have to create an external ID, update the current Customer/Company records with the ID and once that exist use it to update the contacts using the contacts External ID? Will that match, or is the External ID of the Contact different from the External ID of the Customer/Company?
What's my best option or what am I missing?
Thanks
Derek