5

Online Price

/**
 *@NApiVersion 2.1
 *@NScriptType UserEventScript
 */
 
// Load two standard modules.
define ( ['N/record', 'N/ui/serverWidget'] ,
    // Add the callback function.
    (record, serverWidget) => {
 
        // In the beforeSubmit function, add new price to Schema custom field on inv & non-inv item records.
        myBeforeSubmit = (context) => {
            //Simplify Code - remove context.
            const newRecord = context.newRecord;
            const oldRecord = context.oldRecord;

            //Pull the line value of the price level with the Id of 5 (Our Online Price Level).
            const pricingSublistLineLevel = newRecord.findSublistLineWithValue({
                sublistId: "price",
                fieldId: 'pricelevel', //The Id of the sublist values
                value: '5'
            })

            //get the online price that is about to be submitted
            const newItemOnlinePrice = newRecord.getSublistValue({
                sublistId: "price",
                fieldId: "price_1_",
                line: `${Number(pricingSublistLineLevel)}`
            });

            //get the online price that was on the record prior
            const oldItemOnlinePrice = oldRecord.getSublistValue({
                sublistId: "price",
                fieldId: "price_1_",
                line: `${Number(pricingSublistLineLevel)}`
            });

            //If there is no change to the online price the script should be done
            if (oldItemOnlinePrice === newItemOnlinePrice)
                return;

            //Update the custom field on the item record to match the online price. Make sure it is a number record and has 2 decimal places.
            newRecord.setValue({
                fieldId: 'custitem_onlineprice_for_schema',
                value: `${Number(newItemOnlinePrice).toFixed(2)}`
            });
        }
        //Return the before submit statement
        return {
            beforeSubmit: myBeforeSubmit
        };
    });