Report 6 Trial Balance
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