ANS-1911 · WEB SERVICES & INTEGRATIONS
How to Resolve NetSuite Payment File Upload Rejection Due to Past Processing Date?
When a financial institution rejects a NetSuite payment file due to an outdated processing date, users can either reprocess the existing file or create a new payment file.
Short answer
To resolve payment file rejections from banking portals like Capital One due to past processing dates, reverse the payments on the Payment File Administration (PFA) record. Then, either update the processing date on the existing PFA and reprocess it, or create a new PFA for the reversed bills with a current processing date.
Scenario
A NetSuite Payment File, generated from a Payment File Administration (PFA) record, was uploaded to a financial institution's banking portal. The financial institution, such as Capital One, rejected the upload because it only accepts payment files with a processing date of today or in the future, not files with past dates.
Solution
The issue of payment file rejection due to an outdated processing date can be resolved using one of two methods:
Option 1: Reprocess the Existing Payment File Administration (PFA) Record
On the PFA record, click "Reverse Payments." This action reverses the Bill Payment Record for each vendor bill associated with the PFA. The Bill Payment Record normally *Debits Accounts Payable* and *Credits Bank*.
After reversing the payments, the Bill Payment Record will be marked as voided. A journal entry (JE) will be linked to the voided Bill Payment Record, *Debiting Bank* and *Crediting Accounts Payable*.
On the Payment File Record, click "Edit," update the processing date to today’s date, and click "Save."
Then, click the "Reprocess" button and allow the PFA to reprocess. When the XML file is opened, it will display today’s date, which should resolve the upload issue with the financial institution.
To verify, check the relevant bills and navigate to the *Related Record subtab > Payments Sublist*. You will observe two payment records: one marked as voided, and the other as applied.
Option 2: Create a New Payment File Administration (PFA) Record
Reverse the payments on the existing PFA. This will reverse the Bill Payment Record for each vendor bill, similar to Option 1. The Bill Payment Record will *Debit Accounts Payable* and *Credit Bank.* After reversal, the Bill Payment Record will be marked as voided, with a linked journal entry that *Debits Bank* and *Credits Accounts Payable.*
The status of the original PFA will remain in the "Cancelled" state.
Go to *Payments > Payment Processing > Bill Payment Processing*, locate the reversed bills, select them, enter the EFT File Reference Note, and click "Submit."
Refresh the newly created PFA until the payment file is generated.
Important Note:
Both options are viable. However, if Option 2 is utilized, the original PFA will be in a "Cancelled" state. While the "Reprocess" button may still be available on the cancelled PFA, attempting to use it will fail because the bills have already been marked as paid in the new PFA created in step 3 of Option 2.
Expert NetSuite Support
Need help with this NetSuite issue?
Web Services & Integrations consulting and configuration support
