Table 15 G/L Account

Base Application, Microsoft.Finance.GeneralLedger.Account

src/Layers/W1/BaseApp/Finance/GeneralLedger/Account/GLAccount.Table.al1,631 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.Bank.BankAccount;using Microsoft.CostAccounting.Account;using Microsoft.CostAccounting.Setup;using Microsoft.Finance.Analysis;using Microsoft.Finance.Consolidation;using Microsoft.Finance.Currency;using Microsoft.Finance.Deferral;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Budget;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.SalesTax;using Microsoft.Finance.SpendRequest;using Microsoft.Finance.VAT.Setup;using Microsoft.Foundation.Comment;using Microsoft.Foundation.Enums;using Microsoft.Foundation.ExtendedText;using Microsoft.Intercompany.GLAccount;using Microsoft.Pricing.Asset;using Microsoft.Pricing.PriceList;using Microsoft.Projects.Project.Planning;using Microsoft.Purchases.Document;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Utilities;using System.Utilities;/// <summary>/// Central master data table for general ledger accounts containing the chart of accounts structure./// Supports financial reporting, dimension analysis, budgeting, and multi-currency operations./// </summary>/// <remarks>/// Key relationships: G/L Entry, G/L Budget Entry, G/L Account Category, Dimension Values./// Primary data source for financial statements, trial balance, and account analysis reports./// Extensible via table extensions for industry-specific accounting requirements and additional financial dimensions./// Supports account hierarchies through Begin-Total/End-Total structure and account categorization for financial reporting./// </remarks>table 15 "G/L Account"{    Caption = 'G/L Account';    DataCaptionFields = "No.", Name;    DrillDownPageID = "Chart of Accounts";    LookupPageID = "G/L Account List";    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Unique identifier for the general ledger account used throughout all financial transactions and reporting.        /// </summary>        field(1; "No."; Code[20])        {            Caption = 'No.';            OptimizeForTextSearch = true;            NotBlank = true;            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';        }        /// <summary>        /// Descriptive name of the general ledger account displayed in financial reports and account listings.        /// </summary>        field(2; Name; Text[100])        {            Caption = 'Name';            OptimizeForTextSearch = true;            ToolTip = 'Specifies the name of the general ledger account.';            trigger OnValidate()            begin                if ("Search Name" = UpperCase(xRec.Name)) or ("Search Name" = '') then                    "Search Name" := Name;                UpdateMyAccount(FieldNo(Name));            end;        }        /// <summary>        /// Uppercase version of the account name used for faster search operations and lookups.        /// </summary>        field(3; "Search Name"; Code[100])        {            Caption = 'Search Name';            ToolTip = 'Specifies an alternate name that you can use to search for the record in question when you cannot remember the value in the Name field.';            OptimizeForTextSearch = true;        }        /// <summary>        /// Defines the account structure type determining posting capabilities and hierarchical relationships.        /// </summary>        field(4; "Account Type"; Enum "G/L Account Type")        {            Caption = 'Account Type';            ToolTip = 'Specifies the purpose of the account. Total: Used to total a series of balances on accounts from many different account groupings. To use Total, leave this field blank. Begin-Total: A marker for the beginning of a series of accounts to be totaled that ends with an End-Total account. End-Total: A total of a series of accounts that starts with the preceding Begin-Total account. The total is defined in the Totaling field.';            trigger OnValidate()            var                GLEntry: Record "G/L Entry";                GLBudgetEntry: Record "G/L Budget Entry";            begin                case "Account Type" of                    "Account Type"::Posting:                        "API Account Type" := "API Account Type"::Posting;                    "Account Type"::Heading:                        "API Account Type" := "API Account Type"::Heading;                    "Account Type"::Total:                        "API Account Type" := "API Account Type"::Total;                    "Account Type"::"Begin-Total":                        "API Account Type" := "API Account Type"::"Begin-Total";                    "Account Type"::"End-Total":                        "API Account Type" := "API Account Type"::"End-Total";                end;                if ("Account Type" <> "Account Type"::Posting) and                   (xRec."Account Type" = xRec."Account Type"::Posting)                then begin                    GLEntry.SetRange("G/L Account No.", "No.");                    if not GLEntry.IsEmpty() then                        Error(                          Text000,                          FieldCaption("Account Type"));                    GLBudgetEntry.SetRange("G/L Account No.", "No.");                    if not GLBudgetEntry.IsEmpty() then                        Error(                          Text001,                          FieldCaption("Account Type"));                end;                Totaling := '';                UpdateMyAccount(FieldNo(Totaling));                if "Account Type" = "Account Type"::Posting then begin                    if "Account Type" <> xRec."Account Type" then                        "Direct Posting" := true;                end else                    "Direct Posting" := false;            end;        }        /// <summary>        /// First global dimension code for account-level dimensional analysis and reporting segmentation.        /// </summary>        field(6; "Global Dimension 1 Code"; Code[20])        {            CaptionClass = '1,1,1';            Caption = 'Global Dimension 1 Code';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1),                                                          Blocked = const(false));            trigger OnValidate()            begin                Rec.ValidateShortcutDimCode(1, "Global Dimension 1 Code");            end;        }        /// <summary>        /// Second global dimension code for additional dimensional analysis and reporting segmentation.        /// </summary>        field(7; "Global Dimension 2 Code"; Code[20])        {            CaptionClass = '1,1,2';            Caption = 'Global Dimension 2 Code';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2),                                                          Blocked = const(false));            trigger OnValidate()            begin                Rec.ValidateShortcutDimCode(2, "Global Dimension 2 Code");            end;        }        /// <summary>        /// Financial statement category classification for automated financial reporting and analysis.        /// </summary>        field(8; "Account Category"; Enum "G/L Account Category")        {            BlankZero = true;            Caption = 'Account Category';            ToolTip = 'Specifies the category of the G/L account.';            trigger OnValidate()            begin                if "Account Category" = "Account Category"::" " then                    exit;                if "Account Category" in ["Account Category"::Income, "Account Category"::"Cost of Goods Sold", "Account Category"::Expense] then                    "Income/Balance" := "Income/Balance"::"Income Statement"                else                    "Income/Balance" := "Income/Balance"::"Balance Sheet";                if "Account Category" <> xRec."Account Category" then                    "Account Subcategory Entry No." := 0;                UpdateAccountCategoryOfSubAccounts();            end;        }        /// <summary>        /// Determines whether the account appears on Income Statement or Balance Sheet financial reports.        /// </summary>        field(9; "Income/Balance"; Enum "G/L Account Report Type")        {            Caption = 'Income/Balance';            ToolTip = 'Specifies whether a general ledger account is an income statement account or a balance sheet account.';            trigger OnValidate()            var                CostType: Record "Cost Type";            begin                if ("Income/Balance" = "Income/Balance"::"Balance Sheet") and ("Cost Type No." <> '') then begin                    if CostType.Get("No.") then begin                        CostType."G/L Account Range" := '';                        CostType.Modify();                    end;                    "Cost Type No." := '';                end;            end;        }        /// <summary>        /// Restricts posting to debit only, credit only, or allows both debit and credit transactions.        /// </summary>        field(10; "Debit/Credit"; Option)        {            Caption = 'Debit/Credit';            ToolTip = 'Specifies the type of entries that will normally be posted to this general ledger account.';            OptionCaption = 'Both,Debit,Credit';            OptionMembers = Both,Debit,Credit;        }        /// <summary>        /// Secondary account number for alternative identification or integration with external systems.        /// </summary>        field(11; "No. 2"; Code[20])        {            Caption = 'No. 2';            ToolTip = 'Specifies an alternative account number which can be used internally in the company.';        }        /// <summary>        /// Indicates whether comment lines exist for this general ledger account.        /// </summary>        field(12; Comment; Boolean)        {            CalcFormula = exist("Comment Line" where("Table Name" = const("G/L Account"),                                                      "No." = field("No.")));            Caption = 'Comment';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Prevents posting transactions to this account when set to true.        /// </summary>        field(13; Blocked; Boolean)        {            Caption = 'Blocked';            ToolTip = 'Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine.';        }        /// <summary>        /// Enables direct posting of transactions to this account when true, required for posting-type accounts.        /// </summary>        field(14; "Direct Posting"; Boolean)        {            Caption = 'Direct Posting';            ToolTip = 'Specifies whether you will be able to post directly or only indirectly to this general ledger account. To allow Direct Posting to the G/L account, place a check mark in the check box.';            InitValue = true;        }        /// <summary>        /// Identifies accounts used for bank reconciliation processes with bank statement import functionality.        /// </summary>        field(16; "Reconciliation Account"; Boolean)        {            AccessByPermission = TableData "Bank Account" = R;            Caption = 'Reconciliation Account';            ToolTip = 'Specifies whether this general ledger account will be included in the Reconciliation window in the general journal. To have the G/L account included in the window, place a check mark in the check box. You can find the Reconciliation window by clicking Actions, Posting in the General Journal window.';        }        /// <summary>        /// Forces a page break before this account when printing financial reports.        /// </summary>        field(17; "New Page"; Boolean)        {            Caption = 'New Page';            ToolTip = 'Specifies whether you want a new page to start immediately after this general ledger account when you print the chart of accounts. Select this field to start a new page after this general ledger account.';        }        /// <summary>        /// Number of blank lines to insert before this account in printed financial reports.        /// </summary>        field(18; "No. of Blank Lines"; Integer)        {            Caption = 'No. of Blank Lines';            ToolTip = 'Specifies the number of blank lines that you want inserted before this account in the chart of accounts.';            MinValue = 0;        }        /// <summary>        /// Visual indentation level for hierarchical display of accounts in the chart of accounts.        /// </summary>        field(19; Indentation; Integer)        {            Caption = 'Indentation';            MinValue = 0;            trigger OnValidate()            begin                if Indentation < 0 then                    Indentation := 0;            end;        }        /// <summary>        /// Currency code for source currency posting when account supports multi-currency transactions.        /// </summary>        field(20; "Source Currency Code"; Code[10])        {            Caption = 'Currency Code';            ToolTip = 'Specifies the allowed source currency code if Source Currency Posting value is Same Currency.';            TableRelation = Currency;            DataClassification = SystemMetadata;            trigger OnValidate()            var                GLAccountSourceCurrency: Record "G/L Account Source Currency";            begin                if "Source Currency Code" <> '' then                    TestField("Source Currency Posting", "Source Currency Posting"::"Same Currency");                if ("Source Currency Code" <> '') and                   (("Account Type" <> "Account Type"::Posting) or ("Income/Balance" <> "Income/Balance"::"Balance Sheet"))                then                    Error(CurrencyCodeErr);                if "Source Currency Code" <> '' then                    CheckNotUsedAsReceivablesPayablesAccount();                if ("Source Currency Code" <> xRec."Source Currency Code") and (xRec."Source Currency Code" <> '') then begin                    GLAccountSourceCurrency."G/L Account No." := "No.";                    GLAccountSourceCurrency."Currency Code" := xRec."Source Currency Code";                    GLAccountSourceCurrency.CalcFields("Balance at Date", "Source Curr. Balance at Date");                    if (GLAccountSourceCurrency."Balance at Date" <> 0) or (GLAccountSourceCurrency."Source Curr. Balance at Date" <> 0) then                        Error(BalanceMustBeZeroErr);                end;                if "Source Currency Code" <> xRec."Source Currency Code" then                    GLAccountSourceCurrency.InsertRecord("No.", "Source Currency Code");            end;        }        /// <summary>        /// Defines how transactions in different currencies are handled for this source currency account.        /// </summary>        field(21; "Source Currency Posting"; Enum "G/L Source Currency Posting")        {            Caption = 'Source Currency Posting';            ToolTip = 'Specifies how the system will validate posting of entries containing currencies. Blank will allow all currencies to be posted to the account. Same Code will only allow the currency specified in Source Currency Code. Multiple currencies will allow only posting of currencies selected in Source currency code. Local currency only allow posting without a Currency code.';        }        /// <summary>        /// Enables currency revaluation calculations for this source currency account.        /// </summary>        field(22; "Source Currency Revaluation"; Boolean)        {            Caption = 'Source Currency Revaluation';            ToolTip = 'Specifies if source currency revaluation should be done for this account.';            trigger OnValidate()            begin                if "Source Currency Revaluation" then                    CheckNotUsedAsReceivablesPayablesAccount();            end;        }        /// <summary>        /// Indicates whether this account supports unrealized currency revaluation adjustments.        /// </summary>        field(23; "Unrealized Revaluation"; Boolean)        {            Caption = 'Unrealized Revaluation';            ToolTip = 'Specifies if revaluation should be posted to currency realized or unrealized gains and losses accounts.';        }        /// <summary>        /// Timestamp of the last modification to this general ledger account record.        /// </summary>        field(25; "Last Modified Date Time"; DateTime)        {            Caption = 'Last Modified Date Time';            Editable = false;        }        /// <summary>        /// Date when this general ledger account was last modified.        /// </summary>        field(26; "Last Date Modified"; Date)        {            Caption = 'Last Date Modified';            ToolTip = 'Specifies when the G/L account was last modified.';            Editable = false;        }        /// <summary>        /// Date range filter for calculating balance and transaction amounts in flowfields.        /// </summary>        field(28; "Date Filter"; Date)        {            Caption = 'Date Filter';            FieldClass = FlowFilter;        }        /// <summary>        /// Filter for first global dimension to restrict 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 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 as of the specified date filter including all historical transactions.        /// </summary>        field(31; "Balance at Date"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            CalcFormula = sum("G/L Entry".Amount where("G/L Account No." = field("No."),                                                        "G/L Account No." = field(filter(Totaling)),                                                        "Business Unit Code" = field("Business Unit Filter"),                                                        "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                        "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                        "Posting Date" = field(upperlimit("Date Filter")),                                                        "VAT Reporting Date" = field(upperlimit("VAT Reporting Date Filter")),                                                        "Dimension Set ID" = field("Dimension Set ID Filter")));            Caption = 'Balance at Date';            ToolTip = 'Specifies the G/L account balance on the last date included in the Date Filter field.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Net change amount for the account within the specified date filter period.        /// </summary>        field(32; "Net Change"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            CalcFormula = sum("G/L Entry".Amount where("G/L Account No." = field("No."),                                                        "G/L Account No." = field(filter(Totaling)),                                                        "Business Unit Code" = field("Business Unit Filter"),                                                        "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                        "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                        "Posting Date" = field("Date Filter"),                                                        "VAT Reporting Date" = field("VAT Reporting Date Filter"),                                                        "Dimension Set ID" = field("Dimension Set ID Filter")));            Caption = 'Net Change';            ToolTip = 'Specifies the net change in the account balance during the time period in the Date Filter field.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Total budgeted amount for the account within the specified date and budget filters.        /// </summary>        field(33; "Budgeted Amount"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            CalcFormula = sum("G/L Budget Entry".Amount where("G/L Account No." = field("No."),                                                               "G/L Account No." = field(filter(Totaling)),                                                               "Business Unit Code" = field("Business Unit Filter"),                                                               "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                               "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                               Date = field("Date Filter"),                                                               "Budget Name" = field("Budget Filter"),                                                               "Dimension Set ID" = field("Dimension Set ID Filter")));            Caption = 'Budgeted Amount';            ToolTip = 'Specifies either the G/L account''s total budget or, if you have specified a name in the Budget Name field, a specific budget.';            FieldClass = FlowField;        }        /// <summary>        /// Account number range used for totaling calculations when account type is Begin-Total or End-Total.        /// </summary>        field(34; Totaling; Text[250])        {            Caption = 'Totaling';            ToolTip = 'Specifies an account interval or a list of account numbers. The entries of the account will be totaled to give a total balance. How entries are totaled depends on the value in the Account Type field.';            trigger OnValidate()            begin                if not IsTotaling() then                    FieldError("Account Type");                CalcFields(Balance);                UpdateMyAccount(FieldNo(Totaling));            end;        }        /// <summary>        /// Budget name filter for restricting budget calculations to specific budget scenarios.        /// </summary>        field(35; "Budget Filter"; Code[10])        {            Caption = 'Budget Filter';            FieldClass = FlowFilter;            TableRelation = "G/L Budget Name";        }        /// <summary>        /// Current balance of the account including all posted transactions without date restrictions.        /// </summary>        field(36; Balance; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            CalcFormula = sum("G/L Entry".Amount where("G/L Account No." = field("No."),                                                        "G/L Account No." = field(filter(Totaling)),                                                        "Business Unit Code" = field("Business Unit Filter"),                                                        "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                        "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                        "Dimension Set ID" = field("Dimension Set ID Filter")));            Caption = 'Balance';            ToolTip = 'Specifies the balance on this account.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Budgeted amount as of the specified date filter for budget performance analysis.        /// </summary>        field(37; "Budget at Date"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            CalcFormula = sum("G/L Budget Entry".Amount where("G/L Account No." = field("No."),                                                               "G/L Account No." = field(filter(Totaling)),                                                               "Business Unit Code" = field("Business Unit Filter"),                                                               "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                               "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                               Date = field(upperlimit("Date Filter")),                                                               "Budget Name" = field("Budget Filter"),                                                               "Dimension Set ID" = field("Dimension Set ID Filter")));            Caption = 'Budget at Date';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Currency translation method used for consolidation of foreign subsidiaries.        /// </summary>        field(39; "Consol. Translation Method"; Option)        {            AccessByPermission = TableData "Business Unit" = R;            Caption = 'Consol. Translation Method';            ToolTip = 'Specifies the consolidation translation method that will be used for the account.';            OptionCaption = 'Average Rate (Manual),Closing Rate,Historical Rate,Composite Rate,Equity Rate';            OptionMembers = "Average Rate (Manual)","Closing Rate","Historical Rate","Composite Rate","Equity Rate";            trigger OnValidate()            var                ConflictGLAcc: Record "G/L Account";            begin                if TranslationMethodConflict(ConflictGLAcc) then                    if ConflictGLAcc.GetFilter("Consol. Debit Acc.") <> '' then                        Message(                          Text002, ConflictGLAcc.TableCaption(), ConflictGLAcc."No.", ConflictGLAcc.FieldCaption("Consol. Debit Acc."),                          ConflictGLAcc.FieldCaption("Consol. Translation Method"), ConflictGLAcc."Consol. Translation Method")                    else                        Message(                          Text002, ConflictGLAcc.TableCaption(), ConflictGLAcc."No.", ConflictGLAcc.FieldCaption("Consol. Credit Acc."),                          ConflictGLAcc.FieldCaption("Consol. Translation Method"), ConflictGLAcc."Consol. Translation Method");            end;        }        /// <summary>        /// Consolidation account number for debit transactions when consolidating foreign subsidiaries.        /// </summary>        field(40; "Consol. Debit Acc."; Code[20])        {            AccessByPermission = TableData "Business Unit" = R;            Caption = 'Consol. Debit Acc.';            ToolTip = 'Specifies the account number in a consolidated company to transfer credit balances.';            trigger OnValidate()            var                ConflictGLAcc: Record "G/L Account";            begin                if TranslationMethodConflict(ConflictGLAcc) then                    Message(                      Text002, ConflictGLAcc.TableCaption(), ConflictGLAcc."No.", ConflictGLAcc.FieldCaption("Consol. Debit Acc."),                      ConflictGLAcc.FieldCaption("Consol. Translation Method"), ConflictGLAcc."Consol. Translation Method");            end;        }        /// <summary>        /// Consolidation account number for credit transactions when consolidating foreign subsidiaries.        /// </summary>        field(41; "Consol. Credit Acc."; Code[20])        {            AccessByPermission = TableData "Business Unit" = R;            Caption = 'Consol. Credit Acc.';            ToolTip = 'Specifies if amounts without any payment tolerance amount from the customer and vendor ledger entries are used.';            trigger OnValidate()            var                ConflictGLAcc: Record "G/L Account";            begin                if TranslationMethodConflict(ConflictGLAcc) then                    Message(                      Text002, ConflictGLAcc.TableCaption(), ConflictGLAcc."No.", ConflictGLAcc.FieldCaption("Consol. Credit Acc."),                      ConflictGLAcc.FieldCaption("Consol. Translation Method"), ConflictGLAcc."Consol. Translation Method");            end;        }        /// <summary>        /// Business unit filter for restricting balance calculations to specific business units in consolidation.        /// </summary>        field(42; "Business Unit Filter"; Code[20])        {            Caption = 'Business Unit Filter';            FieldClass = FlowFilter;            TableRelation = "Business Unit";        }        /// <summary>        /// General posting type classification for VAT and general posting group combinations.        /// </summary>        field(43; "Gen. Posting Type"; Enum "General Posting Type")        {            Caption = 'Gen. Posting Type';            ToolTip = 'Specifies the general posting type to use when posting to this account.';        }        /// <summary>        /// General business posting group for determining posting accounts in combination with product posting groups.        /// </summary>        field(44; "Gen. Bus. Posting Group"; Code[20])        {            Caption = 'Gen. Bus. Posting Group';            TableRelation = "Gen. Business Posting Group";            ToolTip = 'Specifies the vendor''s or customer''s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup.';            trigger OnValidate()            var                GenBusPostingGrp: Record "Gen. Business Posting Group";            begin                if xRec."Gen. Bus. Posting Group" <> "Gen. Bus. Posting Group" then                    if GenBusPostingGrp.ValidateVatBusPostingGroup(GenBusPostingGrp, "Gen. Bus. Posting Group") then                        Validate("VAT Bus. Posting Group", GenBusPostingGrp."Def. VAT Bus. Posting Group");            end;        }        /// <summary>        /// General product posting group for determining posting accounts in combination with business posting groups.        /// </summary>        field(45; "Gen. Prod. Posting Group"; Code[20])        {            Caption = 'Gen. Prod. Posting Group';            TableRelation = "Gen. Product Posting Group";            ToolTip = 'Specifies the item''s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup.';            trigger OnValidate()            var                GenProdPostingGrp: Record "Gen. Product Posting Group";            begin                CheckOrdersPrepmtToDeduct(FieldCaption("Gen. Prod. Posting Group"));                if xRec."Gen. Prod. Posting Group" <> "Gen. Prod. Posting Group" then                    if GenProdPostingGrp.ValidateVatProdPostingGroup(GenProdPostingGrp, "Gen. Prod. Posting Group") then                        Validate("VAT Prod. Posting Group", GenProdPostingGrp."Def. VAT Prod. Posting Group");            end;        }        /// <summary>        /// Account picture or image for visual identification in user interfaces.        /// </summary>        field(46; Picture; BLOB)        {            Caption = 'Picture';            SubType = Bitmap;        }        /// <summary>        /// Total debit amount for the account within the specified date and dimension filters.        /// </summary>        field(47; "Debit Amount"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            BlankZero = true;            CalcFormula = sum("G/L Entry"."Debit Amount" where("G/L Account No." = field("No."),                                                                "G/L Account No." = field(filter(Totaling)),                                                                "Business Unit Code" = field("Business Unit Filter"),                                                                "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                "Posting Date" = field("Date Filter"),                                                                "VAT Reporting Date" = field("VAT Reporting Date Filter"),                                                                "Dimension Set ID" = field("Dimension Set ID Filter")));            Caption = 'Debit Amount';            ToolTip = 'Specifies the total of the ledger entries that represent debits.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Total credit amount for the account within the specified date and dimension filters.        /// </summary>        field(48; "Credit Amount"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            BlankZero = true;            CalcFormula = sum("G/L Entry"."Credit Amount" where("G/L Account No." = field("No."),                                                                 "G/L Account No." = field(filter(Totaling)),                                                                 "Business Unit Code" = field("Business Unit Filter"),                                                                 "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                 "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                 "Posting Date" = field("Date Filter"),                                                                 "VAT Reporting Date" = field("VAT Reporting Date Filter"),                                                                 "Dimension Set ID" = field("Dimension Set ID Filter")));            Caption = 'Credit Amount';            ToolTip = 'Specifies the total of the ledger entries that represent credits.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Enables automatic insertion of extended text lines when the account is used in documents.        /// </summary>        field(49; "Automatic Ext. Texts"; Boolean)        {            Caption = 'Automatic Ext. Texts';            ToolTip = 'Specifies that an extended text will be added automatically to the account.';        }        /// <summary>        /// Positive budget amounts for the account within the specified date and budget filters.        /// </summary>        field(52; "Budgeted Debit Amount"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            BlankNumbers = BlankNegAndZero;            CalcFormula = sum("G/L Budget Entry".Amount where("G/L Account No." = field("No."),                                                               "G/L Account No." = field(filter(Totaling)),                                                               "Business Unit Code" = field("Business Unit Filter"),                                                               "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                               "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                               Date = field("Date Filter"),                                                               "Budget Name" = field("Budget Filter"),                                                               "Dimension Set ID" = field("Dimension Set ID Filter")));            Caption = 'Budgeted Debit Amount';            ToolTip = 'Specifies the Budgeted Debit Amount for the account.';            FieldClass = FlowField;        }        /// <summary>        /// Negative budget amounts for the account within the specified date and budget filters.        /// </summary>        field(53; "Budgeted Credit Amount"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            BlankNumbers = BlankNegAndZero;            CalcFormula = - sum("G/L Budget Entry".Amount where("G/L Account No." = field("No."),                                                                "G/L Account No." = field(filter(Totaling)),                                                                "Business Unit Code" = field("Business Unit Filter"),                                                                "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                Date = field("Date Filter"),                                                                "Budget Name" = field("Budget Filter"),                                                                "Dimension Set ID" = field("Dimension Set ID Filter")));            Caption = 'Budgeted Credit Amount';            ToolTip = 'Specifies the Budgeted Credit Amount for the account.';            FieldClass = FlowField;        }        /// <summary>        /// Tax area code for sales tax calculation when tax functionality is enabled.        /// </summary>        field(54; "Tax Area Code"; Code[20])        {            Caption = 'Tax Area Code';            TableRelation = "Tax Area";        }        /// <summary>        /// Indicates whether the account is subject to tax calculation in tax-enabled jurisdictions.        /// </summary>        field(55; "Tax Liable"; Boolean)        {            Caption = 'Tax Liable';        }        /// <summary>        /// Tax group code for determining applicable tax rates and calculation methods.        /// </summary>        field(56; "Tax Group Code"; Code[20])        {            Caption = 'Tax Group Code';            ToolTip = 'Specifies the tax group that is used to calculate and post sales tax.';            TableRelation = "Tax Group";        }        /// <summary>        /// VAT business posting group for determining VAT treatment in combination with VAT product posting groups.        /// </summary>        field(57; "VAT Bus. Posting Group"; Code[20])        {            Caption = 'VAT Bus. Posting Group';            TableRelation = "VAT Business Posting Group";            ToolTip = 'Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.';        }        /// <summary>        /// VAT product posting group for determining VAT treatment in combination with VAT business posting groups.        /// </summary>        field(58; "VAT Prod. Posting Group"; Code[20])        {            Caption = 'VAT Prod. Posting Group';            TableRelation = "VAT Product Posting Group";            ToolTip = 'Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.';            trigger OnValidate()            begin                CheckOrdersPrepmtToDeduct(FieldCaption("VAT Prod. Posting Group"));            end;        }        /// <summary>        /// Total VAT amount for the account within the specified date and dimension filters.        /// </summary>        field(59; "VAT Amt."; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            CalcFormula = sum("G/L Entry"."VAT Amount" where("G/L Account No." = field("No."),                                                              "G/L Account No." = field(filter(Totaling)),                                                              "Business Unit Code" = field("Business Unit Filter"),                                                              "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                              "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                              "VAT Reporting Date" = field("VAT Reporting Date Filter"),                                                              "Posting Date" = field("Date Filter")));            Caption = 'VAT Amt.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Net change amount in additional reporting currency for the account within the specified date filters.        /// </summary>        field(60; "Additional-Currency Net Change"; Decimal)        {            AutoFormatExpression = GetCurrencyCode();            AutoFormatType = 1;            CalcFormula = sum("G/L Entry"."Additional-Currency Amount" where("G/L Account No." = field("No."),                                                                              "G/L Account No." = field(filter(Totaling)),                                                                              "Business Unit Code" = field("Business Unit Filter"),                                                                              "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                              "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                              "VAT Reporting Date" = field("VAT Reporting Date Filter"),                                                                              "Posting Date" = field("Date Filter")));            Caption = 'Additional-Currency Net Change';            ToolTip = 'Specifies the net change in the account balance.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Balance in additional reporting currency as of the specified date filter.        /// </summary>        field(61; "Add.-Currency Balance at Date"; Decimal)        {            AutoFormatExpression = GetCurrencyCode();            AutoFormatType = 1;            CalcFormula = sum("G/L Entry"."Additional-Currency Amount" where("G/L Account No." = field("No."),                                                                              "G/L Account No." = field(filter(Totaling)),                                                                              "Business Unit Code" = field("Business Unit Filter"),                                                                              "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                              "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                              "VAT Reporting Date" = field(upperlimit("VAT Reporting Date Filter")),                                                                              "Posting Date" = field(upperlimit("Date Filter"))));            Caption = 'Add.-Currency Balance at Date';            ToolTip = 'Specifies the G/L account balance, in the additional reporting currency, on the last date included in the Date Filter field.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Current balance in additional reporting currency including all posted transactions.        /// </summary>        field(62; "Additional-Currency Balance"; Decimal)        {            AutoFormatExpression = GetCurrencyCode();            AutoFormatType = 1;            CalcFormula = sum("G/L Entry"."Additional-Currency Amount" where("G/L Account No." = field("No."),                                                                              "G/L Account No." = field(filter(Totaling)),                                                                              "Business Unit Code" = field("Business Unit Filter"),                                                                              "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                              "Global Dimension 2 Code" = field("Global Dimension 2 Filter")));            Caption = 'Additional-Currency Balance';            ToolTip = 'Specifies the balance on this account, in the additional reporting currency.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Exchange rate adjustment type for currency revaluation processing.        /// </summary>        field(63; "Exchange Rate Adjustment"; Enum "Exch. Rate Adjustment Type")        {            AccessByPermission = TableData Currency = R;            Caption = 'Exchange Rate Adjustment';            ToolTip = 'Specifies how general ledger accounts will be adjusted for exchange rate fluctuations between LCY and the additional reporting currency.';        }        /// <summary>        /// Total debit amount in additional reporting currency for the account within the specified filters.        /// </summary>        field(64; "Add.-Currency Debit Amount"; Decimal)        {            AutoFormatExpression = GetCurrencyCode();            AutoFormatType = 1;            CalcFormula = sum("G/L Entry"."Add.-Currency Debit Amount" where("G/L Account No." = field("No."),                                                                              "G/L Account No." = field(filter(Totaling)),                                                                              "Business Unit Code" = field("Business Unit Filter"),                                                                              "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                              "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                              "VAT Reporting Date" = field("VAT Reporting Date Filter"),                                                                              "Posting Date" = field("Date Filter")));            Caption = 'Add.-Currency Debit Amount';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Total credit amount in additional reporting currency for the account within the specified filters.        /// </summary>        field(65; "Add.-Currency Credit Amount"; Decimal)        {            AutoFormatExpression = GetCurrencyCode();            AutoFormatType = 1;            CalcFormula = sum("G/L Entry"."Add.-Currency Credit Amount" where("G/L Account No." = field("No."),                                                                               "G/L Account No." = field(filter(Totaling)),                                                                               "Business Unit Code" = field("Business Unit Filter"),                                                                               "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                               "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                               "VAT Reporting Date" = field("VAT Reporting Date Filter"),                                                                               "Posting Date" = field("Date Filter")));            Caption = 'Add.-Currency Credit Amount';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Default intercompany partner general ledger account for automatic intercompany transactions.        /// </summary>        field(66; "Default IC Partner G/L Acc. No"; Code[20])        {            Caption = 'Default IC Partner G/L Acc. No';            ToolTip = 'Specifies accounts that you often enter in the Bal. Account No. field on intercompany journal or document lines.';            TableRelation = "IC G/L Account"."No.";        }        /// <summary>        /// Excludes default account name description from journal entries when posting transactions.        /// </summary>        field(70; "Omit Default Descr. in Jnl."; Boolean)        {            Caption = 'Omit Default Descr. in Jnl.';            ToolTip = 'Specifies if the default description is automatically inserted in the Description field on journal lines created for this general ledger account.';        }        /// <summary>        /// Net change amount in source currency for the account within the specified date filters.        /// </summary>        field(75; "Source Currency Net Change"; Decimal)        {            AutoFormatExpression = Rec."Source Currency Code";            AutoFormatType = 1;            CalcFormula = sum("G/L Entry"."Source Currency Amount" where("G/L Account No." = field("No."),                                                                          "G/L Account No." = field(filter(Totaling)),                                                                          "Business Unit Code" = field("Business Unit Filter"),                                                                          "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                          "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                          "VAT Reporting Date" = field("VAT Reporting Date Filter"),                                                                          "Posting Date" = field("Date Filter")));            Caption = 'Source Currency Net Change';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Balance in source currency as of the specified date filter for source currency accounts.        /// </summary>        field(76; "Source Curr. Balance at Date"; Decimal)        {            AutoFormatExpression = Rec."Source Currency Code";            AutoFormatType = 1;            CalcFormula = sum("G/L Entry"."Source Currency Amount" where("G/L Account No." = field("No."),                                                                          "G/L Account No." = field(filter(Totaling)),                                                                          "Business Unit Code" = field("Business Unit Filter"),                                                                          "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                          "Global Dimension 2 Code" = field("Global Dimension 2 Filter"),                                                                          "VAT Reporting Date" = field(upperlimit("VAT Reporting Date Filter")),                                                                          "Posting Date" = field(upperlimit("Date Filter"))));            Caption = 'Source Curr. Balance at Date';            ToolTip = 'Specifies the G/L account foreign currency balance on the last date included in the Date Filter field.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Current balance in source currency for source currency accounts including all posted transactions.        /// </summary>        field(77; "Source Currency Balance"; Decimal)        {            AutoFormatExpression = Rec."Source Currency Code";            AutoFormatType = 1;            CalcFormula = sum("G/L Entry"."Source Currency Amount" where("G/L Account No." = field("No."),                                                                          "G/L Account No." = field(filter(Totaling)),                                                                          "Business Unit Code" = field("Business Unit Filter"),                                                                          "Global Dimension 1 Code" = field("Global Dimension 1 Filter"),                                                                          "Global Dimension 2 Code" = field("Global Dimension 2 Filter")));            Caption = 'Source Currency Balance';            ToolTip = 'Specifies the foreign currency balance on the G/L account.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Reference to the account subcategory entry for detailed financial statement classification.        /// </summary>        field(80; "Account Subcategory Entry No."; Integer)        {            Caption = 'Account Subcategory Entry No.';            TableRelation = "G/L Account Category";            trigger OnValidate()            var                GLAccountCategory: Record "G/L Account Category";            begin                if "Account Subcategory Entry No." = 0 then                    exit;                GLAccountCategory.Get("Account Subcategory Entry No.");                TestField("Income/Balance", GLAccountCategory."Income/Balance");                "Account Category" := Enum::"G/L Account Category".FromInteger(GLAccountCategory."Account Category");            end;        }        /// <summary>        /// Description text for the account subcategory providing detailed classification information.        /// </summary>        field(81; "Account Subcategory Descript."; Text[80])        {            CalcFormula = lookup("G/L Account Category".Description where("Entry No." = field("Account Subcategory Entry No.")));            Caption = 'Account Subcategory Descript.';            ToolTip = 'Specifies the subcategory of the account category of the G/L account.';            Editable = false;            FieldClass = FlowField;        }        /// <summary>        /// Date filter specifically for VAT reporting date to calculate VAT-related flowfields.        /// </summary>        field(82; "VAT Reporting Date Filter"; Date)        {            Caption = 'VAT Reporting Date Filter';            FieldClass = FlowFilter;        }        /// <summary>        /// Excludes this account from consolidation processes when consolidating multiple companies or business units.        /// </summary>        field(83; "Exclude From Consolidation"; Boolean)        {            Caption = 'Exclude from Consolidation';            ToolTip = 'Specifies whether the account is excluded from consolidation.';            DataClassification = CustomerContent;        }        /// <summary>        /// Specifies whether a spend request is required before expenses can be posted to this account.        /// </summary>        field(90; "Spend Request Required"; Enum "Spend Request Required")        {            Caption = 'Spend Request Required';            ToolTip = 'Specifies whether a spend request is required before expenses can be posted to this account.';            DataClassification = CustomerContent;        }        /// <summary>        /// Filter for dimension set ID to restrict balance calculations to specific dimension combinations.        /// </summary>        field(400; "Dimension Set ID Filter"; Integer)        {            Caption = 'Dimension Set ID Filter';            FieldClass = FlowFilter;        }        /// <summary>        /// Associated cost accounting cost type number for integration with cost accounting functionality.        /// </summary>        field(1100; "Cost Type No."; Code[20])        {            Caption = 'Cost Type No.';            ToolTip = 'Specifies a cost type number to establish which cost type a general ledger account belongs to.';            Editable = false;            TableRelation = "Cost Type";            ValidateTableRelation = false;        }        /// <summary>        /// Default deferral template for automatic deferral processing when the account is used in transactions.        /// </summary>        field(1700; "Default Deferral Template Code"; Code[10])        {            Caption = 'Default Deferral Template Code';            ToolTip = 'Specifies the default deferral template that governs how to defer revenues and expenses to the periods when they occurred.';            TableRelation = "Deferral Template"."Deferral Code";        }        /// <summary>        /// API-compatible account type field that mirrors the Account Type field for external integrations.        /// </summary>        field(9000; "API Account Type"; Enum "G/L Account Type")        {            Caption = 'API Account Type';            Editable = false;        }    }    keys    {        key(Key1; "No.")        {            Clustered = true;        }        key(Key2; "Search Name")        {        }        key(Key3; "Reconciliation Account")        {        }        key(Key4; "Gen. Bus. Posting Group")        {        }        key(Key5; "Gen. Prod. Posting Group")        {        }        key(Key6; "Consol. Debit Acc.", "Consol. Translation Method")        {            Enabled = false;        }        key(Key7; "Consol. Credit Acc.", "Consol. Translation Method")        {            Enabled = false;        }        key(Key8; Name)        {        }        key(Key9; "Account Type")        {        }        key(Key10; "Account Category")        {        }    }    fieldgroups    {        fieldgroup(DropDown; "No.", Name, "Income/Balance", Blocked, "Direct Posting")        {        }        fieldgroup(Brick; "No.", Name, "Income/Balance", Balance, Blocked)        {        }    }    trigger OnDelete()    var        GLBudgetEntry: Record "G/L Budget Entry";        ExtTextHeader: Record "Extended Text Header";        AnalysisViewEntry: Record "Analysis View Entry";        AnalysisViewBudgetEntry: Record "Analysis View Budget Entry";        MyAccount: Record "My Account";        ICGLAccount: Record "IC G/L Account";        MoveEntries: Codeunit MoveEntries;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeOnDelete(Rec, IsHandled);        if IsHandled then            exit;        MoveEntries.MoveGLEntries(Rec);        GLBudgetEntry.SetCurrentKey("Budget Name", "G/L Account No.");        GLBudgetEntry.SetRange("G/L Account No.", "No.");        GLBudgetEntry.DeleteAll(true);        CommentLine.SetRange("Table Name", CommentLine."Table Name"::"G/L Account");        CommentLine.SetRange("No.", "No.");        CommentLine.DeleteAll();        ExtTextHeader.SetRange("Table Name", ExtTextHeader."Table Name"::"G/L Account");        ExtTextHeader.SetRange("No.", "No.");        ExtTextHeader.DeleteAll(true);        AnalysisViewEntry.SetRange("Account No.", "No.");        AnalysisViewEntry.DeleteAll();        AnalysisViewBudgetEntry.SetRange("G/L Account No.", "No.");        AnalysisViewBudgetEntry.DeleteAll();        MyAccount.SetRange("Account No.", "No.");        MyAccount.DeleteAll();        ICGLAccount.SetRange("Map-to G/L Acc. No.", Rec."No.");        if not ICGLAccount.IsEmpty() then            ICGLAccount.ModifyAll("Map-to G/L Acc. No.", '');        DimMgt.DeleteDefaultDim(DATABASE::"G/L Account", "No.");    end;    trigger OnInsert()    begin        DimMgt.UpdateDefaultDim(DATABASE::"G/L Account", "No.",          "Global Dimension 1 Code", "Global Dimension 2 Code");        SetLastModifiedDateTime();        if CostAccSetup.Get() then            CostAccMgt.UpdateCostTypeFromGLAcc(Rec, xRec, 0);        if Indentation < 0 then            Indentation := 0;    end;    trigger OnModify()    begin        SetLastModifiedDateTime();        if CostAccSetup.Get() then            if CurrFieldNo <> 0 then                CostAccMgt.UpdateCostTypeFromGLAcc(Rec, xRec, 1)            else                CostAccMgt.UpdateCostTypeFromGLAcc(Rec, xRec, 0);        if Indentation < 0 then            Indentation := 0;    end;    trigger OnRename()    var        SalesLine: Record "Sales Line";        PurchaseLine: Record "Purchase Line";        JobPlanningLine: Record "Job Planning Line";    begin        SalesLine.RenameNo(SalesLine.Type::"G/L Account", xRec."No.", "No.");        PurchaseLine.RenameNo(PurchaseLine.Type::"G/L Account", xRec."No.", "No.");        DimMgt.RenameDefaultDim(DATABASE::"G/L Account", xRec."No.", "No.");        CommentLine.RenameCommentLine(CommentLine."Table Name"::"G/L Account", xRec."No.", "No.");        JobPlanningLine.RenameNo(JobPlanningLine.Type::"G/L Account", xRec."No.", "No.");        SetLastModifiedDateTime();        if CostAccSetup.ReadPermission then            CostAccMgt.UpdateCostTypeFromGLAcc(Rec, xRec, 3);    end;    var        GLSetup: Record "General Ledger Setup";        CostAccSetup: Record "Cost Accounting Setup";        CommentLine: Record "Comment Line";        DimMgt: Codeunit DimensionManagement;        CostAccMgt: Codeunit "Cost Account Mgt";        GLSetupRead: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'You cannot change %1 because there are one or more ledger entries associated with this account.';        Text001: Label 'You cannot change %1 because this account is part of one or more budgets.';        Text002: Label 'There is another %1: %2; which refers to the same %3, but with a different %4: %5.';#pragma warning restore AA0470#pragma warning restore AA0074        NoAccountCategoryMatchErr: Label 'There is no subcategory description for %1 that matches ''%2''.', Comment = '%1=account category value, %2=the user input.';        GenProdPostingGroupErr: Label '%1 is not set for the %2 G/L account with no. %3.', Comment = '%1 - caption Gen. Prod. Posting Group; %2 - G/L Account Description; %3 - G/L Account No.';        CannotChangeSetupOnPrepmtAccErr: Label 'You cannot change %2 on account %3 while %1 is pending prepayment.', Comment = '%2 - field caption, %3 - account number, %1 - recordId - "Sales Header: Order, 1001".';        CurrencyCodeErr: Label 'Currency codes are only allowed for assets and liabilities and posting account.';        BalanceMustBeZeroErr: Label 'In order to change the currency code, the balance of the account must be zero.';        AccUsedAsReceivablesErr: Label 'G/L Account %1 is used as a Receivables Account in Customer Posting Group %2 and cannot be used for source currency revaluation.', Comment = '%1 = G/L Account No., %2 = Customer Posting Group Code';        AccUsedAsPayablesVendorErr: Label 'G/L Account %1 is used as a Payables Account in Vendor Posting Group %2 and cannot be used for source currency revaluation.', Comment = '%1 = G/L Account No., %2 = Vendor Posting Group Code';    local procedure CheckNotUsedAsReceivablesPayablesAccount()    var        CustomerPostingGroup: Record "Customer Posting Group";        VendorPostingGroup: Record "Vendor Posting Group";    begin        CustomerPostingGroup.SetRange("Receivables Account", "No.");        if CustomerPostingGroup.FindFirst() then            Error(AccUsedAsReceivablesErr, "No.", CustomerPostingGroup.Code);        VendorPostingGroup.SetRange("Payables Account", "No.");        if VendorPostingGroup.FindFirst() then            Error(AccUsedAsPayablesVendorErr, "No.", VendorPostingGroup.Code);    end;    local procedure AsPriceAsset(var PriceAsset: Record "Price Asset"; PriceType: Enum "Price Type")    begin        PriceAsset.Init();        PriceAsset."Price Type" := PriceType;        PriceAsset."Asset Type" := PriceAsset."Asset Type"::"G/L Account";        PriceAsset."Asset No." := "No.";    end;    /// <summary>    /// Displays price list lines for this general ledger account filtered by price type and amount type.    /// </summary>    /// <param name="PriceType">Type of pricing (Sale or Purchase) to filter price lists</param>    /// <param name="AmountType">Amount type filter for displaying relevant price list entries</param>    procedure ShowPriceListLines(PriceType: Enum "Price Type"; AmountType: Enum "Price Amount Type")    var        PriceAsset: Record "Price Asset";        PriceUXManagement: Codeunit "Price UX Management";    begin        AsPriceAsset(PriceAsset, PriceType);        PriceUXManagement.ShowPriceListLines(PriceAsset, PriceType, AmountType);    end;    /// <summary>    /// Initializes a new general ledger account with default values based on an existing account.    /// Copies income/balance classification and other relevant setup from the reference account.    /// </summary>    /// <param name="OldGLAcc">Reference account to copy default values from</param>    /// <param name="BelowOldGLAcc">Indicates whether the new account is positioned below the reference account</param>    procedure SetupNewGLAcc(OldGLAcc: Record "G/L Account"; BelowOldGLAcc: Boolean)    var        OldGLAcc2: Record "G/L Account";    begin        if not BelowOldGLAcc then begin            OldGLAcc2 := OldGLAcc;            OldGLAcc.Copy(Rec);            OldGLAcc := OldGLAcc2;            if not OldGLAcc.Find('<') then                OldGLAcc.Init();        end;        "Income/Balance" := OldGLAcc."Income/Balance";        OnAfterSetupNewGLAcc(Rec);    end;    /// <summary>    /// Validates that the general ledger account is ready for posting transactions.    /// Checks that account type is Posting and account is not blocked.    /// </summary>    procedure CheckGLAcc()    begin        TestField("Account Type", "Account Type"::Posting);        TestField(Blocked, false);        OnAfterCheckGLAcc(Rec);    end;    /// <summary>    /// Validates and sets the account subcategory based on text input from user interface.    /// Matches input text against available subcategory descriptions for the account category.    /// </summary>    /// <param name="NewValue">Text description of the subcategory to match and assign</param>    procedure ValidateAccountSubCategory(NewValue: Text[80])    var        GLAccountCategory: Record "G/L Account Category";    begin        if NewValue = "Account Subcategory Descript." then            exit;        if NewValue = '' then            Validate("Account Subcategory Entry No.", 0)        else begin            GLAccountCategory.SetRange("Account Category", "Account Category");            GLAccountCategory.SetRange(Description, NewValue);            if not GLAccountCategory.FindFirst() then begin                GLAccountCategory.SetFilter(Description, '''@*' + NewValue + '*''');                if not GLAccountCategory.FindFirst() then                    Error(NoAccountCategoryMatchErr, "Account Category", NewValue);            end;            Validate("Account Subcategory Entry No.", GLAccountCategory."Entry No.");        end;        GLAccountCategory.ShowNotificationAccSchedUpdateNeeded();    end;    /// <summary>    /// Opens a lookup page for selecting account subcategory based on the account's income/balance type and category.    /// Updates the account category and subcategory based on user selection.    /// </summary>    procedure LookupAccountSubCategory()    var        GLAccountCategory: Record "G/L Account Category";        GLAccountCategories: Page "G/L Account Categories";    begin        if "Account Subcategory Entry No." <> 0 then            if GLAccountCategory.Get("Account Subcategory Entry No.") then                GLAccountCategories.SetRecord(GLAccountCategory);        GLAccountCategory.SetRange("Income/Balance", "Income/Balance");        if "Account Category" <> "Account Category"::" " then            GLAccountCategory.SetRange("Account Category", "Account Category");        GLAccountCategories.SetTableView(GLAccountCategory);        GLAccountCategories.LookupMode(true);        if GLAccountCategories.RunModal() = ACTION::LookupOK then begin            GLAccountCategories.GetRecord(GLAccountCategory);            Validate("Account Category", GLAccountCategory."Account Category");            "Account Subcategory Entry No." := GLAccountCategory."Entry No.";            GLAccountCategory.ShowNotificationAccSchedUpdateNeeded();        end;        CalcFields("Account Subcategory Descript.");    end;    local procedure UpdateAccountCategoryOfSubAccounts()    var        GLAccountSubAccount: Record "G/L Account";    begin        if "Account Type" <> "Account Type"::"Begin-Total" then            exit;        GLAccountSubAccount.SetFilter("No.", '>%1', "No.");        GLAccountSubAccount.SetRange(Indentation, Indentation, Indentation + 1);        GLAccountSubAccount.SetFilter("Account Category", '%1|%2', "Account Category"::" ", xRec."Account Category");        if not GLAccountSubAccount.FindSet() then            exit;        repeat            if (GLAccountSubAccount.Indentation = Indentation) and               (GLAccountSubAccount."Account Type" <> "Account Type"::"End-Total")            then                exit;            GLAccountSubAccount.Validate("Account Category", "Account Category");            GLAccountSubAccount.Modify();        until GLAccountSubAccount.Next() = 0;    end;    /// <summary>    /// Returns the additional reporting currency code from General Ledger Setup.    /// Used for additional currency amount formatting in flowfields.    /// </summary>    /// <returns>Additional reporting currency code or empty string if not configured</returns>    procedure GetCurrencyCode(): Code[10]    begin        if not GLSetupRead then begin            GLSetup.Get();            GLSetupRead := true;        end;        exit(GLSetup."Additional Reporting Currency");    end;    /// <summary>    /// Validates and updates the shortcut dimension code for the specified dimension field.    /// Saves the dimension value as a default dimension for this account.    /// </summary>    /// <param name="FieldNumber">Dimension field number (1 for Global Dimension 1, 2 for Global Dimension 2)</param>    /// <param name="ShortcutDimCode">Dimension value code to validate and assign</param>    procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin        OnBeforeValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode);        DimMgt.ValidateDimValueCode(FieldNumber, ShortcutDimCode);        if not IsTemporary then begin            DimMgt.SaveDefaultDim(DATABASE::"G/L Account", "No.", FieldNumber, ShortcutDimCode);            Modify();        end;        OnAfterValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode);    end;    /// <summary>    /// Checks for consolidation translation method conflicts with other accounts using same consolidation accounts.    /// Prevents inconsistent translation methods for accounts that consolidate to the same target account.    /// </summary>    /// <param name="GLAcc">Returns the conflicting account record if a conflict is found</param>    /// <returns>True if a translation method conflict exists, false otherwise</returns>    procedure TranslationMethodConflict(var GLAcc: Record "G/L Account"): Boolean    begin        GLAcc.Reset();        GLAcc.SetFilter("No.", '<>%1', "No.");        GLAcc.SetFilter("Consol. Translation Method", '<>%1', "Consol. Translation Method");        if "Consol. Debit Acc." <> '' then begin            if not GLAcc.SetCurrentKey("Consol. Debit Acc.", "Consol. Translation Method") then                GLAcc.SetCurrentKey("No.");            GLAcc.SetRange("Consol. Debit Acc.", "Consol. Debit Acc.");            if GLAcc.Find('-') then                exit(true);            GLAcc.SetRange("Consol. Debit Acc.");        end;        if "Consol. Credit Acc." <> '' then begin            if not GLAcc.SetCurrentKey("Consol. Credit Acc.", "Consol. Translation Method") then                GLAcc.SetCurrentKey("No.");            GLAcc.SetRange("Consol. Credit Acc.", "Consol. Credit Acc.");            if GLAcc.Find('-') then                exit(true);            GLAcc.SetRange("Consol. Credit Acc.");        end;        exit(false);    end;    /// <summary>    /// Validates that the general product posting group is specified for the account.    /// Logs an error message if the posting group is missing for posting-type accounts.    /// </summary>    procedure CheckGenProdPostingGroup()    var        ErrorMessageManagement: Codeunit "Error Message Management";        ForwardLinkMgt: Codeunit "Forward Link Mgt.";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckGenProdPostingGroup(Rec, IsHandled);        if IsHandled then            exit;        if "Gen. Prod. Posting Group" = '' then            ErrorMessageManagement.LogContextFieldError(                0,                StrSubstNo(GenProdPostingGroupErr, FieldCaption("Gen. Prod. Posting Group"), Name, "No."),                Rec,                FieldNo("Gen. Prod. Posting Group"),                ForwardLinkMgt.GetHelpCodeForEmptyPostingSetupAccount());    end;    local procedure SetLastModifiedDateTime()    begin        "Last Modified Date Time" := CurrentDateTime;        "Last Date Modified" := Today;    end;    local procedure CheckOrdersPrepmtToDeduct(FldCaption: Text)    begin        CheckPurchaseOrdersPrepmtToDeduct(FldCaption);        CheckSalesOrdersPrepmtToDeduct(FldCaption);    end;    local procedure CheckSalesOrdersPrepmtToDeduct(FldCaption: Text)    var        GeneralPostingSetup: Record "General Posting Setup";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckSalesOrdersPrepmtToDeduct(Rec, IsHandled);        if IsHandled then            exit;        GeneralPostingSetup.SetLoadFields("Gen. Bus. Posting Group", "Gen. Prod. Posting Group");        GeneralPostingSetup.SetRange("Sales Prepayments Account", "No.");        if GeneralPostingSetup.FindSet() then            repeat                GeneralPostingSetup.CheckPrepmtSalesLinesToDeduct(                    StrSubstNo(CannotChangeSetupOnPrepmtAccErr, '%1', FldCaption, "No."));            until GeneralPostingSetup.Next() = 0;    end;    local procedure CheckPurchaseOrdersPrepmtToDeduct(FldCaption: Text)    var        GeneralPostingSetup: Record "General Posting Setup";    begin        GeneralPostingSetup.SetLoadFields("Gen. Bus. Posting Group", "Gen. Prod. Posting Group");        GeneralPostingSetup.SetRange("Purch. Prepayments Account", "No.");        if GeneralPostingSetup.FindSet() then            repeat                GeneralPostingSetup.CheckPrepmtPurchLinesToDeduct(                    StrSubstNo(CannotChangeSetupOnPrepmtAccErr, '%1', FldCaption, "No."));            until GeneralPostingSetup.Next() = 0;    end;    /// <summary>    /// Determines whether the account type supports totaling functionality.    /// Returns true for Total and End-Total account types used in account hierarchies.    /// </summary>    /// <returns>True if account type is Total or End-Total, false otherwise</returns>    procedure IsTotaling(): Boolean    begin        exit("Account Type" in ["Account Type"::Total, "Account Type"::"End-Total"]);    end;    [InherentPermissions(PermissionObjectType::TableData, Database::"My Account", 'rm')]    local procedure UpdateMyAccount(CallingFieldNo: Integer)    var        MyAccount: Record "My Account";    begin        case CallingFieldNo of            FieldNo(Name):                begin                    MyAccount.SetRange("Account No.", "No.");                    if not MyAccount.IsEmpty() then                        MyAccount.ModifyAll(Name, Name);                end;            FieldNo(Totaling):                begin                    MyAccount.SetRange("Account No.", "No.");                    if not MyAccount.IsEmpty() then                        MyAccount.ModifyAll(Totaling, Totaling);                end;        end;    end;    /// <summary>    /// Integration event raised after validating that a general ledger account is ready for posting.    /// Allows extensions to add custom validation logic for account posting readiness.    /// </summary>    /// <param name="GLAccount">General ledger account being validated for posting</param>    [IntegrationEvent(false, false)]    local procedure OnAfterCheckGLAcc(var GLAccount: Record "G/L Account")    begin    end;    /// <summary>    /// Integration event raised after setting up a new general ledger account with default values.    /// Allows extensions to add custom initialization logic for new accounts.    /// </summary>    /// <param name="GLAccount">Newly created general ledger account being initialized</param>    [IntegrationEvent(false, false)]    local procedure OnAfterSetupNewGLAcc(var GLAccount: Record "G/L Account")    begin    end;    /// <summary>    /// Integration event raised after validating and updating shortcut dimension codes.    /// Allows extensions to perform additional processing after dimension validation.    /// </summary>    /// <param name="GLAccount">Current general ledger account record</param>    /// <param name="xGLAccount">Previous version of the general ledger account record</param>    /// <param name="FieldNumber">Dimension field number being validated</param>    /// <param name="ShortcutDimCode">Dimension value code that was validated</param>    [IntegrationEvent(false, false)]    local procedure OnAfterValidateShortcutDimCode(var GLAccount: Record "G/L Account"; var xGLAccount: Record "G/L Account"; FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin    end;    /// <summary>    /// Integration event raised before validating shortcut dimension codes.    /// Allows extensions to modify validation logic or skip default validation.    /// </summary>    /// <param name="GLAccount">Current general ledger account record</param>    /// <param name="xGLAccount">Previous version of the general ledger account record</param>    /// <param name="FieldNumber">Dimension field number being validated</param>    /// <param name="ShortcutDimCode">Dimension value code being validated</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateShortcutDimCode(var GLAccount: Record "G/L Account"; var xGLAccount: Record "G/L Account"; FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin    end;    /// <summary>    /// Integration event raised before checking general product posting group requirements.    /// Allows extensions to override or supplement posting group validation logic.    /// </summary>    /// <param name="GLAccount">General ledger account being validated</param>    /// <param name="IsHandled">Set to true to skip default validation logic</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckGenProdPostingGroup(var GLAccount: Record "G/L Account"; var IsHandled: Boolean)    begin    end;    /// <summary>    /// Integration event raised before deleting a general ledger account.    /// Allows extensions to perform custom validation or cleanup before account deletion.    /// </summary>    /// <param name="GLAccount">General ledger account being deleted</param>    /// <param name="IsHandled">Set to true to skip default deletion logic</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeOnDelete(var GLAccount: Record "G/L Account"; var IsHandled: Boolean)    begin    end;    /// <summary>    /// Integration event raised before checking sales orders with prepayments to deduct.    /// Allows extensions to override or supplement prepayment validation logic for sales orders.    /// </summary>    /// <param name="GLAccount">General ledger account being checked for sales prepayments</param>    /// <param name="IsHandled">Set to true to skip default prepayment validation logic</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckSalesOrdersPrepmtToDeduct(var GLAccount: Record "G/L Account"; var IsHandled: Boolean)    begin    end;}