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

Help with configurable calculaton

edited Jun 26, 2020 7:17PM in Financial Consolidation and Close 5 comments

Summary

need equivalent of for/next loop to loop through account list

Content

Hi I need to run a calculation for all level 0 accounts under a specific account as well as another calculation for a random list of accounts due to unique translation rules.

I can get the calculations to work just fine but only if have a FIX statement with the accounts listed.  Doing it this way caused the consolidation to take a hour or so for just one month.  The caclulation is running on only 1 entity.  I can also get the rule to work if I hard code each account but that's not practical. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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