Team, I am having an issue related to the 10000 limit on sublist records. I am loading a record via suitescript and it only loads 10000 sublist records and my script fails to find the sublist record I am interested in. It seems to load the most recent 10k records, so I am wondering is there is a way to sort the sublist records somehow via suitescript to load the older records first, I have not found a way to do this. One thing that is interesting when manipulating the sublist on the UI is that if you sort by date, it seems that the sublist is reloaded with the different sort order and loads the missing records on the initial load. I am wondering if there a way to mimic this via script. Thanks!

Are the sublist records you're talking about "child" records?

usually you can use default values to limit the apply sublist to the lines you want

@battk but the default values will find the record within the 10000 records loaded, if you try to find a record that is not on those 10000 records, it will not find it

use the

invoices

default value to limit which invoices are on the invoices sublist

sorry @battk don’t understand what you mean. Remember, I am trying do to this via suitescript, not on the UI

record.load has a default value parameter which can be use to initialize the record

oh, cool

its an array in suitescript, csv in the url

sounds great. I am actually doing a record.transform, but I think the default values work the same, right?

in this case yes

cool, I am going to try it now, thanks a lot

Hello @battk sorry to reuse this thread but I'm having the same issue in a vendor payment. Tried different defaultValues names but all of them failed (bill, bills, invoices). Do you know how this could be achieved? Thanks in advance

are you trying to load a customer payment or transform?

Transform from Vendor

I think on the transform you can use the “invoices” param

I'm doing this:

let payment = Record.transform({fromType: Record.Type.Vendor, toType: Record.Type.VENDOR_PAYMENT, fromId: 23, defaultValues: {invoices: 6745527}})

fromType: Record.Type.VENDOR hopefully. Maybe that should be an array despite being a single value for invoices?

Yes, VENDOR is in uppercase in my code, sorry

I wonder if there are other defaults you need to set too, such as entity / account...

okay, for a Vendor Payment I think the params could be “bill” or “vendorbills”

run

console.log(nsServerCall(nsJSONProxyURL, "getRecordTypes"));

in the console of a page that supports suitescript

also keep in mind the Bills must have the same currency as the Vendor Payment

pay extra attention to the normal initialized defaults vs the transformed defaults, using record.transform means you pick from the transformed defaults

Awesome @battk , where did you get this from?

suitescript's client side code uses the nsapiGetRecord function to tell if an operation is supported or not

Great! Thanks!