Page 154 G/L Account Balance/Budget
src/Layers/W1/BaseApp/Finance/Analysis/GLAccountBalanceBudget.Page.al363 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;page 154 "G/L Account Balance/Budget"{ Caption = 'G/L Account Balance/Budget'; DeleteAllowed = false; InsertAllowed = false; LinksAllowed = false; PageType = ListPlus; 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 UpdateSubForm(); end; } field(PeriodType; PeriodType) { ApplicationArea = Suite; Caption = 'View by'; ToolTip = 'Specifies by which period amounts are displayed.'; trigger OnValidate() begin 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; } } part(GLBalanceLines; "G/L Acc. Balance/Budget Lines") { ApplicationArea = Suite; } group(Filters) { Caption = 'Filters'; 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() begin if DateFilter = '' then Rec.SetRange("Date Filter") else Rec.SetFilter("Date Filter", DateFilter); UpdateSubForm(); 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); UpdateSubForm(); 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); UpdateSubForm(); end; } } } } 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) { 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) { } } trigger OnAfterGetRecord() begin UpdateSubForm(); end; trigger OnOpenPage() var GLBudgetOpen: Codeunit "GLBudget-Open"; begin GLSetup.Get(); GLBudgetOpen.Run(Rec); GLBudgetOpen.SetupFiltersOnGLAccBudgetPage( GlobalDim1Filter, GlobalDim2Filter, GlobalDim1FilterEnable, GlobalDim2FilterEnable, PeriodType, DateFilter, Rec); end; var GLSetup: Record "General Ledger Setup"; GlobalDim1FilterEnable: Boolean; GlobalDim2FilterEnable: Boolean; DateFilter: Text; GlobalDim1Filter: Text; GlobalDim2Filter: Text; protected var PeriodType: Enum "Analysis Period Type"; AmountType: Enum "Analysis Amount Type"; ClosingEntryFilter: Option Include,Exclude; local procedure UpdateSubForm() begin CurrPage.GLBalanceLines.PAGE.SetLines(Rec, PeriodType, AmountType, ClosingEntryFilter); end; local procedure DayPeriodTypeOnPush() begin UpdateSubForm(); end; local procedure WeekPeriodTypeOnPush() begin UpdateSubForm(); end; local procedure MonthPeriodTypeOnPush() begin UpdateSubForm(); end; local procedure QuarterPeriodTypeOnPush() begin UpdateSubForm(); end; local procedure YearPeriodTypeOnPush() begin UpdateSubForm(); end; local procedure AccountingPerioPeriodTypOnPush() begin UpdateSubForm(); end; local procedure NetChangeAmountTypeOnPush() begin UpdateSubForm(); end; local procedure BalanceatDateAmountTypeOnPush() begin UpdateSubForm(); end; local procedure DayPeriodTypeOnValidate() begin DayPeriodTypeOnPush(); end; local procedure WeekPeriodTypeOnValidate() begin WeekPeriodTypeOnPush(); end; local procedure MonthPeriodTypeOnValidate() begin MonthPeriodTypeOnPush(); end; local procedure QuarterPeriodTypeOnValidate() begin QuarterPeriodTypeOnPush(); end; local procedure YearPeriodTypeOnValidate() begin YearPeriodTypeOnPush(); end; local procedure AccountingPerioPeriodTypeOnVal() begin AccountingPerioPeriodTypOnPush(); end; local procedure NetChangeAmountTypeOnValidate() begin NetChangeAmountTypeOnPush(); end; local procedure BalanceatDateAmountTypeOnValid() begin BalanceatDateAmountTypeOnPush(); end;}