Hi everyone,
I am manipulating an invoice aftersu...
# suitescriptm
Menno Janssen
10/07/2021, 12:49 PMHi everyone,
I am manipulating an invoice aftersubmit and changing tax codes. However on large transaction the record.save() operation never succeeds and eventually the page times out.
Attached is the code and the result in execution logs. Any hints on how to investigate/resolve?
t
tuli
10/07/2021, 12:54 PMAre you loading the record in standard mode? I feel like the standard is faster than the dynamic mode.
m
Menno Janssen
10/07/2021, 12:55 PMYes. record is loaded in Standard Mode. (not explicitly but default without setting 'IsDynamic')
b
battk
10/07/2021, 3:08 PMthe slow unfavorable answer is find out what is causing the slowness
battk
10/07/2021, 3:08 PMstart by making your script edit and save the invoice without making any changes
battk
10/07/2021, 3:09 PMif its still slow, the amount of data is not the cause
battk
10/07/2021, 3:09 PMif that fails, then you want to work out how many lines you have to modify to cause the error
battk
10/07/2021, 3:10 PMyou may also want to see if modifying different fields on large numbers of sublists cause the problem
battk
10/07/2021, 3:11 PMthen go to netsuite support with details to see if they have a better answer
battk
10/07/2021, 3:11 PMif you are very lucky, the answer is something simple, like your settings for enableSourcing or ignoreMandatoryFields is causing issues
s
suiteExperimenter
10/12/2021, 2:37 PMWhat do you mean large? Many line items? Does your script also do something with them?
m
Menno Janssen
10/12/2021, 2:39 PMMany line items yes. 600+ where I set some suitetax fields to a different value. it does not consume Netsuite script points per line however
s
suiteExperimenter
10/12/2021, 2:53 PMI think Map Reduce is the answer. Trigger it on afterSubmit.