How to configure BPC 10.0 NW without currency translation?

[daniel_cepok2]

Hi Experts,

we are doing the legal consolidation in BPC NW 10.0. As we have just EUR companies, we do not need the currency translation.

So we load transactional data to BPC in LC and BPC should translate it with factor 1 to EUR which is the group currency.

In the SAP documents I get the note, that in the Account dimension I should left the raw "rate type" blank for the accounts to get the translatoin with factor 1. If I do this, I can not make any rules for currency translation rules, which is correct because I do not need it. But when I start the consolidation, BPC give me an error status for the currency translation and I can not make the consolidation.

Does someone know, how to configure BPC consolidation without currency translation or what should I do to run the currency translation with factor 1?

Thanks

Daniel

[akos_beres]

Daniel,

As Rahul mentioned you can assign a rate in your account dimension to just copy all the values from LC. However if the system needs to convert FX for other non Euro entities in the future, this solution will not work because the account assignments will flip everything to local currency. I'd add FX rate of 1 in the rate application for the EUR to EUR conversion and run FX.

Akos

[daniel_cepok2]

Hi Akos,

thanks for your answer, the idea was not to put FX rates for EUR every consolidation period in the rate application because in the next future there will not be any non Euro company. If it will be in some years, we would change the rule, but at the moment we want to just copy the values of LC to EUR.

But it seems not to work, because the report does not show me any values when I go for one company and change the parameter from LC to EUR and to the Scope.

Thanks and BR

Daniel

[akos_beres]

Daniel,

Can you post the FX package status from Excel>Data manager>View Status

Akos

[daniel_cepok2]

Hi Akos,

here is the status from data manager. its faild when i run the package, but when I run the currency translation from the consolidation monitor, I do not need the logic

Daniel

[daniel_cepok2]

Akos,

I got the sucess in run the package for the fx translation, but as you can see there were no data translated.

BR

Daniel

[akos_beres]

Daniel,

Step 1 - ensure there is rate in the rate app ... this should be good

Step 2 - ensure there is LC in your data intersection that the FX is run on.

Step 3 - run FX from the data manager package and check the status.

Can you post a screenshot of step 2 and 3?

Akos

[akos_beres]

Daniel,

 the idea was not to put FX rates for EUR every consolidation period in the rate application because in the next future there will not be any non Euro company. If it will be in some years, we would change the rule, but at the moment we want to just copy the values of LC to EUR.

If it will be in some years ... I would set up FX the correct way and don't set all your accounts to rule that copies LC.

[akos_beres]

Daniel,

Good job catching the category issue .. it looks like you made the script work.

Akos

[daniel_cepok2]

Akos

here are some screens of data on LC and the status, but stauts is success and no data was translated.

[daniel_cepok2]

Yes I decide to make the rule for FX translation for the future and to put the rates of EUR 1 in the system with input schedule. But when I change the rule it is also not working.

At this time I would like to translate all accounts with the END rate 1 for all flows

[akos_beres]

Daniel,

please remove the entries from the flow ... the formula of END should work. Also here is a link to FX setup. This will help you  check the properties in the category, audittrail and entity dimension ...

Currency Conversion as Script Logic - SAP Business Planning and Consolidation, version for SAP NetWe...

Akos

[daniel_cepok2]

Akos,

what do you mean with remove the entries from the flow? Do you mean in the rule? or something in the dimension?

Thanks

Daniel

[akos_beres]

Daniel,

remove the flows and have only a single line like this

this should work for all flows now

Akos

[daniel_cepok2]

I did it now and have just one line with the formula END, but without any success. I also check the dimensions like in the link.

The package run with success but there are not values translated

Hm, no idea where is the mistake or what is wrong

Daniel

[daniel_cepok2]

There is also the rate 1 on the rate model

so there should also be everything ok i think

[akos_beres]

Daniel,

in my opinion it is either the data intersection that the FX script runs on or one of the dimension properties are not correctly filled out.

Dimension Type       Important Currency Related Requirements

Entity                        The required property is Currency, which stores the local currency of the

                                  Entity.

Group                       The required properties are:

                                    • Currency_Type whose values are G for group currency or N for non-group

                                      currency

                                    • Group_Currency whose values are the group currency(s) such as USD

Category                   This same category dimension must also be used in the Rate Model.

Currency                   The required properties are:

                                         • Reporting whose values are Y or blank

                                         • Currency_Type whose values are T for transaction currency, R for

                                           Reporting, and L for local currency.

Account                    The required property is:

                                         • RateType whose values are AVG, END, and so on

Time                         The required properties are:

                                        • Year with values like 2011, 2012

                                        • Period with values like JUN, JUL

                                        • TimeID with values like 201206, 201207

                                        • Monthnum with values like 6, 7

                                       The same time dimension must also be used in the Rate Model.

DataSource                The required properties are:

                                        • Datasrc_Type whose values are I – Input, M – Manual Adjustment, A –

                                          Eliminations and Adjustments

                                        • IS_Converted whose values include:

                                            N – these members are ignored in the conversion,

                                            Y (or blank) – these members are converted from LC into the desired

                                            currency, and G - these members are entered in a reporting currency

                                            are translated to group currency.

Hope this helps .. at this point someone just needs to log into your system or need to go through the FX setup step by step.

Akos

[daniel_cepok2]

Akos,

thank you very much for this help. I checked the dimensions again and it should be ok.

As we have the test System at the moment and just test data inside, would you like to take a look at the FX setup in our system maybe tomorrow through timeviewer? It would be very kind, because maybe I took a look so many times and do not see the wrong entries.

You can also write me an email directly to dan_ce@me.com

Thanks again

Daniel

[akos_beres]

Daniel,

Contacting SAP would be sufficient.

Akos

[akos_beres]

Daniel,

The rate needs to be added to every month that FX is run.

What dimension is added to column C above Rate Account? Category or Flow?

Akos

[daniel_cepok2]

Akos,

In column C there is the Category and the Rate Account.

I contact the SAP for solution, will see what they say.

BR

Daniel

[former_member225135]

Hi Daniel,

Assign a single rate type to all gl accounts and use standard Currency Conversion rules with formula as "COPYLC", this will transfer the local currency balances to group currency (same in your case)

Regards,

Rahul

[daniel_cepok2]

Hi Rahul,

thanks for you answer. I put the rate type CLO to all accounts and use the standard formula COPYLC as you wrote. I did not put any source flow and destination flow, just the formula COPYLC.

When I start currency translation for one company I get the green status but in the report for this company there are no values in EUR just in LC. It seems not to translate it.

When I start the currency translation for all companies (there are some companies with transactional data and some without) I still the error status. But anyway the system does not translate any data.

Should I customizie something else for the copylc?

Thanks and best Regards

Daniel

[former_member225135]

Hi,

You have to put Source Flow in logic. Blank flow will not work.

Something like:

You can use parent of flow dimension.

Source Flow	Destination Account	Destination Flow	Formula
F_TOT			COPYLC

Regards,

Rahul

[daniel_cepok2]

Hi,

I put the END flow as a source flow in the rule. As I start the currency translation direct from the consolidation center I do not need logic script.

But the result is the same, greed status when I start currency translation for one company and red when I start it on the top hierarchy. But also on the one company when I go to the report I have data on LC but not on EUR.

BR
Daniel

[former_member225135]

Hi Daniel,

Check whether all setting required for currency conversion are there or not.

Refer sap note: 2101349

Regards,

Rahul

[daniel_cepok2]

Hi,

i checked the note and I have the same settings.

I run the currency translation and I get the green status which means the currency translation works well, but when I open a report for one company which has LC Data and change the Currency to EUR and the Scope then I do not get any values. It seems there are not translatet data for it.

What could be the reason?

Thanks and BR

Daniel

[former_member225135]

Hi,

Try maintaining rates for EUR as "1" in rate model

Regards,

Rahul

[daniel_cepok2]

Hi,

I put an Input in the rate model for EUR of 1. Did the translation currency once again an the status is still green but I have not any values on EUR. I tried in the report some different parameters but there are still no velues.

Do you have some more Idea what it could be or where could I make the mistake?

Thanks and BR

Daniel

[former_member225135]

Hi Daniel,

Bit strange, if all the required settings are maintained, it should work.

Can you try to run the FX restatement script logic from Data Manager & UJKT and share the screenshots.

Can you also share the base data (data at LC level), AT dimension & flow dimension?

Also please check this note: https://launchpad.support.sap.com/#/notes/1930598

Regards,

Rahul

[daniel_cepok2]

Hi Rahul,

here are some screens of status from Data Manager.

I have this script logic

When I run the package its failed. I got the message

When I run the currency translation from the consolidation monitor, I do not need the script logic.

Screen from the flow dimension

screen from account dimension

Hope it helps to see the settings.

BR

Daniel

[daniel_cepok2]

Hi,

just one more information, when I go to BW and look at the data on the cube, I just see the data in LC there is no data on EUR, so it seems not to translate any data.

BR

Daniel

[former_member225135]

Hi Daniel,

Just check the audit trail where data is stored, IS_CONVERT property is set to "Y".

and also make sure that there is "CLOSING" flow type in flow dimension also.

Regards,

Rahul

[daniel_cepok2]

Hi Rahul,

ich checked the dimensions and I hav the closing flow and a Y at IS_CONVERT at Audit trail

But the data is not still translated to EUR.

Regards

Daniel

[former_member225135]

Hi Daniel,

If you are convinced enough that you have made all settings required for currency conversion as mentioned in note: 2101349.

I would suggest you to open the incident with SAP and let them check.

Regards,

Rahul

[daniel_cepok2]

Hi Rahul,

yes I thin I will open an incident with SAP today morning and let them check. I checked all settings many times and the currency translation ist not translating data, so I have no idea anymore what to do more.

Thank you very much and best Regards

Daniel

[former_member225135]

Hi Daniel,

Just keep this message updated as and when you receive proper reply from SAP.

This will help someone in future

Regards,

Rahul

[Former Member]

Hi Daniel,

typically you need to run the conversion twice with a slight difference.

*RUN_PROGRAM CURR_CONVERSION

VERSION = %VERSION_SET%

GROUP = %SCOPE_SET%

...

will take EUR / NO_SCOPE values and convert them to EUR / SCOPE. Before that can happen you need to have a scrip that runs

*RUN_PROGRAM CURR_CONVERSION

VERSION = %VERSION_SET%

CURRENCY = %CURRENCY_SET%

...

This will take LC / NO_SCOPE values and convert them to EUR / NO_SCOPE.

BR,

Arnold