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 closing rate but I'm now trying to figure out how to change it to looking at my opening fx rate

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