Page "Acc. Schedule Overview"

ID 490
Namespace: Microsoft.Finance.FinancialReports

On this page, you can run a financial report and see data based on filter values. You can also export the data to Excel or get a PDF version (or print it). When the page is in "Edit mode", you can also change the report definition, such as the choice of column and row definitions used.

Properties

Name Value
AboutTitle About financial report
AboutText On this page, you can run a financial report and see data based on filter values. You can also export the data to Excel or get a PDF version (or print it). When the page is in "Edit mode", you can also change the report definition, such as the choice of column and row definitions used.
Caption Financial Report
DeleteAllowed False
InsertAllowed False
LinksAllowed False
ModifyAllowed False
PageType List
SaveValues True
ShowFilter False
SourceTable Table Microsoft.Finance.FinancialReports."Acc. Schedule Line"
RefreshOnActivate True
UsageCategory None

Methods

SetFinancialReportName

procedure SetFinancialReportName(NewFinancialReport: Code[10])

Parameters

Name Type Description
NewFinancialReport Code[10]

SetColumnDefinition

procedure SetColumnDefinition(ColumnLayoutName: Code[10])

Parameters

Name Type Description
ColumnLayoutName Code[10]

SetAccSchedName

procedure SetAccSchedName(NewAccSchedName: Code[10])

Parameters

Name Type Description
NewAccSchedName Code[10]

SetPeriodType

procedure SetPeriodType(NewPeriodType: Option)

Parameters

Name Type Description
NewPeriodType Option

SetViewOnlyMode

procedure SetViewOnlyMode(NewViewOnlyMode: Boolean)

Parameters

Name Type Description
NewViewOnlyMode Boolean

SetDimFilters

procedure SetDimFilters(DimNo: Integer, DimValueFilter: Text)

Parameters

Name Type Description
DimNo Integer
DimValueFilter Text

FormatStr

procedure FormatStr(ColumnNo: Integer): Text

Parameters

Name Type Description
ColumnNo Integer

Returns

Type Description
Text

RoundIfNotNone

procedure RoundIfNotNone(Value: Decimal, RoundingFactor: Enum "Analysis Rounding Factor"): Decimal

Parameters

Name Type Description
Value Decimal
RoundingFactor Enum Microsoft.Foundation.Enums."Analysis Rounding Factor"

Returns

Type Description
Decimal

Events

OnAfterSetDimFilters

[IntegrationEvent(False,False)]
local procedure OnAfterSetDimFilters(var AccScheduleLine: Record "Acc. Schedule Line", var DimNo: Integer, var DimValueFilter: Text, var CostCenterFilter: Text, var CostObjectFilter: Text, var CurrentCostBudgetFilter: Text, var CurrentGLBudgetFilter: Text, var CurrentCashFlowFilter: Text, AnalysisView: Record "Analysis View", var TempFinancialReport: Record "Financial Report" temporary)

Parameters

Name Type Description
AccScheduleLine Table Microsoft.Finance.FinancialReports."Acc. Schedule Line"
DimNo Integer
DimValueFilter Text
CostCenterFilter Text
CostObjectFilter Text
CurrentCostBudgetFilter Text
CurrentGLBudgetFilter Text
CurrentCashFlowFilter Text
AnalysisView Table Microsoft.Finance.Analysis."Analysis View"
TempFinancialReport Table Microsoft.Finance.FinancialReports."Financial Report"

OnAfterValidateCostCenterFilter

[IntegrationEvent(False,False)]
local procedure OnAfterValidateCostCenterFilter(var AccScheduleLine: Record "Acc. Schedule Line", var CostCenterFilter: Text, var Dim1Filter: Text)

Parameters

Name Type Description
AccScheduleLine Table Microsoft.Finance.FinancialReports."Acc. Schedule Line"
CostCenterFilter Text
Dim1Filter Text

OnAfterValidateCostObjectFilter

[IntegrationEvent(False,False)]
local procedure OnAfterValidateCostObjectFilter(var AccScheduleLine: Record "Acc. Schedule Line", var CostObjectFilter: Text, var Dim2Filter: Text)

Parameters

Name Type Description
AccScheduleLine Table Microsoft.Finance.FinancialReports."Acc. Schedule Line"
CostObjectFilter Text
Dim2Filter Text

OnAfterUpdateDimFilterControls

[IntegrationEvent(True,False)]
local procedure OnAfterUpdateDimFilterControls(var Dim4FilterEnable: Boolean)

Parameters

Name Type Description
Dim4FilterEnable Boolean

OnAfterDrillDown

[IntegrationEvent(True,False)]
local procedure OnAfterDrillDown(ColumnNo: Integer, var TempColumnLayout: Record "Column Layout" temporary, var PeriodType: Option)

Parameters

Name Type Description
ColumnNo Integer
TempColumnLayout Table Microsoft.Finance.FinancialReports."Column Layout"
PeriodType Option

OnAfterOnOpenPage

[IntegrationEvent(True,False)]
local procedure OnAfterOnOpenPage(var AccScheduleLine: Record "Acc. Schedule Line", var CurrentColumnName: Code[10])

Parameters

Name Type Description
AccScheduleLine Table Microsoft.Finance.FinancialReports."Acc. Schedule Line"
CurrentColumnName Code[10]

OnOnAfterGetRecordOnAfterAssignColumnValue

[IntegrationEvent(True,False)]
local procedure OnOnAfterGetRecordOnAfterAssignColumnValue(var ColumnValues: array[15] of Decimal, var ColumnNo: Integer, var ColumnOffset: Integer, var TempColumnLayout: Record "Column Layout" temporary, var UseAmtsInAddCurr: Boolean)

Parameters

Name Type Description
ColumnValues array[15] of Decimal
ColumnNo Integer
ColumnOffset Integer
TempColumnLayout Table Microsoft.Finance.FinancialReports."Column Layout"
UseAmtsInAddCurr Boolean

OnBeforePrint

[IntegrationEvent(False,False)]
local procedure OnBeforePrint(var AccScheduleLine: Record "Acc. Schedule Line", ColumnLayoutName: Code[10], var IsHandled: Boolean, var TempFinancialReport: Record "Financial Report" temporary)

Parameters

Name Type Description
AccScheduleLine Table Microsoft.Finance.FinancialReports."Acc. Schedule Line"
ColumnLayoutName Code[10]
IsHandled Boolean
TempFinancialReport Table Microsoft.Finance.FinancialReports."Financial Report"

OnBeforeCurrentColumnNameOnAfterValidate

[IntegrationEvent(False,False)]
local procedure OnBeforeCurrentColumnNameOnAfterValidate(var CurrentColumnName: Code[10])

Parameters

Name Type Description
CurrentColumnName Code[10]

OnBeforeGetCaptionClass

[IntegrationEvent(False,False)]
local procedure OnBeforeGetCaptionClass(AnalysisView: Record "Analysis View", DimNo: Integer, var Result: Text[250], var IsHandled: Boolean)

Parameters

Name Type Description
AnalysisView Table Microsoft.Finance.Analysis."Analysis View"
DimNo Integer
Result Text[250]
IsHandled Boolean

OnBeforeUpdateColumnCaptions

Obsolete

This element will become obsolete from version 27.0. The ColumnCaptions parameter will be changed to array[15] of Text in a future release.

[IntegrationEvent(False,False)]
[Obsolete(The ColumnCaptions parameter will be changed to array[15] of Text in a future release.,27.0)]
local procedure OnBeforeUpdateColumnCaptions(var ColumnCaptions: array[15] of Text[80], ColumnOffset: Integer, var TempColumnLayout: Record "Column Layout" temporary, NoOfColumns: Integer, var IsHandled: Boolean)

Parameters

Name Type Description
ColumnCaptions array[15] of Text[80]
ColumnOffset Integer
TempColumnLayout Table Microsoft.Finance.FinancialReports."Column Layout"
NoOfColumns Integer
IsHandled Boolean

OnBeforeUpdateDimFilterControls

[IntegrationEvent(False,False)]
local procedure OnBeforeUpdateDimFilterControls(var AccScheduleLine: Record "Acc. Schedule Line", AnalysisView: Record "Analysis View", var IsHandled: Boolean)

Parameters

Name Type Description
AccScheduleLine Table Microsoft.Finance.FinancialReports."Acc. Schedule Line"
AnalysisView Table Microsoft.Finance.Analysis."Analysis View"
IsHandled Boolean

OnGetStyleOnBeforeAssignColumnStyle

[IntegrationEvent(True,False)]
local procedure OnGetStyleOnBeforeAssignColumnStyle(AccScheduleLine: Record "Acc. Schedule Line", ColumnNo: Integer, RowLineNo: Integer, ColumnLineNo: Integer, var ColumnStyle: Text, ColumnValues: array[15] of Decimal)

Parameters

Name Type Description
AccScheduleLine Table Microsoft.Finance.FinancialReports."Acc. Schedule Line"
ColumnNo Integer
RowLineNo Integer
ColumnLineNo Integer
ColumnStyle Text
ColumnValues array[15] of Decimal

OnAfterFormatStr

[IntegrationEvent(False,False)]
local procedure OnAfterFormatStr(ColumnLayoutArr: array[15] of Record "Column Layout", UseAmtsInAddCurr: Boolean, ColumnNo: Integer, NegativeAmountFormatting: Enum "Analysis Negative Format", var Result: Text, var IsHandled: Boolean)

Parameters

Name Type Description
ColumnLayoutArr array[15] of Record "Column Layout"
UseAmtsInAddCurr Boolean
ColumnNo Integer
NegativeAmountFormatting Enum Microsoft.Foundation.Enums."Analysis Negative Format"
Result Text
IsHandled Boolean

OnLoadPageStateOnBeforeCopyColumnsToTemp

[IntegrationEvent(False,False)]
local procedure OnLoadPageStateOnBeforeCopyColumnsToTemp(CurrentColumnName: Code[10], var TempColumnLayout: Record "Column Layout" temporary, var CurrentSchedName: Code[10], var AccScheduleLine: Record "Acc. Schedule Line", var IsHandled: Boolean)

Parameters

Name Type Description
CurrentColumnName Code[10]
TempColumnLayout Table Microsoft.Finance.FinancialReports."Column Layout"
CurrentSchedName Code[10]
AccScheduleLine Table Microsoft.Finance.FinancialReports."Acc. Schedule Line"
IsHandled Boolean

See also