Skip to Content
0
Jul 28, 2023 at 01:39 PM

ICMR: One-Sided Matching Rule for Clearing Document

190 Views

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.

items-leading-unit.jpg

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 ?

rule-definition.jpg

Regards,

Bohdan

Attachments