Need to configure FX Translation even if all data in same currency for legal consolidation?

[Former Member]

Hi,

We are tying to configure legal consolidation. All the entities are submitting the data in same currency - USD. The reporting/group currency is also USD.

The issue:

In Consolidation Monitor "Translate Currency" is a compulsory step before "Consolidate".

We did not configure any currency translation as all the data is in USD. But we are getting an error when we try to run "Consolidate" step on Consolidation Monitor.

Question:

Is there any way we can skip the "Translate Currency" step and proceed with "Consolidate" step?

Regards,

Kalyan.

[former_member182709]

Hi Kalyan,

Now, there is a way to bypass the currency conversion. There is a parameter model leve parameter BYPASS_CT_IN_CONS. With this parameter, you can directly run consolidaion.  You can find the detailes in the following note.

To have the ability, you need to apply the note first.

1957930 - Option to bypass currency conversion in consolidation executed from consolidation monitor

The note can be applied only you are on the following versions.

CPMBPC 800 SP01 - 800 SP12

CPMBPC 801 SP01 - 801 SP05

CPMBPC 810 SP00 - 810 SP01

Of course, if your BPC is 10.0 SP13 or 10.1 SP02, you already have the ability now. What you need is just to set a model level parameter.

This thread was started at May, 2013. Hopefully still useful for you.

Best regards,

Charlie

[former_member196060]

Hi Kalyan,

There is AS_IS could be used to skip the real currency translation.

Regards,

Hengye

[Former Member]

Hi Hengye,

Could you please elaborate?

Regards,

Kalyan.

[former_member215589]

Hi,

In Formula column of Business Rule use 'AS_IS' while configuring the Business Rule for Rate Type value (AVG, CLO, etc).

-Priyanka

[Former Member]

Hi Priyanka,

Thank you for the response.

Actually, my query was is there any way we can skip the step. No currency conversion business rule configuration at all.

We have already implemented work around, but my question was if all the entities are submitting the data in same currency and the same is reporting/group currency as well, then can't "Translate currency" be an optional step just like control and work status.

Regards,

Kalyan.

[Former Member]

Hi Kalyan,

This step cannot be avoided.

We must convert the data from LC to the group currency in order to do the consolidation.

Are you capturing the data in LC or in USD?

[Former Member]

Hi Nilanjan,

Thank you for your response.

We are capturing the data in LC, in fact, we already went ahead and configured currency conversion realizing that there is no work around.

But given the situation we encountered, where loading, reporting and group currency is same, SAP should consider making this step optional just like work status and control.

Regards,

Kalyan.

[Former Member]

Hi Kalyan,

The conversion is required only because you are capturing the data in LC. The system first needs to convert the data from LC into the group currency, and only then the consolidation can take place. Actually, for the consolidation, the system will read the data from the database with the group currency, and since your data is in LC, the system is failing.

Try to capture the data directly in the group currency, in your case, USD.

Hope this helps.

[Former Member]

Hi Nilanjan,

We first loaded the data in USD only, but were getting an error business rules missing. So we loaded the same data again by only changing USD to LC in transformation file .

Regards,

Kalyan.

[Former Member]

Hi Kalyan,

Were you running the consolidation through consolidation central? If yes, then currency conversion is must.

You can try to run it through script logic.

Hope this helps.

[Former Member]

Hi Nilanjan,

We are running it from consolidation central.

But the point I wanted to highlight is that it could be made an optional step just like work status and control, so that the need for configuration of currency translation can be avoided.

Regards,

Kalyan.

[Former Member]

Hi Kalyan,

I completely agree with your point. For avoiding this, you can always do the consolidation through the DM package.

In any case, for any improvements, you can always submit your ideas in the idea place.