Report 17 Consolidated Trial Balance
src/Layers/W1/BaseApp/Finance/Consolidation/ConsolidatedTrialBalance.Report.al315 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.Consolidation;using Microsoft.Finance.GeneralLedger.Account;using System.Utilities;/// <summary>/// Generates consolidated trial balance report showing account balances from multiple business units./// Provides comprehensive trial balance view across consolidated companies with period comparisons./// </summary>/// <remarks>/// Report aggregates G/L account balances from consolidated business units with period and dimension filtering./// Supports currency conversion and multiple reporting options including thousands display./// Integration with consolidated G/L entries for multi-company reporting scenarios./// </remarks>report 17 "Consolidated Trial Balance"{ ApplicationArea = Suite; Caption = 'Consolidated Trial Balance'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("G/L Account"; "G/L Account") { DataItemTableView = sorting("No."); RequestFilterFields = "No.", "Global Dimension 1 Filter", "Global Dimension 2 Filter"; column(PeriodText; StrSubstNo(Text002, PeriodText)) { } column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(GLAccountGLFilter; TableCaption + ': ' + GLFilter) { } column(GLFilter; GLFilter) { } column(No_GLAcc; "No.") { IncludeCaption = true; } column(InThousands; InThousands) { } column(ConsolidatedTrialBalCaption; ConsolidatedTrialBalCaptionLbl) { } column(PageNoCaption; PageNoCaptionLbl) { } column(Amtsinwhole1000sCaption; Amtsinwhole1000sCaptionLbl) { } column(AmountCaption; AmountCaptionLbl) { } column(AmtInclEliminationsCaption; AmtInclEliminationsCaptionLbl) { } column(NameCaption; NameCaptionLbl) { } column(NetChangeCaption; NetChangeCaptionLbl) { } column(BalanceCaption; BalanceCaptionLbl) { } column(EliminationsCaption; EliminationsCaptionLbl) { } 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(No_GLAcc1; "G/L Account"."No.") { } column(GLAccIndentation2GLAccName; PadStr('', "G/L Account".Indentation * 2) + "G/L Account".Name) { } column(AccountType_GLAcc; "G/L Account"."Account Type") { } column(AccountTypePosting; GLAccountTypePosting) { } } dataitem("Business Unit"; "Business Unit") { DataItemTableView = sorting(Code) where(Consolidate = const(true)); column(GLAccIndentation22Code; PadStr('', "G/L Account".Indentation * 2 + 2) + Code) { } column(GLAccNetChange; GLAccNetChange) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(GLBalance; GLBalance) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } trigger OnAfterGetRecord() begin "G/L Account".SetRange("Business Unit Filter", Code); if ("Starting Date" <> 0D) and ("Ending Date" <> 0D) then "G/L Account".SetRange("Date Filter", "Starting Date", "Ending Date") else if ("Starting Date" <> 0D) and ("Ending Date" = 0D) then "G/L Account".SetRange("Date Filter", "Starting Date", ConsolidEndDate) else "G/L Account".SetRange("Date Filter", ConsolidStartDate, ConsolidEndDate); "G/L Account".CalcFields("Net Change", "Balance at Date"); GLAccNetChange := "G/L Account"."Net Change"; GLBalance := "G/L Account"."Balance at Date"; if (GLAccNetChange = 0) and (GLBalance = 0) then CurrReport.Skip(); if InThousands then begin GLAccNetChange := GLAccNetChange / 1000; GLBalance := GLBalance / 1000; end; end; trigger OnPreDataItem() begin Clear(GLAccNetChange); Clear(GLBalance); if BUFilter <> '' then SetFilter(Code, BUFilter); end; } dataitem(ConsolidCounter; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(GLAccIndentation2GLAccName2; PadStr('', "G/L Account".Indentation * 2) + "G/L Account".Name) { } column(EliminationAmount; EliminationAmount) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(GLAccNetChangeElmntnAmt; GLAccNetChange + EliminationAmount) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(GLBalanceEliminationAmt; GLBalance + EliminationAmount) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(PageGroupNo; PageGroupNo) { } column(NoBlankLines_GLAcc; "G/L Account"."No. of Blank Lines") { } trigger OnAfterGetRecord() begin "G/L Account".SetRange("Date Filter", ConsolidStartDate, ConsolidEndDate); "G/L Account".SetRange("Business Unit Filter", ''); "G/L Account".CalcFields("Net Change"); EliminationAmount := "G/L Account"."Net Change"; if InThousands then EliminationAmount := EliminationAmount / 1000; end; } trigger OnAfterGetRecord() begin PageGroupNo := NextPageGroupNo; if "New Page" then NextPageGroupNo := PageGroupNo + 1; GLAccountTypePosting := "Account Type" = "Account Type"::Posting; end; trigger OnPreDataItem() begin PageGroupNo := 1; NextPageGroupNo := 1; end; } } requestpage { AboutTitle = 'About Consolidated Trial Balance'; AboutText = 'Combines financial data across companies, allowing finance teams to analyze consolidated performance and ensure alignment across entities. Use this report when reviewing financial results across multiple companies within an organization.'; SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; group("Consolidation Period") { Caption = 'Consolidation Period'; field(StartingDt; ConsolidStartDate) { ApplicationArea = Suite; Caption = 'Starting Date'; ClosingDates = true; ToolTip = 'Specifies the first date in the period from which posted entries in the consolidated company will be shown.'; } field(EndingDt; ConsolidEndDate) { ApplicationArea = Suite; Caption = 'Ending Date'; ClosingDates = true; ToolTip = 'Specifies the end date for the period to process. If a business unit has a different fiscal year than the group, enter the end date for this company in the Business Unit window.'; } } field(InThousands; InThousands) { ApplicationArea = Suite; Caption = 'Amounts in whole 1000s'; ToolTip = 'Specifies if the amounts in the report are shown in whole 1000s.'; } } } } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Finance/Consolidation/ConsolidatedTrialBalance.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } trigger OnPreReport() begin if ConsolidStartDate = 0D then Error(Text000); if ConsolidEndDate = 0D then Error(Text001); GLFilter := "G/L Account".GetFilters(); "G/L Account".SetRange("Date Filter", ConsolidStartDate, ConsolidEndDate); PeriodText := "G/L Account".GetFilter("Date Filter"); BUFilter := "G/L Account".GetFilter("Business Unit Filter"); end; var#pragma warning disable AA0074 Text000: Label 'Enter the starting date for the consolidation period.'; Text001: Label 'Enter the ending date for the consolidation period.';#pragma warning disable AA0470 Text002: Label 'Period: %1';#pragma warning restore AA0470#pragma warning restore AA0074 InThousands: Boolean; ConsolidStartDate: Date; ConsolidEndDate: Date; GLAccNetChange: Decimal; GLBalance: Decimal; EliminationAmount: Decimal; PeriodText: Text; BUFilter: Text; PageGroupNo: Integer; NextPageGroupNo: Integer; ConsolidatedTrialBalCaptionLbl: Label 'Consolidated Trial Balance'; PageNoCaptionLbl: Label 'Page'; Amtsinwhole1000sCaptionLbl: Label 'Amounts are in whole 1000s.'; AmountCaptionLbl: Label 'Amount'; AmtInclEliminationsCaptionLbl: Label 'Amount Incl. Eliminations'; NameCaptionLbl: Label 'Name'; NetChangeCaptionLbl: Label 'Net Change'; BalanceCaptionLbl: Label 'Balance'; EliminationsCaptionLbl: Label 'Eliminations'; GLAccountTypePosting: Boolean; protected var GLFilter: Text;}