Report 6 Trial Balance

Base Application, Microsoft.Finance.GeneralLedger.Reports

src/Layers/W1/BaseApp/Finance/GeneralLedger/Reports/TrialBalance.Report.al221 lines, Copyright (c) Microsoft Corporation. MIT

#if not CLEAN28// ------------------------------------------------------------------------------------------------// 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 standard trial balance report displaying account balances and period movements./// Shows opening balances, period debits/credits, and closing balances for comprehensive G/L account analysis./// </summary>/// <remarks>/// Data source: G/L Account table with balance calculations and period filtering capabilities./// Used for financial statement preparation, account reconciliation, and period-end procedures./// Supports filtering by account types, date ranges, and global dimensions for customized trial balance reporting./// </remarks>report 6 "Trial Balance"{    AdditionalSearchTerms = 'year closing,close accounting period,close fiscal year';    ApplicationArea = Basic, Suite;    Caption = 'Trial Balance (Obsolete)';    PreviewMode = PrintLayout;    UsageCategory = ReportsAndAnalysis;    DataAccessIntent = ReadOnly;    ObsoleteState = Pending;    ObsoleteReason = 'This report has been replaced by the report Trial Balance (Excel). This report will be removed in a future release.';    ObsoleteTag = '28.0';    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("G/L Account"; "G/L Account")        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.", "Account Type", "Date Filter", "Global Dimension 1 Filter", "Global Dimension 2 Filter";            column(STRSUBSTNO_Text000_PeriodText_; StrSubstNo(Text000, PeriodText))            {            }            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(PeriodText; PeriodText)            {            }            column(G_L_Account__TABLECAPTION__________GLFilter; TableCaption + ': ' + GLFilter)            {            }            column(GLFilter; GLFilter)            {            }            column(G_L_Account_No_; "No.")            {            }            column(Trial_BalanceCaption; Trial_BalanceCaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(Net_ChangeCaption; Net_ChangeCaptionLbl)            {            }            column(BalanceCaption; BalanceCaptionLbl)            {            }            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___Net_Change_Caption; G_L_Account___Net_Change_CaptionLbl)            {            }            column(G_L_Account___Net_Change__Control22Caption; G_L_Account___Net_Change__Control22CaptionLbl)            {            }            column(G_L_Account___Balance_at_Date_Caption; G_L_Account___Balance_at_Date_CaptionLbl)            {            }            column(G_L_Account___Balance_at_Date__Control24Caption; G_L_Account___Balance_at_Date__Control24CaptionLbl)            {            }            column(PageGroupNo; PageGroupNo)            {            }            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___Net_Change_; "G/L Account"."Net Change")                {                }                column(G_L_Account___Net_Change__Control22; -"G/L Account"."Net Change")                {                    AutoFormatType = 1;                }                column(G_L_Account___Balance_at_Date_; "G/L Account"."Balance at Date")                {                }                column(G_L_Account___Balance_at_Date__Control24; -"G/L Account"."Balance at Date")                {                    AutoFormatType = 1;                }                column(G_L_Account___Account_Type_; Format("G/L Account"."Account Type", 0, 2))                {                }                column(No__of_Blank_Lines; "G/L Account"."No. of Blank Lines")                {                }                dataitem(BlankLineRepeater; "Integer")                {                    DataItemTableView = sorting(Number);                    column(BlankLineNo; BlankLineNo)                    {                    }                    trigger OnAfterGetRecord()                    begin                        if BlankLineNo = 0 then                            CurrReport.Break();                        BlankLineNo -= 1;                    end;                }                trigger OnAfterGetRecord()                begin                    BlankLineNo := "G/L Account"."No. of Blank Lines" + 1;                end;            }            trigger OnAfterGetRecord()            begin                CalcFields("Net Change", "Balance at Date");                if ChangeGroupNo then begin                    PageGroupNo += 1;                    ChangeGroupNo := false;                end;                ChangeGroupNo := "New Page";            end;            trigger OnPreDataItem()            begin                PageGroupNo := 0;                ChangeGroupNo := false;            end;        }    }    requestpage    {        SaveValues = true;        AboutTitle = 'About Trial Balance (Obsolete)';        AboutText = 'View a snapshot of your chart of accounts with a balance at date and net change in the specified period.** This report is obsolete and will be removed in a future release.** Please refer to the report documentation for alternative ways to retrieve this information.';        layout        {        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Finance/GeneralLedger/Reports/TrialBalance.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        "G/L Account".SecurityFiltering(SecurityFilter::Filtered);        GLFilter := "G/L Account".GetFilters();        PeriodText := "G/L Account".GetFilter("Date Filter");    end;    var#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'Period: %1';#pragma warning restore AA0470#pragma warning restore AA0074        Trial_BalanceCaptionLbl: Label 'Trial Balance';        CurrReport_PAGENOCaptionLbl: Label 'Page';        Net_ChangeCaptionLbl: Label 'Net Change';        BalanceCaptionLbl: Label 'Balance';        PADSTR_____G_L_Account__Indentation___2___G_L_Account__NameCaptionLbl: Label 'Name';        G_L_Account___Net_Change_CaptionLbl: Label 'Debit';        G_L_Account___Net_Change__Control22CaptionLbl: Label 'Credit';        G_L_Account___Balance_at_Date_CaptionLbl: Label 'Debit';        G_L_Account___Balance_at_Date__Control24CaptionLbl: Label 'Credit';    protected var        GLFilter: Text;        PeriodText: Text[30];        PageGroupNo: Integer;        ChangeGroupNo: Boolean;        BlankLineNo: Integer;}#endif