Skip to Content
author's profile photo Vishwanath Gamanagatti
0
Vishwanath Gamanagatti

FXTRANS Currency translation for plananing application

Posted on Nov 18, 2011 at 08:35 AM 23 Views

Dear Freinds !

I had read many blogs on currency translation but not able to do currency translation with 7.5NW SP 09 even after following SAP Note 1254330 .

Planning appliation had 1.C_Category dim ( default) 2.N_ACCT ( copy of C_ACCT) 3.Entity(Default)4.Time(Default)5.RptCurrency(Default) Referenec to RATE APP ( Default)

RATE APP 1. C_Category dim ( default) 2.R_ACCT ( Defalut) 3.R_Entity(Default)4.Time(Default)5.InputCurrency(Default) Referenec to RATE APP ( Default)

All properties are manined as mentioned in note 1254330.

systemconstants file

*FUNCTION THISAPP=PLANNING

*FUNCTION RATEAPP=RATE

*FUNCTION RATEENTITYDIM=RateEntity

*FUNCTION RATEACCOUNTDIM=RATE

*FUNCTION INPUTCURRENCYDIM=INPUTCURRENCY

*FUNCTION RATEENTITYMBR=Global

*FUNCTION RATESRCCALCMBR=Global

*FUNCTION AVGRATEID=AVG

*FUNCTION ENDRATEID=END

Data enetered for C5000 (JAPAN) INCOME ACCOUNT LC in planning application

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %C_CATEGORY_SET%

CURRENCY=%RPTCURRENCY_SET%

TID_RA = %TIME_SET%

RATEENTITY =GLOBAL

OTHER = ENTITY=%ENTITY_SET%

*ENDRUN_PROGRAM

DM package ran inputed provided is EUR it shows running sucessfully but log say zero record submited/generated

DM package ran inputed provided is blank it shows error LC does not exit

Kindly help me understand why it is not working

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2011 at 09:47 AM
    1

    Hi,

    Please check/correct the following and see if this solves your problem:

    - NW is case-sensitive in most places, you please check that you are referencing the dimensions/apps correctly

    - In your system constants you are defining RateEntity but your dimension is R_Entity. Please make sure these are matching

    - In your logic, you must have the "Other" section in square brackets as so (these are not sq brackets because this blog turns them into a URL): OTHER={ENTITY=%ENTITY_SET%}

    - Check that in RPTCURRENCY dim that LC is labelled as L and EUR is labelled as R

    - Have you ensured that you have put FX rates in the Rate app in the correct period/group as your entered data?

    - In the Datasrc dim, have you entered a Y in the property "Is_Converted" for the Datasrc you have entered data into?

    - Do the accounts that you have entered data against have a valid value entered against property "RateType"? This must then be reference in your FX business rule

    If none of these things solve your problem, please show me what you have put in your FX business rule - as this definition was missing from your post.

    Tom.

    Add a comment
    10|10000 characters needed characters exceeded

    • Vishwanath Gamanagatti Former Member
      Nov 22, 2011 at 06:15 AM

      Dear Tom,

      Thanks ! for your reply. Its my mistake that I had mentioned LC to LC it is LC to Reporting currency .

      I had entered the values againt all reporting currencies but still after running stand datamanager package in formula log values are zero.

      Few thing is not clear to me :

      What setting we need to do to system to identify WHAT ALL LC need to be translated to WHAT Reporting Currency ?

      Is system understands using Entity Hierarchy ?

      Is system translate all LC data to all Reporting Currency for all accounts were ratetype property is defined assuming business rules are perfectly configured?

      Thanks ! in advance

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.