Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
URGENT How to create bank deposit with SuiteScript when there are too many lines
I am trying to create a bank deposit using
recObj.findSublistLineWithValue({
sublistId: 'payment',
fieldId: 'id',
value: transactionId
});
However the deposit has so many lines it cannot find the transaction.
In the UI when I create a deposit there are over 10,000 lines and the transaction I'm looking for isn't in any of them. If I put dates in From and To it shows about 2,000 lines and I can find the transaction.
I can't find a way to set those dates with SuiteScript. The field id for both From and To is Transaction_TRANDATE and setting a date there doesn't help.
I have tried: