Auto reconciliation requirement
SummaryKey auto recon requirements converting Blackline to ARCS
- Prevent Auto-submit or Auto-reconciliation if the Unexplained Difference is $1000 OR Greater than 10% of GL Balance -> I am not able to calculate the 10% value of GL balance (reporting) as that attribute also bring the ‘USD’ string with it and doesn’t let me multiply 0.1 to it. I tried few other ways like SUBSTRING to drop the last 4 characters to get the number value but then it comes as Text and again doesn’t let me multiply the 10% factor. Any idea how can we fulfill this requirement?
- The client checks how many times consecutive over the past months a particular rec has been auto reconciled and if it does beyond a specified value, it prevent auto reconciliation for the next month. For e.g they want limit to 5 for monthly recs so that even if the auto reconciliation criteria is fulfilled for the 6