Page 350 G/L Acc. Balance/Budget Lines
src/Layers/W1/BaseApp/Finance/Analysis/GLAccBalanceBudgetLines.Page.al361 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.Analysis;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Budget;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using System.Utilities;/// <summary>/// Displays G/L account balance and budget analysis across periods with comparison capabilities./// Provides period-based analysis of actual vs. budget amounts with percentage variance calculations./// </summary>page 350 "G/L Acc. Balance/Budget Lines"{ Caption = 'Lines'; DeleteAllowed = false; InsertAllowed = false; LinksAllowed = false; PageType = ListPart; SaveValues = true; SourceTable = "G/L Acc. Balance/Budget Buffer"; SourceTableTemporary = true; layout { area(content) { repeater(Control1) { ShowCaption = false; field("Period Start"; Rec."Period Start") { ApplicationArea = Suite; Caption = 'Period Start'; Editable = false; } field("Period Name"; Rec."Period Name") { ApplicationArea = Suite; Caption = 'Period Name'; Editable = false; } field(DebitAmount; Rec."Debit Amount") { ApplicationArea = Suite; AutoFormatType = 1; BlankNumbers = BlankNegAndZero; Caption = 'Actual Debit Amount'; DrillDown = true; Editable = false; trigger OnDrillDown() begin BalanceDrillDown(); end; } field(CreditAmount; Rec."Credit Amount") { ApplicationArea = Suite; AutoFormatType = 1; BlankNumbers = BlankNegAndZero; Caption = 'Actual Credit Amount'; DrillDown = true; Editable = false; trigger OnDrillDown() begin BalanceDrillDown(); end; } field(NetChange; Rec."Net Change") { ApplicationArea = Suite; AutoFormatType = 1; BlankZero = true; Caption = 'Net Change'; DrillDown = true; Editable = false; Visible = false; trigger OnDrillDown() begin BalanceDrillDown(); end; } field(BudgetedDebitAmount; Rec."Budgeted Debit Amount") { ApplicationArea = Suite; AutoFormatType = 1; BlankNumbers = BlankNegAndZero; Caption = 'Budgeted Debit Amount'; DrillDown = true; trigger OnDrillDown() begin BudgetDrillDown(); end; trigger OnValidate() begin SetDateFilter(); GLAcc.Validate("Budgeted Debit Amount"); CalcFormFields(); end; } field(BudgetedCreditAmount; Rec."Budgeted Credit Amount") { ApplicationArea = Suite; AutoFormatType = 1; BlankNumbers = BlankNegAndZero; Caption = 'Budgeted Credit Amount'; DrillDown = true; trigger OnDrillDown() begin BudgetDrillDown(); end; trigger OnValidate() begin SetDateFilter(); GLAcc.Validate("Budgeted Credit Amount"); CalcFormFields(); end; } field(BudgetedAmount; Rec."Budgeted Amount") { ApplicationArea = Suite; AutoFormatType = 1; BlankZero = true; Caption = 'Budgeted Amount'; DrillDown = true; Visible = false; trigger OnDrillDown() begin BudgetDrillDown(); end; trigger OnValidate() begin SetDateFilter(); GLAcc.Validate("Budgeted Amount"); CalcFormFields(); end; } field(BudgetPct; Rec."Balance/Budget Pct.") { ApplicationArea = Suite; BlankZero = true; Caption = 'Balance/Budget (%)'; DecimalPlaces = 1 : 1; Editable = false; } } } } actions { } trigger OnAfterGetRecord() begin if DateRec.Get(Rec."Period Type", Rec."Period Start") then; SetDateFilter(); CalcFormFields(); end; trigger OnFindRecord(Which: Text) FoundDate: Boolean var VariantRec: Variant; begin VariantRec := Rec; FoundDate := PeriodFormLinesMgt.FindDate(VariantRec, DateRec, Which, PeriodType.AsInteger()); Rec := VariantRec; end; trigger OnNextRecord(Steps: Integer) ResultSteps: Integer var VariantRec: Variant; begin VariantRec := Rec; ResultSteps := PeriodFormLinesMgt.NextDate(VariantRec, DateRec, Steps, PeriodType.AsInteger()); Rec := VariantRec; end; trigger OnOpenPage() begin Rec.Reset(); end; var AccountingPeriod: Record "Accounting Period"; DateRec: Record Date; PeriodFormLinesMgt: Codeunit "Period Form Lines Mgt."; protected var GLAcc: Record "G/L Account"; ClosingEntryFilter: Option Include,Exclude; PeriodType: Enum "Analysis Period Type"; AmountType: Enum "Analysis Amount Type"; /// <summary> /// Configures the page with G/L account data and analysis parameters for period-based comparison. /// </summary> /// <param name="NewGLAcc">G/L account record containing the accounts to analyze</param> /// <param name="NewPeriodType">Period type for analysis breakdown (Day, Week, Month, Quarter, Year)</param> /// <param name="NewAmountType">Amount type for balance calculation (Net Change, Balance at Date)</param> /// <param name="NewClosingEntryFilter">Whether to include or exclude closing entries in analysis</param> procedure SetLines(var NewGLAcc: Record "G/L Account"; NewPeriodType: Enum "Analysis Period Type"; NewAmountType: Enum "Analysis Amount Type"; NewClosingEntryFilter: Option Include,Exclude) begin GLAcc.Copy(NewGLAcc); Rec.DeleteAll(); if GLAcc.GetFilter("Date Filter") <> '' then begin Rec.FilterGroup(2); Rec.SetFilter("Period Start", GLAcc.GetFilter("Date Filter")); Rec.FilterGroup(0); DateRec.FilterGroup(2); DateRec.SetFilter("Period Start", GLAcc.GetFilter("Date Filter")); DateRec.FilterGroup(0); end; PeriodType := NewPeriodType; AmountType := NewAmountType; ClosingEntryFilter := NewClosingEntryFilter; CurrPage.Update(false); end; local procedure BalanceDrillDown() var GLEntry: Record "G/L Entry"; begin SetDateFilter(); GLEntry.Reset(); GLEntry.SetCurrentKey("G/L Account No.", "Posting Date"); GLEntry.SetRange("G/L Account No.", GLAcc."No."); if GLAcc.Totaling <> '' then GLEntry.SetFilter("G/L Account No.", GLAcc.Totaling); GLEntry.SetFilter("Posting Date", GLAcc.GetFilter("Date Filter")); GLEntry.SetFilter("Global Dimension 1 Code", GLAcc.GetFilter("Global Dimension 1 Filter")); GLEntry.SetFilter("Global Dimension 2 Code", GLAcc.GetFilter("Global Dimension 2 Filter")); GLEntry.SetFilter("Business Unit Code", GLAcc.GetFilter("Business Unit Filter")); OnBalanceDrillDownOnAfterSetFilters(GLEntry, GLAcc); PAGE.Run(0, GLEntry); end; local procedure BudgetDrillDown() var GLBudgetEntry: Record "G/L Budget Entry"; begin SetDateFilter(); GLBudgetEntry.Reset(); GLBudgetEntry.SetCurrentKey("Budget Name", "G/L Account No.", Date); GLBudgetEntry.SetFilter("Budget Name", GLAcc.GetFilter("Budget Filter")); GLBudgetEntry.SetRange("G/L Account No.", GLAcc."No."); if GLAcc.Totaling <> '' then GLBudgetEntry.SetFilter("G/L Account No.", GLAcc.Totaling); GLBudgetEntry.SetFilter(Date, GLAcc.GetFilter("Date Filter")); GLBudgetEntry.SetFilter("Global Dimension 1 Code", GLAcc.GetFilter("Global Dimension 1 Filter")); GLBudgetEntry.SetFilter("Global Dimension 2 Code", GLAcc.GetFilter("Global Dimension 2 Filter")); GLBudgetEntry.SetFilter("Business Unit Code", GLAcc.GetFilter("Business Unit Filter")); OnBudgetDrillDownOnAfterSetFilters(GLBudgetEntry, GLAcc); PAGE.Run(0, GLBudgetEntry); end; local procedure SetDateFilter() begin if AmountType = AmountType::"Net Change" then GLAcc.SetRange("Date Filter", Rec."Period Start", Rec."Period End") else GLAcc.SetRange("Date Filter", 0D, Rec."Period End"); if ClosingEntryFilter = ClosingEntryFilter::Exclude then begin AccountingPeriod.SetCurrentKey("New Fiscal Year"); AccountingPeriod.SetRange("New Fiscal Year", true); if GLAcc.GetRangeMin("Date Filter") = 0D then AccountingPeriod.SetRange("Starting Date", 0D, GLAcc.GetRangeMax("Date Filter")) else AccountingPeriod.SetRange( "Starting Date", GLAcc.GetRangeMin("Date Filter") + 1, GLAcc.GetRangeMax("Date Filter")); if AccountingPeriod.Find('-') then repeat GLAcc.SetFilter( "Date Filter", GLAcc.GetFilter("Date Filter") + '&<>%1', ClosingDate(AccountingPeriod."Starting Date" - 1)); until AccountingPeriod.Next() = 0; end else GLAcc.SetRange( "Date Filter", GLAcc.GetRangeMin("Date Filter"), ClosingDate(GLAcc.GetRangeMax("Date Filter"))); end; local procedure CalcFormFields() begin GLAcc.CalcFields("Net Change", "Debit Amount", "Credit Amount", "Budgeted Amount"); Rec."Debit Amount" := GLAcc."Debit Amount"; Rec."Credit Amount" := GLAcc."Credit Amount"; Rec."Net Change" := GLAcc."Net Change"; Rec."Budgeted Debit Amount" := GLAcc."Budgeted Amount"; Rec."Budgeted Credit Amount" := -GLAcc."Budgeted Amount"; Rec."Budgeted Amount" := GLAcc."Budgeted Amount"; if GLAcc."Budgeted Amount" = 0 then Rec."Balance/Budget Pct." := 0 else Rec."Balance/Budget Pct." := Round(GLAcc."Net Change" / GLAcc."Budgeted Amount" * 100); OnAfterCalcFormFields(GLAcc, Rec."Balance/Budget Pct.", Rec, ClosingEntryFilter); end; /// <summary> /// Returns the current G/L account filter configuration used by the page. /// </summary> /// <param name="NewGLAcc">G/L account record to populate with current filter settings</param> procedure GetGLAcc(var NewGLAcc: Record "G/L Account") begin NewGLAcc.Copy(GLAcc); end; /// <summary> /// Integration event for custom calculation logic after computing form field values and budget percentages. /// </summary> /// <param name="GLAccount">G/L account being analyzed</param> /// <param name="BudgetPct">Budget percentage calculation result</param> /// <param name="GLAccBalanceBudgetBuffer">Balance/budget buffer record with calculated values</param> /// <param name="ClosingEntryFilter">Closing entry filter setting (Include or Exclude)</param> [IntegrationEvent(false, false)] local procedure OnAfterCalcFormFields(var GLAccount: Record "G/L Account"; var BudgetPct: Decimal; var GLAccBalanceBudgetBuffer: Record "G/L Acc. Balance/Budget Buffer"; ClosingEntryFilter: Option Include,Exclude) begin end; /// <summary> /// Integration event for custom filter logic when drilling down to G/L entries from balance analysis. /// </summary> /// <param name="GLEntry">G/L entry record for drill-down filtering</param> /// <param name="GLAccount">G/L account context for filter application</param> [IntegrationEvent(true, false)] local procedure OnBalanceDrillDownOnAfterSetFilters(var GLEntry: Record "G/L Entry"; GLAccount: Record "G/L Account") begin end; /// <summary> /// Integration event for custom filter logic when drilling down to G/L budget entries from budget analysis. /// </summary> /// <param name="GLBudgetEntry">G/L budget entry record for drill-down filtering</param> /// <param name="GLAccount">G/L account context for filter application</param> [IntegrationEvent(false, false)] local procedure OnBudgetDrillDownOnAfterSetFilters(var GLBudgetEntry: Record "G/L Budget Entry"; GLAccount: Record "G/L Account") begin end;}