Page 120 G/L Budget Entries
src/Layers/W1/BaseApp/Finance/GeneralLedger/Budget/GLBudgetEntries.Page.al362 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.Budget;using Microsoft.Finance.Analysis;using Microsoft.Finance.Consolidation;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Setup;using System.Utilities;/// <summary>/// List page for viewing and editing individual G/L budget entries with full dimensional analysis capabilities./// Primary data entry interface for budget amounts with validation, dimension support, and drill-down functionality./// </summary>/// <remarks>/// Key features: Budget entry CRUD operations, dimensional filtering, amount validation, and analysis navigation./// Integration: Links to G/L Account analysis, dimension management, and budget reporting workflows./// Performance: Optimized for large datasets with filtered views and indexed access patterns./// </remarks>page 120 "G/L Budget Entries"{ AdditionalSearchTerms = 'general ledger budget entries'; ApplicationArea = Suite; Caption = 'G/L Budget Entries'; DataCaptionFields = "G/L Account No.", "Budget Name"; DelayedInsert = true; PageType = List; AboutTitle = 'About G/L Budget Entries'; AboutText = 'Enter and manage budgeted amounts for specific general ledger accounts, periods, and dimensions within a selected G/L budget to support financial planning and analysis.'; SourceTable = "G/L Budget Entry"; UsageCategory = History; layout { area(content) { repeater(Control1) { ShowCaption = false; field("Budget Name"; Rec."Budget Name") { ApplicationArea = Suite; Editable = false; } field(Date; Rec.Date) { ApplicationArea = Suite; } field("G/L Account No."; Rec."G/L Account No.") { ApplicationArea = Suite; } field(Description; Rec.Description) { ApplicationArea = Suite; } field("Global Dimension 1 Code"; Rec."Global Dimension 1 Code") { ApplicationArea = Dimensions; Enabled = GlobalDimension1CodeEnable; Visible = GlobalDimension1CodeVisible; } field("Global Dimension 2 Code"; Rec."Global Dimension 2 Code") { ApplicationArea = Dimensions; Enabled = GlobalDimension2CodeEnable; Visible = GlobalDimension2CodeVisible; } field("Budget Dimension 1 Code"; Rec."Budget Dimension 1 Code") { ApplicationArea = Dimensions; Enabled = BudgetDimension1CodeEnable; Visible = BudgetDimension1CodeVisible; } field("Budget Dimension 2 Code"; Rec."Budget Dimension 2 Code") { ApplicationArea = Dimensions; Enabled = BudgetDimension2CodeEnable; Visible = BudgetDimension2CodeVisible; } field("Budget Dimension 3 Code"; Rec."Budget Dimension 3 Code") { ApplicationArea = Dimensions; Enabled = BudgetDimension3CodeEnable; Visible = BudgetDimension3CodeVisible; } field("Budget Dimension 4 Code"; Rec."Budget Dimension 4 Code") { ApplicationArea = Dimensions; Enabled = BudgetDimension4CodeEnable; Visible = BudgetDimension4CodeVisible; } field("Business Unit Code"; Rec."Business Unit Code") { ApplicationArea = Suite; Visible = false; } field(Amount; Rec.Amount) { ApplicationArea = Suite; } field("Entry No."; Rec."Entry No.") { ApplicationArea = Suite; Editable = false; } field("Dimension Set ID"; Rec."Dimension Set ID") { ApplicationArea = Dimensions; Visible = false; } } } area(factboxes) { systempart(Control1900383207; Links) { ApplicationArea = RecordLinks; Visible = false; } systempart(Control1905767507; Notes) { ApplicationArea = Notes; Visible = false; } } } actions { area(navigation) { group("Ent&ry") { Caption = 'Ent&ry'; Image = Entry; action(Dimensions) { AccessByPermission = TableData Dimension = R; ApplicationArea = Dimensions; Caption = 'Dimensions'; Image = Dimensions; 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.'; trigger OnAction() begin Rec.ShowDimensions(); CurrPage.SaveRecord(); end; } action(SetDimensionFilter) { ApplicationArea = Dimensions; Caption = 'Set Dimension Filter'; Ellipsis = true; Image = "Filter"; ToolTip = 'Limit the entries according to the dimension filters that you specify. NOTE: If you use a high number of dimension combinations, this function may not work and can result in a message that the SQL server only supports a maximum of 2100 parameters.'; trigger OnAction() begin Rec.SetFilter("Dimension Set ID", DimensionSetIDFilter.LookupFilter()); end; } } } area(Promoted) { group(Category_Process) { Caption = 'Process'; actionref(Dimensions_Promoted; Dimensions) { } actionref(SetDimensionFilter_Promoted; SetDimensionFilter) { } } } } trigger OnDeleteRecord(): Boolean var GLBudgetEntry: Record "G/L Budget Entry"; begin if Rec."Entry No." < LowestModifiedEntryNo then begin CurrPage.SetSelectionFilter(GLBudgetEntry); GLBudgetEntry.SetCurrentKey("Entry No."); GLBudgetEntry.Ascending(true); GLBudgetEntry.FindFirst(); LowestModifiedEntryNo := GLBudgetEntry."Entry No."; UpdateAnalysisView.SetLastBudgetEntryNo(LowestModifiedEntryNo - 1); end; exit(true); end; trigger OnInit() begin BudgetDimension4CodeEnable := true; BudgetDimension3CodeEnable := true; BudgetDimension2CodeEnable := true; BudgetDimension1CodeEnable := true; GlobalDimension2CodeEnable := true; GlobalDimension1CodeEnable := true; BudgetDimension4CodeVisible := true; BudgetDimension3CodeVisible := true; BudgetDimension2CodeVisible := true; BudgetDimension1CodeVisible := true; GlobalDimension2CodeVisible := true; GlobalDimension1CodeVisible := true; LowestModifiedEntryNo := 2147483647; end; trigger OnModifyRecord(): Boolean begin if Rec."Entry No." < LowestModifiedEntryNo then begin LowestModifiedEntryNo := Rec."Entry No."; UpdateAnalysisView.SetLastBudgetEntryNo(LowestModifiedEntryNo - 1); end; exit(true); end; trigger OnNewRecord(BelowxRec: Boolean) begin if Rec.GetFilter("Budget Name") <> '' then Rec."Budget Name" := Rec.GetRangeMin("Budget Name"); if GLBudgetName.Name <> Rec."Budget Name" then GLBudgetName.Get(Rec."Budget Name"); if Rec.GetFilter("G/L Account No.") <> '' then Rec."G/L Account No." := GetFirstGLAcc(Rec.GetFilter("G/L Account No.")); Rec.Date := GetFirstDate(Rec.GetFilter(Date)); Rec."User ID" := CopyStr(UserId(), 1, MaxStrLen(Rec."User ID")); if Rec.GetFilter("Global Dimension 1 Code") <> '' then Rec."Global Dimension 1 Code" := GetFirstDimValue(GLSetup."Global Dimension 1 Code", Rec.GetFilter("Global Dimension 1 Code")); if Rec.GetFilter("Global Dimension 2 Code") <> '' then Rec."Global Dimension 2 Code" := GetFirstDimValue(GLSetup."Global Dimension 2 Code", Rec.GetFilter("Global Dimension 2 Code")); if Rec.GetFilter("Budget Dimension 1 Code") <> '' then Rec."Budget Dimension 1 Code" := GetFirstDimValue(GLBudgetName."Budget Dimension 1 Code", Rec.GetFilter("Budget Dimension 1 Code")); if Rec.GetFilter("Budget Dimension 2 Code") <> '' then Rec."Budget Dimension 2 Code" := GetFirstDimValue(GLBudgetName."Budget Dimension 2 Code", Rec.GetFilter("Budget Dimension 2 Code")); if Rec.GetFilter("Budget Dimension 3 Code") <> '' then Rec."Budget Dimension 3 Code" := GetFirstDimValue(GLBudgetName."Budget Dimension 3 Code", Rec.GetFilter("Budget Dimension 3 Code")); if Rec.GetFilter("Budget Dimension 4 Code") <> '' then Rec."Budget Dimension 4 Code" := GetFirstDimValue(GLBudgetName."Budget Dimension 4 Code", Rec.GetFilter("Budget Dimension 4 Code")); if Rec.GetFilter("Business Unit Code") <> '' then Rec."Business Unit Code" := GetFirstBusUnit(Rec.GetFilter("Business Unit Code")); end; trigger OnOpenPage() var GLBudgetName: Record "G/L Budget Name"; begin if Rec.GetFilter("Budget Name") = '' then GLBudgetName.Init() else begin Rec.CopyFilter("Budget Name", GLBudgetName.Name); GLBudgetName.FindFirst(); end; CurrPage.Editable := not GLBudgetName.Blocked; GLSetup.Get(); GlobalDimension1CodeEnable := GLSetup."Global Dimension 1 Code" <> ''; GlobalDimension2CodeEnable := GLSetup."Global Dimension 2 Code" <> ''; BudgetDimension1CodeEnable := GLBudgetName."Budget Dimension 1 Code" <> ''; BudgetDimension2CodeEnable := GLBudgetName."Budget Dimension 2 Code" <> ''; BudgetDimension3CodeEnable := GLBudgetName."Budget Dimension 3 Code" <> ''; BudgetDimension4CodeEnable := GLBudgetName."Budget Dimension 4 Code" <> ''; GlobalDimension1CodeVisible := GLSetup."Global Dimension 1 Code" <> ''; GlobalDimension2CodeVisible := GLSetup."Global Dimension 2 Code" <> ''; BudgetDimension1CodeVisible := GLBudgetName."Budget Dimension 1 Code" <> ''; BudgetDimension2CodeVisible := GLBudgetName."Budget Dimension 2 Code" <> ''; BudgetDimension3CodeVisible := GLBudgetName."Budget Dimension 3 Code" <> ''; BudgetDimension4CodeVisible := GLBudgetName."Budget Dimension 4 Code" <> ''; end; var GLSetup: Record "General Ledger Setup"; GLBudgetName: Record "G/L Budget Name"; UpdateAnalysisView: Codeunit "Update Analysis View"; DimensionSetIDFilter: Page "Dimension Set ID Filter"; LowestModifiedEntryNo: Integer; GlobalDimension1CodeVisible: Boolean; GlobalDimension2CodeVisible: Boolean; BudgetDimension1CodeVisible: Boolean; BudgetDimension2CodeVisible: Boolean; BudgetDimension3CodeVisible: Boolean; BudgetDimension4CodeVisible: Boolean; GlobalDimension1CodeEnable: Boolean; GlobalDimension2CodeEnable: Boolean; BudgetDimension1CodeEnable: Boolean; BudgetDimension2CodeEnable: Boolean; BudgetDimension3CodeEnable: Boolean; BudgetDimension4CodeEnable: Boolean; local procedure GetFirstGLAcc(GLAccFilter: Text[250]): Code[20] var GLAcc: Record "G/L Account"; begin GLAcc.SetFilter("No.", GLAccFilter); if GLAcc.FindFirst() then exit(GLAcc."No."); exit(''); end; local procedure GetFirstDate(DateFilter: Text[250]): Date var Period: Record Date; begin if DateFilter = '' then exit(0D); Period.SetRange("Period Type", Period."Period Type"::Date); Period.SetFilter("Period Start", DateFilter); if Period.FindFirst() then exit(Period."Period Start"); exit(0D); end; local procedure GetFirstDimValue(DimCode: Code[20]; DimValFilter: Text[250]): Code[20] var DimVal: Record "Dimension Value"; begin if (DimCode = '') or (DimValFilter = '') then exit(''); DimVal.SetRange("Dimension Code", DimCode); DimVal.SetFilter(Code, DimValFilter); if DimVal.FindFirst() then exit(DimVal.Code); exit(''); end; local procedure GetFirstBusUnit(BusUnitFilter: Text[250]): Code[20] var BusUnit: Record "Business Unit"; begin BusUnit.SetFilter(Code, BusUnitFilter); if BusUnit.FindFirst() then exit(BusUnit.Code); exit(''); end;}