This SuiteQL query returns the invoices to which a customer payment was applied. SELECT Invoice.TranID AS InvoiceID, REPLACE( BUILTIN.DF( InvoiceMainLine.CreatedFrom ), ‘Sales Order #’, ” ) AS SONumber, Invoice.OtherRefNum AS CustomerPO, PTLL.ForeignAmount AS AmountPaid FROM Transaction AS Payment INNER JOIN TransactionLine AS PaymentLine ON ( PaymentLine.Transaction = Payment.ID ) AND ( PaymentLine.MainLine = ‘F’ )… Continue reading suiteQL query to get the customer payment application details
Month: May 2025
Why getText() Fails in SuiteScript and How to Resolve It
Error: “Invalid API usage. You must use getValue to return the value set with setValue” The above error message is specific to SuiteScript, and it usually occurs when we’re trying to use getText() on a field that only supports getValue() — such as internal ID fields or hidden/system fields that aren’t rendered as dropdowns or… Continue reading Why getText() Fails in SuiteScript and How to Resolve It
Fragment Nodes
Essentially, a node is a placeholder for a unit of GPU computation, a representation of anything from a basic arithmetic operation, a lighting algorithm, a struct, a line of code, a shader, or a series of post-process passes. The specifics of how any given node works aren’t really important to understand. Nonetheless, they are the… Continue reading Fragment Nodes
Extension to Show Category in website based on the Role and Domain
Overview: An extension named ‘ShowCategoryByRole’ for NetSuite Commerce is designed to dynamically hide or display categories in the site header, navigation facets, and category pages based on customer roles and domain classifications. This multi‑domain solution leverages custom category fields for customer segment and domain assignment, ensuring that only relevant categories appear to each user segment.… Continue reading Extension to Show Category in website based on the Role and Domain
Error – The variant ‘Black’ already exists in Celigo
Reason – Shopify NetSuite Integration app only expect single quantity pricing in Item record in NetSuite , If the item record has more than one quantity pricing , the error ‘The variant ‘Black’ already exists ‘ will show in the Celigo Solution , add one more criteria in the existing saved search in the Celigo. Pricing:Minimum… Continue reading Error – The variant ‘Black’ already exists in Celigo
Resolving ‘Load More’ Issue on PLP Page When Using a Custom Favorites Extension
Resolving ‘Load More’ Issue on PLP Page When Using a Custom Favorites Extension We introduced a custom Favorites extension that allows users to mark items on the PLP as favorites. However, the ‘Load More’ button on the Product Listing Page (PLP) stopped functioning as expected. SCA uses the FacetsItemsCollectionView for Infinite Scroll behavior. It dynamically… Continue reading Resolving ‘Load More’ Issue on PLP Page When Using a Custom Favorites Extension
NetSuite SuiteScript Versions 2.0, 2.1, and 2.2 Overview
SuiteScript 2.0 Introduction: SuiteScript 2.0 was a major update that introduced a modular architecture, allowing developers to load only the modules they need, which improves performance and maintainability. Key Features: Modular Design: Scripts are organized into modules, making it easier to manage dependencies and code organization. Improved API: Enhanced APIs for working with records, searches,… Continue reading NetSuite SuiteScript Versions 2.0, 2.1, and 2.2 Overview
Loyalty Point Rewards in SuiteCommerce Advanced: Comparing CLutch & Netscore
Customer loyalty programs are a crucial component of e-commerce businesses, helping brands retain customers and incentivize repeat purchases. Within SuiteCommerce Advanced (SCA), integrating a loyalty system requires selecting a third-party provider that aligns with business needs. Two major solutions available for this integration are CLutch and Netscore. While both offer rewarding experiences, they differ significantly… Continue reading Loyalty Point Rewards in SuiteCommerce Advanced: Comparing CLutch & Netscore
Consider the User’s Subsidiary in Generating the List of Transactions on the Bulk Approval Page when Using a Custom Approval Workflow
Scenario Add a Formula on the Add Button action of a Workflow to consider the user’s subsidiary in showing the list of transactions on the bulk approval page (for example: Approve Bills page) and displaying the Approve button on transaction records. The standard subsidiary restrictions will not be followed because the bulk approval page generates the list based on the Custom… Continue reading Consider the User’s Subsidiary in Generating the List of Transactions on the Bulk Approval Page when Using a Custom Approval Workflow