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