Update zip codes using mass update script.

To update the default billing address zip code and 3rd party billing address zip code for parent customer named ‘party city’.

/**
 *@NApiVersion 2.0
 *@NScriptType MassUpdateScript
 */
define(['N/record'],
    function(record) {

        function each(params) {
            try {
                var massUpdateRec = record.load(params);

                var lineNumber = massUpdateRec.findSublistLineWithValue({
                    sublistId: 'addressbook',
                    fieldId: 'defaultbilling',
                    value: "T"
                });

                var objSubrecord = massUpdateRec.getCurrentSublistSubrecord({
                    sublistId: 'addressbook',
                    fieldId: 'addressbookaddress',
                    line: lineNumber
                });



                log.debug("entry2");
                massUpdateRec.setText("thirdpartyzipcode", " 07866")
                log.debug("entry3");
                massUpdateRec.save();
                log.debug("massUpdateRec", massUpdateRec);
            } catch (err) {
                log.debug("err", err);
            }

        }
        return {
            each: each
        };
    });

Leave a comment

Your email address will not be published. Required fields are marked *