Hi All, ``` var rec = record.load({ t...
# suitescript
g
Hi All,
Copy code
var 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
Copy code
{"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 Update
if i Uncomment this line of code
Copy code
// 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
Copy code
{
  "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
}
v
Dynamic mode, so behaves as it does in the UI. Keep that in mind. Try setting the fields yourself in the UI in the same order as your script does, and see what happens. The error message gives you a big hint though
g
Okay Let Me Check Those
Thanks @verikott 🙌