Financial Consolidation and Close

Get Involved. Join the Conversation.

Topic

    Cathleen Sweeney
    Restrict consolidation rule by year
    Topic posted September 11, 2019 by Cathleen Sweeney, tagged Consolidation 
    26 Views, 1 Comment
    Title:
    Restrict consolidation rule by year
    Summary:
    Restrict consolidation rule in calc manager by year
    Content:

    We have a requirement to begin a consolidation rule in 2020 but not have it run in prior years.  Is it possible to include an If-Then statement or similar logic in calc manager?  This would be in "After Opening Balance Carry Forward".

    Comment

     

    • Luis

      You should be able to use ismbr to identify the year within the rule is running.

      E.g.:

      IF(@ISMBR("FY19"))

      /* rule applied in 2019 */

      ELSE

      /* rule applied in other years */

      ENDIF

       

      Check on @RSIBLINGS / @LSIBLINGS functions so you can create a IF that supports your scenario.

       

      Regards,

      Luis