Author: Gopika Raveendran

Impact of Return Authorizations, Credit Memos, and Cash Refunds on Sales Orders and General Ledger in NetSuite

This article explains, with examples, how related transactions such as Return Authorization, Credit Memo, and Cash Refund affect the Sales Order amount and the General Ledger (GL) in NetSuite. Example Scenario: Sales Order and Related Transactions Original Sales Order Sales Order Amount: $1,000 Accounts Affected: Accounts Receivable (AR): Debited by $1,000. Sales Revenue: Credited by… Continue reading Impact of Return Authorizations, Credit Memos, and Cash Refunds on Sales Orders and General Ledger in NetSuite

Applying logic to button Make Copy

const lineIsCopied = () => { let lineNumber = opportunity.getCurrentSublistValue({ sublistId: ‘item’, fieldId: ‘line’ }); if (lineNumber) { //linenumber is existing this means line is not a copy return false; } else { //linenumber is empty this mean line is a copy return true; } };

Creating and Customizing Sublists in NetSuite with SuiteScript

1. Overview of Sublists in NetSuite SuiteScript Sublists are essential components in NetSuite that allow developers to display tabular data on custom records, Suitelets, or custom forms. Using SuiteScript, you can create and configure Sublists to show related data, capture user input, or present data summaries for transactions, records, or reports. Sublists enhance usability by… Continue reading Creating and Customizing Sublists in NetSuite with SuiteScript

Directly Triggering Suitelets on Button Click in NetSuite (Without Client Scripts)

1. Overview In NetSuite, Suitelets can be executed by clicking a button on a record. While a Client Script is commonly used to handle button actions, it’s possible to simplify this process by configuring the button to directly open a Suitelet URL. This approach minimizes additional script dependencies and can streamline Suitelet execution in simpler… Continue reading Directly Triggering Suitelets on Button Click in NetSuite (Without Client Scripts)

Understanding and Tags in NetSuite Advanced PDF/HTML Templates

1. Overview of <pdf> and <pdfset> Tags In NetSuite’s Advanced PDF/HTML templates, the <pdf> and <pdfset> tags control PDF formatting and document structuring. These tags are used to define layout, styling, and configuration for the final PDF output, allowing developers to customize document structure dynamically. 2. Purpose and Usage <pdf> Tag: The <pdf> tag is… Continue reading Understanding and Tags in NetSuite Advanced PDF/HTML Templates

IQmetrix API Guide for Purchase Order (PO) Creation: Process, Payload Structure, and Troubleshooting

1. Overview The IQmetrix Vendor Inventory API supports the creation of Purchase Orders (POs) through a structured JSON payload. This guide outlines the key requirements, step-by-step process, and common issues encountered during PO creation using the IQmetrix API. 2. Requirements for Purchase Order Creation To create a Purchase Order, the following prerequisites and fields are… Continue reading IQmetrix API Guide for Purchase Order (PO) Creation: Process, Payload Structure, and Troubleshooting

Remaining Amount of all Customer Deposits linked to a specific Sales Order record

To show the Remaining Amount of all Customer Deposits linked to a specific Sales Order record: Create a Transaction Saved Search as follows: Criteria (Use Expressions) ( Type IS Deposit Application AND Created From Fields > Sales Order IS Sales Order #xyz ) OR ( Type IS Customer Deposit AND Created From IS Sales Order #xyz ) Results Formula (Numeric) (Summary type SUM): CASE WHEN {type} = ‘Customer Deposit’ THEN {debitamount} ELSE -{creditamount} END