Functions supported by the integrator.io EDI generator

The given below are the functions supported by the EDI generator _counter : The _counter function is relatively new and helps you to count the number of EDI segments generated for the same segment identifier. Set the counter to true for an EDI segment in your definition file. _iterationCount : The _iterationCount EDI function is… Continue reading Functions supported by the integrator.io EDI generator

Extracting Image File Names Instead of URLs in Saved Search Results

Query I have saved search having a column of image fields. Whole extract the search results the image column were providing the url of the image in the file cabinet. I would like to see the image file name instead of the URL. Solution As per checking, this is a feature request filed under Enhancement… Continue reading Extracting Image File Names Instead of URLs in Saved Search Results

Email Notification on Transaction Deletion

Unfortunately at the moment we cannot send email confirmation for a transaction record being deleted. There might be a way by creating an UserEvent Script as an alternative. Please let me know if you are confident with running scripts in NetSuite so that I can I can ask my colleagues from SuiteCloud team to assist you. An… Continue reading Email Notification on Transaction Deletion

Separate tax amount of PST and GST/HST in a Report

Query Is there a method to calculate individual taxes for PST and GST/HST on each line item within a sales transaction? The highlighted columns represent standard fields, but we’re struggling to extract the percentage for these fields in the saved search. Obtaining these percentages would facilitate the determination of separate tax amounts through a formula.… Continue reading Separate tax amount of PST and GST/HST in a Report

Trigger Last Modified Date when email is sent and received via Email Tab

 function checkForParameter(parameter) {             try {                 if (parameter !== “” && parameter !== null && parameter !== undefined && parameter !== false && parameter !== “null” && parameter !== “undefined” && parameter !== ” “ && parameter !== ‘false’ && parameter !==… Continue reading Trigger Last Modified Date when email is sent and received via Email Tab

Reason behind Negative Average Cost of an Item

The main reason behind this negative average cost is the backend costing engine being unable to complete its costing calculation because the period is closed. To prevent this type issue, it’s important to ensure that costing calculations are completed before closing a period. This can be verified in two ways: Inventory Valuation Report – If… Continue reading Reason behind Negative Average Cost of an Item

E-Invoicing (India)

E-Invoicing in India refers to the electronic generation and authentication of invoices under the Goods and Services Tax (GST) system. It is designed to standardize and streamline the invoicing process for Business-to-Business (B2B) transactions, exports, and certain other categories. The system ensures that invoices are reported to the GST portal and validated with a unique… Continue reading E-Invoicing (India)

Published
Categorized as Financials

Auto-tag summary accounts during import -Netsuite

Summary Accounts need to be checked manually during COA Import in Netsuite. Solution to tag summary account automatically during import of Chart of Accounts in Netsuite. Configuration Procedures 1.Create a Custom Field name “Is Summary” under Other Record Fields and give record type as Account. 2.Keep the Custom field as checkbox and save. 3.Create a… Continue reading Auto-tag summary accounts during import -Netsuite