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
Tag: EFT
How to Send an Email When a Field’s Value Changes via Workflow in NetSuite
NetSuite’s Workflow Manager (SuiteFlow) allows users to automate processes such as sending emails when specific field values change. While SuiteFlow supports referencing old record values using “Before Record Submit” triggers, some actions like Send Email require a different approach. Use Case Send an email notification when the Title field value on an Opportunity record is… Continue reading How to Send an Email When a Field’s Value Changes via Workflow in NetSuite
Vendor Bill and Expense Report Requisite To Show In The Eft – Bill Payments Page
Scenario In Payments > Payment Processing > Bill Payment Processing, Vendor Bills and Expense Reports show on the EFT – Bill Payment screen when the following conditions are met: Solution A. Vendor Bills The Company’s Payment File Format and the Vendor’s Payment File Format are the same The A/P Account set in the EFT – Bill Payment Page and in the Vendor Bill are the same EFT Bill Payment checkbox in the Vendor Record is checked Vendor Bills are Approved Vendor Record is not “Inactive”. If… Continue reading Vendor Bill and Expense Report Requisite To Show In The Eft – Bill Payments Page
Electronic Bank Payments > Email notification once the Payment Batch is approved
Once the payment batch has been submitted, the approver receives a notification that a batch is awaiting approval. However, once the batch has been approved the person who created the payment batch is not notified. The creator of the batch can be notified by the Saved Search once the payment batch they submitted is approved. Steps to… Continue reading Electronic Bank Payments > Email notification once the Payment Batch is approved
NetSuite Electronic Payments: Payments > Payment Processing > Bill Payment Processing > Payment File Administration Stuck in Queued Status
Scenario Payment File Administration is Stuck in Queued Status Solution A. Navigate to Customization > Scripting > Script Deployments > Status Check if any Electronic Payment scripts are still in the queue, kindly wait for it to finish. If none, proceed to B B. Navigate to Payments > Setup > Electronic Payments Preferences Click Edit Under the General Preferences tab, populate the following fields:… Continue reading NetSuite Electronic Payments: Payments > Payment Processing > Bill Payment Processing > Payment File Administration Stuck in Queued Status
EFT Template Sample
<#– function definitions –> <#function getReferenceNote payment> <#assign paidTransactions = transHash[payment.internalid]> <#assign referenceNote = “”> <#assign paidTransactionsCount = paidTransactions?size> <#if (paidTransactionsCount >= 1)> <#list paidTransactions as transaction> <#if transaction.tranid?has_content> <#if referenceNote?has_content> <#assign referenceNote = referenceNote + “, ” + transaction.tranid> <#else> <#assign referenceNote = transaction.tranid> </#if> </#if> </#list> </#if> <#return referenceNote> </#function> <#function convertSEPACharSet text>… Continue reading EFT Template Sample
Resubmission of EFT (Electronic Fund Transfer) customer payments with Canceled, Failed or Unknown Error status
Whenever users re-submit EFT customer payment, the bank information recorded in the Electronic Fund Transfer tab of the customer record is used. If users updated the bank information prior to resubmission, NetSuite will send the new bank details to Coastal for processing.
Electronic Payment Processing stuck in “Queued” status
There are instances where users have their Payment File Administration (PFA) stuck in Queued status and it usually happens when it is their first time to process PFA’s ( Payment File Administration). In order to re-trigger the Setup, Edit and Save the Electronic Payment Preferences without doing any changes. In case the PFA (Payment File… Continue reading Electronic Payment Processing stuck in “Queued” status
Expense Report not Showing on EFT Bill Payments Page
Scenario There are instances when an Expense Report does not show on the EFT Bill Payments Page even after it has been Approved. Solution An Expense Report will shown on the EFT – Bill Payment* screen when the following conditions are met: The Company’s Payment File Format and the Employee’s Payment File Format are the same The A/P Account set in the EFT – Bill Payment Page and in the Expense Reports are the… Continue reading Expense Report not Showing on EFT Bill Payments Page
Expense Report not Showing on EFT Bill Payments Page
Scenario There are instances when an Expense Report does not show on the EFT Bill Payments Page even after it has been Approved. Solution An Expense Reports will shown on the EFT – Bill Payment* screen when the following conditions are met: The Company’s Payment File Format and the Employee’s Payment File Format are the same The A/P Account set in the EFT – Bill Payment Page and in the Expense Reports are the… Continue reading Expense Report not Showing on EFT Bill Payments Page