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

Currency Conversion issue

Posted on Aug 17, 2016 at 01:45 PM 95 Views

Hi Experts,

I am facing an issue with regards to currency conversion.

I am using consolidation model and the YTD figures for each period are calculated correctly except for the last period as in attached screenshots.

The formula that needs to be applied for YTD calculation is

Period 12 value = (Period 12(LC) - Period 11(LC))*Period 12 Exchange rate + Period 11 USD value.

Instead of this formula, after running the currency conversion package, I can see that formula applied is

Period 12 (USD) = Period 12(LC) * Exchange rate of Period 12

When I reproduce this issue in Dev system, the results are correct. This is happening only in production. I have checked all the dimensions and business rule but have not been able to find any difference/ reason why this could be happening. Please help.

Image1.PNG (26.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Lucas Costa
    Lucas Costa
    Posted on Aug 18, 2016 at 02:24 AM
    3

    Hi Varsha,

    Are you using the currency conversion business rule? Have you flaged the option "Periodic"?

    Cheers,

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2016 at 01:53 PM
    0

    Version details:

    CPMBPC 801 0008 SAPK-80108INCPMBPC CPM Business Planning and Consolidation

    EPM Add -in : version 10.0 SP26 .NET.3.5

    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.