HI,
Ive got a saved search in my netsuite account that retrieves transactions.
The search runs really nicely, however I would like to apply a filter that retrieves the transactions by a customer with the internal ID for that customer.
Right now, my filters have been very easy as ive just been leveraging off the internal ID of the main record, but in this case I need to get all sales orders that are aligned to a particular customer.
When editing the search, I do the following.
1. Chose Customer Fields and get the internal ID for the customer
which then appears like
Customer Fields : Internal ID
My script however needs to have a filter that replicates this.
filter[0] = new nlobjSearchFilter('type', null, 'is', 'salesorder');
filter[1] = new nlobjSearchFilter('Customer Fields : internalid', null, 'is', 'salesorder');
However this fails.
Im hoping someone out there knows how to make a saved search filter on the additional fields.
thanks in advance