If you have your vendor banking information stored in a separate system (like your ERP), you can upload this information in flat file format into Fidesic
Overview
When you start using Fidesic for ACH you may have existing vendor banking information that you need to migrate into Fidesic. You can upload vendor banking info using our flat file uploader.
Note: Once uploaded, this information is stored in an encrypted form and will not be visible to anyone. The flat file you created for uploading should be destroyed appropriately after upload.
Process
Login to Fidesic and navigate to your Import Files page.
Select the Vendor Bank Accounts import
Note: This import is only available to the Fidesic Account Owner. If you're not sure who is the account owner, head to the Manage Users page and look for the Account Owner Tag.
Upload your flat file with the required column headers. This will attach Vendor Banking information to your vendor records. The next time you upload a batch of payments you can pay these vendors via ACH.
SQL Script to Pull Vendor Banking info From GP.
SELECT
pm.VENDORID,
sy.BANKNAME,
sy.EFTBankAcct,
sy.EFTTransitRoutingNo
FROM PM00200 pm
LEFT JOIN SY06000 sy ON pm.VENDORID = sy.VENDORID