Skip to Content
Former Member
Jun 11, 2013 at 07:51 PM

Paying vendor to different banks based on currency



We have been struggling with our ACH payments to vendors where we have invoices in two different currencies (USD and CAD) getting paid to the correct vendor bank account. These vendors typically have two different bank accounts, one for US and another bank account for CA. These banks/accounts are defined on the vendor record. The problem we were having is that regardless of the invoice currency, the invoices were always getting paid to the bank with the CA country code.

Most of these invoices are coming in through interfaces and there are too many to go into each vendor invoice and update the record as to which bank it should pay.

In testing I discovered that if we added a unique identifier to the partner bank type, the payment process seemed to match the banks by currency or bank country code (not sure which).

Does this sound correct? It seems that when the partner bank types were blank, it was defaulting to the first one and the banks were ordered by bank country in LFBK.

Thank you