Hey All !! I want to set value field: "taxcode" in withholding tax subtab through restlet(script) . i tried using record.load/record.setvalue but that did not work. is there any other way to do that?

objRecord.setValue({

            

fieldId: 'custpage_4601_witaxcode',

            

value: taxcode

        

});

What's the issue that you are facing?

I am trying to save invoice from restlet. Issue is that even when I try to set tax code in withholding tax subtab from restlet no value is entered in it when we actually open the saved invoice.

@humzariaz don't you have to call .save() ?

Yeah, my question too. are you saving the invoice after setting the field value?

function Post(body) {

        

var internalid = body.internalid;

        

var objRecord = record.load({

            

type: record.Type.INVOICE,

              

id: internalid,

            

isDynamic: true,

        

});

            

objRecord.setValue({

            

fieldId: 'custpage_4601_witaxcode',

            

value: 61

        

});

        

taxcode = 'taxcode: ' + taxcode

        

objRecord.selectLine({

            

sublistId: 'item',

            

line: 0

        

});

        

objRecord.setCurrentSublistValue({

            

sublistId: 'item',

            

fieldId: 'custcol_4601_witaxapplies',

            

value: true,

            

ignoreFieldChange: false

        

});

        

objRecord.commitLine({

            

sublistId: 'item'

        

});

            

var recordId = objRecord.save({

                

enableSourcing: true,

                

ignoreMandatoryFields: false

            

});

        

return JSON.stringify(recordId);

    

}

@NickSuite I think these are temporary fields as its prefix is "custpage" which is used in fields created using user event scripts instead of "custbody" which are by default the prefix for body fields. Am I right?

@Salman Afzal, yes, you have a valid point. @humzariaz can you confirm if this field is being created using Userevent? Since the ID should start with custbody instead of custpage. Also, please recheck the field Id - if it is a custom field created using SuiteBuilder, then it should start with custbody

I believe its a part of a "withholding tax" bundle provided by netsuite. Are you familiar with that bundle? @NickSuite

There are all the tax related fields on the invoice record

@Salman Afzal, I am not familiar with it. @Craig it is a custom field.... but as @Salman Afzal stated, it might be created via UE instead of SuiteBuilder.

Custom fields are called custbody

As @Salman Afzal Said it is part of the "withholding tax " Bundle. Not sure if the fields are created from UE or suite-builder

@humzariaz then you cannot set it via loading and saving.

No because that field doesnt' exist on the record

okay thank you all

Update us on your solution, always keen to see how people are solving NS issues

@Craig but that would not provide the required GL Impact. Really in a bind here not sure of the solution.

awesome thanks

@humzariaz you can create a Markup item and add it to the lines. It will have the GL Impact.