Skip to Content

Problem when run consolidation, the generate value of transaction is double

Hi all,

I got a problem when run consolidation program in BPC consolidation model.

This is my scenario.

Company BC00 own 80% share of company BC01. BC00 is holding company of scope BC000.

They are assigned to scope BC000 with method 90 (holding) for BC00 and method 86 (purchase) for BC01.

I have run calculate button in ownership management and config for all neccessary business rules.

With BC01 the system work fine, but for holding entity BC00, the result is double than the expected.

At first, I have the transaction:

Entity

Inter company

Account

Value

BC01

I_BC00

4111000000

-1.200.000

BC01

I_NONE

1111100000

  1. 1.200.000

BC00

I_BC01

2210000000

  1. 700.000

BC00

I_NONE

1111100000

  1. 700.000

But when I run consolidation for scope BC000 the result is.

Entity

Inter company

Account

Value

BC00

I_BC01

2210000000

-1.400.000

BC00

I_BC00

4700000000

-240.000

BC01

I_BC00

4700000000

-240.000

BC00

I_BC00

2500000000

-960.000

BC01

I_BC00

2500000000

-960.000

I don’t know why for entity BC00, the system generate transaction with value -1.400.000 while it should be -700.000. The expected result is

Entity

Inter company

Account

Value

BC00

I_BC01

2210000000

-700.000

BC00

I_BC01

2500000000

-260.000

BC01

I_BC00

4111000000

  1. 1.200.000

BC01

I_BC00

4700000000

-240.000

Please, help me to solve this problem.

Thanks,

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2014 at 07:04 AM

    Hi,

    please share the business rules and the scope dimension.

    BR,
    Arnold

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Hùng Trần Huy

      Hi,

      RULE010 seems okay, you want to eliminate from the subsidiary and calculate minority interest. I am a bit confused why you use the same for the parent entity, usually there should be no minority interest on that side.

      Two further questions though.

      1. Why have you not specified a source flow in ELCOINV01?

      2. What have you entered in your OWNERSHIP model?

      If I assume that in your ownership model you have

      BC00 POWN 100%

      BC01 POWN 80%

      I would expect the following (I have shortened the account IDs a bit):

      BC00

      2210 -700

      2500 +700

      BC01

      4111 +1200

      2500 -960

      4700 -240

      BR,
      Arnold

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.