The status for your rebuild search index (manual or automatic) is showing as failed. The failure can be caused by a missing default/online currency on the website setup record. Solution Navigate to Commerce > Websites > Website List Click Edit on your website Click the Shopping tab Scroll down to the Currency subtab Select an Online and Default currency if one has not already been selected… Continue reading Resolve Rebuild Search Index failing
Month: February 2025
Converting Invoice Amount to Arabic Words in NetSuite: A Comprehensive Guide
Overview: NetSuite allows users to create customizations using SuiteScript to enhance business operations. One such customization is the conversion of invoice amounts into Arabic words for better localization and user experience. This article explains how to implement this functionality using a User Event Script in SuiteScript 2.1, enabling automatic conversion of the invoice total to… Continue reading Converting Invoice Amount to Arabic Words in NetSuite: A Comprehensive Guide
Automating Shipping Method Updates in NetSuite with a User Event Script
Overview: NetSuite provides the ability to customize business processes using SuiteScript, and one common use case is updating the shipping method based on certain criteria in a Sales Order. This article will discuss a User Event Script designed to automatically update the shipping method for a Sales Order based on whether the shipping address is… Continue reading Automating Shipping Method Updates in NetSuite with a User Event Script
Best Alternatives to record.load for Optimized NetSuite Scripting
1. Use search.lookupFields (Best for Fetching a Few Fields) When to use: You only need to retrieve a few fields from a record (without modifying it). Governance Cost: 2 units (compared to 10+ for record.load). Limitation: Cannot access sublists or make updates. Example (Fetching Customer Name & Email) let customerData = search.lookupFields({ type: search.Type.CUSTOMER, id:… Continue reading Best Alternatives to record.load for Optimized NetSuite Scripting
Memorized Transactions
A memorized transaction is a transaction you set up to recur in NetSuite, such as recurring journal entries. Memorized transactions eliminate data entry and serve as useful reminders. A memorized transaction consists of two parts: The Memorized Transaction Template defines the transaction to be created. The Memorized Transaction Definition sets the parameters for when to create the transaction, whether… Continue reading Memorized Transactions
Direct Invoice Payment
The Direct Invoice Payment feature lets your customers conveniently pay an invoice online, using a computer or mobile device. Instead of having to contact you and discuss payment, your customers receive an email with a link to an invoice that is stored in the My Account area of your Commerce website. They can then use… Continue reading Direct Invoice Payment
Retrieving Price Level and Quantity-Based Pricing in NetSuite
Overview: This saved search retrieves Inventory Items that are associated with a specific Price Level (e.g., Price Level 12) and provides critical data such as Minimum Quantity, Unit Price, and promotional status. This search is especially useful for businesses that have tiered pricing based on customer groups or regions. Saved Search Explanation This search includes… Continue reading Retrieving Price Level and Quantity-Based Pricing in NetSuite
2024.2.20 Minor Release of SuiteCommerce, SuiteCommerce MyAccount, and SuiteCommerce Advanced
Enhancements Changed the word “Tweet” to “post” on product description pages of Commerce websites with Twitter/X integrations. Fixes Fixed an issue that caused shoppers to be directed to the home page instead of the order confirmation page after they clicked Place Order on the checkout page of some Commerce websites. This issue occurred in SuiteCommerce and SuiteCommerce… Continue reading 2024.2.20 Minor Release of SuiteCommerce, SuiteCommerce MyAccount, and SuiteCommerce Advanced
Quantity Pricing in NetSuite Using Saved Searches
Overview: Quantity pricing in NetSuite allows businesses to apply different prices based on the quantity of an item purchased. This guide explains how to use a saved search to retrieve key data related to quantity-based pricing, focusing on the Minimum Quantity field in the pricing records. Saved Search Explanation The following code snippet is for… Continue reading Quantity Pricing in NetSuite Using Saved Searches
When to Use lookupFields vs. record.load
search.lookupFields (Preferred for Performance) Pros: ✅ Faster execution – Retrieves only the required fields instead of loading the entire record. ✅ Lower governance cost – Uses fewer script governance units (2 units vs. 10+ for record.load). ✅ Ideal for simple lookups – Useful when fetching a few fields (e.g., getting a status, subsidiary, or custom… Continue reading When to Use lookupFields vs. record.load