In our external system where we get our purchases and sales data for at least 2 of our subsidiaries, a Vendor may have 2 or more IDs (one for each Subsidiary). It's already like this before we include them in our NS instance. And I was told that it would be unlikely that we can change these IDs.
In NetSuite, the Vendor is created as one record (multi-subsidiary Vendor). Apparently, we can only assign one External ID per record.
I'm just wondering if it's possible to assigning multiple IDs in NS through scripting or my other means, so that we load out purchases and sales data, NS knows that CUS01, CUS02, CUS03, etc. are all the same and pertain to a single record, say CUS01. Basically, it's a many-to-one relationship (external system to NS).