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

Error in Currency translation....

Hi All,

Can you pls let me know how do I go about and solve the following problem in my query. The currency conversion is not working fine.

We have defined a formula to calculate tax. This formula is made up of 3-4 fields. Problem is, The value of formula in target currency does not become zero when its value in source cuurency is ZERO. Query output looks something like below.

Fisper value in source value in Target

currency currency

002/2006 -1,000.00 1,159.15

003/2006 1,000.00 2,290.44

004/2006 0.00 6,035.39

005/2006 0.00 - 3,040.80

006/2006 0.00 1,500.90

007/2006 0.00 1,587.08

Values in Target currency do not make any sense. I expect for 002/2006 and 003/2006 to have same value in target currency but with a sign change. for 004/2006 to 007/2006 the values should have been zero.

can you pls figure where is it going wrong

Thanks

Raj

Message was edited by: raj kak

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 03, 2006 at 01:14 PM

    Hi Raj,

    How have you set up the currency conversion...in the key figure properties or are you doing it in the report? Also is this a base key figure, or a calculated key figure?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I have done further study on this issue and i wanted to share my findings with you.

      There is no problem in the formula, but it lies some where else. But in nutshell i would say that though the value in source currency is zero it is reasonable for the value in target currency not to be zero. This is a bit strange right.

      Situation is something like this. Imagine there is a formula C. This is made up of two normal key figures say A and B. One key fig, say B is always zero. So we need not consider this. It’s never a trouble maker. Left over is the other key fig A, where the problem lies. The values for this key fig A can be categorized into two sets. One set of values for billing days 01 to 31. For Feb billing day no’s are 01 to 28 and 01 to 30 for other months like Sep, Nov etc. Values of A in target currency for these billing day no’s are derived on Daily Average Rate. The second set of values of A are for billing days 00 and Not assigned (#). The target currency values in this case are derived using month-end rate or you can say period end date.

      The values of A in source currency are such that when you sum up values of A for normal billing days with the values of A for billing days 00 & # the result is zero sometimes. However in such a case the sum of these two sets of values of A in target currency need not be zero.

      Following is an illustration

      Billing Value of A Value of A

      Day No in Source Curr in Target Curr

      01 to 09 -4,043,398.16 - 106,093.05

      10 to 15 -3,526,138.80 - 92,476.34

      16 to 22 -1,387,767.20 - 36,463.97

      23 to 25 -2,198,643.17 - 57,559.76

      26 to 27 -2,222,156.20 - 58,314.69

      28 to 31 -3,185,415.94 - 83,935.03

      -


      -


      Total -16,563,519.47 - 434,842.84 [1]

      -


      -


      Billing Value of A Value of A

      Day No in Source Curr in Target Curr

      00 16,563,519.47 436,429.93

      Not assigned 0.00 0.00

      -


      -


      Total 16,563,519.47 436,429.93 [2]

      -


      -


      Total 0.00 1,587.08 [1]+[2]

      The value in source currency is 0.00 but the value in target currency is 1,587.00. Though this looks absurd, but it holds true when you consider the values of A for two sets of billing day no's seperately.

      This is in COPA.

      Bhanu do you agree with me or you have something to say?.

      I also award you the points for your assistance.

      Thanks

      Raj

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.