In the UI, when you are trying to "apply" something (eg a deposit to an invoice), NetSuite allows the user to set up filters, in case the list is very long. Is there any way to execute a dynamic filter in script. The reason is that I have a scenario where there will be more than 10,000 potential items that can be applied, and since the sublist limits you to 10,000, I sometimes don't find it in the array via script.

this sounds like a customer payment, in which case i recommend the use of a default value to filter the sublist

I was just explaining the concept in general. In my case, I'm actually trying to apply a payable to a vendor payment, but we have more than 10,000 lines of payables from some custom transactions.

same concept,

vendorbills

default value

I'm sorry, but I don't think I'm following. What do you mean with "vendorbills" default value?

default values are used to initialize a record

how many values can I provide? I'm sometimes looking for hundreds or thousands of entries to apply ... but only some of them are outside of the 10k limit

however many you think is sane on a sublist

well, a sublist that won't be edited by a human, but only by script, can be sane even with 10000 entries 🙂

you are unlikely to be able to filter more than 10k lines, nor get that transaction created in the first place