Skip to Content
avatar image
Former Member

BPC 10.0 NW elimination of IC profit from inventory/elimination of profit on IC transfers

Dear Experts,

I have problems with set up of the elimination of intercompany profit and loss
in BPC on my legal consolidation model.

My case is:

Company A send data on Account=ICP1422999, AUDITID= HB1, INTCO=B, MOVEMENTTYPE=END, Amount 1000 EUR

Company B send data on Account =ICP1429999, AUDITID=HB1, INTCO=A, MOVEMENTTYPE=END, Amount 15%

BPC should record on ACCOUNT=3122150 AND ACCOUNT=1422150, MOVEMENTTYPE=END, AUDITID=ICP01 the calculated value of 150 EUR (1000*0,15) with INTCO=A

How can I do the elimination of intercompany profit from inventory/elimination of profit on intercompany transfers? Do someone has a "how to paper for this implementation"?

Normal elimination is ok, but how can I make the calculation on Group Currency of the 15%, when the values are on different companies?

Can someone help here.

Thanks

Daniel

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 09, 2016 at 12:41 PM

    Sorry, but what do you mean by

    Company B send data on Account =ICP1429999, AUDITID=HB1, INTCO=A, MOVEMENTTYPE=END, Amount 15%

    In order to understand eliminations I recommend to read documents for IFRS kit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      company B give just the percentage of the inventory of 15% in BPC. and I want to calculate the 15% and record the value on the PL account.

  • Dec 09, 2016 at 12:59 PM

    You have to use separate technical account to input percentage (of what? not clear...)

    Then in default.lgf you can calculate value from percentage and store the value in the normal account.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      The question is, can I say in BPC default.lgf

      Take the amount of Company A with INTCO=B from the ACCOUNT=ICP1422999 and multiply it with the % on

      ACCOUNT=ICP1429999 on company B with INTCO=A in group currency. And then record the result on ACCOUNT=3122150 AND ACCOUNT=1422150 with INTCO=A?

      But we have 30 companies so not just A and B, so BPC should take the amount on INTCO=A from Company A, on INTCO=C from company C etc.

  • Dec 09, 2016 at 01:57 PM

    Something like:

    *LOOKUP SameModel
    *DIM ICENT:COMPANY=INTERCO.ENTITY //Dimension COMPANY
    *ENDLOOKUP
    
    *WHEN AUDITID
    *IS HB1
    *WHEN MOVEMENTTYPE
    *IS END
    *WHEN ACCOUNT
    *IS ICP1429999 //percent entered
    *REC(EXPRESSION=%VALUE%*LOOKUP(ICENT),ACCOUNT=ICP1422999)
    *ENDWHEN
    *ENDWHEN
    *ENDWHEN
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      ok looks not bad, but there I would REC the value on ICP1422999? But on this account is the amount on the other company. So I would need other account to rec the value?

      Or but where I say in this logic ICP1422999 * ICP1429999?

  • Dec 09, 2016 at 03:08 PM

    Just a small correction to LOOKUP

    *LOOKUP SameModel
    *DIM ICENT:ACCOUNT=ICP1422999 //amount account
    *DIM ICENT:COMPANY=INTERCO.ENTITY //Dimension COMPANY
    *DIM ICENT:INTERCO=COMPANY.INTCO //Dimension INTERCO!!!!!!
    *ENDLOOKUP
    *WHEN AUDITID
    *IS HB1
    *WHEN MOVEMENTTYPE
    *IS END
    *WHEN ACCOUNT
    *IS ICP1429999 //percent entered
    *REC(EXPRESSION=%VALUE%*LOOKUP(ICENT),ACCOUNT=3122150)
    *ENDWHEN
    *ENDWHEN
    *ENDWHEN

    First we read all records on percent account ICP1429999 with AUDITID=HB1 and MOVEMENTTYPE=END

    Each record will also have other dimension members: COMPANY, INTERCO etc...

    %VALUE% is the amount of the current record - percent

    LOOKUP(ICENT) will get the amount from the record with:

    ACCOUNT=ICP1422999
    COMPANY=INTERCO.ENTITY
    INTERCO=COMPANY.INTCO

    other dimensions - from current record

    Add comment
    10|10000 characters needed characters exceeded