cancel
Showing results for 
Search instead for 
Did you mean: 

Paying vendor to different banks based on currency

Former Member
0 Kudos

Everyone,

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

Cindy

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I want to make clear, we are not entering the partner bank type on the vendor invoice.  The only step we did was to define a partner bank type on the vendor banks. 

Cindy

Former Member
0 Kudos

Hi Cynthia,

You're correct. The partner bank is entered in each invoice to specify which bank account will be made payment.

But, have you checked your configuration in tcode FBZP / Bank Determination?

Julie

former_member182575
Contributor
0 Kudos

Use a substitution or validation to enhance this functionality.

Regards

Waza

Former Member
0 Kudos

Yes you are on the right path. In the invoice level, you need to specify the partner bank, system will pick the bank account accordingly. If not , it will always pick up vendor first bank account.