In the realm of business, identifying and categorizing customers accurately is crucial. For many companies, understanding the distinction between customers who have made sample orders and those who have progressed to placing real orders (purchase orders, or POs) is essential. NetSuite, a popular cloud-based business management software, offers robust capabilities for managing customer data. However,… Continue reading Identifying Potential Customers: A Solution for Sample Orders in NetSuite
Month: April 2024
Proposal for split case fee, on prem only and delivery fee developments
This proposal comprehensively outlines the scope of customizations required to address the split case, on-premises only and delivery fee scenarios, including the development of user event scripts, client scripts, workflows, and approval processes, ensuring efficient handling of sales orders based on specific criteria. This proposal also covers the engagement scope of Jobin and Jismi IT… Continue reading Proposal for split case fee, on prem only and delivery fee developments
How to convert base64 text to a PNG image file in NetSuite
Recently, the client requested a feature to send PNG image file content to Netsuite as base64 text so that it would be converted to an actual file and stored in the file cabinet. Here is a sample function I created to test the functionality: function createFileFromBase64(base64String){ try { var folderId = 47609; // Folder ID… Continue reading How to convert base64 text to a PNG image file in NetSuite
Sending Confirmation Email to Customer from Sales Order Record.
User Event Script for adding button in Sales Order based on certain condition. (record, search, serverWidget, url) => { /** * Defines the function to create a search for purchase orders based on an array of internal IDs. * @param {Array} createPOArray – Array of internal IDs of purchase orders * @returns {Array} – Array… Continue reading Sending Confirmation Email to Customer from Sales Order Record.
Importance of Social Media Content: Standalone Posts VS Integrated Posters
In the dynamic landscape of social media, content is king. Whether it’s a captivating image, a thought-provoking article, or a witty tweet, the way content is presented can significantly impact its reach and engagement. One critical decision for social media marketers and creators is whether to focus on standalone posts or integrate posters within content.… Continue reading Importance of Social Media Content: Standalone Posts VS Integrated Posters
REST Query to fetch the transactions created in the last n hours
POST https://{ACCOUNT_ID}.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=100&offset=0 { “q” : “SELECT BUILTIN_RESULT.TYPE_STRING(TRANSACTION.id) AS internalid FROM TRANSACTION, transactionLine WHERE TRANSACTION.ID = transactionLine.TRANSACTION AND ((transactionLine.subsidiary IN (‘x’) AND TRANSACTION.TYPE IN (‘<transactiontype> ex:PurchOrd‘) AND TRANSACTION.createddate > BUILTIN.RELATIVE_RANGES(‘hago<n>’, ‘END’, ‘DATETIME_AS_DATE’) AND transactionLine.mainline = ‘T’)) ORDER BY TRANSACTION.id DESC” }
Date field validation in suitelet page.
By using this function the date from today onwards will be accepted in the date filed /** * Validation function to be executed when field is changed. * @param {Object} scriptContext * @param {Record} scriptContext.currentRecord – Current form record * @param {string} scriptContext.sublistId – Sublist name * @param {string} scriptContext.fieldId – Field name * @param… Continue reading Date field validation in suitelet page.
How to display a file in new browser tab using a download link
If you have a link to a file that can be used to download any file stored in cloud storage, you can use the same to render the file in a new browser tab in JavaScript. Following is a sample script to do the same: getFilePreview(fileURL, fileType) { console.log(“Inside… Continue reading How to display a file in new browser tab using a download link
UPSERT operation in REST Webservices
The upsert operation enables you to either create a record, or update an existing record. You can only use the upsert operation when you use an external ID in the request URL and when you use the PUT HTTP method. For information about using external IDs. You can use the upsert operation as a synchronization… Continue reading UPSERT operation in REST Webservices
How to fetch both Body feilds and line fields of a record in REST Webservices?
REST web services do not automatically expand sublists and subrecords. You can use the expandSubResources query parameter to expand sublists and subrecords. If the query parameter is not used, the response contains only the body fields of the record, and the sublists and subrecords are represented by links. See the example in Getting a Record Instance. The following… Continue reading How to fetch both Body feilds and line fields of a record in REST Webservices?