cancel
Showing results for 
Search instead for 
Did you mean: 

ICMR: One-Sided Matching Rule for Clearing Document

Bohdan
Active Contributor
0 Kudos
797

Hi Experts,

I've an interesting case for ICMR reconciliation, where I need some advise. The situation is as follows. I have a clearing document for a company code with two lines. Line items balance to 0. There is no corresponding document in partner company code. The obvious solution is to group these items on one side with a matching type GM "Group as matched" and assign a dedicated reason code with proper description. The requirement is to set up a rule within matching method that would automate this matching.

During the setup of the matching rule, I can limit the logic per account type & document type. That's easy. But key requirement is that this rule should apply only when the balance of IC-items is 0. I do not see any option of this kind under the filters. The explanations for Expert Mode also do not provide much help. Can anyone suggest if that's possible to use the SQL-engine in Expert Mode for an analysis of this kind ? If yes, how to approach the task ?

Regards,

Bohdan

Accepted Solutions (1)

Accepted Solutions (1)

vincezk
Product and Topic Expert
Product and Topic Expert

Hello Bohdan,

So far the engine doesn't provide a solution. This is a known missing feature that describes as below:

"Allow group-by fields when defining group-only rules. For example, reversed items can be grouped with reversing items for the same reversing document number. "

However, as a workaround, you can simply group all cleared lines into one assignment(using xreversed is true). The drawback is you have to regroup by the reversing documents to understand each transaction. If you want to do some auto follow-ups, you have to group each tranactions by yourself.

B.R.

Vince.

Bohdan
Active Contributor
0 Kudos

Hi Vincent,

Thank you for the confirmation ! I hope there are some plans to introduce a new functionality that would close this gap.

Regards,

Bohdan

Answers (0)