Page 1119 Cost Budget by Cost Object

Base Application, Microsoft.CostAccounting.Budget

src/Layers/W1/BaseApp/CostAccounting/Budget/CostBudgetbyCostObject.Page.al279 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.CostAccounting.Budget;using Microsoft.CostAccounting.Account;using Microsoft.Finance.Analysis;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using System.Utilities;page 1119 "Cost Budget by Cost Object"{    Caption = 'Cost Budget by Cost Object';    DeleteAllowed = false;    InsertAllowed = false;    LinksAllowed = false;    PageType = ListPlus;    SourceTable = "Cost Type";    layout    {        area(content)        {            group(General)            {                Caption = 'General';                field(RoundingFactor; RoundingFactor)                {                    ApplicationArea = CostAccounting;                    Caption = 'Rounding Factor';                    ToolTip = 'Specifies the factor that is used to round the amounts in the columns.';                    trigger OnValidate()                    begin                        UpdateMatrixSubform();                    end;                }                field(BudgetFilter; BudgetFilter)                {                    ApplicationArea = CostAccounting;                    Caption = 'Budget Filter';                    TableRelation = "Cost Budget Name";                    ToolTip = 'Specifies the budget name that you want to work on.';                    trigger OnValidate()                    begin                        UpdateMatrixSubform();                    end;                }                field(PeriodType; PeriodType)                {                    ApplicationArea = CostAccounting;                    Caption = 'View by';                    ToolTip = 'Specifies by which period amounts are displayed.';                    trigger OnValidate()                    begin                        FindPeriod('');                        UpdateMatrixSubform();                    end;                }                field(AmountType; AmountType)                {                    ApplicationArea = CostAccounting;                    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                        FindPeriod('');                        UpdateMatrixSubform();                    end;                }            }            part(MatrixForm; "Cost Bdgt. per Object Matrix")            {                ApplicationArea = CostAccounting;            }        }    }    actions    {        area(navigation)        {            group("Budge&t")            {                Caption = 'Budge&t';                Image = LedgerBudget;                action("By &Period")                {                    ApplicationArea = CostAccounting;                    Caption = 'By &Period';                    Image = Calendar;                    RunObject = Page "Cost Budget per Period";                    RunPageOnRec = true;                    ToolTip = 'View a summary of the amount budgeted in different time periods.';                }                action("By Cost &Center")                {                    ApplicationArea = CostAccounting;                    Caption = 'By Cost &Center';                    Image = CostCenter;                    RunObject = Page "Cost Budget by Cost Center";                    RunPageOnRec = true;                    ToolTip = 'View a summary of the amount budgeted for each cost center in different time periods.';                }                separator(Action5)                {                }                action("&Budget / Movement")                {                    ApplicationArea = CostAccounting;                    Caption = '&Budget / Movement';                    Image = CostBudget;                    RunObject = Page "Cost Type Balance/Budget";                    RunPageOnRec = true;                    ToolTip = 'View a summary of the net changes and the budgeted amounts for different time periods for the cost type that you select in the chart of cost types.';                }            }        }        area(processing)        {            action(PreviousSet)            {                ApplicationArea = CostAccounting;                Caption = 'Previous Set';                Image = PreviousSet;                ToolTip = 'Go to the previous set of data.';                trigger OnAction()                begin                    GenerateColumnCaptions("Matrix Page Step Type"::Previous);                    UpdateMatrixSubform();                end;            }            action(PreviousColumn)            {                ApplicationArea = CostAccounting;                Caption = 'Previous Column';                Image = PreviousRecord;                ToolTip = 'Go to the previous column.';                trigger OnAction()                begin                    GenerateColumnCaptions("Matrix Page Step Type"::PreviousColumn);                    UpdateMatrixSubform();                end;            }            action(NextColumn)            {                ApplicationArea = CostAccounting;                Caption = 'Next Column';                Image = NextRecord;                ToolTip = 'Go to the next column.';                trigger OnAction()                begin                    GenerateColumnCaptions("Matrix Page Step Type"::NextColumn);                    UpdateMatrixSubform();                end;            }            action(NextSet)            {                ApplicationArea = CostAccounting;                Caption = 'Next Set';                Image = NextSet;                ToolTip = 'Go to the next set of data.';                trigger OnAction()                begin                    GenerateColumnCaptions("Matrix Page Step Type"::Next);                    UpdateMatrixSubform();                end;            }        }        area(Promoted)        {            group(Category_Process)            {                Caption = 'Process';                actionref(PreviousSet_Promoted; PreviousSet)                {                }                actionref(PreviousColumn_Promoted; PreviousColumn)                {                }                actionref(NextColumn_Promoted; NextColumn)                {                }                actionref(NextSet_Promoted; NextSet)                {                }            }        }    }    trigger OnOpenPage()    begin        FindPeriod('');        CostObjectMatrixRecord.SetCurrentKey("Sorting Order");        MATRIX_CaptionFieldNo := 1;        BudgetFilter := Rec.GetFilter("Budget Filter");        GenerateColumnCaptions("Matrix Page Step Type"::Initial);        UpdateMatrixSubform();    end;    var        CostObjectMatrixRecords: array[12] of Record "Cost Object";        CostObjectMatrixRecord: Record "Cost Object";        MatrixMgt: Codeunit "Matrix Management";        MatrixRecordRef: RecordRef;        MATRIX_CaptionSet: array[12] of Text[80];        MATRIX_CaptionRange: Text;        MATRIX_PKFirstRecInCurrSet: Text;        PeriodType: Enum "Analysis Period Type";        RoundingFactor: Enum "Analysis Rounding Factor";        AmountType: Enum "Analysis Amount Type";        MATRIX_CaptionFieldNo: Integer;        CurrentMatrixRecordOrdinal: Integer;        MATRIX_CurrSetLength: Integer;        BudgetFilter: Code[10];    local procedure GenerateColumnCaptions(StepType: Enum "Matrix Page Step Type")    begin        Clear(MATRIX_CaptionSet);        Clear(CostObjectMatrixRecords);        CurrentMatrixRecordOrdinal := 1;        CostObjectMatrixRecord.SetRange("Line Type", CostObjectMatrixRecord."Line Type"::"Cost Object");        if CostObjectMatrixRecord.Find('-') then;        MatrixRecordRef.GetTable(CostObjectMatrixRecord);        MatrixRecordRef.SetTable(CostObjectMatrixRecord);        MatrixMgt.GenerateMatrixData(MatrixRecordRef, StepType.AsInteger(), ArrayLen(CostObjectMatrixRecords), MATRIX_CaptionFieldNo,          MATRIX_PKFirstRecInCurrSet, MATRIX_CaptionSet, MATRIX_CaptionRange, MATRIX_CurrSetLength);        if MATRIX_CurrSetLength > 0 then begin            CostObjectMatrixRecord.SetPosition(MATRIX_PKFirstRecInCurrSet);            CostObjectMatrixRecord.Get(CostObjectMatrixRecord.Code);            repeat                CostObjectMatrixRecords[CurrentMatrixRecordOrdinal].Copy(CostObjectMatrixRecord);                CurrentMatrixRecordOrdinal := CurrentMatrixRecordOrdinal + 1;            until (CurrentMatrixRecordOrdinal > MATRIX_CurrSetLength) or (CostObjectMatrixRecord.Next() <> 1);        end;    end;    local procedure FindPeriod(FindTxt: Code[3])    var        Calendar: Record Date;        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(FindTxt, Calendar, PeriodType);        if AmountType = AmountType::"Net Change" then begin            Rec.SetRange("Date Filter", Calendar."Period Start", Calendar."Period End");            if Rec.GetRangeMin("Date Filter") = Rec.GetRangeMax("Date Filter") then                Rec.SetRange("Date Filter", Rec.GetRangeMin("Date Filter"));        end else            Rec.SetRange("Date Filter", 0D, Calendar."Period End");    end;    local procedure UpdateMatrixSubform()    begin        CurrPage.MatrixForm.PAGE.LoadMatrix(          MATRIX_CaptionSet, CostObjectMatrixRecords, MATRIX_CurrSetLength, Rec.GetFilter("Date Filter"), BudgetFilter, RoundingFactor);    end;}