Table 330 Currency Exchange Rate

Base Application, Microsoft.Finance.Currency

src/Layers/W1/BaseApp/Finance/Currency/CurrencyExchangeRate.Table.al717 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Finance.Currency;table 330 "Currency Exchange Rate"{    Caption = 'Currency Exchange Rate';    DataCaptionFields = "Currency Code";    DrillDownPageID = "Currency Exchange Rates";    LookupPageID = "Currency Exchange Rates";    DataClassification = CustomerContent;    fields    {        field(1; "Currency Code"; Code[10])        {            Caption = 'Currency Code';            ToolTip = 'Specifies the code of the currency on this line.';            Editable = false;            NotBlank = true;            TableRelation = Currency;            trigger OnValidate()            begin                if "Currency Code" = "Relational Currency Code" then                    Error(                      Text000, FieldCaption("Currency Code"), FieldCaption("Relational Currency Code"));            end;        }        field(2; "Starting Date"; Date)        {            Caption = 'Starting Date';            ToolTip = 'Specifies the date on which the exchange rate on this line comes into effect.';            NotBlank = true;        }        field(3; "Exchange Rate Amount"; Decimal)        {            Caption = 'Exchange Rate Amount';            ToolTip = 'Specifies the amounts that are used to calculate exchange rates for the currency on this line.';            DecimalPlaces = 1 : 6;            MinValue = 0;            AutoFormatType = 0;            trigger OnValidate()            begin                TestField("Exchange Rate Amount");            end;        }        field(4; "Adjustment Exch. Rate Amount"; Decimal)        {            AccessByPermission = TableData Currency = R;            Caption = 'Adjustment Exch. Rate Amount';            ToolTip = 'Specifies the amounts that are used to calculate exchange rates that will be used by the Adjust Exchange Rates batch job.';            DecimalPlaces = 1 : 6;            MinValue = 0;            AutoFormatType = 0;            trigger OnValidate()            begin                TestField("Adjustment Exch. Rate Amount");            end;        }        field(5; "Relational Currency Code"; Code[10])        {            Caption = 'Relational Currency Code';            ToolTip = 'Specifies how you want to set up the two currencies, one of the currencies can be LCY, for which you want to register exchange rates.';            TableRelation = Currency;            trigger OnValidate()            begin                if "Currency Code" = "Relational Currency Code" then                    Error(                      Text000, FieldCaption("Currency Code"), FieldCaption("Relational Currency Code"));            end;        }        field(6; "Relational Exch. Rate Amount"; Decimal)        {            AccessByPermission = TableData Currency = R;            Caption = 'Relational Exch. Rate Amount';            ToolTip = 'Specifies the amounts that are used to calculate exchange rates for the foreign currency on this line.';            DecimalPlaces = 1 : 6;            MinValue = 0;            AutoFormatType = 0;            trigger OnValidate()            begin                TestField("Relational Exch. Rate Amount");            end;        }        field(7; "Fix Exchange Rate Amount"; Enum "Fix Exch. Rate Amount Type")        {            Caption = 'Fix Exchange Rate Amount';            ToolTip = 'Specifies if the currency''s exchange rate can be changed on invoices and journal lines.';        }        field(8; "Relational Adjmt Exch Rate Amt"; Decimal)        {            AccessByPermission = TableData Currency = R;            Caption = 'Relational Adjmt Exch Rate Amt';            ToolTip = 'Specifies the amounts that are used to calculate exchange rates that will be used by the Adjust Exchange Rates batch job.';            DecimalPlaces = 1 : 6;            MinValue = 0;            AutoFormatType = 0;            trigger OnValidate()            begin                TestField("Relational Adjmt Exch Rate Amt");            end;        }    }    keys    {        key(Key1; "Currency Code", "Starting Date")        {            Clustered = true;        }    }    fieldgroups    {    }    var        CurrencyExchRate2: array[2] of Record "Currency Exchange Rate";        CurrencyExchRate3: array[3] of Record "Currency Exchange Rate";        RelExchangeRateAmt: Decimal;        ExchangeRateAmt: Decimal;        RelCurrencyCode: Code[10];        FixExchangeRateAmt: Enum "Fix Exch. Rate Amount Type";        CurrencyFactor: Decimal;        UseAdjmtAmounts: Boolean;        CurrencyCode2: array[2] of Code[10];        Date2: array[2] of Date;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'The currency code in the %1 field and the %2 field cannot be the same.';#pragma warning restore AA0470#pragma warning restore AA0074    procedure ExchangeAmtLCYToFCY(Date: Date; CurrencyCode: Code[10]; Amount: Decimal; Factor: Decimal): Decimal    var        IsHandled: Boolean;    begin        OnBeforeExchangeAmtLCYToFCY(Rec, Date, CurrencyCode, Amount, Factor, RelExchangeRateAmt, ExchangeRateAmt, RelCurrencyCode, FixExchangeRateAmt, IsHandled);        if IsHandled then            exit(Amount);        if CurrencyCode = '' then            exit(Amount);        FindCurrency(Date, CurrencyCode, 1);        TestField("Exchange Rate Amount");        TestField("Relational Exch. Rate Amount");        if "Relational Currency Code" = '' then            if "Fix Exchange Rate Amount" = "Fix Exchange Rate Amount"::Both then                Amount := (Amount / "Relational Exch. Rate Amount") * "Exchange Rate Amount"            else                Amount := Amount * Factor        else begin            RelExchangeRateAmt := "Relational Exch. Rate Amount";            ExchangeRateAmt := "Exchange Rate Amount";            RelCurrencyCode := "Relational Currency Code";            FixExchangeRateAmt := "Fix Exchange Rate Amount";            FindCurrency(Date, RelCurrencyCode, 2);            TestField("Exchange Rate Amount");            TestField("Relational Exch. Rate Amount");            case FixExchangeRateAmt of                "Fix Exchange Rate Amount"::"Relational Currency":                    ExchangeRateAmt :=                      (Factor * RelExchangeRateAmt * "Relational Exch. Rate Amount") /                      "Exchange Rate Amount";                "Fix Exchange Rate Amount"::Currency:                    RelExchangeRateAmt :=                      (ExchangeRateAmt * "Exchange Rate Amount") /                      (Factor * "Relational Exch. Rate Amount");                "Fix Exchange Rate Amount"::Both:                    case "Fix Exchange Rate Amount" of                        "Fix Exchange Rate Amount"::"Relational Currency":                            "Exchange Rate Amount" :=                              (Factor * RelExchangeRateAmt * "Relational Exch. Rate Amount") /                              ExchangeRateAmt;                        "Fix Exchange Rate Amount"::Currency:                            "Relational Exch. Rate Amount" :=                              (ExchangeRateAmt * "Exchange Rate Amount") /                              (Factor * RelExchangeRateAmt);                    end;            end;            Amount := (Amount / RelExchangeRateAmt) * ExchangeRateAmt;            Amount := (Amount / "Relational Exch. Rate Amount") * "Exchange Rate Amount";        end;        exit(Amount);    end;    procedure ExchangeAmtFCYToLCY(Date: Date; CurrencyCode: Code[10]; Amount: Decimal; Factor: Decimal): Decimal    var        IsHandled: Boolean;    begin        OnBeforeExchangeAmtFCYToLCY(Rec, Date, CurrencyCode, Amount, Factor, UseAdjmtAmounts, RelExchangeRateAmt, ExchangeRateAmt, RelCurrencyCode, FixExchangeRateAmt, IsHandled);        if IsHandled then            exit(Amount);        if CurrencyCode = '' then            exit(Amount);        FindCurrency(Date, CurrencyCode, 1);        if not UseAdjmtAmounts then begin            TestField("Exchange Rate Amount");            TestField("Relational Exch. Rate Amount");        end else begin            TestField("Adjustment Exch. Rate Amount");            TestField("Relational Adjmt Exch Rate Amt");            "Exchange Rate Amount" := "Adjustment Exch. Rate Amount";            "Relational Exch. Rate Amount" := "Relational Adjmt Exch Rate Amt";            OnExchangeAmtFCYToLCYOnAfterSetRelationalExchRateAmount(Rec);        end;        if "Relational Currency Code" = '' then            if "Fix Exchange Rate Amount" = "Fix Exchange Rate Amount"::Both then                Amount := (Amount / "Exchange Rate Amount") * "Relational Exch. Rate Amount"            else                Amount := Amount / Factor        else begin            RelExchangeRateAmt := "Relational Exch. Rate Amount";            ExchangeRateAmt := "Exchange Rate Amount";            RelCurrencyCode := "Relational Currency Code";            FixExchangeRateAmt := "Fix Exchange Rate Amount";            FindCurrency(Date, RelCurrencyCode, 2);            if not UseAdjmtAmounts then begin                TestField("Exchange Rate Amount");                TestField("Relational Exch. Rate Amount");            end else begin                TestField("Adjustment Exch. Rate Amount");                TestField("Relational Adjmt Exch Rate Amt");                "Exchange Rate Amount" := "Adjustment Exch. Rate Amount";                "Relational Exch. Rate Amount" := "Relational Adjmt Exch Rate Amt";                OnExchangeAmtFCYToLCYOnAfterSetRelationalExchRateAmount(Rec);            end;            case FixExchangeRateAmt of                "Fix Exchange Rate Amount"::"Relational Currency":                    ExchangeRateAmt :=                      (RelExchangeRateAmt * "Relational Exch. Rate Amount") /                      ("Exchange Rate Amount" * Factor);                "Fix Exchange Rate Amount"::Currency:                    RelExchangeRateAmt :=                      ((Factor * ExchangeRateAmt * "Exchange Rate Amount") /                       "Relational Exch. Rate Amount");                "Fix Exchange Rate Amount"::Both:                    case "Fix Exchange Rate Amount" of                        "Fix Exchange Rate Amount"::"Relational Currency":                            "Exchange Rate Amount" :=                              (RelExchangeRateAmt * "Relational Exch. Rate Amount") /                              (ExchangeRateAmt * Factor);                        "Fix Exchange Rate Amount"::Currency:                            "Relational Exch. Rate Amount" :=                              ((Factor * ExchangeRateAmt * "Exchange Rate Amount") /                               RelExchangeRateAmt);                        "Fix Exchange Rate Amount"::Both:                            begin                                Amount := (Amount / ExchangeRateAmt) * RelExchangeRateAmt;                                Amount := (Amount / "Exchange Rate Amount") * "Relational Exch. Rate Amount";                                exit(Amount);                            end;                    end;            end;            Amount := (Amount / RelExchangeRateAmt) * ExchangeRateAmt;            Amount := (Amount / "Relational Exch. Rate Amount") * "Exchange Rate Amount";        end;        exit(Amount);    end;    procedure ExchangeRate(Date: Date; CurrencyCode: Code[10]): Decimal    var        IsHandled: Boolean;    begin        OnBeforeExchangeRate(Rec, Date, CurrencyCode, CurrencyFactor, UseAdjmtAmounts, RelExchangeRateAmt, ExchangeRateAmt, RelCurrencyCode, IsHandled);        if IsHandled then            exit(CurrencyFactor);        if CurrencyCode = '' then            exit(1);        FindCurrency(Date, CurrencyCode, 1);        if not UseAdjmtAmounts then begin            TestField("Exchange Rate Amount");            TestField("Relational Exch. Rate Amount");        end else begin            TestField("Adjustment Exch. Rate Amount");            TestField("Relational Adjmt Exch Rate Amt");            "Exchange Rate Amount" := "Adjustment Exch. Rate Amount";            "Relational Exch. Rate Amount" := "Relational Adjmt Exch Rate Amt";            OnExchangeRateOnAfterSetRelationalExchRateAmount(Rec);        end;        RelExchangeRateAmt := "Relational Exch. Rate Amount";        ExchangeRateAmt := "Exchange Rate Amount";        RelCurrencyCode := "Relational Currency Code";        if "Relational Currency Code" = '' then            CurrencyFactor := "Exchange Rate Amount" / "Relational Exch. Rate Amount"        else begin            FindCurrency(Date, RelCurrencyCode, 2);            if not UseAdjmtAmounts then begin                TestField("Exchange Rate Amount");                TestField("Relational Exch. Rate Amount");            end else begin                TestField("Adjustment Exch. Rate Amount");                TestField("Relational Adjmt Exch Rate Amt");                "Exchange Rate Amount" := "Adjustment Exch. Rate Amount";                "Relational Exch. Rate Amount" := "Relational Adjmt Exch Rate Amt";                OnExchangeRateOnAfterSetRelationalExchRateAmount(Rec);            end;            CurrencyFactor := (ExchangeRateAmt * "Exchange Rate Amount") / (RelExchangeRateAmt * "Relational Exch. Rate Amount");        end;        exit(CurrencyFactor);    end;    procedure ExchangeAmtLCYToFCYOnlyFactor(Amount: Decimal; Factor: Decimal): Decimal    begin        Amount := Factor * Amount;        exit(Amount);    end;    procedure ExchangeAmtFCYToLCYAdjmt(Date: Date; CurrencyCode: Code[10]; Amount: Decimal; Factor: Decimal): Decimal    begin        UseAdjmtAmounts := true;        exit(ExchangeAmtFCYToLCY(Date, CurrencyCode, Amount, Factor));    end;    procedure ExchangeRateAdjmt(Date: Date; CurrencyCode: Code[10]): Decimal    begin        UseAdjmtAmounts := true;        exit(ExchangeRate(Date, CurrencyCode));    end;    procedure ExchangeAmount(Amount: Decimal; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; UsePostingDate: Date): Decimal    var        ToCurrency: Record Currency;    begin        if (FromCurrencyCode = ToCurrencyCode) or (Amount = 0) then            exit(Amount);        Amount :=          ExchangeAmtFCYToFCY(            UsePostingDate, FromCurrencyCode, ToCurrencyCode, Amount);        if ToCurrencyCode <> '' then begin            ToCurrency.Get(ToCurrencyCode);            Amount := Round(Amount, ToCurrency."Amount Rounding Precision");        end else            Amount := Round(Amount);        exit(Amount);    end;    procedure FindCurrency(Date: Date; CurrencyCode: Code[10]; CacheNo: Integer)    var        ShouldUseCache: Boolean;    begin        ShouldUseCache := (CurrencyCode2[CacheNo] = CurrencyCode) and (Date2[CacheNo] = Date);        OnFindCurrencyOnAfterCalcShouldUseCache(Rec, CacheNo, ShouldUseCache);        if ShouldUseCache then            Rec := CurrencyExchRate2[CacheNo]        else begin            if Date = 0D then                Date := WorkDate();            CurrencyExchRate2[CacheNo].SetRange("Currency Code", CurrencyCode);            CurrencyExchRate2[CacheNo].SetRange("Starting Date", 0D, Date);            OnFindCurrencyOnAfterCurrencyExchRate2SetFilters(CurrencyExchRate2[CacheNo], CurrencyCode, Date, Rec);            CurrencyExchRate2[CacheNo].FindLast();            Rec := CurrencyExchRate2[CacheNo];            CurrencyCode2[CacheNo] := CurrencyCode;            Date2[CacheNo] := Date;        end;        OnAfterFindCurrency(Rec, CurrencyExchRate2, Date, CurrencyCode, CacheNo);    end;    procedure ExchangeAmtFCYToFCY(Date: Date; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; Amount: Decimal): Decimal    var        IsHandled: Boolean;    begin        OnBeforeExchangeAmtFCYToFCY(Rec, Date, FromCurrencyCode, ToCurrencyCode, Amount, CurrencyExchRate3, IsHandled);        if IsHandled then            exit(Amount);        if FromCurrencyCode = ToCurrencyCode then            exit(Amount);        if ToCurrencyCode = '' then begin            FindCurrency2(Date, FromCurrencyCode, 1);            if CurrencyExchRate3[1]."Relational Currency Code" = '' then                exit(                  (Amount / CurrencyExchRate3[1]."Exchange Rate Amount") *                  CurrencyExchRate3[1]."Relational Exch. Rate Amount");            FindCurrency2(Date, CurrencyExchRate3[1]."Relational Currency Code", 3);            Amount :=              ((Amount / CurrencyExchRate3[1]."Exchange Rate Amount") *               CurrencyExchRate3[1]."Relational Exch. Rate Amount");            exit(              (Amount / CurrencyExchRate3[3]."Exchange Rate Amount") *              CurrencyExchRate3[3]."Relational Exch. Rate Amount");        end;        if FromCurrencyCode = '' then begin            FindCurrency2(Date, ToCurrencyCode, 2);            if CurrencyExchRate3[2]."Relational Currency Code" = '' then                exit(                  (Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *                  CurrencyExchRate3[2]."Exchange Rate Amount");            FindCurrency2(Date, CurrencyExchRate3[2]."Relational Currency Code", 3);            Amount :=              ((Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *               CurrencyExchRate3[2]."Exchange Rate Amount");            exit(              (Amount / CurrencyExchRate3[3]."Relational Exch. Rate Amount") *              CurrencyExchRate3[3]."Exchange Rate Amount");        end;        FindCurrency2(Date, FromCurrencyCode, 1);        FindCurrency2(Date, ToCurrencyCode, 2);        if CurrencyExchRate3[1]."Currency Code" = CurrencyExchRate3[2]."Relational Currency Code" then            exit(              (Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *              CurrencyExchRate3[2]."Exchange Rate Amount");        if CurrencyExchRate3[1]."Relational Currency Code" = CurrencyExchRate3[2]."Currency Code" then            exit(              (Amount / CurrencyExchRate3[1]."Exchange Rate Amount") *              CurrencyExchRate3[1]."Relational Exch. Rate Amount");        if CurrencyExchRate3[1]."Relational Currency Code" = CurrencyExchRate3[2]."Relational Currency Code" then begin            Amount :=              ((Amount / CurrencyExchRate3[1]."Exchange Rate Amount") *               CurrencyExchRate3[1]."Relational Exch. Rate Amount");            exit(              (Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *              CurrencyExchRate3[2]."Exchange Rate Amount");        end;        if (CurrencyExchRate3[1]."Relational Currency Code" = '') and           (CurrencyExchRate3[2]."Relational Currency Code" <> '')        then begin            FindCurrency2(Date, CurrencyExchRate3[2]."Relational Currency Code", 3);            Amount :=              (Amount * CurrencyExchRate3[1]."Relational Exch. Rate Amount") /              CurrencyExchRate3[1]."Exchange Rate Amount";            Amount :=              (Amount / CurrencyExchRate3[3]."Relational Exch. Rate Amount") *              CurrencyExchRate3[3]."Exchange Rate Amount";            exit(              (Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *              CurrencyExchRate3[2]."Exchange Rate Amount");        end;        if (CurrencyExchRate3[1]."Relational Currency Code" <> '') and           (CurrencyExchRate3[2]."Relational Currency Code" = '')        then begin            FindCurrency2(Date, CurrencyExchRate3[1]."Relational Currency Code", 3);            Amount :=              (Amount / CurrencyExchRate3[1]."Exchange Rate Amount") *              CurrencyExchRate3[1]."Relational Exch. Rate Amount";            Amount :=              (Amount / CurrencyExchRate3[3]."Exchange Rate Amount") *              CurrencyExchRate3[3]."Relational Exch. Rate Amount";            exit(              (Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *              CurrencyExchRate3[2]."Exchange Rate Amount");        end;    end;    local procedure FindCurrency2(Date: Date; CurrencyCode: Code[10]; Number: Integer)    begin        if Date = 0D then            Date := WorkDate();        CurrencyExchRate3[Number].SetRange("Currency Code", CurrencyCode);        CurrencyExchRate3[Number].SetRange("Starting Date", 0D, Date);        OnFindCurrency2OnAfterCurrencyExchRate3SetFilters(CurrencyExchRate3[Number], CurrencyCode, Date, Rec);        CurrencyExchRate3[Number].FindLast();        CurrencyExchRate3[Number].TestField("Exchange Rate Amount");        CurrencyExchRate3[Number].TestField("Relational Exch. Rate Amount");    end;    procedure ApplnExchangeAmtFCYToFCY(Date: Date; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; Amount: Decimal; var ExchRateFound: Boolean): Decimal    var        IsHandled: Boolean;    begin        OnBeforeApplnExchangeAmtFCYToFCY(Rec, Date, FromCurrencyCode, ToCurrencyCode, Amount, ExchRateFound, CurrencyExchRate3, IsHandled);        if IsHandled then            exit(Amount);        if FromCurrencyCode = ToCurrencyCode then            exit(Amount);        if ToCurrencyCode = '' then begin            ExchRateFound := FindApplnCurrency(Date, FromCurrencyCode, 1);            if not ExchRateFound then                exit(0);            if CurrencyExchRate3[1]."Relational Currency Code" = '' then                exit(                  (Amount / CurrencyExchRate3[1]."Exchange Rate Amount") *                  CurrencyExchRate3[1]."Relational Exch. Rate Amount");            ExchRateFound := FindApplnCurrency(Date, CurrencyExchRate3[1]."Relational Currency Code", 3);            if not ExchRateFound then                exit(0);            Amount :=              (Amount / CurrencyExchRate3[1]."Exchange Rate Amount") *              CurrencyExchRate3[1]."Relational Exch. Rate Amount";            exit(              (Amount / CurrencyExchRate3[3]."Exchange Rate Amount") *              CurrencyExchRate3[3]."Relational Exch. Rate Amount");        end;        if FromCurrencyCode = '' then begin            ExchRateFound := FindApplnCurrency(Date, ToCurrencyCode, 2);            if not ExchRateFound then                exit(0);            if CurrencyExchRate3[2]."Relational Currency Code" = '' then                exit(                  (Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *                  CurrencyExchRate3[2]."Exchange Rate Amount");            ExchRateFound := FindApplnCurrency(Date, CurrencyExchRate3[2]."Relational Currency Code", 3);            if not ExchRateFound then                exit(0);            Amount :=              ((Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *               CurrencyExchRate3[2]."Exchange Rate Amount");            exit(              (Amount / CurrencyExchRate3[3]."Relational Exch. Rate Amount") *              CurrencyExchRate3[3]."Exchange Rate Amount");        end;        ExchRateFound := FindApplnCurrency(Date, FromCurrencyCode, 1);        if not ExchRateFound then            exit(0);        ExchRateFound := FindApplnCurrency(Date, ToCurrencyCode, 2);        if not ExchRateFound then            exit(0);        if CurrencyExchRate3[1]."Currency Code" = CurrencyExchRate3[2]."Relational Currency Code" then            exit(              (Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *              CurrencyExchRate3[2]."Exchange Rate Amount");        if CurrencyExchRate3[1]."Relational Currency Code" = CurrencyExchRate3[2]."Currency Code" then            exit(              (Amount / CurrencyExchRate3[1]."Exchange Rate Amount") *              CurrencyExchRate3[1]."Relational Exch. Rate Amount");        if CurrencyExchRate3[1]."Relational Currency Code" = CurrencyExchRate3[2]."Relational Currency Code" then begin            Amount :=              ((Amount / CurrencyExchRate3[1]."Exchange Rate Amount") *               CurrencyExchRate3[1]."Relational Exch. Rate Amount");            exit(              (Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *              CurrencyExchRate3[2]."Exchange Rate Amount");        end;        if (CurrencyExchRate3[1]."Relational Currency Code" = '') and           (CurrencyExchRate3[2]."Relational Currency Code" <> '')        then begin            ExchRateFound := FindApplnCurrency(Date, CurrencyExchRate3[2]."Relational Currency Code", 3);            if not ExchRateFound then                exit(0);            Amount :=              (Amount * CurrencyExchRate3[1]."Relational Exch. Rate Amount") /              CurrencyExchRate3[1]."Exchange Rate Amount";            Amount :=              (Amount / CurrencyExchRate3[3]."Relational Exch. Rate Amount") *              CurrencyExchRate3[3]."Exchange Rate Amount";            exit(              (Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *              CurrencyExchRate3[2]."Exchange Rate Amount");        end;        if (CurrencyExchRate3[1]."Relational Currency Code" <> '') and           (CurrencyExchRate3[2]."Relational Currency Code" = '')        then begin            ExchRateFound := FindApplnCurrency(Date, CurrencyExchRate3[1]."Relational Currency Code", 3);            if not ExchRateFound then                exit(0);            Amount :=              (Amount / CurrencyExchRate3[1]."Exchange Rate Amount") *              CurrencyExchRate3[1]."Relational Exch. Rate Amount";            Amount :=              (Amount / CurrencyExchRate3[3]."Exchange Rate Amount") *              CurrencyExchRate3[3]."Relational Exch. Rate Amount";            exit(              (Amount / CurrencyExchRate3[2]."Relational Exch. Rate Amount") *              CurrencyExchRate3[2]."Exchange Rate Amount");        end;    end;    local procedure FindApplnCurrency(Date: Date; CurrencyCode: Code[10]; Number: Integer): Boolean    begin        CurrencyExchRate3[Number].SetRange("Currency Code", CurrencyCode);        CurrencyExchRate3[Number].SetRange("Starting Date", 0D, Date);        if not CurrencyExchRate3[Number].FindLast() then            exit(false);        CurrencyExchRate3[Number].TestField("Exchange Rate Amount");        CurrencyExchRate3[Number].TestField("Relational Exch. Rate Amount");        exit(true);    end;    procedure GetCurrentCurrencyFactor(CurrencyCode: Code[10]): Decimal    begin        SetRange("Currency Code", CurrencyCode);        if FindLast() then            if "Relational Exch. Rate Amount" <> 0 then                exit("Exchange Rate Amount" / "Relational Exch. Rate Amount");    end;    procedure GetLastestExchangeRate(CurrencyCode: Code[10]; var Date: Date; var Amt: Decimal)    var        IsHandled: Boolean;    begin        OnBeforeGetLatestExchangeRate(Rec, CurrencyCode, Date, Amt, IsHandled);        if IsHandled then            exit;        Date := 0D;        Amt := 0;        SetRange("Currency Code", CurrencyCode);        if FindLast() then begin            Date := "Starting Date";            if "Exchange Rate Amount" <> 0 then                Amt := "Relational Exch. Rate Amount" / "Exchange Rate Amount";        end;    end;    procedure CurrencyExchangeRateExist(CurrencyCode: Code[10]; Date: Date): Boolean    var        CurrencyExchangeRate: Record "Currency Exchange Rate";    begin        CurrencyExchangeRate.SetRange("Currency Code", CurrencyCode);        CurrencyExchangeRate.SetRange("Starting Date", 0D, Date);        exit(not CurrencyExchangeRate.IsEmpty);    end;    procedure SetCurrentCurrencyFactor(CurrencyCode: Code[10]; CurrencyFactor: Decimal)    var        RateForTodayExists, IsHandled: Boolean;    begin        OnBeforeSetCurrentCurrencyFactor(Rec, CurrencyCode, CurrencyFactor, IsHandled);        if IsHandled then            exit;        "Currency Code" := CurrencyCode;        TestField("Currency Code");        RateForTodayExists := Get(CurrencyCode, Today);        "Exchange Rate Amount" := 1;        "Relational Exch. Rate Amount" := 1 / CurrencyFactor;        "Adjustment Exch. Rate Amount" := "Exchange Rate Amount";        "Relational Adjmt Exch Rate Amt" := "Relational Exch. Rate Amount";        if RateForTodayExists then begin            "Relational Currency Code" := '';            Modify();        end else begin            "Starting Date" := Today;            Insert();        end;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFindCurrency(var CurrencyExchangeRate: Record "Currency Exchange Rate"; var CurrencyExchangeRateArray: array[2] of Record "Currency Exchange Rate"; Date: Date; CurrencyCode: Code[10]; CacheNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnExchangeAmtFCYToLCYOnAfterSetRelationalExchRateAmount(var CurrencyExchangeRate: Record "Currency Exchange Rate")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFindCurrencyOnAfterCalcShouldUseCache(var CurrencyExchangeRate: Record "Currency Exchange Rate"; CacheNo: Integer; var ShouldUseCache: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFindCurrencyOnAfterCurrencyExchRate2SetFilters(var CurrencyExchRate2: Record "Currency Exchange Rate"; CurrencyCode: Code[10]; Date: Date; var CurrencyExchangeRate: Record "Currency Exchange Rate")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnExchangeRateOnAfterSetRelationalExchRateAmount(var CurrencyExchangeRate: Record "Currency Exchange Rate")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFindCurrency2OnAfterCurrencyExchRate3SetFilters(var CurrencyExchRate3: Record "Currency Exchange Rate"; CurrencyCode: Code[10]; Date: Date; var CurrencyExchangeRate: Record "Currency Exchange Rate")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeExchangeAmtLCYToFCY(var CurrencyExchangeRate: Record "Currency Exchange Rate"; Date: Date; CurrencyCode: Code[10]; var Amount: Decimal; Factor: Decimal; var RelExchangeRateAmt: Decimal; var ExchangeRateAmt: Decimal; var RelCurrencyCode: Code[10]; FixExchangeRateAmt: Enum "Fix Exch. Rate Amount Type"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeExchangeAmtFCYToLCY(var CurrencyExchangeRate: Record "Currency Exchange Rate"; Date: Date; CurrencyCode: Code[10]; var Amount: Decimal; Factor: Decimal; UseAdjmtAmounts: Boolean; var RelExchangeRateAmt: Decimal; var ExchangeRateAmt: Decimal; var RelCurrencyCode: Code[10]; FixExchangeRateAmt: Enum "Fix Exch. Rate Amount Type"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeExchangeRate(var CurrencyExchangeRate: Record "Currency Exchange Rate"; Date: Date; CurrencyCode: Code[10]; var CurrencyFactor: Decimal; UseAdjmtAmounts: Boolean; var RelExchangeRateAmt: Decimal; var ExchangeRateAmt: Decimal; var RelCurrencyCode: Code[10]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeExchangeAmtFCYToFCY(var CurrencyExchangeRate: Record "Currency Exchange Rate"; Date: Date; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; var Amount: Decimal; CurrencyExchRate3: array[3] of Record "Currency Exchange Rate"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeApplnExchangeAmtFCYToFCY(var CurrencyExchangeRate: Record "Currency Exchange Rate"; Date: Date; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; var Amount: Decimal; var ExchRateFound: Boolean; CurrencyExchRate3: array[3] of Record "Currency Exchange Rate"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetLatestExchangeRate(var CurrencyExchangeRate: Record "Currency Exchange Rate"; CurrencyCode: Code[10]; var Date: Date; var Amount: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSetCurrentCurrencyFactor(var CurrencyExchangeRate: Record "Currency Exchange Rate"; CurrencyCode: Code[10]; CurrencyFactor: Decimal; var IsHandled: Boolean)    begin    end;}