Month: March 2025

Scriptable Cart Fundamentals and Set Up

With Scriptable Cart, SuiteCommerce developers can use SuiteScript to invoke client scripts on the sales order form used for website orders. Note that SuiteScript is not available for web store registration, but an SSP application can be used to customize a registration page. Essentially, Scriptable Cart is a SuiteScript file deployed to your NetSuite instance… Continue reading Scriptable Cart Fundamentals and Set Up

Best practices for Suitecommerce – Customize with Workflows

In your Commerce website interactions, you can enhance customer experiences using SuiteFlow, part of SuiteCloud. SuiteFlow allows you to automate business processes without needing any scripting skills. It creates workflows that manage both standard and custom records by defining stages and conditional actions based on criteria set by you. Workflows are especially useful for simple tasks, like… Continue reading Best practices for Suitecommerce – Customize with Workflows

Ensuring Correct RTL Display for Mixed Arabic and English Text in NetSuite Advanced PDF Templates

When generating PDF documents in NetSuite using Advanced PDF templates, you might encounter challenges when displaying mixed Arabic and English text. While Arabic text should naturally render from right to left (RTL), embedding English text within Arabic strings can disrupt this flow, causing display issues. Simply applying dir=”rtl” or direction: rtl; in your HTML styling… Continue reading Ensuring Correct RTL Display for Mixed Arabic and English Text in NetSuite Advanced PDF Templates

BUILTIN.DF() in SuiteQL

BUILTIN.DF(transactionLine.createdfrom) AS so# BreakDown of Code: transactionLine.createdfrom Refers to the Created From field at the line level of a transaction. This field stores the internal ID of the source transaction (e.g., a Sales Order for an Invoice or an Item Receipt for a Purchase Order). BUILTIN.DF(field) BUILTIN.DF() is a NetSuite built-in function that retrieves the… Continue reading BUILTIN.DF() in SuiteQL

Retrieve only the child subsidiary name from the Subsidiary field using a search.

result.getText({ name: ‘subsidiary’ }).split(‘:’).pop().trim() || “” result.getText({ name: ‘subsidiary’ }) Retrieves the text representation of the subsidiary field from the search result. In NetSuite, getText is used to fetch the displayed text instead of the internal ID. .split(‘:’) Splits the retrieved text by the colon (:) separator. Some NetSuite fields (like subsidiary) can return values… Continue reading Retrieve only the child subsidiary name from the Subsidiary field using a search.

Currency conversion Suitescript using Currency Module

currency.exchangeRate : Enter an exchange rate for this currency against the base currency of this company, or if you use OneWorld, for this currency against the base currency of the root parent subsidiary. For example, if your company is located in Canada and you are defining the U.S. dollar, and the current exchange rate is… Continue reading Currency conversion Suitescript using Currency Module

Retrieve invoice details through serch, including Discount Total and Gift Certificate Amount, without loading the record.

let invoiceSearchObj = search.create({                     type: ‘invoice’,                     filters: [                         [‘internalid’, ‘anyof’, invoiceArray],  // Handling multiple invoices                … Continue reading Retrieve invoice details through serch, including Discount Total and Gift Certificate Amount, without loading the record.