Author: Amrutha N R

To Show ‘Approval Status’ and ‘Next Approver’ Fields on Purchase Order Forms

Scenario ‘Approval Status’ and ‘Next Approver’ fields are not displaying even if the settings is already marked as shown on the Form Level. The reason why Approval Status field is not showing even though it is set to show in the form is because the Approval Routing is not enabled for purchase order.  Solution ‘Approval… Continue reading To Show ‘Approval Status’ and ‘Next Approver’ Fields on Purchase Order Forms

workflow action script to send emails for approval in role-based stages

/**  * @NApiVersion 2.1  * @NScriptType WorkflowActionScript  */ define([‘N/record’, ‘N/search’, ‘N/runtime’, ‘N/email’],  /**  * @param{record} record  * @param{search} search  * @param{runtime} runtime  */     (record, search, runtime, email) => {         “use strict”;         /*          * This function fetches the internal IDs of employees… Continue reading workflow action script to send emails for approval in role-based stages

Workflow action script to validate filenames

Workflow action script to validate filenames uploaded under file tab is in correct format ‘Estimate_PO_1236’ and ‘Invoice_PO_1236’ define([‘N/error’, ‘N/file’, ‘N/record’, ‘N/search’, ‘N/runtime’],     /**  * @param{error} error  * @param{file} file  * @param{record} record  * @param{search} search  * @param{runtime} runtime  */     (error, file, record, search, runtime) => {         “use… Continue reading Workflow action script to validate filenames

Item Saved Search that will display the Item’s preferred vendor and the vendor price.

Item Saved Search that will display the Item’s Preferred Vendor and the Vendor Price. Navigate to Reports > Saved Searches > All Saved Searches > New Click Items Click Criteria  Click Results  Click Columns Field: Note: For every required field use the drop-down menu to select it and once adjusted click Add if  needed. Select Name… Continue reading Item Saved Search that will display the Item’s preferred vendor and the vendor price.

Script to set item description in make a copy

Script to set item description in make a copy of a sales order for custom descriptions even if the customer is changed. We can’t implement this using user event script. define([‘N/currentRecord’],   /**    * @param{currentRecord} currentRecord    */   function (currentRecord) {     ‘use strict’;     let originalDescription = {};     let mode;     /**     * Function to handle storing original descriptions.… Continue reading Script to set item description in make a copy

The error message “UPS account number that was provided as the payment method is missing or invalid”

The error message “UPS account number that was provided as the payment method is missing or invalid.” in NetSuite usually occurs due to one of the following reasons: Possible Causes: Incorrect UPS Account Number The UPS account number entered in NetSuite is incorrect, invalid, or has expired. Missing UPS Account Number The UPS account number… Continue reading The error message “UPS account number that was provided as the payment method is missing or invalid”

UPS Registration Error Troubleshooting Tricks

Use invoice related date from Amount from Amount Due. On your browser, disable the tool (i.e. AdBlock, any Apps that store passwords and/or auto-fill) to allow the UPS Device ID (Blackbox) value to load. Check if you have an application that automatically populates your password on your browser.  Please make sure to manually type in all information in… Continue reading UPS Registration Error Troubleshooting Tricks

Error: “Unable to save record. Record was changed by a different user. Please reload and try again.”

Each custom record type has a Enable Optimistic Locking option that can be enabled to protect custom record data integrity. Enabling this option causes the system to check for conflicting updates whenever a user or script attempts to save updates to an instance of this custom record type. If another user, script, or action has… Continue reading Error: “Unable to save record. Record was changed by a different user. Please reload and try again.”

NetSuite global search Prefixes:

Type the first few words of the record type you’re looking for (i.e. “sale” for a sales order, “cu” for a customer the n colon (:) and then your search query to narrow the search to just the records those you search.