Page 563 G/L Entries Dimension Overview, source in 29
Source29
src/Layers/W1/BaseApp/Finance/GeneralLedger/Ledger/GLEntriesDimensionOverview.Page.al159 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.Ledger;
using Microsoft.Finance.Analysis;
using Microsoft.Finance.Dimension;
using Microsoft.Foundation.Enums;
/// <summary>
/// Overview page for analyzing G/L entries by dimensions using matrix view.
/// Provides dimensional analysis capabilities with configurable column sets and matrix display.
/// </summary>
/// <remarks>
/// PageType = Card. Data source: G/L Entry table. Non-editable overview page.
/// Supports matrix view for dimensional analysis with configurable column ranges.
/// Used for multi-dimensional financial analysis and reporting with drill-down capabilities.
/// </remarks>
page 563 "G/L Entries Dimension Overview"
{
Caption = 'G/L Entries Dimension Overview';
DeleteAllowed = false;
InsertAllowed = false;
LinksAllowed = false;
ModifyAllowed = false;
PageType = Card;
SourceTable = "G/L Entry";
layout
{
area(content)
{
group("Matrix Options")
{
Caption = 'Matrix Options';
field(MATRIX_CaptionRange; MATRIX_CaptionRange)
{
ApplicationArea = Dimensions;
Caption = 'Column Set';
Editable = false;
ToolTip = 'Specifies the range of values that are displayed in the matrix window, for example, the total period. To change the contents of the field, choose Next Set or Previous Set.';
}
}
}
}
actions
{
area(processing)
{
action(ShowMatrix)
{
ApplicationArea = Dimensions;
Caption = '&Show Matrix';
Image = ShowMatrix;
ToolTip = 'View the data overview according to the selected filters and options.';
trigger OnAction()
var
MatrixForm: Page "G/L Entries Dim. Overv. Matrix";
begin
Clear(MatrixForm);
MatrixForm.Load(MATRIX_CaptionSet, MATRIX_PKFirstCaptionInCurrSet, MATRIX_CurrSetLength);
if RunOnTempRec then
MatrixForm.SetTempGLEntry(TempGLEntry)
else
MatrixForm.SetTableView(Rec);
MatrixForm.RunModal();
end;
}
action("Previous Set")
{
ApplicationArea = Dimensions;
Caption = 'Previous Set';
Image = PreviousSet;
ToolTip = 'Go to the previous set of data.';
trigger OnAction()
begin
GenerateColumnCaptions("Matrix Page Step Type"::Previous);
end;
}
action("Next Set")
{
ApplicationArea = Dimensions;
Caption = 'Next Set';
Image = NextSet;
ToolTip = 'Go to the next set of data.';
trigger OnAction()
begin
GenerateColumnCaptions("Matrix Page Step Type"::Next);
end;
}
}
area(Promoted)
{
group(Category_Process)
{
Caption = 'Process';
actionref("Previous Set_Promoted"; "Previous Set")
{
}
actionref(ShowMatrix_Promoted; ShowMatrix)
{
}
actionref("Next Set_Promoted"; "Next Set")
{
}
}
}
}
trigger OnOpenPage()
begin
GenerateColumnCaptions("Matrix Page Step Type"::Initial);
end;
var
MatrixRecord: Record Dimension;
TempGLEntry: Record "G/L Entry" temporary;
RunOnTempRec: Boolean;
MATRIX_CaptionSet: array[32] of Text[80];
MATRIX_PKFirstCaptionInCurrSet: Text;
MATRIX_CaptionRange: Text;
MATRIX_CurrSetLength: Integer;
/// <summary>
/// Sets up the page to run on temporary G/L entry records instead of the main table.
/// </summary>
/// <param name="NewGLEntry">G/L Entry records to copy to temporary table for dimension analysis.</param>
procedure SetTempGLEntry(var NewGLEntry: Record "G/L Entry")
begin
RunOnTempRec := true;
TempGLEntry.DeleteAll();
if NewGLEntry.Find('-') then
repeat
TempGLEntry := NewGLEntry;
TempGLEntry.Insert();
until NewGLEntry.Next() = 0;
end;
local procedure GenerateColumnCaptions(StepType: Enum "Matrix Page Step Type")
var
MatrixMgt: Codeunit "Matrix Management";
RecRef: RecordRef;
begin
RecRef.GetTable(MatrixRecord);
RecRef.SetTable(MatrixRecord);
MatrixMgt.GenerateMatrixData(
RecRef, StepType.AsInteger(), ArrayLen(MATRIX_CaptionSet), 1,
MATRIX_PKFirstCaptionInCurrSet, MATRIX_CaptionSet, MATRIX_CaptionRange, MATRIX_CurrSetLength);
end;
}