Set the Item Amount to Zero for Marketing Orders

To create the custom field:

1. Go to Customization > Lists, Records, Fields > Transaction Body Fields > New.

2. Enter or select values for fields as listed in the following table:

   Field	Value
   Label	Marketing Order
   ID	_marketing_order NetSuite prepends ‘custbody’ to this ID.
   Type	Check Box
   Description	Indicates whether the sales order is a marketing order.
   Applies To	Sale
   Display	Subtab: Main

3. Click Save.

Script Summary

The following table summarizes the script:

For more information about script types and entry points, see SuiteScript 2.x Script Types.

The Complete Script

This tutorial includes the complete script along with individual steps you can follow to build the script in logical sections. The complete script is provided below so that you can copy and paste it into your text editor and save the script as a .js file (for example, ue_marketingOrder.js).

If you would rather create your script by adding code in logical sections, follow the steps in Build the Script.

              /**
 * @NApiVersion 2.1
 * @NScriptType UserEventScript
 * @NModuleScope SameAccount
 */

 define(['N/record', 'N/log'], (record, log) => {
    function afterSubmit(context) {
        try {
            const currentRecord = context.newRecord;
            const recordID = currentRecord.id;
            const recordType = currentRecord.type;
            const objSalesOrder = record.load({
                type: recordType, 
                id: recordID,
                isDynamic: true
            });
            const isMktgSalesOrder = objSalesOrder.getValue({
                fieldId: 'custbody_marketing_order'
            });
            if (isMktgSalesOrder) {
                const intItemLines = objSalesOrder.getLineCount({
                    sublistId: 'item',
                });
                for (let i = 0; i < intItemLines; i++) {
                    objSalesOrder.selectLine({
                        sublistId: 'item',
                        line: i
                    });
                    objSalesOrder.setCurrentSublistValue({
                        sublistId: 'item',
                        fieldId: 'amount',
                        value: 0
                    });
                    objSalesOrder.commitLine({
                       sublistId: 'item'
                    });
                }
                objSalesOrder.save();
            }
        } catch(e) {
            log.error({
                title: 'marketing order script - afterSubmit',
                details: e.message
            });
        } 
    }
    return {
        afterSubmit: afterSubmit
    };
}); 

            

Build the Script

You can write the script using a step-by-step approach that includes the following:

• Start with required opening lines

• Create the entry point function

• Load the sales order that is being saved

• Create the return statement

• Save your script file

                /**
 * @NApiVersion 2.1
 * @NScriptType UserEventScript
 * @NModuleScope SameAccount
 */

define(['N/record', 'N/log'], (record, log) => {
}); 

              

                function afterSubmit(context) {
    try {
    } catch(e) {
        log.error({
            title: 'marketing order script - afterSubmit',
            details: e.message
        });
    } 
} 

              

                const currentRecord = context.newRecord;
const recordID = currentRecord.id;
const recordType = currentRecord.type;
const objSalesOrder = record.load({
    type: recordType, 
    id: recordID,
    isDynamic: true
}); 

              

                const isMktgSalesOrder = objSalesOrder.getValue({
    fieldId: 'custbody_marketing_order'
}); 

              

                if (isMktgSalesOrder) {
    const intItemLines = objSalesOrder.getLineCount({
        sublistId: 'item',
    });
    for (let i = 0; i < intItemLines; i++) {
        objSalesOrder.selectLine({
            sublistId: 'item',
            line: i
        });
        objSalesOrder.setCurrentSublistValue({
            sublistId: 'item',
            fieldId: 'amount',
            value: 0
        });
        objSalesOrder.commitLine({
            sublistId: 'item'
        });
    }
    objSalesOrder.save();
} 

              

                return {
    afterSubmit: afterSubmit
}; 

              

To create the script record:

1. Upload your script to the NetSuite File Cabinet.

2. Go to Customization > Scripting > Scripts > New.

3. Select your script from the Script File list and click Create Script Record. The Script page is displayed.

4. On the Script page, enter the following values:

   Field	Value
   Name	Marketing Order
   ID	_ue_marketing_order NetSuite prepends ‘customscript’ to this ID.
   Description	This script sets the amount value to 0 for all items on a marketing (sales) order.

5. Optionally set any other fields on the script record as desired.

6. Click Save and Deploy. The Script Deployment page appears. Continue with Step 4: Deploy the Script.

To deploy the script:

1. Complete the steps in Step 3: Create the Script Record.

2. On the Script Deployment page, enter the following values:

   Field	Value
   Applies To	Sales Order
   ID	_ue_marketing_order NetSuite prepends 'customdeploy' to this ID.
   Status	Testing The Testing status allows the script owner to test the script without affecting other users in the account.
   Log Level	Debug The Debug level will write all log.debug statements in a script to the Execution Log tab of the script deployment record as well as all errors.
   Execute As Role	Current Role It is normally best practice to have scripts execute with the user’s current role to avoid granting unwanted access.
   Audience > Roles	Check Select All

3. Click Save.

To test your solution:

1. Go to Transaction > Sales > Enter Sales Orders.

2. Select the Standard Sales Order form and verify that the Marketing Order box field is shown on the form. This field will be included on all standard and custom sales order forms. For this tutorial, you can use the Standard Sales Order form.

3. Add multiple items to the sales order. You do not need to adjust any field for the item unless you want to. Ensure that the Amount field for each item is not already 0.

4. Fill out all other required fields.

5. Check the Marketing Order box.

6. Click Save.

7. View the newly created sales order and verify that the Marketing Order box is checked and that the Amount for all items is 0.