Ignore partner bank type in payment run balance

[former_member610150]

Hi,

In below payment run (F110) situation, the vendor invoice gets paid, despite a debit balance.

Vendor invoice, partner bank type A, -10.000 EUR

Vendor credit note, partner bank type B, +30.000 EUR

Balance +20.000 EUR

SAP note 164835 describes the following: Check the partner bank type in the line items (> Other data > field BSEG-BVTYP). These values must also match for clearing. You can specify the partner bank type in the master record of the business partner for general payment transactions.

What's the business logic behind this? If there's a debit vendor balance, it doesn't seem to make sense to pay the invoice to the vendor (the bank account number should be irrelevant for calculating the vendor balance), right?

Regards

[former_member318765 · Accepted solution]

Dear Borgerink,

In reference to your query on note 164835 please note that in this note we are trying to explain when an vendor invoice and credit memo are clubbed together. For example in your example,

You have a

Vendor invoice          for   -10000EUR with Partner Bank A

Vendor Credit memo for  +30000EUR with Partner Bank B

Then both these will not be grouped together in the first place as partner bank is different for both the cases. So if in f110 you are entering an outgoing payment method then only Invoice of 10000Eur is paid and credit memo will go to exception item as

1. There is no incoming payment method maintained in f110 parameter and

2. As it cannot be grouped with invoice due to difference in partner Bank fields between both items

Structure ZHLG1 gives you the list of fields which must be same for items to be grouped together. This applied to Invoice-Invoice case also i.e.

Vendor Invoice 1 1000 EUR partner bank A

Vendor Invoice 2 2000 EUR partner Bank B

will not be grouped together and paid.

In what can you do section of the note, they are explaining all the possible fields that have to be checked by you to find out why grouping did not take place.

Now in your case assuming all field from structure ZHLG1 are matching then

vendor invoice  -10000 EUR

Credit memo    +30000 EUR

Balance +20000 EUR

Both items are grouped together but if F110 has just outgoing payment method maintained then no payment will happen as it is a debit balance and F110 would expect incoming payment method.

Above explaination should help you to understand the system behaviour.

Kind Regards

Soumya Rao

[former_member610150 · Accepted solution]

Dear Soumya Rao,

Thanks for your clarification. I do now fully understand this behavior from technical perspective. I still find it difficult to understand this system behavior from business perspective though.

In below example 2000 EUR instead of 1500 is getting paid. From technical perspective I do understand that this is because of the different partner bank, but from business perspective it doesn't seem to be logic that the paid amount to one vendor depends on the bank account we are paying to. Do you (or someone else) have an explanation for this?

Vendor Invoice 2000 EUR partner bank A

Credit memo 500 EUR partner bank B

Balance -1500

Regards

[former_member318765 · Accepted solution]

Dear Borgerink,

Here the balance 1500 is not paid and is still a debit balance. Debit balance can be picked up by payment run only if you choose a payment method with incoming payment set. Only credit balances are paid via payment method with outgoing payment method. So I see no issue in business process as well. Hope this explanation is more clear else please feel free to reach me back.

Also for your reference, create a F110 run only with a payment method which is set as outgoing payment and recreate the same case above you can see that it will fail saying debit balance.

Note that for both invoice and credit memo to be clubbed together all the fields as mentioned earlier should be same.

Kind Regards

Soumya Rao

[former_member610150 · Accepted solution]

Dear Soumya Rao,

Vendor Invoice 2000 EUR partner bank A (credit)

Credit Memo 500 EUR partner bank B (debit)

Balance -1500 (credit)

I would expect 1500 EUR getting paid to the vendor, but instead 2000 is paid to the vendor and 500 EUR debit remains open.

Regards,

Jan

[former_member318765 · Accepted solution]

Dear Jan,

Sorry I did not check your exact example. I now understand it. Regarding your question, different partner bank type would have been entered in invoice and credit memo based on business requirement or requirement from your vendor right? In what case are you entering a different partner bank type? If your vendor wants invoice and credit memo to be accounted with different banks it cannot be clubbed/grouped together right? Also if there is no such requirement from vendor/business then there is no need to enter different partner banks in items and they would be clubbed together in that case and 1500 would be paid.

Similarly for other fields of ZHLG1 which is considered for grouping. For example you have a Payment method for Check say "C"and Payment Method for Transfer say "T" entered in the open items. These items cannot be clubbed or grouped together as it has been mentioned that the way they are paid is differently one with check other with transfer hence we need 2 payment documents here.

Hope I have explained the behaviour from business perspective.

Kind Regards

Soumya Rao

[former_member610150 · Accepted solution]

Dear Soumya Rao,

Thanks for your answer. The requirement for us is that vendors have different bank accounts for different currencies. If there's a payment to bank account A (currency X) and an amount to be received from bank account B (currency Y), we want the payment to bank account A to be deducted with the debit amount to be received from bank account B. I still believe this is a valid business requirement. From technical perspective I can understand this requirement makes clubbing almost impossible though.

Regards, Jan

[former_member318765 · Accepted solution]

Dear Jan,

Sorry I could not respond yesterday. In reference to your specific business requirement, you can use the available BTE's. You can review note 545340 which has more details on BTE's available.

Maybe BTE 1810 can help..you can write a logic for such cases..Please check .

Regards

Soumya Rao

[former_member610150 · Accepted solution]

Thanks Soumya Rao,

This indeed seems to be the best location to implement such change. I will analyze with our technical team. Thanks for your support.

Regards, Jan