Financial Consolidation and Close

Get Involved. Join the Conversation.

Topic

    Kimborey Lam
    Data Load from Data Management to FCCS - best practicesAnswered
    Topic posted November 10, 2017 by Kimborey LamSilver Medal: 2,000+ Points 
    240 Views, 3 Comments
    Title:
    Data Load from Data Management to FCCS - best practices
    Summary:
    Data Load from Data Management to FCCS - best practices
    Content:

    Hi all,

    Few questions on data load from Data Management to FCCS:

    - Is it recommended to load YTD or Periodic values for Balance Sheet and does loading YTD balances has a performance impact on the application?

    - I'm currently loading my BS on Mvmt: Closing Balance_Input and Income Statement on No_Movement. Do you recommend loading Income Statement data directly on FCCS_Mvmts_NetIncome? The reason I'm asking is because to generate the cash flow I need to get income statement on FCCS_Mvmts_NetIncome.

    Thanks,

    Kim

    Best Comment

    Ganesh Nellayappan

    Hi Kim,

    Answers to your question

    -Is it recommended to load YTD or Periodic values for Balance Sheet and does loading YTD balances has a performance impact on the application?

    You can load YTD or Periodic , There is no performance impact on this.

    - I'm currently loading my BS on Mvmt: Closing Balance_Input and Income Statement on No_Movement. Do you recommend loading Income Statement data directly on FCCS_Mvmts_NetIncome? The reason I'm asking is because to generate the cash flow I need to get income statement on FCCS_Mvmts_NetIncome

    It is mandatory to load Income statement data to FCCS_Mvmts_NetIncome.

    For the Balance sheet account, there are predefined members in Movement as per the Account (most of the real time use cases are covered) , you can use that to load. If not you can create your own member under the respective predefined Movement and you can use it.

    Example:

    For Cash Accounts:

    FCCS_Mvmts_Cash can be used.

    If you need more movement dimension then for Cash you can create this below

    FCCS_Mvmts_Cash

                          - Mvmts_Cash_Increases

                          - Mvmts_Cash_Decreases

    These two can roll up to FCCS_Mvmts_Cash.

    You can use the above procedure for all Balance Sheet account and respective Movement Dimension.

    Let me know if you need any other clarification.

    PS: Please mark the answer as helpful if this comment helps so that others can consume for their benefit.

     

     

     

     

     

     

     

     

     

     

     

     

    Comment

     

    • Bernardo Andres Neira

      Hi, I can only help you with the second one, as far as I know Income Statement accounts HAVE to use FCCS_NetIncome as the default movement. No_Movement shouldn't be use on your app. I guess a default mapping should do the trick

    • Ganesh Nellayappan

      Hi Kim,

      Answers to your question

      -Is it recommended to load YTD or Periodic values for Balance Sheet and does loading YTD balances has a performance impact on the application?

      You can load YTD or Periodic , There is no performance impact on this.

      - I'm currently loading my BS on Mvmt: Closing Balance_Input and Income Statement on No_Movement. Do you recommend loading Income Statement data directly on FCCS_Mvmts_NetIncome? The reason I'm asking is because to generate the cash flow I need to get income statement on FCCS_Mvmts_NetIncome

      It is mandatory to load Income statement data to FCCS_Mvmts_NetIncome.

      For the Balance sheet account, there are predefined members in Movement as per the Account (most of the real time use cases are covered) , you can use that to load. If not you can create your own member under the respective predefined Movement and you can use it.

      Example:

      For Cash Accounts:

      FCCS_Mvmts_Cash can be used.

      If you need more movement dimension then for Cash you can create this below

      FCCS_Mvmts_Cash

                            - Mvmts_Cash_Increases

                            - Mvmts_Cash_Decreases

      These two can roll up to FCCS_Mvmts_Cash.

      You can use the above procedure for all Balance Sheet account and respective Movement Dimension.

      Let me know if you need any other clarification.

      PS: Please mark the answer as helpful if this comment helps so that others can consume for their benefit.

       

       

       

       

       

       

       

       

       

       

       

       

    • Kimborey Lam

      Thanks a lot Ganesh for this reply! It clarifies everything.

      One more thing, I haven't tested it yet but how does the system know that I'm loading YTD data for the Balance Sheet and therefore should derive periodic data (or vice-versa)? Should I also load the 0s in this case?

      Thanks again for your reply!