Change the Internal ID Field on the Payment File Administration (PFA) file to the Vendor ID

Scenario

On the Payment File Administration (PFA) record, when the file is created and uploaded to the Bank, it includes Internal IDs of the Bank Payment Records. Here’s how you can change it to the Vendor ID instead.

Solution

1. Log in as Administrator
2. Navigate to Payments > Setup > Payment File Templates
3. Edit the template used in the Payment File Administration
4. Bank File Template field
5. After this line on the code: <#list ccdPayments as payment>, add this line: <#assign entityId = payment.entity>
6. Locate this line on the code: ${setLength(ebank.custrecord_2663_parent_vendor.entitynumber,15)}
7. Change it to: ${setLength(entityId,10)}
8. Click Save
9. Open the PFA record
10. Click Recreate File button
11. Wait for the File to finish processing
12. The new File Reference should now show the Vendor ID instead of the Internal ID