Report 1 Chart of Accounts
src/Layers/W1/BaseApp/Finance/GeneralLedger/Reports/ChartofAccounts.Report.al225 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.Reports;using Microsoft.Finance.GeneralLedger.Account;using System.Utilities;/// <summary>/// Generates comprehensive chart of accounts report displaying account structure and balances./// Provides hierarchical view of G/L accounts with account types, names, and current balance information./// </summary>/// <remarks>/// Data source: G/L Account table with sorting by account number and account type filtering./// Output format: RDLC layout supporting account hierarchy display with indentation and balance calculations./// Includes options for filtering by account number ranges and account types for customized reporting./// </remarks>report 1 "Chart of Accounts"{ ApplicationArea = Basic, Suite; Caption = 'Chart of Accounts'; PreviewMode = PrintLayout; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("G/L Account"; "G/L Account") { DataItemTableView = sorting("No."); RequestFilterFields = "No.", "Account Type"; column(COMPANYNAME; COMPANYPROPERTY.DisplayName()) { } column(G_L_Account__TABLECAPTION__________GLFilter; TableCaption + ': ' + GLFilter) { } column(GLFilter; GLFilter) { } column(Chart_of_AccountsCaption; Chart_of_AccountsCaptionLbl) { } column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl) { } column(G_L_Account___No__Caption; FieldCaption("No.")) { } column(PADSTR_____G_L_Account__Indentation___2___G_L_Account__NameCaption; PADSTR_____G_L_Account__Indentation___2___G_L_Account__NameCaptionLbl) { } column(G_L_Account___Income_Balance_Caption; G_L_Account___Income_Balance_CaptionLbl) { } column(G_L_Account___Account_Type_Caption; G_L_Account___Account_Type_CaptionLbl) { } column(G_L_Account__TotalingCaption; G_L_Account__TotalingCaptionLbl) { } column(G_L_Account___Gen__Posting_Type_Caption; G_L_Account___Gen__Posting_Type_CaptionLbl) { } column(G_L_Account___Gen__Bus__Posting_Group_Caption; G_L_Account___Gen__Bus__Posting_Group_CaptionLbl) { } column(G_L_Account___Gen__Prod__Posting_Group_Caption; G_L_Account___Gen__Prod__Posting_Group_CaptionLbl) { } column(G_L_Account___Direct_Posting_Caption; G_L_Account___Direct_Posting_CaptionLbl) { } column(G_L_Account___Consol__Translation_Method_Caption; G_L_Account___Consol__Translation_Method_CaptionLbl) { } dataitem(BlankLineCounter; "Integer") { DataItemTableView = sorting(Number); trigger OnPreDataItem() begin SetRange(Number, 1, "G/L Account"."No. of Blank Lines"); end; } dataitem("Integer"; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(G_L_Account___No__; "G/L Account"."No.") { } column(PADSTR_____G_L_Account__Indentation___2___G_L_Account__Name; PadStr('', "G/L Account".Indentation * 2) + "G/L Account".Name) { } column(G_L_Account___Income_Balance_; "G/L Account"."Income/Balance") { } column(G_L_Account___Account_Type_; "G/L Account"."Account Type") { } column(G_L_Account__Totaling; "G/L Account".Totaling) { } column(G_L_Account___Gen__Posting_Type_; "G/L Account"."Gen. Posting Type") { } column(G_L_Account___Gen__Bus__Posting_Group_; "G/L Account"."Gen. Bus. Posting Group") { } column(G_L_Account___Gen__Prod__Posting_Group_; "G/L Account"."Gen. Prod. Posting Group") { } column(G_L_Account___Direct_Posting_; "G/L Account"."Direct Posting") { } column(G_L_Account___Consol__Translation_Method_; "G/L Account"."Consol. Translation Method") { } column(G_L_Account___No__of_Blank_Lines_; "G/L Account"."No. of Blank Lines") { } column(PageGroupNo; PageGroupNo) { } column(DirectPostingTxt; DirectPostingTxt) { } column(CheckAccType; CheckAccType) { } column(AccountType; AccountType) { } column(ConsTransMethod; ConsTransMethod) { } column(IncomeBalance; IncomeBalance) { } column(GenPostingType; GenPostingType) { } } trigger OnAfterGetRecord() begin PageGroupNo := NextPageGroupNo; if "New Page" then NextPageGroupNo := PageGroupNo + 1; DirectPostingTxt := Format("Direct Posting"); AccountType := Format("Account Type"); ConsTransMethod := Format("Consol. Translation Method"); CheckAccType := "Account Type" = "Account Type"::Posting; IncomeBalance := Format("Income/Balance"); GenPostingType := Format("Gen. Posting Type"); end; trigger OnPreDataItem() begin PageGroupNo := 1; NextPageGroupNo := 1; end; } } requestpage { AboutTitle = 'About Chart of Accounts'; AboutText = 'The **Chart of Accounts** report provides a complete overview of all general ledger accounts, grouped by category, including balances and account types. Use it for setting up or reviewing your company’s account structure, verifying posting groups, and preparing for audits or financial reporting.'; layout { } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Finance/GeneralLedger/Reports/ChartofAccounts.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } trigger OnPreReport() begin GLFilter := "G/L Account".GetFilters(); end; var PageGroupNo: Integer; NextPageGroupNo: Integer; DirectPostingTxt: Text[30]; CheckAccType: Boolean; AccountType: Text[30]; ConsTransMethod: Text[30]; IncomeBalance: Text[30]; GenPostingType: Text[30]; Chart_of_AccountsCaptionLbl: Label 'Chart of Accounts'; CurrReport_PAGENOCaptionLbl: Label 'Page'; PADSTR_____G_L_Account__Indentation___2___G_L_Account__NameCaptionLbl: Label 'Name'; G_L_Account___Income_Balance_CaptionLbl: Label 'Income/Balance'; G_L_Account___Account_Type_CaptionLbl: Label 'Account Type'; G_L_Account__TotalingCaptionLbl: Label 'Totaling'; G_L_Account___Gen__Posting_Type_CaptionLbl: Label 'Gen. Posting Type'; G_L_Account___Gen__Bus__Posting_Group_CaptionLbl: Label 'Gen. Bus. Posting Group'; G_L_Account___Gen__Prod__Posting_Group_CaptionLbl: Label 'Gen. Prod. Posting Group'; G_L_Account___Direct_Posting_CaptionLbl: Label 'Direct Posting'; G_L_Account___Consol__Translation_Method_CaptionLbl: Label 'Consol. Translation Method'; protected var GLFilter: Text;}