Financial Consolidation and Close

Get Involved. Join the Conversation.

Topic

    Karan Sharma
    Net Income MigrationAnswered
    Topic posted June 22, 2017 by Karan Sharma, tagged Income Statement 
    85 Views, 10 Comments
    Title:
    Net Income Migration
    Summary:
    YTD not calcualting in forms after NetIncome data Migration
    Content:

    Hi,

    So we have moved all our Income Statement data from No Movement to Changes in Net Income. What we have just realised is the form FCCS_Income Statement by Period is show Periodic Values for YTD POV as well. On digging further it seems like the problem is due to movement dimension being fixed at Total Movement. When I change the movemenet memeber to Changes in Net Income the YTD values are shown correctly. Has anyone else facing this issue or I have broken soemthing in my pod? Enclsoed the screenshots.

     

    Regards

    Karan

     

    Document:

    Best Comment

    Margaret Reed

    The reason that you're only getting YTD data at FCCS_Movements level is because of the calculation of opening balance, FX and CTA for all of the level zero members under Net Income.  This was because FCCS_Retained Earnings - Current is now a parent member and these items couldn't be calculated just at that member.  Currently, you should use FCCS_Mvmts_Subtotal to get Periodic, QTD and YTD values for Net Income.  In the next couple of months we will be modifying this behavior where we will have a sibling of Net Income that will house the opening balance, FX and CTA calculations.  At that time you can use FCCS_Movements for reporting on both balance sheet and income.  Let me know if this doesn't make sense.

    Comment

     

    • Margaret Reed

      The reason that you're only getting YTD data at FCCS_Movements level is because of the calculation of opening balance, FX and CTA for all of the level zero members under Net Income.  This was because FCCS_Retained Earnings - Current is now a parent member and these items couldn't be calculated just at that member.  Currently, you should use FCCS_Mvmts_Subtotal to get Periodic, QTD and YTD values for Net Income.  In the next couple of months we will be modifying this behavior where we will have a sibling of Net Income that will house the opening balance, FX and CTA calculations.  At that time you can use FCCS_Movements for reporting on both balance sheet and income.  Let me know if this doesn't make sense.

      • Nayar Ellis

        Currently, If I try and create a balance sheet for year end, I do not end up with the correct results.  My retained earning - current displays only monthly income and if I change the movements to remove the opening balance, my other balance sheet accounts are incorrect.  Essentially, I cannot get a year end balance sheet.  I believe what you have discussed here will fix the issue, but is there a work around for the interim?

      • Nayar Ellis

        Currently, If I try and create a balance sheet for year end, I do not end up with the correct results.  My retained earning - current displays only monthly income and if I change the movements to remove the opening balance, my other balance sheet accounts are incorrect.  Essentially, I cannot get a year end balance sheet.  I believe what you have discussed here will fix the issue, but is there a work around for the interim?

      • Nayar Ellis

        Currently, If I try and create a balance sheet for year end, I do not end up with the correct results.  My retained earning - current displays only monthly income and if I change the movements to remove the opening balance, my other balance sheet accounts are incorrect.  Essentially, I cannot get a year end balance sheet.  I believe what you have discussed here will fix the issue, but is there a work around for the interim?

        • Margaret Reed

          Please open an SR for this.  I don't have enough details to know what your issue is.  I need you to add your application snapshot and a spreadsheet/form/screenshot with the data to show the issue.

    • Karan Sharma

      Thanks Margaret for your quick response. I think I understand what you are poitning to. To put it simply FCCS is calculating opening balance (from last month periodic activity+last month opening) even for all IS accounts. This results in Current month period activity being YTD figure at total movements as total movements include opening balance (YTD LM) and total movement changes (Period CM). My simple mind would say just exclude NetInc form opening balance calcualtion but I know development would have their reasons to do it this way.

      I met Rich yesterday and he mentioned you have posted a document on Net Income migration somewhere on this portal. You mind pointing me to that?

      Regards

      Karan

    • Karan Sharma

      Found the document. Thanks

    • Bernardo Andres Neira

      Hi

      With the new release I read something about a Closing balance input movement, I thought with this feature, the "normal" behavior of Revenue and Expense accounts regarding Periodic and YTD views would be fixed ?? But then I found this bit on the admin guide "The data loaded to this member represents a YTD value, so the data must be loaded to the FCCS_YTD_Input View dimension member" and then I understood this member was basically created for balance accounts and had little to nothing to do with Net Income accounts

      I'm still thinking the "To get Periodic, QTD and YTD values you should report on net income at the FCCS_Mvmts_Subtotal" part of the document is a bit difficult for normal users to understand

    • Margaret Reed

      This new member FCCS_ClosingBalance_Input is for you to load life to date values.  There is a FCCS_ClosingBalance_Variance member that will tell you that you have either entered or not entered the movements to generate a calculated closing balance that equals the life to date value.  This new member will not be translated or consolidated.  It will be available when configurable calculations comes out to calculate specific movement members.