Custom Attribute scripting for Auto-Reconciliation Rule for Threshold
Summary
Rule to auto-submit/approve reconciliation based on Risk Profile (High/Medium/Low) and % Tolerance (0.25,0.50,0.75) respectivelyContent
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):