Report 4 Detail Trial Balance
src/Layers/W1/BaseApp/Finance/GeneralLedger/Reports/DetailTrialBalance.Report.al394 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 Microsoft.Finance.GeneralLedger.Ledger;using System.Utilities;/// <summary>/// Generates detailed trial balance with individual transaction breakdowns for each G/L account./// Provides comprehensive audit trail with transaction-level detail including closing entries and corrections analysis./// </summary>/// <remarks>/// Data sources: G/L Account and G/L Entry tables with posting account filtering and transaction detail display./// Supports multiple filter options: balance-only accounts, closing entries, reversed entries, and correction entries./// Used for detailed financial analysis, audit procedures, and transaction-level reconciliation requirements./// </remarks>report 4 "Detail Trial Balance"{ AdditionalSearchTerms = 'payment due,order status'; ApplicationArea = Basic, Suite; Caption = 'Detail Trial Balance'; PreviewMode = PrintLayout; UsageCategory = ReportsAndAnalysis; DataAccessIntent = ReadOnly; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("G/L Account"; "G/L Account") { DataItemTableView = where("Account Type" = const(Posting)); PrintOnlyIfDetail = true; RequestFilterFields = "No.", "Search Name", "Income/Balance", "Debit/Credit", "Date Filter"; column(PeriodGLDtFilter; StrSubstNo(Text000, GLDateFilter)) { } column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(ExcludeBalanceOnly; ExcludeBalanceOnly) { } column(PrintReversedEntries; PrintReversedEntries) { } column(PageGroupNo; PageGroupNo) { } column(PrintOnlyOnePerPage; PrintOnlyOnePerPage) { } column(PrintClosingEntries; PrintClosingEntries) { } column(PrintOnlyCorrections; PrintOnlyCorrections) { } column(GLAccTableCaption; TableCaption + ': ' + GLFilter) { } column(GLFilter; GLFilter) { } column(EmptyString; '') { } column(No_GLAcc; "No.") { } column(DetailTrialBalCaption; DetailTrialBalCaptionLbl) { } column(PageCaption; PageCaptionLbl) { } column(BalanceCaption; BalanceCaptionLbl) { } column(PeriodCaption; PeriodCaptionLbl) { } column(OnlyCorrectionsCaption; OnlyCorrectionsCaptionLbl) { } column(NetChangeCaption; NetChangeCaptionLbl) { } column(GLEntryDebitAmtCaption; GLEntryDebitAmtCaptionLbl) { } column(GLEntryCreditAmtCaption; GLEntryCreditAmtCaptionLbl) { } column(GLBalCaption; GLBalCaptionLbl) { } dataitem(PageCounter; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(Name_GLAcc; "G/L Account".Name) { } column(StartBalance; StartBalance) { AutoFormatType = 1; } dataitem("G/L Entry"; "G/L Entry") { DataItemLink = "G/L Account No." = field("No."), "Posting Date" = field("Date Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Business Unit Code" = field("Business Unit Filter"), "Dimension Set ID" = field("Dimension Set ID Filter"); DataItemLinkReference = "G/L Account"; DataItemTableView = sorting("G/L Account No.", "Posting Date"); column(VATAmount_GLEntry; "VAT Amount") { IncludeCaption = true; } column(DebitAmount_GLEntry; "Debit Amount") { } column(CreditAmount_GLEntry; "Credit Amount") { } column(PostingDate_GLEntry; Format("Posting Date")) { } column(DocumentNo_GLEntry; "Document No.") { } column(ExtDocNo_GLEntry; "External Document No.") { IncludeCaption = true; } column(Description_GLEntry; Description) { } column(GLBalance; GLBalance) { AutoFormatType = 1; } column(EntryNo_GLEntry; "Entry No.") { } column(ClosingEntry; ClosingEntry) { } column(Reversed_GLEntry; Reversed) { } trigger OnAfterGetRecord() begin if PrintOnlyCorrections then if not (("Debit Amount" < 0) or ("Credit Amount" < 0)) then CurrReport.Skip(); if not PrintReversedEntries and Reversed then CurrReport.Skip(); ClosingEntry := "Posting Date" = ClosingDate("Posting Date"); if ClosingEntry and not PrintClosingEntries then CurrReport.Skip(); GLBalance := GLBalance + Amount; NumberOfGLEntryLines += 1; end; trigger OnPreDataItem() begin GLBalance := StartBalance; OnAfterOnPreDataItemGLEntry("G/L Entry"); end; } trigger OnAfterGetRecord() begin CurrReport.PrintOnlyIfDetail := ExcludeBalanceOnly or (StartBalance = 0); end; } trigger OnAfterGetRecord() var GLEntry: Record "G/L Entry"; Date: Record Date; begin StartBalance := 0; if GLDateFilter <> '' then begin Date.SetRange("Period Type", Date."Period Type"::Date); Date.SetFilter("Period Start", GLDateFilter); if Date.FindFirst() then begin SetRange("Date Filter", 0D, ClosingDate(Date."Period Start" - 1)); CalcFields("Net Change"); StartBalance := "Net Change"; SetFilter("Date Filter", GLDateFilter); end; end; if PrintOnlyOnePerPage then begin GLEntry.Reset(); GLEntry.SetRange("G/L Account No.", "No."); if CurrReport.PrintOnlyIfDetail and (not GLEntry.IsEmpty()) then PageGroupNo := PageGroupNo + 1; end; end; trigger OnPreDataItem() begin PageGroupNo := 1; end; } } requestpage { SaveValues = true; AboutTitle = 'About Detail Trial Balance'; AboutText = 'View bank account balances at the end of the period, including the opening balance, each transaction within the period, and the closing balance grouped by bank. View a running balance and reconciled entries.'; layout { area(content) { group(Options) { Caption = 'Options'; field(NewPageperGLAcc; PrintOnlyOnePerPage) { ApplicationArea = Basic, Suite; Caption = 'New Page per G/L Acc.'; ToolTip = 'Specifies if each G/L account information is printed on a new page if you have chosen two or more G/L accounts to be included in the report.'; } field(ExcludeGLAccsHaveBalanceOnly; ExcludeBalanceOnly) { ApplicationArea = Basic, Suite; Caption = 'Exclude G/L Accs. That Have a Balance Only'; MultiLine = true; ToolTip = 'Specifies if you do not want the report to include entries for G/L accounts that have a balance but do not have a net change during the selected time period.'; } field(InclClosingEntriesWithinPeriod; PrintClosingEntries) { ApplicationArea = Basic, Suite; Caption = 'Include Closing Entries Within the Period'; MultiLine = true; ToolTip = 'Specifies if you want the report to include closing entries. This is useful if the report covers an entire fiscal year. Closing entries are listed on a fictitious date between the last day of one fiscal year and the first day of the next one. They have a C before the date, such as C123194. If you do not select this field, no closing entries are shown.'; } field(IncludeReversedEntries; PrintReversedEntries) { ApplicationArea = Basic, Suite; Caption = 'Include Reversed Entries'; ToolTip = 'Specifies if you want to include reversed entries in the report.'; } field(PrintCorrectionsOnly; PrintOnlyCorrections) { ApplicationArea = Basic, Suite; Caption = 'Print Corrections Only'; ToolTip = 'Specifies if you want the report to show only the entries that have been reversed and their matching correcting entries.'; } } } } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Finance/GeneralLedger/Reports/DetailTrialBalance.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { PostingDateCaption = 'Posting Date'; DocNoCaption = 'Document No.'; DescCaption = 'Description'; VATAmtCaption = 'VAT Amount'; EntryNoCaption = 'Entry No.'; } trigger OnPreReport() begin StartDateTime := CurrentDateTime(); "G/L Account".SecurityFiltering(SecurityFilter::Filtered); "G/L Entry".SecurityFiltering(SecurityFilter::Filtered); GLFilter := "G/L Account".GetFilters(); GLDateFilter := "G/L Account".GetFilter("Date Filter"); OnAfterOnPreReport("G/L Account", ExcludeBalanceOnly); end; trigger OnPostReport() begin FinishDateTime := CurrentDateTime(); LogReportTelemetry(StartDateTime, FinishDateTime, NumberOfGLEntryLines); end; var#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Period: %1';#pragma warning restore AA0470#pragma warning restore AA0074 GLDateFilter: Text; GLBalance: Decimal; StartBalance: Decimal; PrintOnlyOnePerPage: Boolean; ExcludeBalanceOnly: Boolean; PrintClosingEntries: Boolean; PrintOnlyCorrections: Boolean; PrintReversedEntries: Boolean; PageGroupNo: Integer; ClosingEntry: Boolean; DetailTrialBalCaptionLbl: Label 'Detail Trial Balance'; PageCaptionLbl: Label 'Page'; BalanceCaptionLbl: Label 'This also includes general ledger accounts that only have a balance.'; PeriodCaptionLbl: Label 'This report also includes closing entries within the period.'; OnlyCorrectionsCaptionLbl: Label 'Only corrections are included.'; NetChangeCaptionLbl: Label 'Net Change'; GLEntryDebitAmtCaptionLbl: Label 'Debit'; GLEntryCreditAmtCaptionLbl: Label 'Credit'; GLBalCaptionLbl: Label 'Balance'; TelemetryCategoryTxt: Label 'Report', Locked = true; DetailedTrialBalanceReportGeneratedTxt: Label 'Detail Trial Balance report generated.', Locked = true; protected var GLFilter: Text; NumberOfGLEntryLines: Integer; StartDateTime: DateTime; FinishDateTime: DateTime; /// <summary> /// Initializes report parameters for programmatic execution with detailed filtering and display options. /// Configures entry type filters, page break options, and transaction inclusion criteria for customized trial balance generation. /// </summary> /// <param name="NewPrintOnlyOnePerPage">Whether to print only one account per page</param> /// <param name="NewExcludeBalanceOnly">Whether to exclude accounts with balance-only information</param> /// <param name="NewPrintClosingEntries">Whether to include closing entries in the report</param> /// <param name="NewPrintReversedEntries">Whether to include reversed entries in the report</param> /// <param name="NewPrintOnlyCorrections">Whether to print only correction entries</param> procedure InitializeRequest(NewPrintOnlyOnePerPage: Boolean; NewExcludeBalanceOnly: Boolean; NewPrintClosingEntries: Boolean; NewPrintReversedEntries: Boolean; NewPrintOnlyCorrections: Boolean) begin PrintOnlyOnePerPage := NewPrintOnlyOnePerPage; ExcludeBalanceOnly := NewExcludeBalanceOnly; PrintClosingEntries := NewPrintClosingEntries; PrintReversedEntries := NewPrintReversedEntries; PrintOnlyCorrections := NewPrintOnlyCorrections; end; local procedure LogReportTelemetry(StartDateTime: DateTime; FinishDateTime: DateTime; NumberOfLines: Integer) var Dimensions: Dictionary of [Text, Text]; ReportDuration: BigInteger; begin ReportDuration := FinishDateTime - StartDateTime; Dimensions.Add('Category', TelemetryCategoryTxt); Dimensions.Add('ReportStartTime', Format(StartDateTime, 0, 9)); Dimensions.Add('ReportFinishTime', Format(FinishDateTime, 0, 9)); Dimensions.Add('ReportDuration', Format(ReportDuration)); Dimensions.Add('NumberOfLines', Format(NumberOfLines)); Session.LogMessage('0000FJL', DetailedTrialBalanceReportGeneratedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, Dimensions); end; [IntegrationEvent(false, false)] /// <summary> /// Integration event raised after G/L Entry data item preprocessing for customization of entry filtering or data modification. /// Allows extensions to modify G/L Entry record properties or apply additional filters before report generation. /// </summary> /// <param name="GLEntry">G/L Entry record reference for modification by subscribers</param> local procedure OnAfterOnPreDataItemGLEntry(var GLEntry: Record "G/L Entry") begin end; [IntegrationEvent(false, false)] /// <summary> /// Integration event raised after report preprocessing for customization of G/L Account filtering or exclusion criteria. /// Allows extensions to modify account selection logic and balance exclusion rules before detail processing. /// </summary> /// <param name="GLAccount">G/L Account record reference for modification by subscribers</param> /// <param name="ExcludeBalanceOnly">Balance exclusion flag that can be modified by subscribers</param> local procedure OnAfterOnPreReport(var GLAccount: Record "G/L Account"; var ExcludeBalanceOnly: Boolean) begin end;}