Financial Consolidation and Close

Get Involved. Join the Conversation.


  • Rafael Blanco

    hi, have you tried Force Consolidation?

  • Rafael Blanco

    Hello, I had the same problem two days ago and I just restored the movement dimension from the day before backup .You can also take it from the Production environment if you are working on Test.


  • Rafael Blanco

    Hello, I had the same problem two days ago and I just restored the movement dimension from the day before backup .You can also take it from the Production environment if you are working on Test.


  • Michel Schoolenaar

    select one of the column names, like "Parent Member" and select "Member Selection", then add all available columns to your selection and refresh your worksheet. Now all properties should show up in the columns.


  • Wendy Willis

    I have successfully configured Valid Intersections for FCC.   I came across the exact issue you are reporting.  

    Through some testing, I verified that Data Management did not recognize the Valid Intersections and allowed the data to be posted.  A quick review in an Ad Hoc verified the data loaded to what should have been an invalid intersection.  I then tested using an Ad Hoc to manually input to the Invalid Intersection.  The Ad Hoc was yellow cell and allowed input, but as soon as I hit "submit" the system cleared the data.  To get around the issue in Data Management, I added mapping to process the data correctly.   My valid intersection was for valid ICP for intercompany accounts.  So, the mapping was easy to correct to a valid ICP.


  • Keith Glide

    There are many ways to achieve similar results... and the choice made will generally depend on the client's approach (some like to give their users lots of choice, others prefer to "guide" their users as much as possible).

    In FCCS, the scope of each rule-set can be limited by Period (the same can be done in HFM VBScript rules via IF conditions). So for example, you could create two rule-sets that run when the method changes from Subsidiary (or Equity) to Not Consolidated... one limited to run only in period Jan (assuming a calendar year) and the other to run in all periods except Jan.

    If the client prefers the user to explicitly select an "exit" method, then as you note, two methods can be created and a different rule-set attached to each method.

    My preference is to provide as much flexibility to the application implementer as is practical... that is where the best insight into the client's requirements lies.

  • Carolina Rodríguez

    The value is in "parrent currency" but in "Amount Override", how should I do so that the value arrives inside "entity input"? (C17).

    Thank you very much


  • Steven Getze, CMA

    Ah ... I had Private Connections established previously and my instructions (FCCS section 29-32) did not provide these additional steps.   I am now all set.   Thank you!!!!

  • Antonio Barbaro

    I'm agree with you.

    In HFM, EXIT and EXITFL are two consolidation methods very useful because thanks to them you can manage the Disposals at the beginning of the year (EXIT) and the disposals in a period different from the beginning of the year (EXITFL).

    In details, if you use EXIT and EXITFL the P&L Result will be aggregated but the Balance Sheet not.



  • Keith Glide

    The consolidation methods listed in your screen shot are all of the "seeded" methods provided out-of-the-box with FCCS. You can however create your own additional methods and add configurable consolidation rule-sets for those methods as required. The current seeded rule-sets should handle Acquisitions (but not Disposals yet)... but this is not based on a specific method being applied during the period of acquisition... it is based on a change of method from period-to-period. So it should not be necessary to create a separate method to record an acquisition... a change in method from "Not Consolidated" to "Subsidiary" for example should provide the acquisition adjustments. The longer term intention is to provide the same seeded rule-sets to cater for disposals (which is what I assume you refer to as an EXIT or EXITFL method).

    Note however that we are focusing currently on feature enhancement rather than seeded content... so that clients / partners can develop more complex rule-sets that match their requirements rather than relying on generic content that might not exactly match anyone's requirements.   

  • Tom LeFebvre

    Did you connect to the FCCS application using the correct URL?

    See step #4 - In Add Connection - URL, use the following syntax for the private connection, and then click Next.

    • For Task Manager


    • For Supplemental Data Manager:


  • Antonio Barbaro


    according to you, can I delete the periods from FDMEE and to re - create them?

  • Carolina Rodríguez

    You are right. I forgot to show you the "USD- input currency" member where I post the Amount Override 1500 (D22).

    However, after running the consolidation, the result is 1588 (C17).

    Thank you very much for your answers!







  • Bernardo Andres Neira

    You could also create an alternate hierarchy without levels, a flat hierarchy if you will.

    That would allow you to see all the eliminations under a single parent but would probably show you wrong data for your equity and/or investmentes depending on your rules

  • Keith Glide

    What Currency dimension member are you entering the override amount / rate to? It appears that you are entering to "Parent Currency". Input the override entry to the Input Currency that represents the parent currency to which you are translating. Take a look at the POV of the cells in the Override Rates form shown above (second column of the row headers).