Only When we are using the summary search, this option can be used. Use case: Search for the Purchase history of the customer to get the last selling date, last selling price, and last selling Quantity. Here we need to use the summary search where we have to fetch the maximum date and the maximum… Continue reading Use of When Ordered By in saved search
Author: Gloria George C
Sample Code For usage of Inline HTML field in Suitelet Client side functions
This script facilitates the addition of multiple items to a sales order by allowing users to search for items and add them to a cart on the suitelet page. The page displays items in a list format where users can specify quantities and use buttons associated with each item to add them to the cart.… Continue reading Sample Code For usage of Inline HTML field in Suitelet Client side functions
Custom GL Line plugin On Edit Action Behavior
Each time an edit action is performed on the transaction record, custom GL lines must be included. If these custom GL lines are only added during the creation action, they will be removed whenever the transaction is edited.
Client Side SetCurrentSublistValue doesn’t work in Suitelet POST page
When accessing a Suitelet page via a POST request, NetSuite prohibits setting sublist select fields using client-side SetCurrentSublistValue. Additionally, employing SetCurrentSublistText can cause the page to hang. To resolve this problem, a workaround involves utilizing two separate text fields to store the value and text independently.
PROPOSAL FOR SHOPIFY – NETSUITE INTEGRATION USING NETSUITE CONNECTOR
Proposal Summary This proposal outlines the implementation of Shopify Integration to NetSuite using NetSuite Connector. Requirement The client requires to integrate the following features from Shopify to NetSuite and NetSuite to Shopify: Orders from Shopify to NetSuite Products from NetSuite to Shopify Inventory levels from NetSuite to Shopify Fulfilments from NetSuite to Shopify We assume… Continue reading PROPOSAL FOR SHOPIFY – NETSUITE INTEGRATION USING NETSUITE CONNECTOR
PROPOSAL FOR SHOPIFY – NETSUITE INTEGRATION USING SUITE SCRIPT
Proposal Summary This proposal outlines the implementation of Shopify Integration to NetSuite using suite script. Requirement The client requires to integrate the following features from Shopify to NetSuite and NetSuite to Shopify: Orders from Shopify to NetSuite Products from NetSuite to Shopify Inventory levels from NetSuite to Shopify Fulfilments from NetSuite to Shopify We assume… Continue reading PROPOSAL FOR SHOPIFY – NETSUITE INTEGRATION USING SUITE SCRIPT
Summary Saved Search: Retrieve All Results, Not Just Max or Min
We can use the ns_concat to get all the results of the saved search in the summary search. search.createColumn({ name: “formulatext”, summary: “MAX”,… Continue reading Summary Saved Search: Retrieve All Results, Not Just Max or Min
How to Add Custom field to Time Bill or Time Tracking record
In the Classic center role or Administrator role, go to: Customization –> Lists, Records & Fields –> Transaction Line Fields –> New In the Field creation page, select “Time” under the Applies To sub-tab. Enter the Lable, ID and select the Type of the field. Then save the page to create the Time Tracking field.
Efficiently convert amounts between various currencies using the Currency module
The currency module provides an accurate way to convert the amount of transactions between different currencies. You can use this module to find the exchange rate between two currencies based on a certain date. The following code snippet shows the use of the currency module. /** * Function defined to… Continue reading Efficiently convert amounts between various currencies using the Currency module
Over Receiving Management in Purchase
In certain situations, handling more items than initially specified in a purchase order can pose a challenge within NetSuite. To address this, a customization involves adding a special field to the Item receipt. This field allows users to input the over-received quantity. Consequently, the quantity specified in this custom field will update the corresponding Item… Continue reading Over Receiving Management in Purchase