We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Custom Attribute scripting for Auto-Reconciliation Rule for Threshold

Question
32
Views
0
Comments
edited Jun 17, 2019 1:44PM in Account Reconciliation

Summary

Rule to auto-submit/approve reconciliation based on Risk Profile (High/Medium/Low) and % Tolerance (0.25,0.50,0.75) respectively

Content

 

We are looking into creating a business rule for their ARCS application which auto-closes and auto-submits reconciliations under a certain % threshold for unexplained variances based on the Risk Rating of the profiles.
If the Risk Rating is 

High -> Tolerance Level is 0.25%
Medium -> Tolerance Level is 0.50%
Low -> Tolerance Level is 0.75%.

We looked at the 'Auto Reconciliation' Method: Balance match (% tolerance), the restriction with this is that Match Threshold % should be a whole number between 1 and 100.

<Image 1>

To overcome this, we're trying to create a customer attribute that can calculate the value of the unexplained difference from the profile. We have used the following script (in Custom Attribute Scripting):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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