Currency conversion

kolaboy

Hi Experts,
I have a field call grant total in report which is defined in C/AL globals as decimal and is use to calculate Grand total for totals. How do you convert this field values which is in foreign currency to a local currency?

Thanks.

David_Cox

What exchange rate do you want to use as at today?
Assuming your report has a group total by "Currency Code"

Hint:
Look at the code on the Sales Line table search for FCYtoLCY

David

kolaboy

I am using 30.00 for a test.
The variable is not a standard field in the table. I defined it to take the results of the calculated total for the totals of certain amounts. this value is in foreign currency USD and i want to convert the equivalent to LCY.
I have not seen FCYtoLCY in the sales line table.
can you please tell me what i should do to get the equivalence in LCY Please!!!
Thanks.

David_Cox

The "Currency Exchange Rate" tables has currency functions for
LCY to FCY
FCY to LCY
FCY to FCY

Currency = Record = Currency
CurrExchRate = Record = Currency Exchange Rate
AmountLCY = Decimal
AmountFCY = Decimal

You also need a "Currency Code"
This function will return the currency factor
CurrExchRate.ExchangeRate(WORKDATE,"Currency Code")

//Sets the Defaults
Currency.InitRoundingPrecision;
IF "Currency Code" <> '' THEN
  AmountLCY :=
    ROUND(
      CurrExchRate.ExchangeAmtFCYToLCY(
        WORKDATE,"Currency Code",
        AmountFCY,CurrExchRate.ExchangeRate(WORKDATE,"Currency Code")),
      Currency."Amount Rounding Precision")
ELSE
  AmountLCY :=
    ROUND(AmountFCY,Currency."Amount Rounding Precision");

David

kolaboy

Thank you very much David, It has worked.

=D>

rsgilbert

Thanks David.

txeriff

if you are using a document in the header you will find a field called "currency factor". That's the rate applied for the day the document was created.

Just do a calcfields() to amounts in the header and then *"currency factor"