Skip to Content
author's profile photo Former Member
Former Member

SAP BPC 7.5 NW Currency Translation

Hi Guys

Good day

ISSUE:When i run the FCTR Logic Balance sheet figures are translating, but Income statement figures are not.

I am currently working on Currency Translation(SAP BPC 7.5NW) . Used business rules to translate the Local currency to Reporting currency. It’s a financial type Application

The issues is my Balance sheet figures are translating, but Income statement figures are not.

ACCTYPE Property (EXP) and RATE TYPE Property (AVG) in Account dimension is fine.

Business rules setup.

Formula: 1 . for Balance sheet figures used “[END]”

2. for IS figures used “[AVG]”

I don’t understand why only BS figures translated when I run FX Trans logic.

Is there any other place to check ???.

Guys please advise me where I must check .

Thanks

Regards

Narsi

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Sep 04, 2013 at 10:42 AM

    Hi Narsi,

    Share "AVG " Business Rule once.

    regards

    Niranjan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 04, 2013 at 10:38 AM

    Hi Narasaih,

    Please make sure that in ur rate application you are loading the average rates along with the ending rates.

    If the rates are properly uploaded and still you are having issues than please share screen shot of your account dimension and business rules for currency translation

    Regards,

    Kalyan,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 04, 2013 at 11:55 AM

    Hi,

    To understand the reason you can go and check the Account Dimension properly

    You have a Rate Type property to be maintained for both Balance Sheet and P&L Accounts.This ratetype is referred in business rules.

    So it could be either place missing - either you have missed out to maintain the ratetype or your business rule is not calling that ratetype which you have maintained for P&L Accounts.

    3rd reason could be what kalyan pointed out --missing exchange rates for the period with rate type used for P&L Accounts.

    Regards,

    Rakesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 04, 2013 at 04:34 PM

    Hi Narsi, there is a good SAP 'how to' paper on currency translation in BPC that you should check out. See link below.

    http://scn.sap.com/docs/DOC-4192

    Also, you may want to check the datasource. Is the P&L going to a different one? If so, check the datasource property IS_CONVERTED.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2013 at 07:45 AM

    Hi Experts

    Thanks for your input

    I ahve traced the issue. the issue is insted of AVG Business rule i used AVGE.

    I ahve deleted the AVGE Business rule and created a New Business rule for Averages [AVG]

    Then did cuple of test, its working fine

    Thanks Alot Gents

    Regards

    Narsi

    Add a comment
    10|10000 characters needed characters exceeded

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.