Wrong local currency coversion

ratana_pouy — Fri, 03 Jun 2016 04:44:55 GMT

Dear All,

In SQ02, i am using a function to convert other currency to local currency. when i generate the report, converted amount doesn't match with fbl1n.

i already check amount document currency+Exchange rate with query are the same.

FBL1N:

Amount in document currency [THB]=52,747.84

Ex.Rate=/34.94160

Local Amount currency [USD] = 1,509.60

but;

Query:

Amount in document currency [THB]=52,747.84

Ex.Rate=/34.94160

Local Amount currency [USD] = 1,481.28

Between FBL1N & Query is different 28.32, why???

please help....

Here's ABAP Code in Query:

DATA: v_da TYPE RBKP-BUDAT,

v_fa TYPE RSEG-WRBTR,

v_fc TYPE RBKP-WAERS,

rate TYPE RBKP-KURSF.

CLEAR: v_fa, v_fc, AMOUNTLC.

v_da = RBKP-BUDAT. "Date

v_fa = RSEG-WRBTR. "amount in document

v_fc = RBKP-WAERS. "document currency

if RSEG-SHKZG = 'H'.

AMOUNTLC = AMOUNTLC * -1.

endif.

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'

EXPORTING

date = v_da

foreign_amount = v_fa

foreign_currency = v_fc

local_currency = 'USD' "system local currency

RATE = rate "Rate field

TYPE_OF_RATE = 'M' "type of Rate:tcode OB08

IMPORTING

local_amount = AMOUNTLC. "new field

Re: Wrong local currency coversion

former_member218424 — Fri, 03 Jun 2016 05:09:43 GMT

hi,

check if the values are maintained in tcurr table.. kurst = 1001 (Current exchange rate)

Re: Wrong local currency coversion

Former Member — Fri, 03 Jun 2016 09:52:28 GMT

Hi,

I Think system is picking Ex.Rate = /35.6096, So check whether this value is maintained in your table or valid for the date.

Regards,

Venu

topic Wrong local currency coversion in Application Development and Automation Discussions

Wrong local currency coversion

Re: Wrong local currency coversion

Re: Wrong local currency coversion