We are encountering an issue when there are more than 10,000 open vendor bills for a single vendor. When I attempt to apply a vendor prepayment using a vendor prepayment application or vendor credit to a vendor bill, the apply sublist of the vendor credit or vendor prepayment application transaction will only have the first 10,000 vendor bills. For example, when I execute the SuiteScript

Record.getLineCount({fieldId: 'apply'})

on a vendor credit, it returns 10,000 when there are more that 10,000 open vendor bills. Has anyone found a workaround or solution for working with more than the 10,000 sublist limit? Is there a way to filter the sublist in SuiteScript 2.x?

hmm can you use

Record.findSublistLineWithValue

, to return a line number that you can then use to set apply = true? no idea if it will work if the line isn't in the first 10,000 lines though might just return -1 for not found

@Anthony OConnor, I am using

Record.findSublistLineWithValue

now to find lines. If the vendor bill is not in the first 10,000, it returns -1.

okay, so then that's how they're doing it in the UI? is there a predefined filter that they have? like date = this month or something?

On the sublist tab, you can select the Customize button, which shows a screen where you can select one or more filter criteria. These then appear as fields on the sublist tab.

yeah.. once you set it

Where do you set the form?

record setValue customform = custform1234

interesting

maybe there's something to explore there? I'm not hopeful though tbh, this all sounds kind of insane 😂

Thank you. I like insane. Most of what I have to do to work around NetSuite’s hard limitations is insane 😄

i mean this is true, this is why we get paid 😉

Shipping / Freight forwarding industry

ahhh yeah okay, I can see that

for your vendor credit, you can use the

vendorbills

default value to limit the lines in the apply sublist

@battk, what do you mean by

vendorbills

default value?

Thanks. I will give it a try.