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
Category: Errors & Solutions
Articles related to errors and its solutions
Understanding SSS_STATEMENT_COUNT_EXCEEDED Error in NetSuite
Error Summary Error: SSS_STATEMENT_COUNT_EXCEEDED Script Execution Statement Count Exceeded Script Type: User Event Script Function Triggered: afterSubmit Environment: Production Error Time: 09/19/2025 09:41 AM Execution Time: 0.00s What This Error Means This is a SuiteScript governance error triggered when the script exceeds NetSuite’s maximum statement count limit during execution. NetSuite allows a maximum of 10,000… Continue reading Understanding SSS_STATEMENT_COUNT_EXCEEDED Error in NetSuite
Number of working days using a date field to get that months working day
CASE WHEN {date} IS NOT NULL THEN TO_NUMBER(TO_CHAR(LAST_DAY({date}), ‘DD’)) – (FLOOR( ( (TO_NUMBER(TO_CHAR(LAST_DAY({date}), ‘DD’)) + ( TO_NUMBER(TO_CHAR(TO_DATE(TO_CHAR({date}, ‘YYYY-MM’) || ‘-01’, ‘YYYY-MM-DD’),’DD’)) -1) ) / 7 ) ) * 2) ELSE 0 END
RATIO_TO_REPORT() OVER () —- % of Total Function alternative
A workaround for this scenario is to use the RATIO_TO_REPORT() OVER () formula in the Formula column, and then select one of the Round functions from the Function drop down menu. The steps below show how to create a Transaction Saved Search to show the total sales per customer and the percentage related to the total sales of the company. The search results include… Continue reading RATIO_TO_REPORT() OVER () —- % of Total Function alternative
SQL Fornula to check if one string or ID contains in a concat string using summary FUnctions
CASE WHEN INSTR( TO_CHAR(REPLACE(NS_CONCAT(DISTINCT {custrecord_jj_transaction_number_ahap729.salesteammember.id}), ‘,’, ‘<br>’)), TO_CHAR(MAX({custrecord_jj_sales_person_ahap_729.id})) ) > 0 THEN ‘Y’ ELSE ‘N’ END add this in the formula text Maximum
Wave Still Showing In Progress
Scenario: The user has reported that a Wave is still marked as “In Progress”, despite the fact that the corresponding order has already been shipped and billed. Solution: The most frequent reason a Wave remains “In Progress” is that there are associated pick tasks that are still ongoing. This represents a critical dependency within the… Continue reading Wave Still Showing In Progress
Financial parser plugin – Connection issue
Problem Statement: In the match bank data page following error occurred and further checking it was found that the connection was not established and occurring as shown below Plugin scripts for Connectivity are locked and it’s a managed bundle. Solution: While checking the backend logs it was found that the custom record search throwing error.… Continue reading Financial parser plugin – Connection issue
Fulfill button missing in sales order record
The possible reasons are, The absence of the Fulfill button on a sales order can be attributed to several factors. Firstly, it may be due to the sales order being in a Pending Fulfillment status, as indicated in the documents for NetSuite 2019.2, 2022.1, and 2022.2. In such cases, the Fulfill button is not displayed.123… Continue reading Fulfill button missing in sales order record
Allow multi select in bank reconciliation
In the console, we can type the below. document.querySelectorAll(‘.uif1506.uif1510.uif1513.uif1515.uif1438’).forEach(el=>el.click()) It will multi-select 111 records at a time
Print picking ticket page saved search sample reference’s
Ignore Item Availability search below Search : JJ Print Picking Ticket JJ Print Picking Ticket: Results – NetSuite (Magswitch Technology Worldwide Pty Ltd) Open image-20250522-053713.png FYI: When you move to production, all three searches may be revamped as this is correct now based on the SB data only @Shekha E K @Angel Mariya… Continue reading Print picking ticket page saved search sample reference’s