This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Has anyone had any experience using SuiteScript to manipulate native sub-list data? 

Specifically, attempting to locate an invoice that is not located within the first 10,000 in the Customer Payment “apply” sub-list. 

If I could filter the sub-list, or even sort by date, that would get me where I need to be. 

Any insight is greatly appreciated! 

you would need to use <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4267258059.html|defaultValues> to limit the number of invoices that appear in the apply subtab

for customer payments, the usual choices are the `invoices` or `inv` default values

default values also work as query parameters in the url, so i usually advise trying them out in the ui while creating a customer payment to see what they do