F110 Grouping Key Issue

[Former Member]

I have 3 open items for a vendor - 2 credit memos (with 1000 and 600 amounts ) and one invoice (with amount 600). In the current situation, these items are not offset against each other as they have different payment methods, payment supplement code etc etc. The only common factor between these items is the company code and the vendor number.

And the current requirement is that, only these 2 fields - company code and vendor number need to be considered in offsetting the open items and all the other fields including the payment method etc should be ignored. So, after some research - I figured out that there is something called a grouping key that can be set in the configuration using transaction OBAP. I set the grouping key in OBAP. And this grouping key needs to be used in the vendor master screen for payments for that particular vendor so that all the other parameters will be overridden by this grouping key. FYI..I set this grouping key 02 to use only the vendor number.

Technically.. SAP says this should work. They also say that if it does not work, go and generate the program RSZGR000 as this program contains the respective code to make the payment run program understand that the grouping key is the overriding factor. So, I generated this program too and made sure the code exists. This grouping key is populated in the structure ZHLG1-PAYGR and the payment run program is supposed to understand that this is the overriding field for offsetting the invoices against credit memos. I debugged the payment run proposal and saw that it is populating this field in the structure.

So, I do all this and yet, my open items are not cleared using JUST the Company & vendor. It is still looking for the other fields like payment methods, supplment code etc.

I was looking up at the note 164835 and found that for automatic payment transactions the following fields need to be same for the documents that are being offset with each other: Currency, Receiver, Payment Mthod in the Item and Bank Details in the item.

I was assuming that once the grouping key is populated and used, all the other fields above should be ignored for offsetting.

Any help in this matter would be appreciated!!

[Former Member]

Hi,

you can configure grouping key at the vendor master data in order to use it .

if u have used it by vendor wise ( grouping Key ). then only it will work.

and in this position u have to your invoice is less then the debit item so it will go to block.

if your invoice is equal debit or less it will be cleared and net will be paid.

hope thisis clear assign points.

With reagrds

Krishna

[Former Member]

I have already assigned the Grouping key to the vendor as I mentioned in my post. I did not understand your debit/credit amount part of it. Can you elaborate? According to my understanding, it is supposed to offset the entries as long as the keys are same irrespective of what amounts we post.

[Former Member]

hi,

if the debit item is more them the invoice then it go block ... as total can not be cleared .

in this case debit is more them the invoice. so it is not cleared.

with regards

krishna

[Former Member]

I do not think that is the issue here. The issue here is that the payment methods are different for these invoices/cedit memos. One of the Credit Memo's has a blank payment method. So, the automatic payment program is not picking that document with blank payment method.

Invoice 1 has payment method C

Credit Memo 1 has payment method S

Credit Memo 2has payment method as blank

There is an option in the Automatic Payment Transactions screen where you enter the company code and payment methods. In the payment methods, we can enter multiple ones - so, I added S and C, but there is no way to tell the program to pick documents with blank payment methods too.

That is why the Credit memo2 is left out and not settled with other documents.

Please let me know if there is a way out for this.

[Former Member]

We want to clear CPD open items (F110) but the system generates as many documents as CPD documents are for a vendor. The payment program is grouping taking in account the field BSEC-EMPFG in the structure ZHLG1. How can we change this behavior? There isnu2019t any OSS note available that explains this issue.

Thanks.

Fernando.