Forum Stats

  • 3,855,352 Users
  • 2,264,499 Discussions
  • 7,905,976 Comments

Discussions

Ownership details are not carry forwarding to next/future periods

Ch.KK
Ch.KK Member Posts: 11 Blue Ribbon
edited Sep 16, 2016 4:11AM in Financial Consolidation

Hello  Experts,

Your views & suggestions are highly appreciable on below issue,

We are entering the Ownership details through Manage Ownership module within HFM but those details except [Active] the rest ( [Method], [PCon], [POwn]...so on...) are not carry forwarding to next/future period/s, all we have to do it manually again (either data extract or smartview ), even though those system Accounts account type is "Balance Recurring". Can't we avoid manual input on the same..

HFM Version - 11.1.2.3.500

DefaultValueForActive   -   1

OrgByPeriodApplication   -    Yes

ConsolidationRules  -  Yes

Regards

KK

Tagged:

Best Answer

  • stefr
    stefr Member Posts: 36
    edited Sep 16, 2016 4:07AM Answer ✓

    I'm afraid there is not an "automatic" way to carry forward System Account (from my side i do not know anything).

    Another solution to be verified from your side is to change the section of the Consolidate Routine in which HFM reads the ownership to perform the consolidation:

            Parent=HS.Parent.Member

            Entity=HS.Entity.Member

            PCon=HS.Node.PCon("")

            POwn=HS.Node.POwn("")

            PMin=PCon-POwn

            PCon_1=HS.Node.PCon("P#[Year].Y#Prior")

            POwn_1=HS.Node.POwn("P#[Year].Y#Prior")

            PMin_1=PCon_1-POwn_1

            VPCon=PCon-PCon_1

            VPOwn=POwn-POwn_1

            VPMin=PMin-PMin_1

    For istance we could tell to HFM it must reads the ownership always from "Actual December 2015" for every scenario / year / period that needs a consolidation. By the way you can insert the ownership only once.

    Regards

    Stefano

Answers

  • stefr
    stefr Member Posts: 36
    edited Sep 16, 2016 3:23AM

    Hi, account type doesn't matter in carry forward the ownership.

    You need to enter these for every data unit to be consolidated.

    You can do it by using two alternative methods to the "manual one":

    1 - From "copy data" function you can copy the ownership: select as source the scenario, year, period, the consolidation node and the account list [System]: i'm not sure anyway that in the 11.1.2.3 this function produces the desired output; there was a bug. You see the ownership into the destination data unit, but when you consolidate, company doesn't rollup in Contribution;

    2 - Extract data .dat with the ownership and load data .dat after changing scenario / and or year / and or period.

    Ciao

    Stefano

  • Sounak_C
    Sounak_C Member Posts: 183 Bronze Badge
    edited Sep 16, 2016 3:36AM

    Hi,

    I thought these system accounts are 'Balance' type except 'Active' which has a 'Balance Recurring' type. Please refer to the admin guide once.

    Regards,

    S

  • Ch.KK
    Ch.KK Member Posts: 11 Blue Ribbon
    edited Sep 16, 2016 3:55AM

    Hi Stefano,

    Thanks for your quick response..

    Right now we are copying the details manually for the respective scenario, Year & period through Data Extract & load option.

    But is there any way to do automatically by system itself till no changes.

    I have changed the account type from Balance to Balance Recurring for those system accounts but still no luck..

    Regards

    KK

  • stefr
    stefr Member Posts: 36
    edited Sep 16, 2016 4:07AM Answer ✓

    I'm afraid there is not an "automatic" way to carry forward System Account (from my side i do not know anything).

    Another solution to be verified from your side is to change the section of the Consolidate Routine in which HFM reads the ownership to perform the consolidation:

            Parent=HS.Parent.Member

            Entity=HS.Entity.Member

            PCon=HS.Node.PCon("")

            POwn=HS.Node.POwn("")

            PMin=PCon-POwn

            PCon_1=HS.Node.PCon("P#[Year].Y#Prior")

            POwn_1=HS.Node.POwn("P#[Year].Y#Prior")

            PMin_1=PCon_1-POwn_1

            VPCon=PCon-PCon_1

            VPOwn=POwn-POwn_1

            VPMin=PMin-PMin_1

    For istance we could tell to HFM it must reads the ownership always from "Actual December 2015" for every scenario / year / period that needs a consolidation. By the way you can insert the ownership only once.

    Regards

    Stefano

  • Ch.KK
    Ch.KK Member Posts: 11 Blue Ribbon
    edited Sep 16, 2016 4:11AM

    Many thanks,

    Let me test it out..

    Regards

    KK

This discussion has been closed.