Script to set line price and alt price to 0 when closed

Set line price and alt price to 0 when closed.

/**
         * Function to be executed when field is changed.
         *
         * @param {Object} scriptContext
         * @param {Record} scriptContext.currentRecord - Current form record
         * @param {string} scriptContext.sublistId - Sublist name
         * @param {string} scriptContext.fieldId - Field name
         * @param {number} scriptContext.lineNum - Line number. Will be undefined if not a sublist or matrix field
         * @param {number} scriptContext.columnNum - Line number. Will be undefined if not a matrix field
         *
         * @since 2015.2
         */
        function fieldChanged(scriptContext) {
            var currentRecord = scriptContext.currentRecord;
            var sublistName = scriptContext.sublistId;
            var fieldName = scriptContext.fieldId;
            if (sublistName === 'item' && fieldName === 'custcol_crfq_close_line') {
                var isChecked = currentRecord.getCurrentSublistValue({
                    sublistId: 'item',
                    fieldId: 'custcol_crfq_close_line'
                });
                var altSales = currentRecord.getCurrentSublistValue({
                    sublistId: 'item',
                    fieldId: 'altsalesamt',
                });
                if (isChecked) {
                    currentRecord.setCurrentSublistValue({
                        sublistId: 'item',
                        fieldId: 'custcol_mhi_ibs_entity_price',
                        value: 0
                    });
                    currentRecord.setCurrentSublistValue({
                        sublistId: 'item',
                        fieldId: 'altsalesamt',
                        value: altSales - altSales
                    });
                }
            }
        }

Leave a comment

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