Sales Rep full Name: CONCAT({employee.firstname}, CONCAT(‘ ‘,{employee.lastname})) Month Wise Sort: CONCAT( CASE TO_CHAR({trandate}, ‘MM’) WHEN ’01’ THEN ‘a. ‘ WHEN ’02’ THEN ‘b. ‘ WHEN ’03’ THEN ‘c. ‘ WHEN ’04’ THEN ‘d. ‘ WHEN ’05’ THEN ‘e. ‘ WHEN ’06’ THEN ‘f. ‘ WHEN ’07’ THEN ‘g. ‘ WHEN ’08’ THEN ‘h. ‘ WHEN… Continue reading Workbook Pivot Formula
Category: Errors & Solutions
Articles related to errors and its solutions
Error in Bank Statement Import Via Financial Institution
The Error: The file could not be parsed or imported because of the following error: The file upload failed due to one of the following reasons One or more CSV column headers do not match the format profile’s Field Mapping subtab values. The uploaded CSV file is not in UTF-8 encoded format. Check your CSV… Continue reading Error in Bank Statement Import Via Financial Institution
How to resolve error “INVALID_FLD_VALUE The field custrecord_ste_backend_inv_error_details contained more than the maximum number ( 4000 ) of characters allowed.”
Scenario: An error keeps showing when we enter each detail in the Tax Registrations subtab of vendor, or customer records. The error-mentioned field is from the Suite Tax Engine bundle and is a locked one. We have recently migrated to SuiteTax and the new subsidiary implementation is ongoing. The error started after SuiteTax Migration. The… Continue reading How to resolve error “INVALID_FLD_VALUE The field custrecord_ste_backend_inv_error_details contained more than the maximum number ( 4000 ) of characters allowed.”
Custom formula to set the amount based on account type
DECODE({accounttype}, ‘Expense’, (case when {creditamount} >0 then -1 else 1 end), ‘Other Expense’, (case when {creditamount} >0 then -1 else 1 end), ‘Cost of Goods Sold’, (case when {creditamount} >0 then -1 else 1 end), ‘Income’, (case when {debitamount} >0 then -1 else 1 end),’Other Income’, (case when {debitamount} >0 then -1 else 1 end),1)*{custcol_jj_amnt_usd}… Continue reading Custom formula to set the amount based on account type
Debugging EFT Template Errors
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
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