Page 422 G/L Balance/Budget
- App
- Base Application
- Namespace
- Microsoft.Finance.Analysis
- Versions
- 17-28
- Source table
- 15
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/Finance/Analysis/GLBalanceBudget.Page.al799 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.Dimension;
using Microsoft.Finance.GeneralLedger.Account;
using Microsoft.Finance.GeneralLedger.Budget;
using Microsoft.Finance.GeneralLedger.Ledger;
using Microsoft.Finance.GeneralLedger.Setup;
using Microsoft.Foundation.Comment;
using Microsoft.Foundation.Enums;
using Microsoft.Foundation.ExtendedText;
using Microsoft.Foundation.Period;
using System.Text;
using System.Utilities;
/// <summary>
/// Matrix worksheet for comparing G/L account balances with budget amounts across time periods.
/// Provides budget variance analysis with period-based columns and flexible filtering options.
/// </summary>
page 422 "G/L Balance/Budget"
{
Caption = 'G/L Balance/Budget';
PageType = Worksheet;
SaveValues = true;
SourceTable = "G/L Account";
layout
{
area(content)
{
group(Options)
{
Caption = 'Options';
field(ClosingEntryFilter; ClosingEntryFilter)
{
ApplicationArea = Suite;
Caption = 'Closing Entries';
OptionCaption = 'Include,Exclude';
ToolTip = 'Specifies whether the balance shown will include closing entries. If you want to see the amounts on income statement accounts in closed years, you must exclude closing entries.';
trigger OnValidate()
begin
FindPeriod('');
ClosingEntryFilterOnAfterValid();
end;
}
field(PeriodType; PeriodType)
{
ApplicationArea = Suite;
Caption = 'View by';
ToolTip = 'Specifies by which period amounts are displayed.';
trigger OnValidate()
begin
OnBeforeValidatePeriodType(PeriodType);
if PeriodType = PeriodType::"Accounting Period" then
AccountingPerioPeriodTypeOnVal();
if PeriodType = PeriodType::Year then
YearPeriodTypeOnValidate();
if PeriodType = PeriodType::Quarter then
QuarterPeriodTypeOnValidate();
if PeriodType = PeriodType::Month then
MonthPeriodTypeOnValidate();
if PeriodType = PeriodType::Week then
WeekPeriodTypeOnValidate();
if PeriodType = PeriodType::Day then
DayPeriodTypeOnValidate();
end;
}
field(AmountType; AmountType)
{
ApplicationArea = Suite;
Caption = 'View as';
ToolTip = 'Specifies how amounts are displayed. Net Change: The net change in the balance for the selected period. Balance at Date: The balance as of the last day in the selected period.';
trigger OnValidate()
begin
if AmountType = AmountType::"Balance at Date" then
BalanceatDateAmountTypeOnValid();
if AmountType = AmountType::"Net Change" then
NetChangeAmountTypeOnValidate();
end;
}
field(DateFilter; DateFilter)
{
ApplicationArea = Suite;
Caption = 'Date Filter';
ToolTip = 'Specifies the dates that will be used to filter the amounts in the window.';
trigger OnValidate()
var
FilterTokens: Codeunit "Filter Tokens";
DateFilter2: Text;
begin
if DateFilter = '' then
Rec.SetRange("Date Filter")
else begin
DateFilter2 := DateFilter;
FilterTokens.MakeDateFilter(DateFilter2);
DateFilter := CopyStr(DateFilter2, 1, MaxStrLen(DateFilter));
Rec.SetFilter("Date Filter", DateFilter);
end;
CurrPage.Update();
end;
}
field(GLAccFilter; GLAccFilter)
{
ApplicationArea = Suite;
Caption = 'G/L Account Filter';
ToolTip = 'Specifies the G/L accounts for which you will see information in the window.';
trigger OnLookup(var Text: Text): Boolean
var
GLAccList: Page "G/L Account List";
begin
GLAccList.LookupMode(true);
if not (GLAccList.RunModal() = ACTION::LookupOK) then
exit(false);
Text := GLAccList.GetSelectionFilter();
exit(true);
end;
trigger OnValidate()
begin
if GLAccFilter = '' then
Rec.SetRange("No.")
else
Rec.SetFilter("No.", GLAccFilter);
CurrPage.Update();
end;
}
field(GLAccCategory; GLAccCategoryFilter)
{
ApplicationArea = Suite;
Caption = 'G/L Account Category Filter';
ToolTip = 'Specifies the category of the G/L account for which you will see information in the window.';
trigger OnValidate()
begin
if GLAccCategoryFilter = GLAccCategoryFilter::" " then
Rec.SetRange("Account Category")
else
Rec.SetRange("Account Category", GLAccCategoryFilter);
CurrPage.Update();
end;
}
field(IncomeBalGLAccFilter; IncomeBalanceGLAccFilter)
{
ApplicationArea = Suite;
Caption = 'Income/Balance G/L Account Filter';
OptionCaption = ' ,Income Statement,Balance Sheet';
ToolTip = 'Specifies the type of the G/L account for which you will see information in the window.';
trigger OnValidate()
begin
case IncomeBalanceGLAccFilter of
IncomeBalanceGLAccFilter::" ":
Rec.SetRange("Income/Balance");
IncomeBalanceGLAccFilter::"Balance Sheet":
Rec.SetRange("Income/Balance", Rec."Income/Balance"::"Balance Sheet");
IncomeBalanceGLAccFilter::"Income Statement":
Rec.SetRange("Income/Balance", Rec."Income/Balance"::"Income Statement");
end;
IncomeBalanceVisible := Rec.GetFilter("Income/Balance") = '';
CurrPage.Update();
end;
}
field(GlobalDim1Filter; GlobalDim1Filter)
{
ApplicationArea = Dimensions;
CaptionClass = '1,3,1';
Caption = 'Global Dimension 1 Filter';
Enabled = GlobalDim1FilterEnable;
ToolTip = 'Specifies by which global dimension data is shown. Global dimensions are the dimensions that you analyze most frequently. Two global dimensions, typically for the company''s most important activities, are available on all cards, documents, reports, and lists.';
trigger OnLookup(var Text: Text): Boolean
var
DimensionValue: Record "Dimension Value";
begin
exit(DimensionValue.LookUpDimFilter(GLSetup."Global Dimension 1 Code", Text));
end;
trigger OnValidate()
begin
if GlobalDim1Filter = '' then
Rec.SetRange("Global Dimension 1 Filter")
else
Rec.SetFilter("Global Dimension 1 Filter", GlobalDim1Filter);
CurrPage.Update();
end;
}
field(GlobalDim2Filter; GlobalDim2Filter)
{
ApplicationArea = Dimensions;
CaptionClass = '1,3,2';
Caption = 'Global Dimension 2 Filter';
Enabled = GlobalDim2FilterEnable;
ToolTip = 'Specifies by which global dimension data is shown. Global dimensions are the dimensions that you analyze most frequently. Two global dimensions, typically for the company''s most important activities, are available on all cards, documents, reports, and lists.';
trigger OnLookup(var Text: Text): Boolean
var
DimensionValue: Record "Dimension Value";
begin
exit(DimensionValue.LookUpDimFilter(GLSetup."Global Dimension 2 Code", Text));
end;
trigger OnValidate()
begin
if GlobalDim2Filter = '' then
Rec.SetRange("Global Dimension 2 Filter")
else
Rec.SetFilter("Global Dimension 2 Filter", GlobalDim2Filter);
CurrPage.Update();
end;
}
}
repeater(Control5)
{
IndentationColumn = NameIndent;
IndentationControls = Name;
ShowCaption = false;
field("No."; Rec."No.")
{
ApplicationArea = Suite;
Style = Strong;
StyleExpr = Emphasize;
}
field(Name; Rec.Name)
{
ApplicationArea = Suite;
Style = Strong;
StyleExpr = Emphasize;
}
field("Income/Balance"; Rec."Income/Balance")
{
ApplicationArea = Suite;
Style = Strong;
StyleExpr = Emphasize;
Visible = IncomeBalanceVisible;
}
field("Debit Amount"; Rec."Debit Amount")
{
ApplicationArea = Suite;
BlankNumbers = BlankNegAndZero;
Style = Strong;
StyleExpr = Emphasize;
}
field("Credit Amount"; Rec."Credit Amount")
{
ApplicationArea = Suite;
BlankNumbers = BlankNegAndZero;
Style = Strong;
StyleExpr = Emphasize;
}
field("Net Change"; Rec."Net Change")
{
ApplicationArea = Basic, Suite;
BlankZero = true;
Style = Strong;
StyleExpr = Emphasize;
Visible = false;
}
field("Budgeted Debit Amount"; Rec."Budgeted Debit Amount")
{
ApplicationArea = Suite;
Style = Strong;
StyleExpr = Emphasize;
trigger OnValidate()
begin
CalcFormFields();
BudgetedDebitAmountOnAfterVali();
end;
}
field("Budgeted Credit Amount"; Rec."Budgeted Credit Amount")
{
ApplicationArea = Suite;
Style = Strong;
StyleExpr = Emphasize;
trigger OnValidate()
begin
CalcFormFields();
BudgetedCreditAmountOnAfterVal();
end;
}
field("Budgeted Amount"; Rec."Budgeted Amount")
{
ApplicationArea = Basic, Suite;
BlankZero = true;
Style = Strong;
StyleExpr = Emphasize;
Visible = false;
trigger OnValidate()
begin
CalcFormFields();
BudgetedAmountOnAfterValidate();
end;
}
field(BudgetPct; BudgetPct)
{
AutoFormatType = 0;
ApplicationArea = Suite;
BlankZero = true;
Caption = 'Balance/Budget (%)';
DecimalPlaces = 1 : 1;
Editable = false;
Style = Strong;
StyleExpr = Emphasize;
ToolTip = 'Specifies a summary of the debit and credit balances and the budgeted amounts for different time periods for the account that you select in the chart of accounts.';
}
}
}
area(factboxes)
{
systempart(Control1900383207; Links)
{
ApplicationArea = RecordLinks;
Visible = false;
}
systempart(Control1905767507; Notes)
{
ApplicationArea = Notes;
Visible = false;
}
}
}
actions
{
area(navigation)
{
group("A&ccount")
{
Caption = 'A&ccount';
Image = ChartOfAccounts;
action(Card)
{
ApplicationArea = Suite;
Caption = 'Card';
Image = EditLines;
RunObject = Page "G/L Account Card";
RunPageLink = "No." = field("No."),
"Date Filter" = field("Date Filter"),
"Global Dimension 1 Filter" = field("Global Dimension 1 Filter"),
"Global Dimension 2 Filter" = field("Global Dimension 2 Filter"),
"Budget Filter" = field("Budget Filter"),
"Business Unit Filter" = field("Business Unit Filter");
ShortCutKey = 'Shift+F7';
ToolTip = 'Open the G/L account card for the selected record.';
}
action("Ledger E&ntries")
{
ApplicationArea = Suite;
Caption = 'Ledger E&ntries';
Image = GLRegisters;
//The property 'PromotedCategory' can only be set if the property 'Promoted' is set to 'true'
//PromotedCategory = Process;
RunObject = Page "General Ledger Entries";
RunPageLink = "G/L Account No." = field("No.");
RunPageView = sorting("G/L Account No.");
ShortCutKey = 'Ctrl+F7';
ToolTip = 'View the history of transactions that have been posted for the selected record.';
}
action("Co&mments")
{
ApplicationArea = Comments;
Caption = 'Co&mments';
Image = ViewComments;
RunObject = Page "Comment Sheet";
RunPageLink = "Table Name" = const("G/L Account"),
"No." = field("No.");
ToolTip = 'View or add comments for the record.';
}
action(Dimensions)
{
ApplicationArea = Dimensions;
Caption = 'Dimensions';
Image = Dimensions;
RunObject = Page "Default Dimensions";
RunPageLink = "Table ID" = const(15),
"No." = field("No.");
ShortCutKey = 'Alt+D';
ToolTip = 'View or edit dimensions, such as area, project, or department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history.';
}
action("E&xtended Texts")
{
ApplicationArea = Suite;
Caption = 'E&xtended Texts';
Image = Text;
RunObject = Page "Extended Text List";
RunPageLink = "Table Name" = const("G/L Account"),
"No." = field("No.");
RunPageView = sorting("Table Name", "No.", "Language Code", "All Language Codes", "Starting Date", "Ending Date");
ToolTip = 'View additional information that has been added to the description for the current account.';
}
}
}
area(processing)
{
action("Previous Period")
{
ApplicationArea = 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.';
trigger OnAction()
begin
FindPeriod('<=');
end;
}
action("Next Period")
{
ApplicationArea = 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.';
trigger OnAction()
begin
FindPeriod('>=');
end;
}
group("F&unctions")
{
Caption = 'F&unctions';
Image = "Action";
action("Copy Budget")
{
ApplicationArea = Suite;
Caption = 'Copy Budget';
Ellipsis = true;
Image = CopyBudget;
RunObject = Report "Copy G/L Budget";
ToolTip = 'Create a copy of the current budget.';
}
}
}
area(Promoted)
{
group(Category_Process)
{
Caption = 'Process';
actionref("Previous Period_Promoted"; "Previous Period")
{
}
actionref("Next Period_Promoted"; "Next Period")
{
}
}
}
}
trigger OnAfterGetRecord()
begin
NameIndent := 0;
CalcFormFields();
FormatLine();
end;
trigger OnNewRecord(BelowxRec: Boolean)
begin
Rec.SetupNewGLAcc(xRec, BelowxRec);
end;
trigger OnOpenPage()
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeOpenPage(Rec, IsHandled);
if IsHandled then
exit;
GLSetup.Get();
InitDefaultFilters();
CODEUNIT.Run(CODEUNIT::"GLBudget-Open", Rec);
FindPeriod('');
end;
var
GLSetup: Record "General Ledger Setup";
GLAccCategoryFilter: Enum "G/L Account Category";
IncomeBalanceGLAccFilter: Option " ","Income Statement","Balance Sheet";
BudgetPct: Decimal;
Emphasize: Boolean;
IncomeBalanceVisible: Boolean;
GlobalDim1FilterEnable: Boolean;
GlobalDim2FilterEnable: Boolean;
NameIndent: Integer;
GlobalDim1Filter: Text;
GlobalDim2Filter: Text;
GLAccFilter: Text;
protected var
PeriodType: Enum "Analysis Period Type";
AmountType: Enum "Analysis Amount Type";
ClosingEntryFilter: Option Include,Exclude;
DateFilter: Text;
/// <summary>
/// Finds and navigates to specific periods in the matrix based on search criteria.
/// Updates date filters and refreshes matrix display for period-based analysis.
/// </summary>
/// <param name="SearchText">Period navigation command (e.g., '+', '-', '=')</param>
procedure FindPeriod(SearchText: Code[10])
var
Calendar: Record Date;
AccountingPeriod: Record "Accounting Period";
PeriodPageMgt: Codeunit PeriodPageManagement;
begin
if Rec.GetFilter("Date Filter") <> '' then begin
Calendar.SetFilter("Period Start", Rec.GetFilter("Date Filter"));
if not PeriodPageMgt.FindDate('+', Calendar, PeriodType) then
PeriodPageMgt.FindDate('+', Calendar, PeriodType::Day);
Calendar.SetRange("Period Start");
end;
PeriodPageMgt.FindDate(SearchText, Calendar, PeriodType);
if AmountType = AmountType::"Net Change" then
if Calendar."Period Start" = Calendar."Period End" then
Rec.SetRange("Date Filter", Calendar."Period Start")
else
Rec.SetRange("Date Filter", Calendar."Period Start", Calendar."Period End")
else
Rec.SetRange("Date Filter", 0D, Calendar."Period End");
if ClosingEntryFilter = ClosingEntryFilter::Exclude then begin
AccountingPeriod.SetCurrentKey("New Fiscal Year");
AccountingPeriod.SetRange("New Fiscal Year", true);
if Rec.GetRangeMin("Date Filter") = 0D then
AccountingPeriod.SetRange("Starting Date", 0D, Rec.GetRangeMax("Date Filter"))
else
AccountingPeriod.SetRange(
"Starting Date",
Rec.GetRangeMin("Date Filter") + 1,
Rec.GetRangeMax("Date Filter"));
if AccountingPeriod.Find('-') then
repeat
Rec.SetFilter(
"Date Filter", Rec.GetFilter("Date Filter") + '&<>%1',
ClosingDate(AccountingPeriod."Starting Date" - 1));
until AccountingPeriod.Next() = 0;
end else
Rec.SetRange(
"Date Filter",
Rec.GetRangeMin("Date Filter"),
ClosingDate(Rec.GetRangeMax("Date Filter")));
DateFilter := Rec.GetFilter("Date Filter");
end;
local procedure CalcFormFields()
begin
Rec.CalcFields("Net Change", "Budgeted Amount");
if Rec."Net Change" >= 0 then begin
Rec."Debit Amount" := Rec."Net Change";
Rec."Credit Amount" := 0;
end else begin
Rec."Debit Amount" := 0;
Rec."Credit Amount" := -Rec."Net Change";
end;
if Rec."Budgeted Amount" >= 0 then begin
Rec."Budgeted Debit Amount" := Rec."Budgeted Amount";
Rec."Budgeted Credit Amount" := 0;
end else begin
Rec."Budgeted Debit Amount" := 0;
Rec."Budgeted Credit Amount" := -Rec."Budgeted Amount";
end;
if Rec."Budgeted Amount" = 0 then
BudgetPct := 0
else
BudgetPct := Rec."Net Change" / Rec."Budgeted Amount" * 100;
end;
local procedure BudgetedDebitAmountOnAfterVali()
begin
CurrPage.Update();
end;
local procedure BudgetedCreditAmountOnAfterVal()
begin
CurrPage.Update();
end;
local procedure BudgetedAmountOnAfterValidate()
begin
CurrPage.Update();
end;
local procedure DayPeriodTypeOnAfterValidate()
begin
CurrPage.Update();
end;
local procedure WeekPeriodTypeOnAfterValidate()
begin
CurrPage.Update();
end;
local procedure MonthPeriodTypeOnAfterValidate()
begin
CurrPage.Update();
end;
local procedure QuarterPeriodTypeOnAfterValida()
begin
CurrPage.Update();
end;
local procedure YearPeriodTypeOnAfterValidate()
begin
CurrPage.Update();
end;
local procedure AccountingPerioPeriodTypeOnAft()
begin
CurrPage.Update();
end;
local procedure ClosingEntryFilterOnAfterValid()
begin
CurrPage.Update();
end;
local procedure NetChangeAmountTypeOnAfterVali()
begin
CurrPage.Update();
end;
local procedure BalanceatDateAmountTypeOnAfter()
begin
CurrPage.Update();
end;
local procedure DayPeriodTypeOnPush()
begin
FindPeriod('');
end;
local procedure WeekPeriodTypeOnPush()
begin
FindPeriod('');
end;
local procedure MonthPeriodTypeOnPush()
begin
FindPeriod('');
end;
local procedure QuarterPeriodTypeOnPush()
begin
FindPeriod('');
end;
local procedure YearPeriodTypeOnPush()
begin
FindPeriod('');
end;
local procedure AccountingPerioPeriodTypOnPush()
begin
FindPeriod('');
end;
local procedure NetChangeAmountTypeOnPush()
begin
FindPeriod('');
end;
local procedure BalanceatDateAmountTypeOnPush()
begin
FindPeriod('');
end;
local procedure FormatLine()
begin
NameIndent := Rec.Indentation;
Emphasize := Rec."Account Type" <> Rec."Account Type"::Posting;
end;
local procedure DayPeriodTypeOnValidate()
begin
DayPeriodTypeOnPush();
DayPeriodTypeOnAfterValidate();
end;
local procedure WeekPeriodTypeOnValidate()
begin
WeekPeriodTypeOnPush();
WeekPeriodTypeOnAfterValidate();
end;
local procedure MonthPeriodTypeOnValidate()
begin
MonthPeriodTypeOnPush();
MonthPeriodTypeOnAfterValidate();
end;
local procedure QuarterPeriodTypeOnValidate()
begin
QuarterPeriodTypeOnPush();
QuarterPeriodTypeOnAfterValida();
end;
local procedure YearPeriodTypeOnValidate()
begin
YearPeriodTypeOnPush();
YearPeriodTypeOnAfterValidate();
end;
local procedure AccountingPerioPeriodTypeOnVal()
begin
AccountingPerioPeriodTypOnPush();
AccountingPerioPeriodTypeOnAft();
end;
local procedure NetChangeAmountTypeOnValidate()
begin
NetChangeAmountTypeOnPush();
NetChangeAmountTypeOnAfterVali();
end;
local procedure BalanceatDateAmountTypeOnValid()
begin
BalanceatDateAmountTypeOnPush();
BalanceatDateAmountTypeOnAfter();
end;
local procedure InitDefaultFilters()
var
TempGLAccount: Record "G/L Account" temporary;
GLBudgetOpen: Codeunit "GLBudget-Open";
begin
GLBudgetOpen.SetupFiltersOnGLAccBudgetPage(
GlobalDim1Filter, GlobalDim2Filter, GlobalDim1FilterEnable, GlobalDim2FilterEnable,
PeriodType, DateFilter, Rec);
IncomeBalanceVisible := Rec.GetFilter("Income/Balance") = '';
GLAccFilter := Rec.GetFilter("No.");
if Evaluate(TempGLAccount."Account Category", Rec.GetFilter("Account Category")) then
GLAccCategoryFilter := TempGLAccount."Account Category"
else
GLAccCategoryFilter := GLAccCategoryFilter::" ";
if Evaluate(TempGLAccount."Income/Balance", Rec.GetFilter("Income/Balance")) then
case TempGLAccount."Income/Balance" of
TempGLAccount."Income/Balance"::"Income Statement":
IncomeBalanceGLAccFilter := IncomeBalanceGLAccFilter::"Income Statement";
TempGLAccount."Income/Balance"::"Balance Sheet":
IncomeBalanceGLAccFilter := IncomeBalanceGLAccFilter::"Balance Sheet";
end
else
IncomeBalanceGLAccFilter := IncomeBalanceGLAccFilter::" ";
OnAfterInitDefaultFilters(GlobalDim1Filter, GlobalDim2Filter, DateFilter);
end;
/// <summary>
/// Integration event raised before validating period type changes in the analysis view.
/// Enables custom validation logic for period type selection and filtering requirements.
/// </summary>
/// <param name="PeriodType">Period type being validated for the analysis display</param>
[IntegrationEvent(true, false)]
local procedure OnBeforeValidatePeriodType(var PeriodType: Enum "Analysis Period Type")
begin
end;
/// <summary>
/// Integration event raised before opening the page to allow custom initialization.
/// Enables modification of G/L account filters and default settings before page display.
/// </summary>
/// <param name="GLAccount">G/L account record being used as data source</param>
/// <param name="IsHandled">Set to true to skip standard page opening logic</param>
[IntegrationEvent(true, false)]
local procedure OnBeforeOpenPage(var GLAccount: Record "G/L Account"; var IsHandled: Boolean)
begin
end;
/// <summary>
/// Integration event raised after initializing default filters for balance/budget analysis.
/// Enables customization of default dimension and date filters for analysis display.
/// </summary>
/// <param name="GlobalDim1Filter">Global dimension 1 filter that can be modified</param>
/// <param name="GlobalDim2Filter">Global dimension 2 filter that can be modified</param>
/// <param name="DateFilter">Date filter expression that can be modified</param>
[IntegrationEvent(true, false)]
local procedure OnAfterInitDefaultFilters(var GlobalDim1Filter: Text; var GlobalDim2Filter: Text; var DateFilter: Text)
begin
end;
}