Author: Gopinath Matcharaja

Automatically Allocating Subsidiaries and Currencies to Newly Created Entities in NetSuite

This topic covers how to automate the allocation of all active subsidiaries and currencies to newly created entity records (such as customers, vendors, leads, or prospects) in NetSuite using a User Event Script. The script ensures that when a new entity record is created, it is automatically associated with all relevant subsidiaries and currencies defined… Continue reading Automatically Allocating Subsidiaries and Currencies to Newly Created Entities in NetSuite

Automating File Storage in NetSuite Using RESTlet API

Knowledge Base Topic: Storing Files in NetSuite Using a RESTlet Overview This knowledge base article explains how to create and store files in NetSuite’s File Cabinet through a RESTlet. The RESTlet allows external systems to send files to NetSuite by making a POST request with the necessary details, such as record type, internal ID, file… Continue reading Automating File Storage in NetSuite Using RESTlet API

Transaction Logs as attachments in NetSuite Custom transactions

We’ve added functionality in NetSuite to store transaction logs received from the Portal via an API POST request using a RESTlet script. Two folders have been created in the file cabinet ‘Pending Donation’ and ‘Outgoing Fund’ to store the files. The files are saved in the format ‘<record type>_<internal id>. <file type>’ (e.g., pend_donation_102.png). We… Continue reading Transaction Logs as attachments in NetSuite Custom transactions

Automatically Adding Attachments from Bills and Bill Credits to related Payment records- Update for handling Bulk Processing

Developed scripts in Production environment for the functionality developed to automatically attach the PDF files in the Bill Payment Record related to the Vendor Bill and Bill Credit. In the create and edit context of Bill Payment record the scripts will execute and files will be attached in the File section below the Communication subtab… Continue reading Automatically Adding Attachments from Bills and Bill Credits to related Payment records- Update for handling Bulk Processing

G/L impact of creating Credit memos from Invoices

G/L impact of creating Credit memos from Invoices, I’ve added a detailed report below. Please review and verify. Detailed Report on GL and Inventory Impact in NetSuite Scenario 1: Create an Invoice from the Sales Order and then Return it Using the Return Authorization Step 1: Create an Invoice from the Sales Order Sales Order… Continue reading G/L impact of creating Credit memos from Invoices

Unable to Create a Time off Request for a Specific User Error: “the Time off Request for XX/XX/XX to XX/XX/XX Time off Request [Pto-Xxxx] Already Exists for All or Part of This Date Range”

Scenario Unable to create a Time off request for a specific user Error: “The Time off request for xx/xx/xx to xx/xx/xx time off request [PTO-XXXX] already exists for all or part of this date range”.  One possible issue why this error message occurs is there is a schedule exception created on the users/employee schedule after… Continue reading Unable to Create a Time off Request for a Specific User Error: “the Time off Request for XX/XX/XX to XX/XX/XX Time off Request [Pto-Xxxx] Already Exists for All or Part of This Date Range”

Resolve Unexpected Error When Editing an Advanced PDF/HTML Template

Scenario An Unexpected Error is encountered when trying to Edit or Customize an Advanced PDF/HTML Template for a specific Transaction. This happens when a Script or Workflow deployed is encountering an error when loading the record.   NetSuite runs all before load scripts to get updates on the records and it triggers all Before Record… Continue reading Resolve Unexpected Error When Editing an Advanced PDF/HTML Template

Unable to Send Email When Adding a PDF Template Through Attach Document Template. Error Exception During Message Creation

Scenario User is unable to send email from Record > Communication > Email. Receiving error “Exception during message creation. Caused by: com.netledger.common.exceptions.NLUserError: Template not found” when selecting a PDF template under Email > Attachments > Attach Document Template. Error is caused by missing attachment on the saved template. Solution Log in as an Administrator Note: Take note… Continue reading Unable to Send Email When Adding a PDF Template Through Attach Document Template. Error Exception During Message Creation

Resolve Error: “A problem occurred during dunning letter PDF file creation probably due to malformed XML template”

Scenario User is unable to generate Dunning Letter due to an Error: “A problem occurred during dunning letter PDF file creation probably due to malformed XML template” The error is usually received if there is a missing HTML Tag on the Dunning Letter Template.  To resolve, check the exact Error message of the Template in Customization > Scripting… Continue reading Resolve Error: “A problem occurred during dunning letter PDF file creation probably due to malformed XML template”