The ItemPricing sublist is located the Financial subtab in Customer record. It contains the columns Item,Price level, Currency and Unit price by default. It is not possible to add a new column to this sublist through the standard NetSuite form/field customizations. Here is a sample code to add a custom column in UI which can… Continue reading Add a new column to ItemPricing Sublist
Author: Aishwarya M J
Webhook response codes
The following response codes can return from integrator.io webhooks accessed via HTTP connections: 204 – Successful 400 – Bad request 401 – Unauthorized 403 – Forbidden 429 – Throttling errors 422 – Custom errors 500 – 511 – Server errors
You Cannot Receive More Items Than You Shipped for an Intercompany Transfer Order
Scenario User is encountering error ‘You cannot receive more items than you shipped for an intercompany transfer’, when trying to create Item Receipt for an Intercompany Purchase Order. Solution Possible reasons of the error: The transaction is an Intercompany Purchase Order and there is no linked Sales Order yet. The linked Sales Order is not yet… Continue reading You Cannot Receive More Items Than You Shipped for an Intercompany Transfer Order
Catch the Void Action Using a User Event Script
Scenario: Currently, Suitescript does not have the capability yet to catch the Void action on a record. However, we can check if a record is already voided in NetSuite. sample code if(scriptContext.type == “edit”){ var objRecordNew = scriptContext.newRecord; var internalID = scriptContext.newRecord.id var objRecord = record.load({ type: record.Type.PURCHASE_ORDER, id: internalID, isDynamic: true, }); var voided = objRecord.getValue({… Continue reading Catch the Void Action Using a User Event Script
No results shown on Mass update preview
Scenario: User would like to perform mass update for Sales Orders and has used a transaction saved search’s criteria to filter the records to be updated. However, when previewing results, no records are found. When running the saved search, there should be a number of records returned. Solution: Check the Saved search criteria if Mainline… Continue reading No results shown on Mass update preview
Dynamically assign default customer for Magento Orders
The Magento2-NetSuite Integration app provides an option to assign one default customer to all Magento Orders. For this the internal id of the customer is to be specified and the Add all orders against the NetSuite customer is to be marked true. We can assign different default customer to Magento Orders from different Stores. For… Continue reading Dynamically assign default customer for Magento Orders
CSV Import to add values to Custom List
A custom list is created in NetSuite with no values added. If there are many values to be added in the custom list, it can be done through csv import. As the first step, create the CSV file to be imported. The csv file should have 2 columns: column A for name of the custom… Continue reading CSV Import to add values to Custom List
Split Backordered items to a new Sales Order
Whenever a Sales Order include items which are backordered, those items are removed from the original order and a new Sales Order is created with the backordered items. A saved search is used to identify the Sales Orders to be considered for splitting. This saved search is passed as script parameter.
Sync more than one Item image to Shopify
The Item images in NetSuite are synced to Shopify along with the product details using the NetSuite Item to Shopify Product Add/Update flow. By default, only one image which is selected in the field ITEM IMAGE ({custitem_atlas_item_image}) is only synced to Shopify. If we need to sync images in another field , add the new… Continue reading Sync more than one Item image to Shopify
Sync NetSuite customer refund created against the customer deposit to Shopify
When you sync a paid order as a sales order with a customer deposit, and if there is a refund request even before the order is fulfilled, a refund adjustment is required instead of item restock. In this scenario, the fulfillment and invoice records are not created in NetSuite and a customer refund is created… Continue reading Sync NetSuite customer refund created against the customer deposit to Shopify