0

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

Dec 09, 2016 at 12:34 PM

219

Former Member

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

Vadim Kalinin Dec 09, 2016 at 12:41 PM
0

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

Show 1 Share
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.

Vadim Kalinin Dec 09, 2016 at 12:59 PM
0

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.

Show 3 Share

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

Former Member

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?

Former Member

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.

Vadim Kalinin Dec 09, 2016 at 01:57 PM
0

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```
Show 3 Share

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!

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

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?

Vadim Kalinin Dec 09, 2016 at 03:08 PM
0

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

Show 1 Share

Sample logic:

lookup.png (35.2 kB)