Validation Checks for transaction matching
Hi, below are two validation checks we wish to complete in ARCS transaction matching. Any thoughts as to how to accomplish these checks at either the individual transaction level or a summed level?
- Missing days check: System to recognize if business dates are missing. For example, if yesterday's data was loaded for business date 2/13 and today's data is loaded for business date 2/15, system should flag 2/14 as missing.
- Ending and starting balances check: System to flag data if the ending balance from previous day does not equal the starting balance from current day.
Tagged:
0