Auto Approval on period activity as 0
Summary
Auto approval of reconciliation with adjustment in the subsystem in previous monthContent
For our balance sheet recs we are currently loading the Oracle GL balances into Source system and subsystem. The users perform an offline reconciliation and then manually update the Sub system balance if their offline reconciliation determines the numbers do no match.
For our Balance Sheet recs we have setup an Auto Approval rule. The rule is based on the period Activity field and says if the period activity is 0 then Auto submit and Auto Approve the reconciliation.
The problem we have with this is that it only seems to look at the Source System Balance for the movement between periods. This means that any manual updates to subsystem balance and subsequent adjustments in the system are not taken into account for the rule. As an example in Apr we loaded £100 and put in an adjustment of 20 totalling to £120. But in the next month if the loaded balance is £100 it will auto approve the reconciliation ignoring the adjustment of £20