If the output file is not created successfully when using FreeMarker as the template engine, the Payment File Administration page shows a status of Processed with Errors, with details indicating that the system failed to render the payment file template. This error is caused by one of the following conditions: The Advanced PDF/HTML Templates feature… Continue reading Debugging EFT Template Errors
Author: Angel Mariya
Render HTML Markup on a Suitelet From an HTML File in File Cabinet
Scenario A user wants to create their own form/HTML page using a Suitelet. Instead of concatenating a string that represents HTML markup, the user would like to use an HTML file uploaded into their File Cabinet and render it onto a Suitelet. Solution This can be accomplished by using the write method of the ServerResponse object,… Continue reading Render HTML Markup on a Suitelet From an HTML File in File Cabinet
Removing CRLF (End of Line) Character
When working with templates, you may want to control the presence of end-of-line (CRLF) characters in your output. Typically, placing output tags on separate lines introduces line breaks. To remove the CRLF character at the end, use the FreeMarker tag <#rt> directly after your content: Template: #OUTPUT START # ABC #OUTPUT END # Output : With this adjustment, the… Continue reading Removing CRLF (End of Line) Character
Show Amount Due for Each Invoice on a Customer Statement Using Advanced PDF/HTML Template
Scenario The user needs to display the Amount Due for each Invoice on a Customer Statement printed with the Advanced PDF/HTML Template. Solution Navigate to Customization > Forms > Advanced PDF/HTML Templates Preferred Custom Statement PDF/HTML Template: Click Edit Top right corner: Toggle Source Code Look for the line of code that contains class=”itemtable” Within the <thead> tag, insert the following code: <th align=”right”>Amount Due</th> Within… Continue reading Show Amount Due for Each Invoice on a Customer Statement Using Advanced PDF/HTML Template
‘Current Record’ value is not appearing in Selection list of the Set Field Value action on the Workflow
Problem Statement: We have encountered an issue during the workflow development where the ‘Current Record’ value is not appearing as expected in the Selection list of the Set Field Value action on the Workflow. This seems to be due to the large volume of transactions in the account, which causes the field values to buffer… Continue reading ‘Current Record’ value is not appearing in Selection list of the Set Field Value action on the Workflow
Renaming of the System Notes Permission
The existing name used for the System Notes permission will change to System Notes for Analytics and REST, Effective from June 10, 2025. The System Notes for Analytics and REST permission allows you to query system notes through the analytics data source. This update won’t change how the permission works. The permission will continue to… Continue reading Renaming of the System Notes Permission
Online Form Validation by ReCAPTCHA
There are instances where Online forms are vulnerable to BOT attacks, leading to the creation of multiple fraudulent LEAD records in NetSuite. One way to overcome this is to use ReCAPTCHA by Google, which protects websites from spam and abuse by distinguishing human users from automated bots. However, the said feature is an enhancement which… Continue reading Online Form Validation by ReCAPTCHA
OAuth 2.0 over OAuth 1.0
OAuth 2.0 is preferred over OAuth 1.0 for several reasons: 1. Simplicity of Implementation OAuth 1.0: Requires complex cryptographic signatures to verify requests. This means developers have to deal with complicated encryption methods and handle signing each request, which can be tricky and error-prone. OAuth 2.0: Uses simpler bearer tokens for authentication. This means you don’t need to… Continue reading OAuth 2.0 over OAuth 1.0
Total Sales Orders per Day Using SuiteQL
SuiteQL in NetSuite enables the extraction and manipulation of data from your NetSuite account. It provides users with flexibility and efficiency when accessing data by allowing them to design complicated queries to retrieve specific information. Here’s an example SuiteQL query for calculating total revenues per day. SELECTTranDate,COUNT(*) as Count,SUM(ForeignTotal) as TotalFROMTransactionWHERE( Type = ‘SalesOrd’ )AND (… Continue reading Total Sales Orders per Day Using SuiteQL
Display the Line Memo Field in a Balance Sheet Report
Finance teams frequently require an evaluation of the specifics behind specific Balance Sheet entries, such as transaction line memos, in order to comprehend the context of each line item, particularly in Journal Entries. By adding the transaction line memo to the Balance Sheet report, administrators can ensure these important details are displayed directly within the… Continue reading Display the Line Memo Field in a Balance Sheet Report