Skip to Content

Development in a model(previously App) with poor architecture can be a frustrating task for any BPC professional. Complex architecture impedes performance, maintenance and consultant desirability. Sticking to the basics in terms of what is needed is most certainly the quickest route to delivering a solution.

In this short blog I’d like to emphasize what are the system prerequisites for the architecture within a bare bone legal consolidation:

Environment

Models:

  • Legal Consolidation – This can be classified as the framework for the consolidation where the bulk of the work is done
  • Rate – This model would house data pertinent to exchange rates and currency translation
  • Ownership – This model is where we store data required for the consolidating roll up or structure, necessary for the Ownership Manager or previously Dynamic Hierarchy Editor (DHE)

    

(Note: An intercompany model is seen more often than not, however it is not a system requirement for setup of a legal consolidation. This model is used to match and pair intercompany transactions within the organizational structure)

Dimensions

Legal Consolidation

  1. Account
  2. Category
  3. Entity
  4. Time
  5. Flow/Movement
  6. RptCurrency
  7. Intercompany
  8. AuditID
  9. Consolidation Group

    

Rate

  1. Account
  2. Category
  3. Entity
  4. Time
  5. Input Curreny

    

Ownership

  1. Account
  2. Category
  3. Entity
  4. Time
  5. Intercompany
  6. Consolidation Group

You may notice that each model has the same first 4 dimensions. These dimensions are the basic system requirement for any model type, can can be  easily referenced using the acronym  A(ccount).C(ategory).E(ntity).T(ime)

Hope this helps, and I’d invite correction if I have misinterpreted the above in any way.

Devon Abraham

Follow me: @_Devon_Abraham

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Ravindra Sane

    Hi Devon,

    What is your opinion on INTERCOMPANY MODEL? If the client want to see matching and reconciliation, then we shall provide the separate Model.

    Is the Intercompany differences and reconciliation is taking place in CONSOLIDATION Model?

    Are differences sorted out in ECC?

    Thanks,

    Ravindra Sane

    (0) 
    1. Devon Abraham Post author

      Hi Ravindra,

      Thank you for the question. Can you please expand a little bit more, I am not certain i understand fully.

      Devon

      (0) 
      1. Ravindra Sane

        Hi Devon,

        I got the answer. We need to create ICMATCHING application separately in BPC10 as it is not available as per standard. I have gone thru. IFRS Starter Kit. They have given it as optional.

        Have you worked on ESKOM?

        (0) 

Leave a Reply