Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Can you join on internalid for customer on a custom record?
I have searched and found a few older posts that suggest the following code should work:
var arrFilters = [];
arrFilters[0] = new nlobjSearchFilter('internalid','customer','anyof', CustomerID);
var searchResults = nlapiSearchRecord('customrecord_profile',null, arrFilters, null);
I've also tried using the custom field name (custrecord_customer) as the second value in the search filter. I keep getting the following error:
An nlobjSearchFilter contains an invalid join ID, or is not in proper syntax: internalid.
I can't believe that it isn't possible to connect a customer to a custom record that has to be a function that is well used. I am limited to using SuiteScript 1.0 so I can't use any 2.0 solutions.
0