Netsuite - Invalid Sublist operation / Apply list limits

Integrator.io
1

Hi there,

When creating Bill Payments (sometimes called Vendor Payments) they need to be applied to a bill. There is a technical limitation in the Netsuite API where the 'apply list' (which is a list of possible bills that the bill payment can be applied to) is limited to the first 10,000 bills. If the bill to apply it to is not in that list, then it'll fail.

I’ve read hints of conversations suggesting the Apply List can be filtered in advance, however I haven’t successfully managed to do so.

We have available the internal ID and various other references of the Bill we want the Bill Payment to apply to.

For Customer Payments we had a similar issue, but worked around it by creating the cash payment without applying it to anything, and then updating the invoice. This isn’t possible with Bill Payments unfortunately.

Anyone successfully worked around this problem?

I appreciate this could be avoided by not having >10000 open bills on a vendor, but that is what we’re dealing with…

Thanks for your help!

2

Hi Andy! Thank you for reaching out. As for your concern, could you answer a few questions so we can narrow down the issue and provide you with better assistance?

  • How are the Bill Payments created? Are you using a customized flow or a pre-built application from the Market?
  • If so, which endpoints are you using for this flow, or which pre-built application are you using to create the payments?
  • You mentioned that you heard suggestions of having an Apply List and trying it on your own. What methods have you used so far, so we can remove them from the troubleshooting steps?
  • Have you tried using a Saved Search instead to filter down the Apply List?

Thank you, looking forward to hearing back from you.

3

  • How are the Bill Payments created? Custom flow

  • If so, which endpoints are you using for this flow, or which pre-built application are you using to create the payments? Snowflake import → Netsuite export

  • You mentioned that you heard suggestions of having an Apply List and trying it on your own. What methods have you used so far, so we can remove them from the troubleshooting steps? All of the import fields are correct. I have mapped them to the correct export fields. We know this because the flow works for other vendors who do not have so many open bills. We’re using the dynamic flag.

  • Have you tried using a Saved Search instead to filter down the Apply List? No - can you explain how to do this? That was one of the topics I mentioned I would like to know how to do.

Thank you for your help

4

Hi Andy,

Regarding the Saved Search, you can try using ‘Lookups’ to help load the Saved Search and narrow down the bills that you would like to apply. Here’s an article that you can use to learn more about the lookup step: Lookups and results mapping.

If you are building a customized flow, you can also join our Office Hours.

Thank you, looking forward to hearing back from you.