How to close recons where same account from different GLs have the same balances
Any advice appreciated regarding implementing a solution to the following requirements.
We have the same entity-account-channel in a primary GL and a secondary GL in ARCS. I would like to add rule in ARCS which approves and submits the reconciliation for the account in the secondary GL, if the balances ( Source System Balance (functional)) equals the value of the account from the primary ledger.
Account ID consists of Ledger-Entity-Account-Channel.
Summary of Rule Logic
When secondary ledger and primary accounts IDs match e.g.
HU TESCO SECONDARY-0206-20300-0000 == HU TESCO PRIMARY-0206-20300-0000
and closing balance is the same - approve, submit and close the reconciliation.