Month: July 2025

Currency Exchange Rate Providers

User can set exchange rate provider from the Exchange Rate Integration section of the General subtab on the Accounting Preferences page.  HSBC  Xignite  Setting the exchange rate provider first time will not update rates in historical transactions. For past dates, exchange rates won’t be available automatically. To make them accessible, the rates must be manually… Continue reading Currency Exchange Rate Providers

Proximity Fading Effects in ThreeJS

Overview Subtle visual cues can dramatically improve clarity in 3D interfaces. One elegant and efficient approach is to make objects fade in and out based on how close the player or camera is to them. The applyDistanceFade utility is a minimalist function that does exactly this — fading an object’s opacity based on proximity. Let’s… Continue reading Proximity Fading Effects in ThreeJS

Warning Message during the creation of custom segment: “The custom record type name or custom field name entered already exists. Enter a different name”

To create a new custom segment: Navigate to Customization > Lists, Records & Fields > Custom Segment. Enter the required details such as the segment Name, ID, and other configuration settings. Note: When attempting to save the segment, you may encounter the following message “The custom record type name or custom field name entered already… Continue reading Warning Message during the creation of custom segment: “The custom record type name or custom field name entered already exists. Enter a different name”

Matrix Sub-Item Images Don’t Show by Default in NetSuite SCA

In NetSuite’s SuiteCommerce Advanced (SCA), managing product imagery for matrix items—especially sub-items—can be unintuitive. By default, images added to the “Related Images” field of a matrix sub-item do not appear on the website’s Product Detail Page (PDP). This behavior stems from how NetSuite handles image inheritance and rendering logic for matrix items. 🔍 Default Behavior… Continue reading Matrix Sub-Item Images Don’t Show by Default in NetSuite SCA

How to Compare a Record’s Date Created with a Specific Date in NetSuite Saved Search

This article explains how to write a NetSuite Saved Search formula to check whether the Date Created ({datecreated}) of a record is earlier than a specific date, such as July 1, 2025. The formula works independently of the user’s date format preferences. Use Case: You may need to filter or mark records created before a… Continue reading How to Compare a Record’s Date Created with a Specific Date in NetSuite Saved Search

Error on installation of Singapore localization SuiteApp

Issue The error shown on installation of the Singapore localization SuiteApp was: Failed: An installation script execution error occurred. Details: {“type”:”error.SuiteScriptError”,”name”:”INVALID_FLD_VALUE”,”message”:”You have entered an Invalid Field Value SG for the following field: country”,”id”:””,”stack”:[“Errorn    at RecordInvoker.setValue (suitescript/resources/javascript/record/serverRecordService.js:443:5)n    at NetSuiteObject.thenableFunction() (suitescript/resources/javascript/record/proxy.js:115:24)n    at addStandardTaxType (/SuiteApps/com.netsuite.singaporelocalization/src/entrypoints/ss/sgl_taxcode_provision_ss.js:103:27)n    at seedStandardTaxType (/SuiteApps/com.netsuite.singaporelocalization/src/entrypoints/ss/sgl_taxcode_provision_ss.js:50:13)n    at provisiontaxcodes (/SuiteApps/com.netsuite.singaporelocalization/src/entrypoints/si/sgl_installer.js:167:9)n    at runSTRInstallationProcedures (/SuiteApps/com.netsuite.singaporelocalization/src/entrypoints/si/sgl_installer.js:88:9)n    at Object.run (/SuiteApps/com.netsuite.singaporelocalization/src/entrypoints/si/sgl_installer.js:52:9)”],”cause”:{“type”:”internal error”,”code”:”INVALID_FLD_VALUE”,”details”:”You… Continue reading Error on installation of Singapore localization SuiteApp

“Submit Failed. NetSuite could not submit all…” in Match Bank

For finance teams, maintaining accurate and timely bank reconciliations is critical for reliable financial reporting, fraud prevention, and cash flow management. Many businesses rely on NetSuite’s Match Bank Data feature to streamline this process. However, users often overlook a key step—submitting the matched or cleared transactions—which can prevent completion of the reconciliation. Understanding the correct submission workflow and… Continue reading “Submit Failed. NetSuite could not submit all…” in Match Bank

Best Practices for HTML Templates in Marketing Campaigns & Email Templates

OverviewCreating HTML templates for NetSuite Marketing Campaigns and Email Templates requires careful design for compatibility across email clients. This quick guide offers essential tips for NetSuite admins to craft effective email content that renders well and communicates clearly. Key Terms:HTML Template: Code for designing email layouts for marketing campaigns.Marketing Campaigns: NetSuite feature for promotional email… Continue reading Best Practices for HTML Templates in Marketing Campaigns & Email Templates