F110-Automatic Selection of vendor bank by document currency

[Former Member]

We are currently on version 5.0 and have a situation where one company code wants to eliminate the manual input of partner bank type-field BVTYP into the invoice document. The desired objective is to have the system automatically populate the field dependant on the currency in the document. The vendor master has several bank accounts within the same country, but with different bank accounts depending on the currency to be paid. The field has been populated with a representative country designation followed by the currency type. Payment grouping has been tried by creating a new type using the partner bank type. We are not using payment requests at the current time. Optimization has been briefly investigated.

Does anyone know or have exposure on how to get the payment proposal to show the same vendor with the two different bank accounts that are paid from different partner bank types? Since this pertains to just one company code we don't want to create a customized program.

Thank you for any suggestions.

[Former Member]

Hi Sara,

We are having a problem with the BVTYP field while running the F110 and wondering you other guru may know how to solve it. We run the proposal in F110 for a vendor for 2 documents, one credit memo and one invoice (invoice amount is greater than credit memo's), currency for both documents is USD and vendor has ban types USD and MXN. We are expecting the proposal to show the USD bank account for the vendor, so we can pay the document in USD (as the document currency), however the proposal is using MXN and don't know why, does anyone know?, please help.

I checked configuration for payment program and we do have defined both banks, one for MXN and one for USD for the same payment method as the 2 documents (T) and both banks has same ranking = 1.

[Former Member]

Question for you-Within the banking details on the vendor, which bank is set up first? We have run into a similar problem but it occurs when we have two USD or similar banks and one has details in the bank reference field and the other does not. The partner bank type is not selected in the document and the system will go to the first bank in the queque. The other think I can think about offhand is has some selected the currency as a field within the payment proposal to exclude? This will exclude the currency you have indicated, but this doesn't sound like your issue. I have run accross this at another client in which they had the payment currency specified in the document as one thing and the actual document currency was something else. Sorry I can't be more helpful. Could you give me some details of how your vendor master is set up? Are you using any bank chains?

Regards,

Sara Perry

[Former Member]

Hello Sara,

On my case, it resulted to be an odd situation. Problem appeared when we had credit memos and invoices in the payment proposal, but situation was that we had the invoices making reference to the credit memos and this caused the problem. At the moment we switch that reference now adding the invoice number into the credit memo, the automatic payment program selected the right bank type according to the invoice bank parameters.

Thanks for your attention.