Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

I am trying to translate my F#OpeningBalance at an opening rate. It is naturally translating at average rate.

Originally posted by Rich House 6/4/2019 I am trying to translate my F#OpeningBalance at an opening rate. It is naturally translating at average rate. I have managed to get to translate at closi...
FX Rates
Time
OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago
Originally posted by Joakim Kulan

This might be a start:
If (api.Cons.IsCurrency() And Not api.Cons.IsLocalCurrencyforEntity()) Then
Dim RateTypeOpe As FxRateType = api.FxRates.GetFxRateType(""OpeningRate"")

Dim RateOPE As Decimal = api.FxRates.GetCalculatedFxRate(RateTypeOpe,)

api.data.calculate(""F#OpeningBalance:C#Local * "" & api.Data.DecimalToText(RateOpe) & "" "")

End If