Organizations often find that although NetSuite does a great job as an ERP/financial system, their go-to analytics and ad-hoc reporting tool remains Microsoft Excel. The challenge arises when data must be exported manually (CSV dumps, manual copy-pastes), or when non-technical users want to update NetSuite records in bulk via Excel. ExtendInsights addresses this by enabling:… Continue reading Integrating Excel with NetSuite via ExtendInsights
Author: Abhincy Thomas
Understanding Advanced PDF Printing Errors with Rich Text Fields in NetSuite
When printing transactions in NetSuite using Advanced PDF/HTML Templates, user may encounter errors if the template includes a Rich Text custom field. The printing failed with the following error: Error Message: The template cannot be printed due to the following errors: Error on line 203, column 504 in template. Detail: The value of attribute “style”… Continue reading Understanding Advanced PDF Printing Errors with Rich Text Fields in NetSuite
E-Invoice Generation Enhancements for Overseas Customers
Summary This article explains enhancements made to the E-Invoice module in NetSuite to support overseas customers (i.e., those whose billing country is not India). These updates ensure appropriate field visibility, default values, and IRN payload compliance for export transactions. Enhancement Overview 1. E-Invoice Button Visibility Logic Condition: The E-Invoice Generation button is now visible if… Continue reading E-Invoice Generation Enhancements for Overseas Customers
Signing and encrypting a file using N/pgp module
Background The process involves encrypting and signing a file before transmitting it to an external server. Once received, the external server will: Decrypt the file using their private key (which pairs with the public key we used to encrypt it). Verify the signature using our public key (which pairs with the private key we used… Continue reading Signing and encrypting a file using N/pgp module
Resolving Misalignment and Text Wrapping Issues in Advanced PDF Templates
In NetSuite, advanced PDF/HTML templates offer a flexible way to customize transaction forms. However, during customization, developers may encounter issues such as misalignment of table cells and improper text wrapping—for example as shown below, with item names, dates, and other dynamic fields. These issues can manifest as unexpected spacing between letters or text overflow, which… Continue reading Resolving Misalignment and Text Wrapping Issues in Advanced PDF Templates
Rendering and consolidating multiple picking ticket in Customer Locale PDFs into a single file
let xmlContent = `<?xml version=”1.0″?>n<!DOCTYPE pdf PUBLIC “-//big.faceless.org//report” “report-1.1.dtd”>n`; xmlContent += “<pdfset>”; for (let i = 0; i < Object.keys(groupedLines).length; i++) { let internalId = Object.keys(groupedLines)[i]; let transactionFile = render.pickingTicket({ entityId: Number(internalId), printMode: render.PrintMode.PDF, formId: Number(custLocaleformId), inCustLocale: true }); //save the pdf to filecabinet transactionFile.name = `Picking_Ticket_${i}.pdf`; transactionFile.folder = 3855258; transactionFile.isOnline = true; let fileId… Continue reading Rendering and consolidating multiple picking ticket in Customer Locale PDFs into a single file
Inheriting Passwords for multiple accounts
When performing a bulk update of employee email addresses in NetSuite, it’s often necessary to reset user passwords so they are prompted to change them on next login. However, during this process, you may encounter a specific error that affects how the reset should be handled. Error Message Encountered When updating an email address and… Continue reading Inheriting Passwords for multiple accounts
Redirect to a record from the suitelet page
From a suitelet page, to redirect to a record, use the below code: scriptContext.response.sendRedirect({ type: https.RedirectType.RECORD, identifier: CUSTOM_REC_IDS.eWayBillIRNRec, id: eWayBill.internalId }); Method Description: Creates a redirect URL that resolves to a NetSuite resource. For example, you could use this method to redirect to a new sales order page for… Continue reading Redirect to a record from the suitelet page
Inventory Detail Setting using script
Issue In a vendor return record, a client script is deployed. In the pageInit of the script, the code intended to set the inventory details for the item lines. But when the pageInit was triggered, an error occurred saying selectNewLine is not a function when the script was trying to set the inventory detail. Also,… Continue reading Inventory Detail Setting using script
Search for Subsidiary Specific Posting period
The search will show the periods which are closed for a specific subsidiary for A/R or A/P or ALL types. Go to Setup -> Accounting -> Manage Accounting periods. Click the check List In the Period Close Checklist page, click the arrow for any period type. The task for that type will be opened At… Continue reading Search for Subsidiary Specific Posting period