BPC 10.1 NW currency conversion issue

[Former Member]

Hi,

I have an issue with the currency conversion in BPC 10.1 NW. When I run the conversion via the consolidation monitor in the web Interface it works fine for the parameters shown on conversion.png.

When I try to run the conversion via this datamanager script

*RUN_PROGRAM CURR_CONVERSION
CATEGORY=%VERSION_SET%
CURRENCY=%WAEHRUNG_SET%
TID_RA=%ZEIT_M_SET%
OTHER = [ENTITY=%LEGAL_STRUKTUR_SET%]
R_ENTITY=Global
*ENDRUN_PROGRAM

and use the same parameters when calling the package, see excel.png.

I get no converted values in EUR (package always says 0 SUBMITTED, 0 SUCCESS, 0 FAIL). However, when I enter values in EUR and run the conversion as a package, the conversion will overwrite those entered EUR values with 0 values.

I have checked SAP NOTE 1650709, I have verified that I have currency rates entered even though I only use on conversion method (called NTR) at the moment which only uses [COPYLC] as the formula. I have tried with [AVG] and [CLO] instead of [COPYLC] but that made no difference either.

However, as the conversion via the consolidation monitor works I am fairly certain that the general settings in the system are correct.

Would anyone have an idea what the problem could be?

Thanks,

Arnold

[former_member186338 · Accepted solution]

Just some minor issues:

Not

R_ENTITY=Global

But:

RATEENTITY = Global

R_ENTITY will not be processed, but default will be used RATEENTITY = Global

Have you tried to simulate monitor conversion using GROUP script?

[former_member186338]

Just found the issue!!!!

Not:

OTHER = [ENTITY=%LEGAL_STRUKTUR_SET%]

But:

OTHER = [LEGAL_STRUKTUR=%LEGAL_STRUKTUR_SET%]

Well known error!

[former_member186338]

In OTHER statement you have to use real dimension names!

[Former Member]

Changing from R_ENTITY to RATEENTITY solved the issue. I tried to accept the answer as correct but only got an internal server error.

[Former Member]

Arnold...its showing as the Best answer accepted! Though it showed internal error it reflects in system.

Regards,

JP

[Former Member]

I also created a new entry in the R_ENTITY dimension called KURSE and used that in my script. Made no difference either.

[Former Member]

this is what it looks like when I run it in UJKT

[Former Member]

This is the time dimension, I am using 2015.12 as a test period.

[former_member186338]

No issues!

[Grégoire2Ombres]

I suggest you execute the script logic from UJKT and assign directly the values to dimension (ie TID_RA=2015.12...) to check that this is not due to variables.

I also remember that in the past, the rate entity ID with lower case (Global) caused issues and the workaround was to change it to upper case (GLOBAL) as mentionned in note 1848061. But I think this is solved now...?

[former_member186338]

What about TIME dimension?

[Former Member]

In the monitor I ran it at entity level.

[Grégoire2Ombres]

Hi Arnold,

In your script logic there is no selection for the group-type dimension. This means that you run the currency translation at entity level (for a selected target currency).

When you run the currency translation from the monitor, are you running it at entity level or at group level?

Just to make sure that the way you run it from the monitor is the same as when you run it from a package.

[Former Member]

Here are screenshots of the rule, the dimensions and a value I would expect to be converted.

[former_member186338]

I see no issues with the script and selection! Please provide additional screenshots for rule and dimensions setup.