Month: February 2022

Using Text Join function to combine values in different rows to a single cell

The TEXTJOIN Function joins text from two or more strings together with a delimiter separating each value.The TEXTJOIN function takes three required arguments: delimiter, ignore_empty, and text1. The delimiter is the text to use between values that are concatenated together and should be enclosed in double-quotes (“”), for example, a space (” “) or a comma with a space (“, “). To use… Continue reading Using Text Join function to combine values in different rows to a single cell

“RECALC” Replaced by “SUBLISTCHANGED”

Before we wrap up, there is one important change to SuiteScript 2.0 Client Scripts that impacts how we work with sublists. In 1.0 Client Scripts, there is an event called recalc. This event fires whenever a change has been made to a sublist that impacts the total of a transaction. Let’s say you are editing a… Continue reading “RECALC” Replaced by “SUBLISTCHANGED”

Use multiple pricing

Scenario Define price level in the customers record. Solution Enable the Multiple Pricing feature: Your administrator can go to Setup > Company > Setup Tasks > Enable Features. On the Transactions subtab, check the Multiple Prices box. Click Save. Create price level records: To create price levels, go to Setup > Accounting > Setup Tasks > Accounting Lists > New. Set price… Continue reading Use multiple pricing

Published
Categorized as Financials

Customer statement

We can send statements to remind customers to pay their invoices. Customer statement can be generated for multiple customers and as individual statements. By NetSuite standard, it will be in PDF or HTML formats. To print the customer statements for multiple customers: Go to Transactions > Customers > Generate Statements(admin) and select all the customers… Continue reading Customer statement

Release Preview Account – Test drive before you go live

“Test drive before you go live” is NetSuite’s standard pre-release mantra and good advice which you should take seriously. NetSuite is a cloud-based ERP platform. As such, upgrades do not require any installation on your end. However, you should be informed of what’s coming your way by carefully reviewing the release notes. You should also… Continue reading Release Preview Account – Test drive before you go live

Convert Base 64 encoded image data to a JPEG and encoded PDF file in to the File cabinet.

NetSuite does convert Base64 image data to a JPEG file in the file cabinet automatically. I have tried different methods to decode the base 64 encoded image data. Failed to save the image data to a folder created in file cabinet. solution: Use N/encode module, in file.create() use “file.Encoding.BASE_64” for encoding type. Instead of trying… Continue reading Convert Base 64 encoded image data to a JPEG and encoded PDF file in to the File cabinet.

Search is not working in the Extension

The search is not working in the extension. But the search is working in Netsuite. Issue: There are two functions in the extension for getting details of files and folders from the backend(suitescript file), In the execution log of the corresponding ssp application, it is showing as blank object value is not getting. Solution 1:… Continue reading Search is not working in the Extension