Table 589 G/L Account Source Currency

Base Application, Microsoft.Finance.GeneralLedger.Account

src/Layers/W1/BaseApp/Finance/GeneralLedger/Account/GLAccountSourceCurrency.Table.al220 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.GeneralLedger.Account;using Microsoft.Finance.Currency;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Ledger;/// <summary>/// Tracks source currency balances and transactions for general ledger accounts that support multi-currency operations./// Provides detailed currency-specific balance information for accounts configured with source currency posting./// </summary>/// <remarks>/// Key relationships: G/L Account, Currency, G/L Entry with source currency amounts./// Used for multi-currency accounting scenarios where accounts maintain balances in specific currencies./// Supports dimensional analysis and date-filtered balance calculations for source currency amounts./// Enables currency-specific reporting and exchange rate adjustment processes./// </remarks>table 589 "G/L Account Source Currency"{    Caption = 'G/L Account Source Currency';    DrillDownPageId = "Exchange Rate Adjmt. Register";    LookupPageID = "Exchange Rate Adjmt. Register";    DataClassification = CustomerContent;    fields    {        /// <summary>        /// General ledger account number that supports source currency posting and multi-currency transactions.        /// </summary>        field(1; "G/L Account No."; Code[20])        {            Caption = 'G/L Account No.';            TableRelation = "G/L Account";        }        /// <summary>        /// Currency code for the source currency used in transactions for this account.        /// </summary>        field(2; "Currency Code"; Code[10])        {            Caption = 'Currency Code';            ToolTip = 'Specifies the source currency code.';            TableRelation = Currency;        }        /// <summary>        /// Date range filter for calculating currency-specific balance amounts in flowfields.        /// </summary>        field(28; "Date Filter"; Date)        {            Caption = 'Date Filter';            FieldClass = FlowFilter;        }        /// <summary>        /// Filter for first global dimension to restrict currency balance calculations to specific dimension values.        /// </summary>        field(29; "Global Dimension 1 Filter"; Code[20])        {            CaptionClass = '1,3,1';            Caption = 'Global Dimension 1 Filter';            FieldClass = FlowFilter;            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1));        }        /// <summary>        /// Filter for second global dimension to restrict currency balance calculations to specific dimension values.        /// </summary>        field(30; "Global Dimension 2 Filter"; Code[20])        {            CaptionClass = '1,3,2';            Caption = 'Global Dimension 2 Filter';            FieldClass = FlowFilter;            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2));        }        /// <summary>        /// Account balance in local currency as of the specified date filter for this source currency combination.        /// </summary>        field(31; "Balance at Date"; Decimal)        {            AutoFormatExpression = "Currency Code";            AutoFormatType = 1;            CalcFormula = sum("G/L Entry".Amount where("G/L Account No." = field("G/L Account No."),                                                        "Source Currency Code" = field("Currency Code"),                                                        "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                        "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                        "Posting Date" = field(upperlimit("Date Filter"))));            Caption = 'Balance at Date';            ToolTip = 'Specifies the account balance in local currency.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Net change amount in source currency for the account within the specified date filter period.        /// </summary>        field(75; "Source Currency Net Change"; Decimal)        {            AutoFormatExpression = "Currency Code";            AutoFormatType = 1;            CalcFormula = sum("G/L Entry"."Source Currency Amount" where("G/L Account No." = field("G/L Account No."),                                                                          "Source Currency Code" = field("Currency Code"),                                                                          "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                          "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                          "Posting Date" = field("Date Filter")));            Caption = 'Source Currency Net Change';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Account balance in source currency as of the specified date filter for exchange rate analysis.        /// </summary>        field(76; "Source Curr. Balance at Date"; Decimal)        {            AutoFormatExpression = "Currency Code";            AutoFormatType = 1;            CalcFormula = sum("G/L Entry"."Source Currency Amount" where("G/L Account No." = field("G/L Account No."),                                                                          "Source Currency Code" = field("Currency Code"),                                                                          "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                          "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                          "Posting Date" = field(upperlimit("Date Filter"))));            Caption = 'Source Curr. Balance at Date';            ToolTip = 'Specifies the account balance in source currency.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Indicates whether general ledger entries exist for this account and currency combination.        /// </summary>        field(77; "Entries Exists"; Boolean)        {            CalcFormula = exist("G/L Entry" where("G/L Account No." = field("G/L Account No."),                                                   "Source Currency Code" = field("Currency Code")));            Caption = 'Entries Exists';            ToolTip = 'Specifies if general ledger entries with this source currency code exists.';            Editable = false;            FieldClass = FlowField;        }    }    keys    {        key(Key1; "G/L Account No.", "Currency Code")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    begin        CalcFields("Entries Exists");        TestField("Entries Exists", false);        GLAccount.Get("G/L Account No.");        if (GLAccount."Source Currency Code" = "Currency Code") and           (GLAccount."Source Currency Posting" = GLAccount."Source Currency Posting"::"Same Currency")        then            error(CannotDeleteErr, "Currency Code", GLAccount.FieldCaption("Source Currency Code"), GLAccount.TableCaption);    end;    trigger OnInsert()    begin        GLAccount.Get("G/L Account No.");        GLAccount.TestField("Source Currency Posting", GLAccount."Source Currency Posting"::"Multiple Currencies");    end;    trigger OnRename()    begin        Error(CannotRenameErr, "Currency Code");    end;    var        GLAccount: Record "G/L Account";        GLAccountSourceCurrency: Record "G/L Account Source Currency";        CannotRenameErr: Label 'You cannot rename %1', Comment = '%1 - currency code';        CannotDeleteErr: Label 'You cannot remove currency %1 because this currency code is set in field %2 in table %3', Comment = '%1 - currency code, %2 - field caption, %3 table caption';    /// <summary>    /// Builds a complete list of source currency records for a general ledger account based on existing entries.    /// Scans all general ledger entries for the filtered account and creates source currency records as needed.    /// </summary>    /// <remarks>    /// Creates missing source currency records for currencies found in general ledger entries.    /// Requires a G/L Account No. filter to be set before calling this procedure.    /// Used to initialize source currency tracking for accounts with multi-currency transactions.    /// </remarks>    procedure BuildCurrencyList()    var        GLEntry: Record "G/L Entry";        GLAccountNo: Code[20];    begin        if Rec.GetFilter("G/L Account No.") = '' then            exit;        GLAccountNo := Rec.GetRangeMin("G/L Account No.");        GLEntry.SetRange("G/L Account No.", GLAccountNo);        if GLEntry.FindSet() then            repeat                if not GLAccountSourceCurrency.Get(GLEntry."G/L Account No.", GLEntry."Source Currency Code") then                    InsertRecord(GLEntry."G/L Account No.", GLEntry."Source Currency Code");            until GLEntry.Next() = 0;    end;    /// <summary>    /// Creates a new source currency record for the specified general ledger account and currency combination.    /// Initializes the record with proper validation for account and currency relationships.    /// </summary>    /// <param name="GLAccountNo">General ledger account number for the source currency record</param>    /// <param name="CurrencyCode">Currency code for the source currency configuration</param>    procedure InsertRecord(GLAccountNo: Code[20]; CurrencyCode: Code[10])    begin        GLAccountSourceCurrency.Init();        GLAccountSourceCurrency.Validate("G/L Account No.", GLAccountNo);        GLAccountSourceCurrency.Validate("Currency Code", CurrencyCode);        GLAccountSourceCurrency.Insert();    end;}