Page 1393 Trial Balance

Base Application, Microsoft.Finance.FinancialReports

src/Layers/W1/BaseApp/Finance/FinancialReports/TrialBalance.Page.al647 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.FinancialReports;using Microsoft.Foundation.Period;using System.Environment;/// <summary>/// Provides interactive trial balance interface with period-based analysis and drill-down capabilities./// Displays general ledger account balances with period-over-period comparison and trend analysis./// </summary>/// <remarks>/// Card part page designed for embedding in trial balance analysis forms. Supports configurable/// period types, interactive drilling into account details, and balance verification workflows./// Integrates with general ledger posting for real-time balance updates and reconciliation./// </remarks>page 1393 "Trial Balance"{    Caption = 'Trial Balance';    LinksAllowed = false;    PageType = CardPart;    SaveValues = true;    layout    {        area(content)        {            grid(Control234)            {                ShowCaption = false;                group(Control3)                {                    ShowCaption = false;                    Visible = IsError;                    field(GETLASTERRORTEXT; GetLastErrorText)                    {                        ApplicationArea = All;                        ShowCaption = false;                    }                }            }            grid(Control45)            {                Editable = false;                GridLayout = Columns;                ShowCaption = false;                group(Control44)                {                    ShowCaption = false;                    Visible = not IsError;                    field(DescriptionCap; DescriptionCap)                    {                        ApplicationArea = Basic, Suite;                        ShowCaption = false;                        Style = StrongAccent;                        StyleExpr = true;                    }                    field(Description1; Descriptions[1])                    {                        ApplicationArea = Basic, Suite;                        ShowCaption = false;                    }                    field(Description2; Descriptions[2])                    {                        ApplicationArea = Basic, Suite;                        ShowCaption = false;                    }                    field(Description3; Descriptions[3])                    {                        ApplicationArea = Basic, Suite;                        ShowCaption = false;                    }                    field(Description4; Descriptions[4])                    {                        ApplicationArea = Basic, Suite;                        ShowCaption = false;                        Style = Strong;                        StyleExpr = true;                    }                    field(Description5; Descriptions[5])                    {                        ApplicationArea = Basic, Suite;                        ShowCaption = false;                    }                    field(Description6; Descriptions[6])                    {                        ApplicationArea = Basic, Suite;                        ShowCaption = false;                    }                    field(Description7; Descriptions[7])                    {                        ApplicationArea = Basic, Suite;                        ShowCaption = false;                        Style = Strong;                        StyleExpr = true;                    }                    field(Description8; Descriptions[8])                    {                        ApplicationArea = Basic, Suite;                        ShowCaption = false;                        StyleExpr = true;                    }                    field(Description9; Descriptions[9])                    {                        ApplicationArea = Basic, Suite;                        ShowCaption = false;                        Style = Strong;                        StyleExpr = true;                    }                }                group(Control33)                {                    ShowCaption = false;                    Visible = not IsError;                    field("PeriodCaptionTxt[1]"; PeriodCaptionTxt[1])                    {                        ApplicationArea = Basic, Suite;                        ShowCaption = false;                        Style = StrongAccent;                        StyleExpr = true;                    }                    field(CurrentPeriodValues1; Values[1, 1])                    {                        ApplicationArea = Basic, Suite;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[1], PeriodCaptionTxt[1]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(1, 1);                        end;                    }                    field(CurrentPeriodValues2; Values[2, 1])                    {                        ApplicationArea = Basic, Suite;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[2], PeriodCaptionTxt[1]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(2, 1);                        end;                    }                    field(CurrentPeriodValues3; Values[3, 1])                    {                        ApplicationArea = Basic, Suite;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[3], PeriodCaptionTxt[1]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(3, 1);                        end;                    }                    field(CurrentPeriodValues4; Values[4, 1])                    {                        ApplicationArea = Basic, Suite;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[4], PeriodCaptionTxt[1]);                        ShowCaption = false;                        StyleExpr = GrossMarginPct1;                        trigger OnDrillDown()                        begin                            DrillDown(4, 1);                        end;                    }                    field(CurrentPeriodValues5; Values[5, 1])                    {                        ApplicationArea = Basic, Suite;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[5], PeriodCaptionTxt[1]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(5, 1);                        end;                    }                    field(CurrentPeriodValues6; Values[6, 1])                    {                        ApplicationArea = Basic, Suite;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[6], PeriodCaptionTxt[1]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(6, 1);                        end;                    }                    field(CurrentPeriodValues7; Values[7, 1])                    {                        ApplicationArea = Basic, Suite;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[7], PeriodCaptionTxt[1]);                        ShowCaption = false;                        StyleExpr = OperatingMarginPct1;                        trigger OnDrillDown()                        begin                            DrillDown(7, 1);                        end;                    }                    field(CurrentPeriodValues8; Values[8, 1])                    {                        ApplicationArea = Basic, Suite;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[8], PeriodCaptionTxt[1]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(8, 1);                        end;                    }                    field(CurrentPeriodValues9; Values[9, 1])                    {                        ApplicationArea = Basic, Suite;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[9], PeriodCaptionTxt[1]);                        ShowCaption = false;                        StyleExpr = IncomeBeforeInterestAndTax1;                        trigger OnDrillDown()                        begin                            DrillDown(9, 1);                        end;                    }                }                group(Control22)                {                    ShowCaption = false;                    Visible = PeriodVisible and (not IsError);                    field("PeriodCaptionTxt[2]"; PeriodCaptionTxt[2])                    {                        ApplicationArea = All;                        ShowCaption = false;                        Style = StrongAccent;                        StyleExpr = true;                    }                    field(CurrentPeriodMinusOneValues1; Values[1, 2])                    {                        ApplicationArea = All;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[1], PeriodCaptionTxt[2]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(1, 2);                        end;                    }                    field(CurrentPeriodMinusOneValues2; Values[2, 2])                    {                        ApplicationArea = All;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[2], PeriodCaptionTxt[2]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(2, 2)                        end;                    }                    field(CurrentPeriodMinusOneValues3; Values[3, 2])                    {                        ApplicationArea = All;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[3], PeriodCaptionTxt[2]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(3, 2);                        end;                    }                    field(CurrentPeriodMinusOneValues4; Values[4, 2])                    {                        ApplicationArea = All;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[4], PeriodCaptionTxt[2]);                        ShowCaption = false;                        StyleExpr = GrossMarginPct2;                        trigger OnDrillDown()                        begin                            DrillDown(4, 2);                        end;                    }                    field(CurrentPeriodMinusOneValues5; Values[5, 2])                    {                        ApplicationArea = All;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[5], PeriodCaptionTxt[2]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(5, 2);                        end;                    }                    field(CurrentPeriodMinusOneValues6; Values[6, 2])                    {                        ApplicationArea = All;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[6], PeriodCaptionTxt[2]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(6, 2);                        end;                    }                    field(CurrentPeriodMinusOneValues7; Values[7, 2])                    {                        ApplicationArea = All;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[7], PeriodCaptionTxt[2]);                        ShowCaption = false;                        StyleExpr = OperatingMarginPct2;                        trigger OnDrillDown()                        begin                            DrillDown(7, 2);                        end;                    }                    field(CurrentPeriodMinusOneValues8; Values[8, 2])                    {                        ApplicationArea = All;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[8], PeriodCaptionTxt[2]);                        ShowCaption = false;                        trigger OnDrillDown()                        begin                            DrillDown(8, 2);                        end;                    }                    field(CurrentPeriodMinusOneValues9; Values[9, 2])                    {                        ApplicationArea = All;                        AutoFormatType = 2;                        AutoFormatExpression = '';                        BlankZero = true;                        CaptionClass = GetCaptionForDrillDownTooltip(Descriptions[9], PeriodCaptionTxt[2]);                        ShowCaption = false;                        StyleExpr = IncomeBeforeInterestAndTax2;                        trigger OnDrillDown()                        begin                            DrillDown(9, 2);                        end;                    }                }            }        }    }    actions    {        area(processing)        {            action(PreviousPeriod)            {                ApplicationArea = Basic, Suite;                Caption = 'Previous Period';                Image = PreviousRecord;                ToolTip = 'Show the information based on the previous period. If you set the View by field to Day, the date filter changes to the day before.';                Visible = not IsError;                trigger OnAction()                begin                    if LoadedFromCache then begin                        TrialBalanceMgt.LoadData(Descriptions, Values, PeriodCaptionTxt, NoOfColumns);                        LoadedFromCache := false;                    end;                    TrialBalanceMgt.PreviousPeriod(Descriptions, Values, PeriodCaptionTxt, NoOfColumns);                    SetStyles();                    CurrPage.Update();                end;            }            action(NextPeriod)            {                ApplicationArea = Basic, Suite;                Caption = 'Next Period';                Image = NextRecord;                ToolTip = 'Show the information based on the next period. If you set the View by field to Day, the date filter changes to the day before.';                Visible = not IsError;                trigger OnAction()                begin                    if LoadedFromCache then begin                        TrialBalanceMgt.LoadData(Descriptions, Values, PeriodCaptionTxt, NoOfColumns);                        LoadedFromCache := false;                    end;                    TrialBalanceMgt.NextPeriod(Descriptions, Values, PeriodCaptionTxt, NoOfColumns);                    SetStyles();                    CurrPage.Update();                end;            }            action(Setup)            {                ApplicationArea = Basic, Suite;                Image = Setup;                trigger OnAction()                var                    TrialBalanceSetup: Page "Trial Balance Setup";                begin                    if TrialBalanceSetup.RunModal() <> Action::Cancel then begin                        IsError := false;                        LoadTrialBalanceData(false);                        CurrPage.Update();                    end;                end;            }            action(Information)            {                ApplicationArea = Basic, Suite;                Caption = 'Chart Information';                Image = AboutNav;                ToolTip = 'View a description of the chart.';                trigger OnAction()                var                    ChartInfo: Text;                begin                    if PeriodVisible then                        ChartInfo := StrSubstNo(InstructionMsg, PeriodsMsg)                    else                        ChartInfo := StrSubstNo(InstructionMsg, '');                    Message(ChartInfo);                end;            }        }    }    trigger OnInit()    var        AccountingPeriod: Record "Accounting Period";    begin        PeriodVisible := true;        NoOfColumns := 2;        if (ClientTypeManagement.GetCurrentClientType() = ClientType::Phone) or AccountingPeriod.IsEmpty() then begin            NoOfColumns := 1;            PeriodVisible := false;        end;    end;    trigger OnOpenPage()    begin        LoadTrialBalanceData(true);    end;    var        TrialBalanceMgt: Codeunit "Trial Balance Mgt.";        ClientTypeManagement: Codeunit "Client Type Management";        TrialBalanceCacheMgt: Codeunit "Trial Balance Cache Mgt.";        Descriptions: array[9] of Text[80];        Values: array[9, 2] of Decimal;        PeriodCaptionTxt: array[2] of Text;        GrossMarginPct1: Text;        GrossMarginPct2: Text;        OperatingMarginPct1: Text;        OperatingMarginPct2: Text;        IncomeBeforeInterestAndTax1: Text;        IncomeBeforeInterestAndTax2: Text;#pragma warning disable AA0074        DescriptionCap: Label 'Description';#pragma warning restore AA0074        PeriodVisible: Boolean;        InstructionMsg: Label 'This chart provides a quick overview of the financial performance of your company%1. The chart is a simplified version of the G/L Trial Balance chart. The Total Revenue figure corresponds to the total in your chart of accounts.', Comment = '%1=message about the number of periods displayed, if not running on phone client';        PeriodsMsg: Label ', displayed in two periods';        TrialBalanceTelemetryCategoryTok: Label 'Trial Balance', Locked = true;        PBTSuccessTelemetryMsg: Label 'Page Background Task successfully calculated values and saved to cache.', Locked = true;        PBTFailed1TelemetryMsg: Label 'Page Background Task failed. Task scheduled to update values.', Locked = true;        NoOfColumns: Integer;        IsError: Boolean;        LoadedFromCache: Boolean;        BackgroundTaskId: Integer;    local procedure SetStyles()    begin        SetRedForNegativeBoldForPositiveStyle(4, 1, GrossMarginPct1);        SetRedForNegativeBoldForPositiveStyle(4, 2, GrossMarginPct2);        SetRedForNegativeBoldForPositiveStyle(7, 1, OperatingMarginPct1);        SetRedForNegativeBoldForPositiveStyle(7, 2, OperatingMarginPct2);        SetRedForNegativeBoldForPositiveStyle(9, 1, IncomeBeforeInterestAndTax1);        SetRedForNegativeBoldForPositiveStyle(9, 2, IncomeBeforeInterestAndTax2);    end;    local procedure SetRedForNegativeBoldForPositiveStyle(RowNo: Integer; ColumnNo: Integer; var StyleText: Text)    begin        if Values[RowNo, ColumnNo] < 0 then            StyleText := 'Unfavorable'        else            StyleText := 'Strong';    end;    local procedure GetCaptionForDrillDownTooltip(Description: Text; DatePeriod: Text): Text    begin        exit('3,' + StrSubstNo('%1 (%2)', Description, DatePeriod));    end;    [TryFunction]    local procedure TryLoadTrialBalanceData(UsePBT: Boolean; var DataLoaded: Boolean)    begin        if UsePBT and (NoOfColumns <> 1) then begin            SchedulePBT();            DataLoaded := false;        end else begin            TrialBalanceMgt.LoadData(Descriptions, Values, PeriodCaptionTxt, NoOfColumns);            DataLoaded := true;        end;    end;    local procedure SchedulePBT()    var        CalculateTrialBalance: Codeunit "Calculate Trial Balance";        Input: Dictionary of [Text, Text];        TimeoutinMs: Integer;    begin        TimeoutinMs := 2000; // Default timeout;        Clear(Input);        Input.Add(CalculateTrialBalance.GetNoOfColumnsLabel(), Format(NoOfColumns));        CurrPage.EnqueueBackgroundTask(BackgroundTaskId, Codeunit::"Calculate Trial Balance", Input, TimeoutInMs);    end;    trigger OnPageBackgroundTaskCompleted(TaskId: Integer; Results: Dictionary of [Text, Text])    var        CalculateTrialBalance: Codeunit "Calculate Trial Balance";    begin        // As PBT runs synchronously when running in test, the task is called even before PBTList is updated.        // So, we use (TaskIdCalculateCue = TaskId) to check if the task is the one we are interested in.        if BackgroundTaskId = TaskId then begin            CalculateTrialBalance.TransformDictionaryToValues(Descriptions, Values, PeriodCaptionTxt, NoOfColumns, Results);            TrialBalanceCacheMgt.SaveToCache(Descriptions, Values, PeriodCaptionTxt);            LoadedFromCache := true;            IsError := false;            SetStyles();            Session.LogMessage('0000ODU', PBTSuccessTelemetryMsg, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', TrialBalanceTelemetryCategoryTok);        end    end;    trigger OnPageBackgroundTaskError(TaskId: Integer; ErrorCode: Text; ErrorText: Text; ErrorCallStack: Text; var IsHandled: Boolean)    var        ScheduledTask: Record "Scheduled Task";        DataLoaded: Boolean;    begin        if BackgroundTaskId = TaskId then            if not TaskScheduler.CanCreateTask() then begin // Users like Team Members and Delegated Admins cannot create tasks                if TryLoadTrialBalanceData(false, DataLoaded) then                    if DataLoaded then                        TrialBalanceCacheMgt.SaveToCache(Descriptions, Values, PeriodCaptionTxt);            end else begin                ScheduledTask.SetRange("Run Codeunit", Codeunit::"Calculate Trial Balance");                ScheduledTask.SetRange(Company, CompanyName());                ScheduledTask.SetRange("Is Ready", true);                if ScheduledTask.IsEmpty() then begin                    TaskScheduler.CreateTask(Codeunit::"Calculate Trial Balance", 0, true, CompanyName(), CurrentDateTime());                    Session.LogMessage('0000ODV', PBTFailed1TelemetryMsg, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', TrialBalanceTelemetryCategoryTok);                end;            end;        IsHandled := true;    end;    local procedure LoadTrialBalanceData(LoadFromCache: Boolean)    var        DataLoaded: Boolean;    begin        if not TrialBalanceMgt.SetupIsInPlace() then            exit;        if LoadFromCache then            if (not TrialBalanceCacheMgt.IsCacheStale()) and (NoOfColumns <> 1) then begin                DataLoaded := TrialBalanceCacheMgt.LoadFromCache(Descriptions, Values, PeriodCaptionTxt);                LoadedFromCache := true;            end;        if not DataLoaded then begin            if not TryLoadTrialBalanceData(LoadFromCache, DataLoaded) then // LoadFromCache is true when called from OnOpenPage                IsError := true;            if not IsError and DataLoaded and (NoOfColumns <> 1) then                TrialBalanceCacheMgt.SaveToCache(Descriptions, Values, PeriodCaptionTxt);        end;        if DataLoaded then            SetStyles();    end;    local procedure DrillDown(RowNo: Integer; ColumnNo: Integer)    begin        if LoadedFromCache then begin            TrialBalanceMgt.LoadData(Descriptions, Values, PeriodCaptionTxt, NoOfColumns);            LoadedFromCache := false;        end;        TrialBalanceMgt.DrillDown(RowNo, ColumnNo);    end;}