Gurudeep Naik
11/20/2023, 1:23 PMvar rec = record.load({
type: "salesorder",
id: "192571",
isDynamic: true,
});
rec.setValue("custbody_rr_startnewcontract", true);
rec.setValue("custbody_rr_contractpaymentmethod", "3");
rec.setValue("custbody_rr_billdaysinadvance", "15");
rec.setValue("opportunity", "192471");
rec.setValue("cseg_property", "218");
rec.setValue("custbodytransactionunit", "8100");
rec.setValue("entity", "1666");
rec.setValue("memo", "testing");
rec.setValue("custbody_agreement_tnumber", "5581");
rec.setValue("custbody_rr_contract_billing_day", "10");
rec.setValue("salesrep", "8");
rec.setValue("department", "4");
rec.selectNewLine({ sublistId: "item" });
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "line",
value: "1",
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "item",
value: "29",
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "rate",
value: 700,
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "quantity",
value: 1,
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "amount",
value: 700,
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "cseg_property",
value: "218",
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "cseg_unit",
value: "8100",
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "department",
value: "4",
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "description",
value: "Testing",
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "custcol_rr_startdate",
value: new Date("2023-11-10T13:34:03.237Z"),
});
// rec.setCurrentSublistValue({
// sublistId: "item",
// fieldId: "custcol_rr_firstbillingdate",
// value: new Date("2024-11-10T13:34:03.237Z"),
// });
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "custcol_rr_nextescalationdate",
value: new Date("2024-11-01T13:34:03.237Z"),
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "custcol_rr_escpercent",
value: "3",
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "custcol_rr_escperiodmonths",
value: "12",
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "custcol_rr_contractendoftermaction",
value: "4",
});
rec.setCurrentSublistValue({
sublistId: "item",
fieldId: "custcolagreementline",
value: "5581",
});
rec.commitLine({ sublistId: "item" });
var recordId = rec.save();
any one knows why am i getting this error
{"type":"error.SuiteScriptError","name":"TRANS_UNBALNCD","message":"Transaction was not in balance. Total = 700.0","id":"","stack":["anonymous(N/serverRecordService)","_put2(/SuiteScripts/RestLet_Crude_Operation.js:333)"],"cause":{"type":"internal error","code":"TRANS_UNBALNCD","details":"Transaction was not in balance. Total = 700.0","userEvent":null,"stackTrace":["anonymous(N/serverRecordService)","_put2(/SuiteScripts/RestLet_Crude_Operation.js:333)"],"notifyOff":false},"notifyOff":false,"userFacing":false}
Error: Error: {"type":"error.SuiteScriptError","name":"TRANS_UNBALNCD","message":"Transaction was not in balance. Total = 700.0","id":"","stack":["anonymous(N/serverRecordService)","_put2(/SuiteScripts/RestLet_Crude_Operation.js:333)"],"cause":{"type":"internal error","code":"TRANS_UNBALNCD","details":"Transaction was not in balance. Total = 700.0","userEvent":null,"stackTrace":["anonymous(N/serverRecordService)","_put2(/SuiteScripts/RestLet_Crude_Operation.js:333)"],"notifyOff":false},"notifyOff":false,"userFacing":false}
and Below is the Sales Order I am Trying to UpdateGurudeep Naik
11/20/2023, 1:24 PM// rec.setCurrentSublistValue({
// sublistId: "item",
// fieldId: "custcol_rr_firstbillingdate",
// value: new Date("2024-11-10T13:34:03.237Z"),
// });
I am Getting a Different Error Which is
{
"type": "error.SuiteScriptError",
"name": "JS_EXCEPTION",
"message": "Error: Error calculating initial billing period amount for transaction/contract line with start date: Fri Nov 10 2023 00:00:00 GMT-0800 (PST), first recurring bill date: Sun Nov 10 2024 00:00:00 GMT-0800 (PST), end date: , cancellation date: undefined, billing day: 10, weekly billing day: NaN, with Error: \"Required property 'rate' missing from object 'dataIn' (or is 'null' or 'undefined') in function: calculateProratedValues\"",
"id": "",
"stack": [
"anonymous(N/serverRecordService)",
"_put2(/SuiteScripts/RestLet_Crude_Operation.js:328)"
],
"cause": {
"type": "internal error",
"code": "JS_EXCEPTION",
"details": "Error: Error calculating initial billing period amount for transaction/contract line with start date: Fri Nov 10 2023 00:00:00 GMT-0800 (PST), first recurring bill date: Sun Nov 10 2024 00:00:00 GMT-0800 (PST), end date: , cancellation date: undefined, billing day: 10, weekly billing day: NaN, with Error: \"Required property 'rate' missing from object 'dataIn' (or is 'null' or 'undefined') in function: calculateProratedValues\"",
"userEvent": null,
"stackTrace": [
"anonymous(N/serverRecordService)",
"_put2(/SuiteScripts/RestLet_Crude_Operation.js:328)"
],
"notifyOff": false
},
"notifyOff": false,
"userFacing": false
}
verikott
11/20/2023, 3:12 PMGurudeep Naik
11/21/2023, 4:41 AMGurudeep Naik
11/22/2023, 7:29 AM