Suitescript - How do I access the values in “Subsidiaries” sublist on vendor record?

Question

On the vendor record, I need to loop over the Subsidiaries sublist through a scripted search, to get all of the values. I am specifically trying to find vendors that do not belong to a particular subsidiary.

UPDATE

To clear up my question, I was trying to access the Subsidiaries sublist and not the actual primary subsidiary. However NetSuite said that this is currently not possible and is a requested enhancement.

Answer 1

bluejay92, the vendor search has a join to the subsidiary record, see attach screen shot. You can even check "use expressions" to gain access to the NOT function in the criteria.

Answer 2

Workaround:

1 - Create a user event script that runs after the record is created/edited.

2 - Have the script load the record, get the subsidiaries and create a custom record to save the info so you can search it later.

3 - Export all vendors internal ids in 1 column. Run a CSV import of vendors and map internalid csv column to internalid field to trigger the user event script and populate the custom records.

Extra tip: Make sure the script does 'upserts' to the custom record to avoid duplicates. There should be one record per vendor.