SAP BPC 10 NW - Currency Translation

[Former Member]

Hi

I have to Currency Translation for the Opening Flow

I have one BCF in LC and INR

There are 2 requirements related to currency translation.

1. For the Opening Flow I dont want any conversion as I already gave done BCF.

2. For Opening Flow only those data should be converted where there is a difference in prior year and current year Rates.

I am using the CLO Ratetype also I have a customised period of the prior year.

2014.00 is the prior customised period

2014.12 is the current year period.

Please guide me.

Regards

Ravi

[former_member193143]

Hello Ravi,

Did you try the way I suggested in the first point.

Maintain a property and and skip the respective accounts which you don't have want touch..

I don't have system to test right now... try in that way I hope it will work..

Regards,

Saida Reddy Gogireddy

[Former Member]

Hi,

The properties that you have mentioned is not working.

Please see the below screen shot where I have 4 records which is brought by BCF and after the Currency Conversion it adds 2 records for the CSO Entity.

It adds 2 records of CSO Entity because in the SCOPE Dimension is has 2 properties STORE ENTITY & STORE GROUP CURRENCY set as "Y".

I dont want for the Opening Flow it should add the records for CSO Entity so how can I achieve that?

I cannot change the master data of SCOPE dimension as I also have the Closing Flow data.

ACCOUNT	AUDITTRAIL	CATEGORY	ENTITY	FLOW	INTERCO	RPTCURRENCY	SCOPE	TIME	SIGNEDDATA
10100000	Input	Actual	4000	Opening	I_NONE	LC	S_NONE	2014.12	-2474422
10100000	Input	Actual	4000	Opening	I_NONE	INR	S_NONE	2014.12	-120470946.7
10100000	Input	Actual	4000	Opening	I_NONE	INR	S_1000	2014.12	-120470946.7
10100000	Input	Actual	4000	Opening	I_NONE	INR	S_4000	2014.12	-120470946.7
10100000	Input	Actual	CSO	Opening	I_NONE	INR	S_1000	2014.12	-120470946.7
10100000	Input	Actual	CSO	Opening	I_NONE	INR	S_4000	2014.12	-120470946.7

[Former Member]

Hi,

I have got the solution for the difference of the prior year.

But I am stuck with 1 thing is I dont want to touch my Opening data which is in INR which I had done the BCF from last year.

Now what is happening is after conversion the INR values for the respective entity is untouched by using AS_IS . But it adds a new record for the CSO (Console Entity).

I already have the BCF for CSO and I dont want now that CSO data is generated for the Opening Flow.

How can I avoid this?

Please guide me

Regards,

Ravi

[former_member193143]

Hello Ravi,

In the Data Source dimension please maintain a property IS_CONVERTED and maintain that property as N for whose account members you don't want do the currency conversion...

or maintain rate type as AS_IS for those account members you don't do the currency conversion for the account members which are already converted...

And then maintain the AS_IS under formula column in the currency conversion table...

Regards,

Saida Reddy Gogireddy