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!
How to search Customers who are connected to a particular partner (even not primary)?
Good morning,
In my account I've enabled the multi-partner management.
Now I need to create a search to find all the customers that, in the "Partners" subtab, have a particular partner, even if its contribution is 0%.
I cannot find any way to do that, I've tried:
1) search by Customer, with
- criteria: Partner fields -> Internal ID = [ID of the partner]
2) search by Partner, with
- criteria: Internal ID = [ID of the partner]
- results: Customer fields -> Internal ID
3) search with a script:
- oRecPartner = nlapiLoadRecord('partner', [ID of the partner]);
- nCustomersCount = oRecPartner.getLineItemCount('customer');
No one of these solutions is working at all.
0