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
Tagged:
0