Vendor Payments

[Former Member]

Hi Gurus,

In vendor master data, we configure more than one bank account for the vendor with multiply currencies. How do I make sure that whenever I have a USD payment, the payment is made to the vendor's USD account?

Thanks,

Josef

[Former Member · Accepted solution]

I found the correct answer in this thread -

[Former Member]

For Controlling the Bank Business Partner Bank account Selection ( Vendor or Customer ) it is advisable to enter the Partner Bank Type in the Accounting Document( vendor/Customer) line Item.

The same Partner Bank Type identify the bank account in vendor Master Data.

Depending on the origin of the document you may set up validation and substitution , or user exit to populate the Partner Bank Type in the document .

Thanks.

Maulesh

[Former Member]

Partner bank type in the invoice is not a standard field right? So you are suggesting we customize this in the invoice?

[Former Member]

Partner bank type is a standard field on vendor and customer line items .

click on additional data on line item to view it.

Bank type field on line item may be hidden due to field status of posting key or Field status group assigned to GL account .

Thanks.

Maulesh.

[Former Member]

When I try to post via FB60, I do not see a partner bank type field. Am I not supposed to find one there? Shouldn't I because this is a vendor specific document?

[Former Member]

Please see the highlighted field Part Bank in FB60.

Select the bank that you want to pay with.

Partner Bank Entries are maintained in Vendor Master Data with Partner Bank type as Key..

Thanks.

[Former Member]

Hi All,

I don't think you understand my question. I just want to rephrase it to be clear. How do I know which vendor bank account my company code is paying when doing an F110 payment run? I am aware you can check this via the vendor master data but if I had more than 1 bank account for the vendor. How do I know which vendor bank account was paid by my company code?

Thanks,

Josef

[Former Member]

Hi

1st of all your question is not clear ...now you are coming to the point....

1. Its on depends  on the Bank raking order

2.based on your assigment in the vendor msater

3.Based on our assigment at vendor invoice level

4.you can check at edit proposal....

5.once post the document ...in FB03 you check at check information deatails for respective payment document....

6. if you want to know more clear ...check in quality by testing

Regards

asuvamsi

[Former Member]

Hi Josef,

In Vendor Master data, you can specify the Bank type (Field BnkT) in tab Payment transaction, where you maintain Bank data.

This field is free text.

Example:

Bank account 1 - Currency USD - Bank type USD1

Bank account 2 - Currency SGD - Bank type SGD1

When you post invoice, you should fill Bank type (field Part.Bank) in More data.

When you run F110, the system will pick bank account to be paid based on Partner Bank Type (besides configuration in FBZP)

You can check the result in Proposal log.

Julie

[Former Member]

Hi Julie,

Thanks for your response! I can't seem to see the vendor's bank account or bank type in the F110 proposal though. That is actually what I want to discover too, where the system says that the specific vendor bank was paid to.

I hope you can help where I can find this.

Thanks,

Josef

[Former Member]

Hi Josef

You can check the Payee's account number in display proposal and payment logs,

Below is the screenshot after the payment proposal. You need to check the Payee's account number in your case.

[Former Member]

Hi Josef,

In tcode F110, go to menu Edit > Proposal > Proposal list

Then, press Enter, you can see the bank information of Vendor in the right side of Header.

Sorry, I cannot attach screenshot here..

Julie

[Former Member]

You don't have the payee's account number displayed in your screenshot. So does mine.

[Former Member]

I checked both Proposal and Payment List but I do not see any vendor bank account number

[Former Member]

For That you need to check layout.... like go to setting click on line layout to display vendor bank account number at edit proposal...in F110

Regards

sudharsana

[former_member218253]

Hi

Suggest you take it thru to payments and see if the payment is based on Bank Type as suggested by Julie.

[Former Member]

Hi Rosef,

Can you share the screenshot?

[Former Member]

[Former Member]

Hi Josef,

I have searched around and found that there is one guy met the same error to you, but it's not solved.

http://scn.sap.com/thread/2116175

This is some related SAP notes:

RFZALI20: Bank control key not displayed

RFZALI20 and IBAN

I think you should raise OSS to get solution from SAP.

Julie

[Former Member]

Hi...

from here click on control+F8 and there the following layout

Hope it will helps

Regards

[Former Member]

Still does not come out

[Former Member]

Hi Josef

My case is different, it is a inter company netting scenario were I don't need the bank account as I don't send file to bank in the example which I have given.

Please, check your scenario.

Regards

Nikhil Kothari

[Former Member]

Hi

1. Did you run the Print schedule?

2. did you tick the create payment medium option while run the F110?

Regards

Sudharsana

[Former Member]

Hi Julie,

You're answer in another thread fixed my problem. Thanks! you are a lifesaver!

Cheers,

Josef

[Former Member]

Hi

One other option is:

say you have Vendor A , Bank X for USD and Bank Y for Non-USD

1) create another Vendor, say Vendor B (with same details as Vendor A) and bank X details assigned to it

2) Assign Vendor B as permitted payee of Vendor A

3) write a substitution rule saying when LIFNR = A and WAERS = USD, EMPFB = B

with this, when doing F110 the payment goes to vendor B (nothing but Vendor A bank X)

Hope this helps

Thanks

[former_member188028]

You can use bank type option in vendor master_payment transactions tab. Here you can maintain bank details of vendors, while creating the invoice based on the document currency/vendor currency you can choose vendor bank in transaction itself. Rgds MBN

[former_member218253]

Hi

I may be wrong but I dont think there is any other way except the user manually allocating the bank at the edit proposal stage.

[former_member183378]

Hi Josef,

The same is defined in Ranking order oin Bank determination of FBZP Settings.

Here you can define the which payments need to prioritized according to the currency from the bank accounts.

For more details on ranking order pls chk the below given link.

https://scn.sap.com/thread/983890

Thanks & Regards,

Lakshmi S

[Former Member]

Hi Lakshmi,

I am aware of the FBZP ranking order settings but isn't that the settings for the company code's banks. Meaning, these are settings to know which bank account the company code will use to pay the vendor. My question is how the company code knows which vendor bank account to pay?

Thanks,

Josef

[Former Member]

Hi Josef,

Please enter the bank deatail in vendor msater like mention in the screen shot.

Based on the system will behave.

one more option ...you can seen blow option also...in F110 at edit proposal....enter the house bank and  bank account number manually at re-allocatin step.

Hoep it will helps.

Regards

Sudharsana

[Former Member]

Hi Josef,

You need to use BTE 1810 to write your custom logic in the function module, that, if the Invoice transaction currency is USD, select the Vendor bank account in USD currency. You can maintain USD in Partner Bank type. It is a freely definalble field in Vendor master. In case you do not use this BTE, it would pick up the first bank maintained in master by default.

This BTE needs to be maintained in transaction code FIBF. Take help of ABAPer for custom logic.

Regards,

Kavita

[Former Member]

Hi Josef,

First one is go to Vendor master purchasing data Order currency will be changed.(INR> USD)

Second one is Create two vendor codes.One is Domestic vendor code& Import vendor code.Then payment done in Reqiured currency codes.

Regards

Srilatha

[Former Member]

Hi

Please check SAP note : 0001412591 F110/BTE1810: Changing predefined house bank

You need to implement the BTE 1810 , make à Z copy of SAMPLE_PROCESS_00001810 FM -

transaction FIBF > Settings > Process Module > of a customer > New entries > 00001810

Add your Z FM

Regards

[Former Member]

Hi Josef,

You have to define the payment method for country in tc: fbzp.. payment method in country ( For US need to maintain a payment method) the same payment method you have to assign in the vendor master.

Regards

Dileep

[Former Member]

Hi Dileep,

I am rephrasing my question. Please see scenario below:

I have an invoice in USD and I make a payment to a vendor who has both a USD and SGD bank account in his vendor master data. By the default, will the company code pay the vendor in his USD bank account?

Josef