Author: Swathi Krishna K S

N/scriptTypes/restlet Module

Use the N/scriptTypes/restlet module to create custom HTTP responses for your RESTlet script. This module is available only to RESTlet script type. N/scriptTypes/restlet Module Members restlet.Response :- restlet.createResponse(options): – Parameters:- Errors:- Response Object Members The following members are called on the restlet.Response object. Response.content:- Response.contentType:- Syntax: /** * @NApiVersion 2.1 * @NScriptType RESTlet */ define([‘N/scriptTypes/restlet’,… Continue reading N/scriptTypes/restlet Module

Shipping Integration with FedEx, UPS, and USPS/Endicia

The Shipping Label Integration feature enables you to generate tracking numbers and shipping labels in your NetSuite account. After you register your FedEx, UPS, or USPS/Endicia account with NetSuite, you can create real-time rate shipping items so that the shipping charges on orders are always up to date. To setup shipping label integration: -Go to… Continue reading Shipping Integration with FedEx, UPS, and USPS/Endicia

Creating Shipping Items with FedEx Integration

To use FedEx integration, create shipping items that are marked for integration. After you create a FedEx integrated shipping item, you can enter sales orders with the integrated shipping item selected in the Ship Via field. When you fulfill an order, your FedEx account is charged with the FedEx shipping method rate. To create a… Continue reading Creating Shipping Items with FedEx Integration

SQL Datetime functions

The following tables outline the SQL datetime functions that can be used in NetSuite search formulas and custom formula fields: Datetime Functions:

Customer shipping address Fields – limitations and Restrictions

On a Customer Record when entering Shipping Address there are some restrictions on the number and/or nature of characters that are allowed. Here are summary of these restrictions. In terms of number: Addressee = 100 characters Address 1 = 150 characters Address 2 = 150 characters City = 50 Characters Phone = 50 Characters Postal… Continue reading Customer shipping address Fields – limitations and Restrictions

Shipping Item Not Showing up on Sales Order Transaction Shipping Method Drop Down List

Scenario When Charge For Shipping = T on Setup > Accounting > Shipping, Shipping cost is recognized and should be tied up with Accounts together with the desired rate. Solution Navigate to Lists > Accounting > Shipping Items and make sure that the Shipping Item has the following mandatory fields: Under Shipping Rate tab, Account (Shipping)  Under Shipping Rate tab, Type of Rate  Under Shipping Rules tab, Charge Tax on this Shipping Portion of Item (on some cases this field is mandatory)

Proposal for Sales Order Approval Process

Requirement  The client’s requirement is to implement an approval process for Sales orders to catch certain issues and send them for secondary or tertiary approval.  The approval flow should be as:  -The Sales Order is entered by the Order Entry Team.  -The Sales Order is reviewed by another team member.  -If correct, the order is… Continue reading Proposal for Sales Order Approval Process

Add QR code in Xml template

<barcode codetype=”qrcode” style=”width: 1.5in; height: 1.5in; align:center;” showtext=”false” value=”${schemaArr.itemID}”></barcode> Specify the codetype as qrcode and add the required width and height. The Item Id value will be the value sourced for the QR code.

Fetching the credit Sublist values From Payment record.

The credit sublist values are not directly accessible using a script. However, we can create a workbook to fetch the credit data, and then use SQL to retrieve it in the script. Steps: Create a dataset for the required data. Navigate to Analytics > create new dataset. We can filter the results by adding criteria.… Continue reading Fetching the credit Sublist values From Payment record.