Report 10 Closing Trial Balance

Base Application, Microsoft.Finance.GeneralLedger.Reports

src/Layers/W1/BaseApp/Finance/GeneralLedger/Reports/ClosingTrialBalance.Report.al255 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.Setup;using Microsoft.Foundation.Period;using System.Utilities;/// <summary>/// Generates closing trial balance for fiscal year-end procedures and audit requirements./// Displays account balances as of fiscal year end with options for additional currency amounts and closing period analysis./// </summary>/// <remarks>/// Data source: G/L Account table with fiscal year-end date filtering and balance calculations./// Supports additional currency display option and comprehensive dimension filtering./// Used primarily for year-end closing procedures, audit trail documentation, and regulatory reporting requirements./// </remarks>report 10 "Closing Trial Balance"{    AdditionalSearchTerms = 'year closing balance,close accounting period balance,close fiscal year balance';    ApplicationArea = Basic, Suite;    Caption = 'Closing Trial Balance';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("G/L Account"; "G/L Account")        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.", "Account Type", "Global Dimension 1 Filter", "Global Dimension 2 Filter";            column(PeriodText; StrSubstNo(Text001, PeriodText))            {            }            column(CompanyName; COMPANYPROPERTY.DisplayName())            {            }            column(GLAccGLFilter; TableCaption + ': ' + GLFilter)            {            }            column(GLFilter; GLFilter)            {            }            column(UseAmtsInAddCurr; UseAmtsInAddCurr)            {            }            column(AllAmountsIn; AllAmountsInLbl)            {            }            column(LCYcode; GLSetup."LCY Code")            {            }            column(AddreportingCurrency; GLSetup."Additional Reporting Currency")            {            }            dataitem("Integer"; "Integer")            {                DataItemTableView = sorting(Number) where(Number = const(1));                column(No_GLAccount; "G/L Account"."No.")                {                    IncludeCaption = true;                }                column(GLAccName; PadStr('', "G/L Account".Indentation * 2) + "G/L Account".Name)                {                }                column(FiscalYearBalance; FiscalYearBalance)                {                    AutoFormatExpression = GetCurrency();                    AutoFormatType = 1;                }                column(NegFiscalYearBalance; -FiscalYearBalance)                {                    AutoFormatExpression = GetCurrency();                    AutoFormatType = 1;                }                column(LastYearBalance; LastYearBalance)                {                    AutoFormatExpression = GetCurrency();                    AutoFormatType = 1;                }                column(NegLastYearBalance; -LastYearBalance)                {                    AutoFormatExpression = GetCurrency();                    AutoFormatType = 1;                }                column(NoBlankLines_GLAccount; "G/L Account"."No. of Blank Lines")                {                }                column(AccountType_GLAccount; "G/L Account"."Account Type")                {                }                column(AccountTypePosting; GLAccountTypePosting)                {                }                column(PageGroupNo; PageGroupNo)                {                }            }            trigger OnAfterGetRecord()            begin                PageGroupNo := NextPageGroupNo;                if "New Page" then                    NextPageGroupNo := PageGroupNo + 1;                if "Income/Balance" = "Income/Balance"::"Income Statement" then                    SetRange("Date Filter", FiscalYearStartDate, FiscalYearEndDate)                else                    SetRange("Date Filter", 0D, ClosingDate(FiscalYearEndDate));                CalcFields("Net Change", "Additional-Currency Net Change");                if UseAmtsInAddCurr then                    FiscalYearBalance := "Additional-Currency Net Change"                else                    FiscalYearBalance := "Net Change";                if "Income/Balance" = "Income/Balance"::"Income Statement" then                    SetRange("Date Filter", 0D, FiscalYearStartDate - 1)                else                    SetRange("Date Filter", 0D, ClosingDate(FiscalYearStartDate - 1));                CalcFields("Net Change", "Additional-Currency Net Change");                if UseAmtsInAddCurr then                    LastYearBalance := "Additional-Currency Net Change"                else                    LastYearBalance := "Net Change";                GLAccountTypePosting := "Account Type" = "Account Type"::Posting;            end;            trigger OnPreDataItem()            begin                PageGroupNo := 1;                NextPageGroupNo := 1;                GLSetup.Get();            end;        }    }    requestpage    {        SaveValues = true;        AboutTitle = 'About Closing Trial Balance';        AboutText = 'Report and verify your end of financial year figures, excluding closing entries, comparing this year to the previous year.';        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(StartingDate; FiscalYearStartDate)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Fiscal Year Starting Date';                        ToolTip = 'Specifies the last date in the closed trial balance. This date is used to determine the closing date.';                    }                    field(AmtsInAddCurr; UseAmtsInAddCurr)                    {                        ApplicationArea = Suite;                        Caption = 'Show Amounts in Add. Reporting Currency';                        MultiLine = true;                        ToolTip = 'Specifies if the reported amounts are shown in the additional reporting currency.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Finance/GeneralLedger/Reports/ClosingTrialBalance.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {        ClosingTrialBalanceCaption = 'Closing Trial Balance';        PageNoCaption = 'Page';        ThisYearCaption = 'This Year';        LastYearCaption = 'Last Year';        NameCaption = 'Name';        DebitCaption = 'Debit';        CreditCaption = 'Credit';    }    trigger OnPreReport()    begin        GLFilter := "G/L Account".GetFilters();        if FiscalYearStartDate = 0D then            Error(Text000);        AccountingPeriod.SetRange("New Fiscal Year", true);        AccountingPeriod."Starting Date" := FiscalYearStartDate;        AccountingPeriod.Find();        AccountingPeriod.Next(1);        FiscalYearEndDate := AccountingPeriod."Starting Date" - 1;        "G/L Account".SetRange("Date Filter", FiscalYearStartDate, FiscalYearEndDate);        PeriodText := "G/L Account".GetFilter("Date Filter");    end;    var        AccountingPeriod: Record "Accounting Period";        GLSetup: Record "General Ledger Setup";        FiscalYearStartDate: Date;        FiscalYearEndDate: Date;        PeriodText: Text;        GLFilter: Text;        FiscalYearBalance: Decimal;        LastYearBalance: Decimal;        UseAmtsInAddCurr: Boolean;        PageGroupNo: Integer;        NextPageGroupNo: Integer;        AllAmountsInLbl: Label 'All amounts are in';        GLAccountTypePosting: Boolean;#pragma warning disable AA0074        Text000: Label 'Enter the starting date for the fiscal year.';#pragma warning disable AA0470        Text001: Label 'Period: %1';#pragma warning restore AA0470#pragma warning restore AA0074    local procedure GetCurrency(): Code[10]    begin        if UseAmtsInAddCurr then            exit(GLSetup."Additional Reporting Currency");        exit('');    end;    /// <summary>    /// Initializes report parameters for programmatic execution with fiscal year and currency options.    /// Sets fiscal year starting date and additional currency display option for automated closing trial balance generation.    /// </summary>    /// <param name="NewFiscalYearStartDate">Starting date of fiscal year for closing balance calculation</param>    /// <param name="NewUseAmtsInAddCurr">Whether to display amounts in additional reporting currency</param>    procedure InitializeRequest(NewFiscalYearStartDate: Date; NewUseAmtsInAddCurr: Boolean)    begin        FiscalYearStartDate := NewFiscalYearStartDate;        UseAmtsInAddCurr := NewUseAmtsInAddCurr;    end;}