Partner Bank Type In Vendor Master

Financials (FI, CO, TR, EC)

Moderators: Snowy, thx4allthefish, Baz, darkduck

Post Reply
charlo
Posts: 9
Joined: Thu Aug 13, 2009 1:39 am

Partner Bank Type In Vendor Master

Post by charlo » Wed Nov 14, 2012 2:38 am

Hi Gurus,

I am faced with the following issue and need some advice

We have 1 vendor assigned to multiple company codes. As the vendor banking detail falls under the basic data view of the master data all information is the same for all company codes.

We are populating the reference details field in the banking detail of the vendor. What ever is in here will display on the vendors bank statement as payment reference. The problem we are facing is that the reference should be different for each company code.

I thought I could bypass this by entering another line with the same banking details and enter a different reference. Assign these duplicate lines to a Partner Bank Type Key. I am receiving an error message that the bank details has been duplicated Message no. F2049

Hope you can assist.

Regards

Charl

slinkyjib
Posts: 293
Joined: Mon May 17, 2004 3:15 am
Location: 29 Acacia Road

Re: Partner Bank Type In Vendor Master

Post by slinkyjib » Wed Nov 14, 2012 3:46 am

If you created another line, how would the payment program know which line to process?

Why does the reference need to be different per company code? as this is payment information to the bank rather than on the remittance advice.

darkduck
Posts: 2472
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?
Contact:

Re: Partner Bank Type In Vendor Master

Post by darkduck » Wed Nov 14, 2012 4:29 am

slinkyjib wrote:If you created another line, how would the payment program know which line to process?
That's why "Partner bank" field is available in the document: you can specify which bank account send money to.
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...

charlo
Posts: 9
Joined: Thu Aug 13, 2009 1:39 am

Re: Partner Bank Type In Vendor Master

Post by charlo » Wed Nov 14, 2012 7:38 am

Hi,

First of all this is a flat file that is being sent to the bank.

The payment program actually looks at the partner bank type key created in the banking details. This key you specify in FB60 under the payment tab. That is how the payment program picks this up.

Various company codes do business with this vendor. So the vendor is able to see via the reference on his bank statement which company paid them. This reference is entered in the banking details (general data of the vendor).

Regards

Charl

darkduck
Posts: 2472
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?
Contact:

Re: Partner Bank Type In Vendor Master

Post by darkduck » Wed Nov 14, 2012 7:52 am

I am not sure you can overcome this message. All the places where it is called up, there is a hardcoded logic to verify the uniqueness of the key country/bank number/account number.
You will probably need to create another vendor.

As a side note, usually vendor prefers to see the invoice number rather than the paying company name. It more helps in cash allocation.
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...

charlo
Posts: 9
Joined: Thu Aug 13, 2009 1:39 am

Re: Partner Bank Type In Vendor Master

Post by charlo » Wed Nov 14, 2012 8:19 am

Hi,

Thanks for your reply. I first wanted to see if there was a way around this before I suggest creating seperate vendor accounts per company code. I agree with your side note, but this was a specific requirement from the client.

I have suggested they enter a reference in the account memo field under the correspondence tab and ABAP will then direct their program to that field.

Kind Regards

Charl

slinkyjib
Posts: 293
Joined: Mon May 17, 2004 3:15 am
Location: 29 Acacia Road

Re: Partner Bank Type In Vendor Master

Post by slinkyjib » Thu Nov 15, 2012 3:41 am

Is it bad that I actually find this one interesting?..This seems like something so trivial i.e. so obvious that it should be available without even having to think about it. I love SAP.


Darkduck has probably got a bit further with experimenting than I have, but have you considered turning off the duplicate error message at the master data level? (Would this then be picked up elsewhere? or would this allow you to process with less ABAP than otherwise?)

darkduck
Posts: 2472
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?
Contact:

Re: Partner Bank Type In Vendor Master

Post by darkduck » Thu Nov 15, 2012 3:56 am

slinkyjib wrote:Is it bad that I actually find this one interesting?..This seems like something so trivial i.e. so obvious that it should be available without even having to think about it. I love SAP.


Darkduck has probably got a bit further with experimenting than I have, but have you considered turning off the duplicate error message at the master data level? (Would this then be picked up elsewhere? or would this allow you to process with less ABAP than otherwise?)
I looked into the code. As i mentioned, the message is hardcoded without an option to configure.
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...

Post Reply