Report 18 Consolidated Trial Balance (4)
src/Layers/W1/BaseApp/Finance/Consolidation/ConsolidatedTrialBalance4.Report.al404 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 Microsoft.Foundation.Enums;using System.Utilities;/// <summary>/// Generates consolidated trial balance report with four-column layout for comprehensive financial analysis./// Provides enhanced trial balance view with multiple period comparisons and detailed account breakdowns./// </summary>/// <remarks>/// Extended trial balance report with four-column format for period-over-period analysis across consolidated entities./// Supports advanced filtering by consolidation dates, amount types, and currency conversion options./// Integrates with consolidated G/L entries for multi-company financial reporting and analysis./// </remarks>report 18 "Consolidated Trial Balance (4)"{ ApplicationArea = Suite; Caption = 'Consolidated Trial Balance (4)'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("Business Unit"; "Business Unit") { DataItemTableView = sorting(Code) where(Consolidate = const(true)); trigger OnAfterGetRecord() begin j := j + 1; if j > ArrayLen(BusUnitColumn) then Error(Text002, ArrayLen(BusUnitColumn)); BusUnitColumn[j] := "Business Unit"; end; trigger OnPreDataItem() begin PageGroupNo := 1; NextPageGroupNo := 1; j := 0; if BUFilter <> '' then SetFilter(Code, BUFilter); end; } dataitem("G/L Account"; "G/L Account") { DataItemTableView = sorting("No."); RequestFilterFields = "No.", "Global Dimension 1 Filter", "Global Dimension 2 Filter", "Business Unit Filter"; column(FORMAT_TODAY_0_4_; Format(Today, 0, 4)) { } column(STRSUBSTNO_Text003_PeriodText_; StrSubstNo(Text003, PeriodText)) { } column(COMPANYNAME; COMPANYPROPERTY.DisplayName()) { } column(USERID; UserId) { } column(InThousands; InThousands) { } column(G_L_Account__TABLECAPTION__________GLFilter; TableCaption + ': ' + GLFilter) { } column(GLFilter; GLFilter) { } column(AmountType; AmountType) { } column(EmptyString; '') { } column(BusUnitColumn_1__Code; BusUnitColumn[1].Code) { } column(BusUnitColumn_2__Code; BusUnitColumn[2].Code) { } column(BusUnitColumn_3__Code; BusUnitColumn[3].Code) { } column(BusUnitColumn_4__Code; BusUnitColumn[4].Code) { } column(ConsolidStartDate; ConsolidStartDate) { } column(ConsolidEndDate; ConsolidEndDate) { } column(NextPageGroupNo; NextPageGroupNo) { } column(PageGroupNo; PageGroupNo) { } column(NewPage; "New Page") { } column(AccountType; Format("Account Type", 0, 2)) { } column(NoBlankLines; "No. of Blank Lines") { } column(G_L_Account_No_; "No.") { } column(Consolidated_Trial_Balance__4_Caption; Consolidated_Trial_Balance__4_CaptionLbl) { } column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl) { } column(Amounts_are_in_whole_1000sCaption; Amounts_are_in_whole_1000sCaptionLbl) { } 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(Amount_1__Amount_2__Amount_3__Amount_4_Caption; Amount_1__Amount_2__Amount_3__Amount_4_CaptionLbl) { } column(EliminationAmountCaption; EliminationAmountCaptionLbl) { } column(Amount_1__Amount_2__Amount_3__Amount_4__EliminationAmountCaption; Amount_1__Amount_2__Amount_3__Amount_4__EliminationAmountCaptionLbl) { } 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(Amount_1_; Amount[1]) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(Amount_2_; Amount[2]) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(Amount_3_; Amount[3]) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(Amount_4_; Amount[4]) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(Amount_1__Amount_2__Amount_3__Amount_4_; Amount[1] + Amount[2] + Amount[3] + Amount[4]) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(EliminationAmount; EliminationAmount) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(Amount_1__Amount_2__Amount_3__Amount_4__EliminationAmount; Amount[1] + Amount[2] + Amount[3] + Amount[4] + EliminationAmount) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(G_L_Account___No___Control30; "G/L Account"."No.") { } column(PADSTR_____G_L_Account__Indentation___2___G_L_Account__Name_Control31; PadStr('', "G/L Account".Indentation * 2) + "G/L Account".Name) { } column(Amount_1__Control32; Amount[1]) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(Amount_2__Control33; Amount[2]) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(Amount_3__Control34; Amount[3]) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(Amount_4__Control35; Amount[4]) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(Amount_1__Amount_2__Amount_3__Amount_4__Control36; Amount[1] + Amount[2] + Amount[3] + Amount[4]) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(EliminationAmount_Control37; EliminationAmount) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(Amount_1__Amount_2__Amount_3__Amount_4__EliminationAmount_Control38; Amount[1] + Amount[2] + Amount[3] + Amount[4] + EliminationAmount) { AutoFormatType = 1; DecimalPlaces = 0 : 0; } column(Integer_Number; Number) { } } trigger OnAfterGetRecord() begin PageGroupNo := NextPageGroupNo; if "New Page" then NextPageGroupNo := PageGroupNo + 1; for i := j downto 1 do begin SetRange("Business Unit Filter", BusUnitColumn[i].Code); if (BusUnitColumn[i]."Starting Date" <> 0D) or (BusUnitColumn[i]."Ending Date" <> 0D) then SetRange("Date Filter", BusUnitColumn[i]."Starting Date", BusUnitColumn[i]."Ending Date") else SetRange("Date Filter", ConsolidStartDate, ConsolidEndDate); if AmountType = AmountType::"Net Change" then begin CalcFields("Net Change"); Amount[i] := "Net Change"; end else begin CalcFields("Balance at Date"); Amount[i] := "Balance at Date"; end; if InThousands then Amount[i] := Amount[i] / 1000; end; SetRange("Date Filter", ConsolidStartDate, ConsolidEndDate); SetRange("Business Unit Filter", ''); if AmountType = AmountType::"Net Change" then begin CalcFields("Net Change"); EliminationAmount := "Net Change"; end else begin CalcFields("Balance at Date"); EliminationAmount := "Balance at Date"; end; if InThousands then EliminationAmount := EliminationAmount / 1000; end; trigger OnPreDataItem() begin PageGroupNo := 1; NextPageGroupNo := 1; if j = 0 then CurrReport.Break(); end; } } requestpage { AboutTitle = 'About Consolidated Trial Balance (4)'; AboutText = 'Offers enhanced visibility into financial performance across companies with breakdowns by company, adjustments, and totals in one report. Use this report when you need a detailed breakdown of consolidation components.'; SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; group("Consolidation Period") { Caption = 'Consolidation Period'; field(ConsolidStartDate; 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(ConsolidEndDate; 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(AmountType; AmountType) { ApplicationArea = Suite; Caption = 'Show'; ToolTip = 'Specifies if the selected value is shown in the 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/ConsolidatedTrialBalance4.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(); if ConsolidStartDate = 0D then Error(Text000); if ConsolidEndDate = 0D then Error(Text001); "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 BusUnitColumn: array[4] of Record "Business Unit"; ConsolidStartDate: Date; ConsolidEndDate: Date; InThousands: Boolean; AmountType: Enum "Analysis Amount Type"; EliminationAmount: Decimal; PeriodText: Text; Amount: array[4] of Decimal; i: Integer; j: Integer; BUFilter: Text; PageGroupNo: Integer; NextPageGroupNo: Integer;#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 'A maximum of %1 consolidating companies can be included in this report.'; Text003: Label 'Period: %1';#pragma warning restore AA0470#pragma warning restore AA0074 Consolidated_Trial_Balance__4_CaptionLbl: Label 'Consolidated Trial Balance (4)'; CurrReport_PAGENOCaptionLbl: Label 'Page'; Amounts_are_in_whole_1000sCaptionLbl: Label 'Amounts are in whole 1000s.'; PADSTR_____G_L_Account__Indentation___2___G_L_Account__NameCaptionLbl: Label 'Name'; Amount_1__Amount_2__Amount_3__Amount_4_CaptionLbl: Label 'Total'; EliminationAmountCaptionLbl: Label 'Eliminations'; Amount_1__Amount_2__Amount_3__Amount_4__EliminationAmountCaptionLbl: Label 'Total Incl. Eliminations'; protected var GLFilter: Text;}