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

[daniel_cepok2]

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

[former_member186338]

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

[former_member186338]

Sample logic:

[former_member186338]

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

[former_member186338]

LOOKUP will select COMPANY based on the ENTITY property of INTERCO dimension of the current record of WHEN/ENDWHEN loop. All other dimension members will be used from current record!

[former_member186338]

For currency conversion you will have to run the script like this after currency conversion with DM package with the line *XDIM_MEMBERSET CURRENCY=EUR

[daniel_cepok2]

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?

[former_member186338]

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.

[former_member186338]

But in general data entry process is not clear! What is the sequence of events...

[daniel_cepok2]

Ok, maybe it is clear with the accounts names.

Account ICP1422999 Raw materials and operating supplies

Account ICP1429999 Sales price - margin in %

This are Statistical accounts. So the company save data on statistical items in LC and % on AUDITID=HB1. then do the currency translation on this accounts. Amount in LC to EUR with AVG and the value of % 1:1 from LC to EUR.

The case is to calculate the sales price margin for the company with the interco. The calculated value should be recorded to PL and BS Item and do the elimination on the group level.

For the calculated account I can create an addtional statistical account and then to reclasificy it to the PL and BS it this would be a solution but how can I tell BPC to take the amount from other company and calculate it?

[daniel_cepok2]

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.

[former_member186338]

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

[daniel_cepok2]

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.