Hello, is there a reason why an oldrecord call wou...
# suitescriptp
Phillip
12/16/2021, 12:39 AMHello, is there a reason why an oldrecord call would not get the field value that was changed? I am tracking it in the logs and it is returning the same value as the newrecord call
b
battk
12/16/2021, 1:04 AMid double check that it isnt something like the record being saved twice
p
Phillip
12/16/2021, 1:13 AMdo you mean like multiple aftersubmit scripts?
b
battk
12/16/2021, 1:14 AMan after submit script would not trigger other scripts
p
Phillip
12/16/2021, 1:16 AMgot it. I am trying to trigger it once a reject is made from a workflow.
Phillip
12/16/2021, 1:17 AMI have tried a workflow action script and an aftersubmit script. The workflow action gives an error that the record has been submitted and the aftersubmit returns the same field values for the old and new records
b
battk
12/16/2021, 1:18 AMwhat does your code look like
p
Phillip
12/16/2021, 1:18 AMvar oldrec = scriptContext.oldRecord;
var rec = scriptContext.newRecord;
var recordId = scriptContext.newRecord.id;
var oldrecordid = scriptContext.oldRecord.id;
var accountchanged = 0;
var recordtype = record.Type.VENDOR_BILL;
var oldrecord = record.load({
type: recordtype,
id: oldrecordid
});
var newapprovalstatus = rec.getValue({fieldId: 'status'});
var paymentneedsfixing = rec.getValue({fieldId: 'custbody_pi_paymentapplied'});
var oldapprovalstatus = oldrec.getText({fieldId: 'status'});
b
battk
12/16/2021, 1:32 AMdepends on the context on that one
battk
12/16/2021, 1:32 AMthe status of a record is set after the record has been submitted to netsuite
battk
12/16/2021, 1:32 AMunless you manually change the status yourself
battk
12/16/2021, 1:33 AMso changes to the status wont be reflected on the oldRecord or the newRecord
p
Phillip
12/16/2021, 1:41 AMgot it. When I try to set the value through a workflow action script I get a record has already been edited. Is there a way I can workaround this error?
b
battk
12/16/2021, 1:42 AMboth oldrec and rec should have the value of the old status
battk
12/16/2021, 1:42 AMyour badly named oldrecord should have the current data
battk
12/16/2021, 1:44 AMin cases where the status field was actually changed by the user, then the oldrec will have the old status while oldrecord and rec will have the new changed status
battk
12/16/2021, 1:44 AMyou probably have to read that very carefully, your badly named variables makes that very confusing
p
Phillip
12/16/2021, 1:54 AMgot it. what about if the status is changed by another process?
b
battk
12/16/2021, 1:59 AMno matter what happens, the oldrecord represents the current state of the record
battk
12/16/2021, 1:59 AMsince you just loaded it
p
Phillip
12/16/2021, 2:00 AMgot it. what about if I remove the record load?
b
battk
12/16/2021, 2:00 AMthen my previous statements stand
battk
12/16/2021, 2:00 AMyou will need an understanding of what i said before
p
Phillip
12/16/2021, 2:09 AMthanks battk. I understand what you mean and I appreciate the help
3 Views