Share via

Page "Budget Matrix"

ID 9203
Namespace: Microsoft.Finance.Analysis
Source table: Table Microsoft.Finance.Dimension."Dimension Code Buffer"

Properties

Name Value
Caption Budget Matrix
DataCaptionExpression BudgetName
DeleteAllowed False
InsertAllowed False
LinksAllowed False
PageType ListPart
RefreshOnActivate True
SourceTable Table Microsoft.Finance.Dimension."Dimension Code Buffer"

Methods

LoadMatrix

procedure LoadMatrix(NewMatrixColumns: array[32] of Text[80], var NewMatrixRecords: array[12] of Record "Dimension Code Buffer", CurrentNoOfMatrixColumns: Integer, NewLineDimCode: Text[30], NewLineDimType: Enum "G/L Budget Matrix Dimensions", NewColumnDimType: Enum "G/L Budget Matrix Dimensions", NewGlobalDim1Filter: Code[250], NewGlobalDim2Filter: Code[250], NewBudgetDim1Filter: Code[250], NewBudgetDim2Filter: Code[250], NewBudgetDim3Filter: Code[250], NewBudgetDim4Filter: Code[250], var NewGLBudgetName: Record "G/L Budget Name", NewDateFilter: Text[30], NewGLAccFilter: Text, NewIncomeBalanceGLAccFilter: Enum "G/L Account Income/Balance", NewGLAccCategoryFilter: Enum "G/L Account Category", NewRoundingFactor: Enum "Analysis Rounding Factor", NewPeriodType: Enum "Analysis Period Type")

Parameters

Name Type Description
NewMatrixColumns array[32] of Text[80]
NewMatrixRecords array[12] of Record "Dimension Code Buffer"
CurrentNoOfMatrixColumns Integer
NewLineDimCode Text[30]
NewLineDimType Enum Microsoft.Finance.GeneralLedger.Budget."G/L Budget Matrix Dimensions"
NewColumnDimType Enum Microsoft.Finance.GeneralLedger.Budget."G/L Budget Matrix Dimensions"
NewGlobalDim1Filter Code[250]
NewGlobalDim2Filter Code[250]
NewBudgetDim1Filter Code[250]
NewBudgetDim2Filter Code[250]
NewBudgetDim3Filter Code[250]
NewBudgetDim4Filter Code[250]
NewGLBudgetName Table Microsoft.Finance.GeneralLedger.Budget."G/L Budget Name"
NewDateFilter Text[30]
NewGLAccFilter Text
NewIncomeBalanceGLAccFilter Enum Microsoft.Finance.GeneralLedger.Account."G/L Account Income/Balance"
NewGLAccCategoryFilter Enum Microsoft.Finance.GeneralLedger.Account."G/L Account Category"
NewRoundingFactor Enum Microsoft.Foundation.Enums."Analysis Rounding Factor"
NewPeriodType Enum Microsoft.Foundation.Enums."Analysis Period Type"

LoadMatrix

Obsolete

This element will become obsolete from version 26.0. Replaced by LoadMatrix with NewGLAccFilter: Text instead of Code[250]

[Obsolete(Replaced by LoadMatrix with NewGLAccFilter: Text instead of Code[250],26.0)]
procedure LoadMatrix(NewMatrixColumns: array[32] of Text[80], var NewMatrixRecords: array[12] of Record "Dimension Code Buffer", CurrentNoOfMatrixColumns: Integer, NewLineDimCode: Text[30], NewLineDimType: Enum "G/L Budget Matrix Dimensions", NewColumnDimType: Enum "G/L Budget Matrix Dimensions", NewGlobalDim1Filter: Code[250], NewGlobalDim2Filter: Code[250], NewBudgetDim1Filter: Code[250], NewBudgetDim2Filter: Code[250], NewBudgetDim3Filter: Code[250], NewBudgetDim4Filter: Code[250], var NewGLBudgetName: Record "G/L Budget Name", NewDateFilter: Text[30], NewGLAccFilter: Code[250], NewIncomeBalanceGLAccFilter: Enum "G/L Account Income/Balance", NewGLAccCategoryFilter: Enum "G/L Account Category", NewRoundingFactor: Enum "Analysis Rounding Factor", NewPeriodType: Enum "Analysis Period Type")

Parameters

Name Type Description
NewMatrixColumns array[32] of Text[80]
NewMatrixRecords array[12] of Record "Dimension Code Buffer"
CurrentNoOfMatrixColumns Integer
NewLineDimCode Text[30]
NewLineDimType Enum Microsoft.Finance.GeneralLedger.Budget."G/L Budget Matrix Dimensions"
NewColumnDimType Enum Microsoft.Finance.GeneralLedger.Budget."G/L Budget Matrix Dimensions"
NewGlobalDim1Filter Code[250]
NewGlobalDim2Filter Code[250]
NewBudgetDim1Filter Code[250]
NewBudgetDim2Filter Code[250]
NewBudgetDim3Filter Code[250]
NewBudgetDim4Filter Code[250]
NewGLBudgetName Table Microsoft.Finance.GeneralLedger.Budget."G/L Budget Name"
NewDateFilter Text[30]
NewGLAccFilter Code[250]
NewIncomeBalanceGLAccFilter Enum Microsoft.Finance.GeneralLedger.Account."G/L Account Income/Balance"
NewGLAccCategoryFilter Enum Microsoft.Finance.GeneralLedger.Account."G/L Account Category"
NewRoundingFactor Enum Microsoft.Foundation.Enums."Analysis Rounding Factor"
NewPeriodType Enum Microsoft.Foundation.Enums."Analysis Period Type"

Events

OnAfterFindRec

[IntegrationEvent(False,False)]
local procedure OnAfterFindRec(DimType: Enum "G/L Budget Matrix Dimensions", Which: Text[250], var DimensionCodeBuffer: Record "Dimension Code Buffer", var Found: Boolean)

Parameters

Name Type Description
DimType Enum Microsoft.Finance.GeneralLedger.Budget."G/L Budget Matrix Dimensions"
Which Text[250]
DimensionCodeBuffer Table Microsoft.Finance.Dimension."Dimension Code Buffer"
Found Boolean

OnAfterLookUpCode

[IntegrationEvent(False,False)]
local procedure OnAfterLookUpCode(DimType: Enum "G/L Budget Matrix Dimensions", DimCode: Text[30], FieldCode: Text[30])

Parameters

Name Type Description
DimType Enum Microsoft.Finance.GeneralLedger.Budget."G/L Budget Matrix Dimensions"
DimCode Text[30]
FieldCode Text[30]

OnAfterNextRec

[IntegrationEvent(False,False)]
local procedure OnAfterNextRec(DimType: Enum "G/L Budget Matrix Dimensions", Steps: Integer, var DimensionCodeBuffer: Record "Dimension Code Buffer", var ResultSteps: Integer)

Parameters

Name Type Description
DimType Enum Microsoft.Finance.GeneralLedger.Budget."G/L Budget Matrix Dimensions"
Steps Integer
DimensionCodeBuffer Table Microsoft.Finance.Dimension."Dimension Code Buffer"
ResultSteps Integer

OnAfterSetCommonFilters

[IntegrationEvent(False,False)]
local procedure OnAfterSetCommonFilters(var TheGLAccBudgetBuffer: Record "G/L Acc. Budget Buffer")

Parameters

Name Type Description
TheGLAccBudgetBuffer Table Microsoft.Finance.Analysis."G/L Acc. Budget Buffer"

OnAfterSetDimFilters

[IntegrationEvent(False,False)]
local procedure OnAfterSetDimFilters(var TheGLAccBudgetBuffer: Record "G/L Acc. Budget Buffer", DimType: Enum "G/L Budget Matrix Dimensions", DimCodeBuf: Record "Dimension Code Buffer")

Parameters

Name Type Description
TheGLAccBudgetBuffer Table Microsoft.Finance.Analysis."G/L Acc. Budget Buffer"
DimType Enum Microsoft.Finance.GeneralLedger.Budget."G/L Budget Matrix Dimensions"
DimCodeBuf Table Microsoft.Finance.Dimension."Dimension Code Buffer"

OnAfterSetIncomeBalanceGLAccFilterOnGLAcc

[IntegrationEvent(False,False)]
local procedure OnAfterSetIncomeBalanceGLAccFilterOnGLAcc(var GLAccount: Record "G/L Account")

Parameters

Name Type Description
GLAccount Table Microsoft.Finance.GeneralLedger.Account."G/L Account"

OnAfterSetDimensionValueFilters

[IntegrationEvent(False,False)]
local procedure OnAfterSetDimensionValueFilters(var DimensionValue: Record "Dimension Value")

Parameters

Name Type Description
DimensionValue Table Microsoft.Finance.Dimension."Dimension Value"

OnAfterUpdateAmount

[IntegrationEvent(True,False)]
local procedure OnAfterUpdateAmount()

OnBeforeUpdateAmount

[IntegrationEvent(True,False)]
local procedure OnBeforeUpdateAmount(MATRIX_ColumnOrdinal: Integer)

Parameters

Name Type Description
MATRIX_ColumnOrdinal Integer

OnBeforeCalcFieldsAndGetBudgetedAmount

[IntegrationEvent(False,False)]
local procedure OnBeforeCalcFieldsAndGetBudgetedAmount(var GLAccBudgetBuffer: Record "G/L Acc. Budget Buffer", var Result: Decimal, var IsHandled: Boolean)

Parameters

Name Type Description
GLAccBudgetBuffer Table Microsoft.Finance.Analysis."G/L Acc. Budget Buffer"
Result Decimal
IsHandled Boolean

OnBeforeCalcFieldsAndSetNewBudgetedAmount

[IntegrationEvent(False,False)]
local procedure OnBeforeCalcFieldsAndSetNewBudgetedAmount(var GLAccBudgetBuf: Record "G/L Acc. Budget Buffer", NewAmount: Decimal, var IsHandled: Boolean)

Parameters

Name Type Description
GLAccBudgetBuf Table Microsoft.Finance.Analysis."G/L Acc. Budget Buffer"
NewAmount Decimal
IsHandled Boolean

OnBudgetDrillDownOnBeforePageRun

[IntegrationEvent(False,False)]
local procedure OnBudgetDrillDownOnBeforePageRun(var GLAccBudgetBuffer: Record "G/L Acc. Budget Buffer", var GLBudgetEntry: Record "G/L Budget Entry", var IsHandled: Boolean)

Parameters

Name Type Description
GLAccBudgetBuffer Table Microsoft.Finance.Analysis."G/L Acc. Budget Buffer"
GLBudgetEntry Table Microsoft.Finance.GeneralLedger.Budget."G/L Budget Entry"
IsHandled Boolean

OnAfterCopyGLAccToBuf

[IntegrationEvent(False,False)]
local procedure OnAfterCopyGLAccToBuf(GLAcc: Record "G/L Account", var DimCodeBuf: Record "Dimension Code Buffer")

Parameters

Name Type Description
GLAcc Table Microsoft.Finance.GeneralLedger.Account."G/L Account"
DimCodeBuf Table Microsoft.Finance.Dimension."Dimension Code Buffer"

OnAfterCopyDimValueToBuf

[IntegrationEvent(False,False)]
local procedure OnAfterCopyDimValueToBuf(DimVal: Record "Dimension Value", var DimCodeBuf: Record "Dimension Code Buffer")

Parameters

Name Type Description
DimVal Table Microsoft.Finance.Dimension."Dimension Value"
DimCodeBuf Table Microsoft.Finance.Dimension."Dimension Code Buffer"

See also