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

Auto Approval on period activity as 0

Received Response
34
Views
3
Comments
edited Sep 17, 2019 12:42PM in Account Reconciliation 3 comments

Summary

Auto approval of reconciliation with adjustment in the subsystem in previous month

Content

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  

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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