hey everyone, I am trying to set a custom transaction body field value (date field) in a scheduled script (2.0). I've used record.setValue( ) in Suitelets and I've used record.submitFields in Map/Reduce to basically do what I needed, but neither of those are working here. With the record.setValue() call, nothing happens, no errors, and a log after the call will fire. record.submitFields breaks because the record is in standard mode. Feel like this is something simple I am just missing. Thank you

share the code, preferably with whatever value you are using

var date = '04/01/2020';

var formatDate = format.parse({value:date, type:format.Type.DATE});

rec.setValue({

fieldId: 'custbody_late_po_date',

value: formatDate,

});

that looks correct

M/D/YYYY

i believe you are supposed to use 4/1/2020 then, im not sure if that matters

Thank you. That didn't work either

your date setting code looks reasonable as far as i can tell

No errors or anything. It makes me think the field is not properly configured, but it look ok

you probably need to show more of your code

And that code to set the value on a date field I have used over and over again in other scripts succesfully

you also would want to make sure there are no user event or workflows overriding your value

I am not sure what else I can show. I've stripped this down to it's most basic to get this part to work. And no, there is no other event or workflow. The field is brand new, not used anywhere else.

nope

Store Value is checked, there are no restrictions set in the Access Tab . . .

this code, works for me

/**
 *@NApiVersion 2.0
 *@NScriptType ScheduledScript
 */
define(["N/record", "N/format"], function (record, format) {
  function execute() {
    var rec = record.load({ type: record.Type.PURCHASE_ORDER, id: "1780" });
    var date = "4/1/2020";
    var formatDate = format.parse({ value: date, type: format.Type.DATE });
    rec.setValue({
      fieldId: "custbody_late_po_date",
      value: formatDate,
    });
    rec.save();
  }
  return {
    execute: execute,
  };
});

Interesting. Thanks. I'll keep digging.