Currency conversions in BPS.

[Former Member]

Hi experts,

My planning data is coming from SAP. The data will be having multiple currency.

I need to convert currency wherever it's not equal to INR. The conversion will happen twice:

Once while showing data in planning layout, system should convert it into INR

After saving , system should convert the currency into original currency.

In this case, how should we achive this ?

Points ensured !

Regards,

Sameer

[Former Member]

From my experiece, in order to use the standard currency tranlation function to convert curreny, you can not put the 0currency in the header because it required a single value for header, you have to leave it in your leading column or data column. This is very unconvenient and the layout look urgly if you put the 0currency in you leading column.

[Former Member]

Hi,

In manual planning, you have an amount as a key figure. In this case , field currency also be there as a charateristic. I have to put it as one more column !

Can I avoid this ?

Sunil -

Can I use planning function of some other level , in manual planning layout ?

Thanks

[Former Member]

Sameer,

You can use a planning function from any level. Just ensure that the required parameters/variables are also in the other planning level.

As far as the currency field is concerned, you can choose to put it as part of the header only on the condition that the currency is unique in the data selection. If amounts with different currencies are a part of the layout, then you would have to have it as a column.

Sunil

[Former Member]

Hi Anurag,

Got into some issue. The added new key figure will also be associated with the CURRENCY unit as a character.

When I do the conversion, it creates two record for non-INR currency ! Using different units for both key figures also do the same.

The issue is, in planning layout, I HAVE to put this currency in lead column. I can't get rid of this by putting currency in header due to multiple values.

Any suggestions on this with your experience ?

Thanks a lot.

Regards,

Sameer

[Former Member]

Hello Sameer,

Regarding restricting selections to Non-INR currencies,

we can acheive it by creating a separate planning level/package as needed and use that as the criteria to filter and run your planning function.

In our case, our planning functions were created under the planning level created exclusively to filter currencies for conversion.

We have multiple planning packages to filter currencies as desired.

Sunil

[Former Member]

Thanks Anurag.

That brings few questions to me. Pls share your expertise.

a) I was wondering ab is there any way to automate this planning function.

b)Would this conversion hit perfomance for large records ?

c) Also can this planning function be done only for Non-INR records? (In fields for condition, I am not able to put != condition for currency. )

Thanks a lot again, I have already done with points.

Regards,

Sameer.

[Former Member]

Hi Sameer,

Responses to your queries

a) Yes you can automate execution of Planning functions directly in the Manual planning layout, when the user enters and saves the data. Refer to the third button at Right top in the first screen of the manual planning layout, you can attach a Planning function/Planning sequence here to be executed automatically.

b) Yes if you have large records it could definitely reflect in the performance, but another way could be you could always schedule the conversion using a planning sequence when the data is not being used by other users. As a result of which it would not impact the user activity.

c) Not sure about this, as the exclusion (not equal to) facility is not available in BPS, may be you might have to look at the option of creating an formula/exit.

Hope it helps

[Former Member]

Hi Sameer,

One way of doing it is have two key figures in the Infocube, one storing the data in INR and the other storing the data in the original currency. In this case you would not have to do the conversion every time and revert it back to the original currency.

Moreover if you have two key figures you will always have the option of deciding the rate at which you want to convert the original currency to INR (month end, year end, current rate etc.), as you can always do the conversion once again on another rate, without impacting the original data.

You can do the conversion to INR any time using the Currency Conversion Planning function available.

Hope it helps