SreeVidhya Sanoj – Page 4 – knowledgebase JJ

Script for creating the suitelet page from sales order and setting the value from suitelet page to Sales Order.

Item defaults to a specific Location upon Sales Order Entry Even if there is no Preferred Location Set in either the Item Record or in Accounting Preferences

The Location on the line item level of the Sales Order is based on the Location set on the Item record. The system first considers the Preferred Location under Purchasing/Inventory subtab. If the Preferred Location is blank, then system considers the Location on the Classification section in the Main Line of the Item record. To resolve User may check if there is a designated Location in the main line Location field of the Item record… Continue reading Item defaults to a specific Location upon Sales Order Entry Even if there is no Preferred Location Set in either the Item Record or in Accounting Preferences

Error when Printing using Template > SyntaxError: Unexpected token> Advanced PDF/HTML Template

When printing a record using an Advanced PDF/HTML Template, you run into the ff error: “SyntaxError: Unexpected token: <“ Solution Possible Solution to this error is to check for invalid XML characters [<, >, “, ‘, &] in the template. These characters need to be replaced with the corresponding Escape String as shown below. Character Escape String: <… Continue reading Error when Printing using Template > SyntaxError: Unexpected token> Advanced PDF/HTML Template

Error: “RCRD_LOCKED_BY_WF” Load Records Locked by Workflow

User encounters error: “RCRD_LOCKED_BY_WF” when loading a record that is locked by a workflow through Lock Record action when using SuiteScript through record.load(options) Solution: Utilize the search.lookupFields(options) API Example: Using N/Search module in SuiteScript 2.0,

Proposal of Stock List update based on CSV File

Proposal summary The proposal covers the scope of updating item record based on the CSV attached for vendor Pacific Lifestyle. Requirement The requirement is to map SKU(product code), SRP price and Stock in item record based on the CSV file attached Our Solution We assume that you will create a folder and a file inside… Continue reading Proposal of Stock List update based on CSV File

Resolve error: “Invalid orderstatus reference key H.” When Changing Order Status Using Workflow

User is trying to override the Order Status to Closed using workflow, it returns the error “Invalid orderstatus reference key H”. Transactions can be set the Order Status to Closed only if all Items on the Order are also Closed. Below is a sample of workflow that sets the Order Status to Closed after clicking… Continue reading Resolve error: “Invalid orderstatus reference key H.” When Changing Order Status Using Workflow

Change the page size on advanced PDF Template

There will be scenarios that smaller page size for taking the print. For example: PDF like item label, shipping label can have smaller pager size. Solutions Navigate to Customization > Forms > Advanced PDF/HTML Templates Preferred Advanced PDF/HTML Template: Click Edit Top Right Corner: Toggle Source Code Source Code: Locate the code below from the PDF source code<body header=”nlheader” header-height=”10%” footer=”nlfooter” footer-height=”10pt”padding=”0.5in 0.5in 0.5in 0.5in”… Continue reading Change the page size on advanced PDF Template

Script to add Colorado delivery fee in Sales order.

Requirement When creating a sales order or open an existing sales order, before saving that SO we need to check whether the colorado delivery fee is added properly or not based on the shipping address as colorado. Therefore, only shipping addresses to COLORADO are affected. Only customers who have to pay sales tax, must pay… Continue reading Script to add Colorado delivery fee in Sales order.

Saved Search > Add a Link of Custom record to the transaction saved search.

The users want to have a saved search that shows the links of the custom record which will route them to the results of that custom record from transaction search Navigate to Reports > Saved Searches > All Saved Searches > New Select Transaction Saved Search Rename Search Under Criteria tab, add the field:**You may also add another criteria such as the type and… Continue reading Saved Search > Add a Link of Custom record to the transaction saved search.

WMS : WMS Mobile > How to Save a Value from the WMS Page Element (text box) into a NetSuite Transaction Body Field (free-form text) upon Click of the Enter Staging Bin Button in WMS Mobile?

Solution First, clone the process to be customized (eg. NSWMS_multiOrder_Picking) View the cloned process (eg. NSWMS_multiOrder_Picking_1) From the Mobile Process, view the Mobile – Page where the custom page element will be created (eg. multiOrderPicking_enterStagingBin_1 Under Page Elements subtab, create a new Mobile – Page Element, making sure to provide the ff in the element: a) record name (eg. purchaseorder) //internal ID of the record as per… Continue reading WMS : WMS Mobile > How to Save a Value from the WMS Page Element (text box) into a NetSuite Transaction Body Field (free-form text) upon Click of the Enter Staging Bin Button in WMS Mobile?