CONVERT_TO_LOCAL_CURRENCY

[Former Member]

Dear All,

I am facing a strange issue, the function module CONVERT_TO_LOCAL_CURRENCY is returning wrong results in BW system and correct in R/3.

In BW system, it looks like it is returning back amounts multiplied by 100 or more.

I have checked the currencies, BW is in sync with R/3.

Any idea how could this be solved ?

Thanks.

[Former Member]

Hi,

From the below out put it is clear that the Local Factor & Foreign Factor in BW and R/3 are reversed.

OUTPUT (BW)

EXCHANGE_RATE 25

FOREIGN_FACTOR 1

LOCAL_AMOUNT 9908005 (should have been 991)

LOCAL_FACTOR 100

EXCHANGE_RATEX 2486325000000

FIXED_RATE 0

DERIVED_RATE_TYPE

OUTPUT (R/3)

EXCHANGE_RATE 25

FOREIGN_FACTOR 100

LOCAL_AMOUNT 991

LOCAL_FACTOR 1

EXCHANGE_RATEX 2486325211338

FIXED_RATE 0

DERIVED_RATE_TYPE

Please recheck these fields in the R/3 and BW systems.

foreign_factor = tcurr-ffact.

local_factor = tcurr-tfact.

the calculation of local currency value is of type

loc curr = x * local factor / foreign.

In this case ,

r/3 = x*1/100

bw = x*100 / 1

so you are getting a difference in multiples of 10000

Regards,

Shyam.

[Former Member]

Hi,

Can you check if the ratio is also fine in the tcurr table.

Regards,

Shyam.

[Former Member]

hi,

Check tables TCURF and TCURR in R/3 and BW and see for any differences.

regards,

Arvind.

[Former Member]

TCURF & TCURR are in sync.

TCURX though in R?3 there are some extra entries but I don;t think this would be an issue.

Example - CONVERT_TO_LOCAL_CURRENCY

CLIENT 20

DATE 20.04.2011

FOREIGN_AMOUNT 40

FOREIGN_CURRENCY PLN

LOCAL_CURRENCY EUR

RATE 24.8632500

TYPE_OF_RATE EURX

READ_TCURR X

OUTPUT (BW)

EXCHANGE_RATE 25

FOREIGN_FACTOR 1

LOCAL_AMOUNT 9908005 (should have been 991)

LOCAL_FACTOR 100

EXCHANGE_RATEX 2486325000000

FIXED_RATE 0

DERIVED_RATE_TYPE

OUTPUT (R/3)

EXCHANGE_RATE 25

FOREIGN_FACTOR 100

LOCAL_AMOUNT 991

LOCAL_FACTOR 1

EXCHANGE_RATEX 2486325211338

FIXED_RATE 0

DERIVED_RATE_TYPE

TCURF:

EURX PLN EUR (valid from 30.04.2010) Ratio From/to : 100/1 (same in both R/3 and BW )

Any ideas please ...

[Former Member]

Hi,

Not the number of entries but actual value in Decimals field for particular Currency.

For eg: if USD has Decimels = 0 in R3 and 0 in BW... all values will be multiplied by 100.

[Former Member]

Check the decimals for that currency in TCURX tables in BW & R3.