Scenario
A user created a custom version of the standard ACH CCD/PPD Payment File Template in NetSuite to support a small formatting change required by the bank for ACH uploads.
After updating Vendor Bank Details records to use the new custom payment file template, the user noticed that not all Vendor Bills appeared on the Bill Payment Processing page. Only a portion of the bills were available when using the custom template, while the remaining bills only appeared when switching the Company Bank Details back to the original ACH CCD/PPD template.
The user wanted to understand why the bills were still tied to the old payment format even after updating the Vendor Bank Details through CSV Import.
Solution
This behavior occurred because updating the Vendor Bank Details through CSV Import did not fully update the relationships between the existing bills and the associated Bank Details records.
Although the Vendor Bank Details records appeared to reference the new custom payment file template, the existing Vendor Bills were still linked to Bank Details records associated with the original ACH CCD PPD format.
Recommended Validation Steps
When troubleshooting this issue, review the following:
- Confirm that all Vendor Bank Details records were successfully updated
- Verify whether existing Vendor Bills are still tied to older Bank Details records
- Check whether Vendors have multiple Bank Details records assigned
- Confirm the correct Bank Details record is marked as primary or default for the Vendor, Subsidiary, and Currency combination
Resolution
The issue was resolved by manually updating each Vendor Bank Details record to use the new custom payment file template directly within the record rather than through CSV Import.
After manually saving the updated Bank Details records:
- All Vendor Bills became available on the Bill Payment Processing page
- The payment file template relationships were refreshed correctly
This indicates that additional internal processing or scripting occurs when the Bank Details record is manually updated, which may not be triggered through CSV Import updates alone.
-----
If you find this information useful, let us know by reacting or commenting on this post!
