cancel
Showing results for 
Search instead for 
Did you mean: 

Currency conversion- not convert to currency group

monica_marquez2
Participant
0 Kudos

Hi all!

 

We have a problem with our currency conversion   in the consolidation application.

We are using business rules to convert at historical rates, we have defined the specific ratetype.

The currency conversion for another rate currency its worked, but the problem is for historical rate, because the result is empty, so when we launch the conversion to euros BPC is converting well but we do not have data in the group (for historical rate).

For example:

                            LC     EUR    G1 (group 1)

acct1 ( end rate)    10      20       20

acct2 (hist rate)     100    50      [x]

The issue is [x] really if this package was working ok, then [x] will be 50, but we haven't data.

We do not know what the problem is, as only  is wrong for accounts with historical rate

The script is:

// Execute Currency Conversion

*RUN_PROGRAM CURR_CONVERSION

        CATEGORY = %CATEGORY_SET%

        GROUP = GIRUS

        TID_RA = %TIME_SET%

        RATEENTITY = Global

*ENDRUN_PROGRAM

// Execute Consolidation

*RUN_PROGRAM CONSOLIDATION

        CATEGORY = %CATEGORY_SET%

        GROUP = %CURRENCY_SET%

        TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

Please, any suggestions?

Thanx!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Monica,

do you have separate group and currency dimensions or only one currency dimension? And have you tried to use this code

// Execute Currency Conversion

*RUN_PROGRAM CURR_CONVERSION

        CATEGORY = %CATEGORY_SET%

        GROUP = GIRUS

        TID_RA = %TIME_SET%

        RATEENTITY = Global

*ENDRUN_PROGRAM

// Execute Consolidation

*RUN_PROGRAM CONSOLIDATION

        CATEGORY = %CATEGORY_SET%

        GROUP = GIRUS

        TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

Regards,

Arnold

former_member186498
Active Contributor
0 Kudos

Hi Monica,

try with "RATEENTITY = GLOBAL" (capital letters)

Kind regards

     Roberto

monica_marquez2
Participant
0 Kudos

Hi Roberto,

With "GLOBAL" the currency conversion isn't working because in our Rate Entity dimension appear like "Global".

Besides  works well for all rate currency less for the historic rate

Thanxs

former_member186498
Active Contributor
0 Kudos

Hi Monica,

please see http://service.sap.com/sap/support/notes/1650709

http://service.sap.com/sap/support/notes/1674967 maybe it helps.

Kind regards

     Roberto