Leverage Groovy to Consolidate Multiple Years

Summary:

This tip uses Groovy to invoke FCCS seeded Consolidate by iterating on multiple years

Content (please ensure you mask any confidential information):

This implementation is to address Idea Lab request mentioned here.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

I have attached herewith a detailed video (MultiYearConsolidate.zip) and Groovy based business rule (ConsolidateAllYears.txt), that can be readily consumed in FCCS multiple currency apps. Rule file can be modified to use in single currency apps.

To view video download and extract MultiYearConsolidate.zip to a directory. To use Groovy business rule, download ConsolidateAllYears.txt and rename it to ConsolidateAllYears.xml. Import the rule using Calculation Manager's Import right-click menu on Consol tree node. Remember to specify you application name.