ICMR: One-Sided Matching Rule for Clearing Document

[Bohdan]

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

[vincezk · Accepted solution]

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 · Accepted solution]

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