Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 reconciliation requirement

edited Nov 6, 2020 3:56PM in Account Reconciliation 1 comment

Summary

Key auto recon requirements converting Blackline to ARCS

Content

  1. 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?
  1. 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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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