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
Author: Aishwarya M J
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
Sales Order status set to Closed upon creation
Usually, a Sales Order can be closed manually in the following ways: Click on the CLOSE button visible in the Sales Order Mark the CLOSED checkbox true in all the item lines. Besides the above mentioned a Sales Order get closed automatically when all the Item Quantities are set as 0. The Sales Order status… Continue reading Sales Order status set to Closed upon creation
Composite Method in HTTP import
Composite method imports records depending on the existence or absence of records in the destination application. Composite requests require you to define how to create new records, identify existing records, and update existing records. Different options available in Composite method are: Create new records & update existing records: dynamically create new records or update existing… Continue reading Composite Method in HTTP import