You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Many to Many or Many to 1?

I need help deciding whether my rule should be Many‑to‑Many or Many‑to‑1.

Scenario:

GL Side

ID field = TCH
Date = same day
There are multiple GL transactions for that ID/date, and together they total 300,000.

Bank Side

CH field can be NO, OS, or NS
Bank Date can be within 7 days after the GL date
There are Bank transactions for the CH field and different bank dates, and together they total 300,000.

Rule Setup So Far

I applied filters on both GL and Bank sides.
I grouped the GL conditions by ID field + Date.

The match conditions include:

Amount = exact match

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!