Calculates the cell for the specified Acc. Schedule Line and Column Layout combination.
An additional currency can be calculated using the CalcAddCurr parameter, but this parameter may be ignored if the Column Layout's Show in ACY field is set to true.
procedure CalcCell(var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean): Decimal
procedure CalcGLAcc(var GLAcc: Record "G/L Account", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean): Decimal
procedure CalcCFAccount(var CFAccount: Record "Cash Flow Account", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout"): Decimal
procedure SetGLAccGLEntryFilters(var GLAcc: Record "G/L Account", var GLEntry: Record "G/L Entry", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", UseBusUnitFilter: Boolean, UseDimFilter: Boolean)
procedure SetGLAccGLBudgetEntryFilters(var GLAcc: Record "G/L Account", var GLBudgetEntry: Record "G/L Budget Entry", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", UseBusUnitFilter: Boolean, UseDimFilter: Boolean)
procedure SetGLAccAnalysisViewBudgetEntries(var GLAcc: Record "G/L Account", var AnalysisViewBudgetEntry: Record "Analysis View Budget Entry", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout")
procedure SetGLAccAnalysisViewEntryFilters(var GLAcc: Record "G/L Account", var AnalysisViewEntry: Record "Analysis View Entry", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout")
procedure SetCFAccColumnFilter(var CFAccount: Record "Cash Flow Account", AccSchedLine2: Record "Acc. Schedule Line", var ColumnLayout2: Record "Column Layout")
procedure CalcCostType(var CostType: Record "Cost Type", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean): Decimal
procedure SetCostTypeRowFilters(var CostType: Record "Cost Type", var AccSchedLine2: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout")
procedure SetCostTypeColumnFilters(var CostType: Record "Cost Type", AccSchedLine2: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout")
procedure DrillDownFromOverviewPage(TempColumnLayout: Record "Column Layout" temporary, var AccScheduleLine: Record "Acc. Schedule Line", PeriodLength: Option)
[IntegrationEvent(False,False)]
local procedure OnBeforeCalcColumnHeader(var AccSchedLine: Record "Acc. Schedule Line", ColumnLayout: Record "Column Layout", var NewColumnHeader: Text, var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnCalcColumnHeaderElseCase(var AccSchedLine: Record "Acc. Schedule Line", ColumnLayout: Record "Column Layout", FromDate: Date, ToDate: Date, var DateText: Text, var IsHandled: Boolean)
[IntegrationEvent(True,False)]
local procedure OnAfterCalcCellValue(var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", var Result: Decimal, var SourceAccScheduleLine: Record "Acc. Schedule Line", var GLAcc: Record "G/L Account")
[IntegrationEvent(False,False)]
local procedure OnAfterCheckAnalysisView(AccSchedName: Record "Acc. Schedule Name", ColumnLayoutName: Record "Column Layout Name", var AnalysisView: Record "Analysis View")
[IntegrationEvent(False,False)]
local procedure OnAfterCheckName(CurrentScheduleName: Code[10])
Parameters
Name
Type
Description
CurrentScheduleName
Code[10]
OnAfterCheckColumnName
[IntegrationEvent(False,False)]
local procedure OnAfterCheckColumnName(CurrentColumnName: Code[10])
Parameters
Name
Type
Description
CurrentColumnName
Code[10]
OnAfterCheckTemplateAndSetFilter
[IntegrationEvent(False,False)]
local procedure OnAfterCheckTemplateAndSetFilter(var CurrentScheduleName: Code[10], var AccScheduleLine: Record "Acc. Schedule Line")
[IntegrationEvent(False,False)]
local procedure OnAfterHasDimFilter(var AccScheduleLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", var Result: Boolean)
[IntegrationEvent(False,False)]
local procedure OnAfterFormatCellAsText(var ColumnLayout2: Record "Column Layout", var ValueAsText: Text[30], Value: Decimal)
[IntegrationEvent(False,False)]
local procedure OnAfterSetGLAccRowFilters(var GLAccount: Record "G/L Account", var AccScheduleLine: Record "Acc. Schedule Line")
[IntegrationEvent(False,False)]
local procedure OnAfterSetCFAccRowFilter(var CashFlowAccount: Record "Cash Flow Account", var AccScheduleLine: Record "Acc. Schedule Line")
[IntegrationEvent(False,False)]
local procedure OnAfterSetCFAnalysisViewEntryFilters(var AnalysisViewEntry: Record "Analysis View Entry", var AccScheduleLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout")
[IntegrationEvent(False,False)]
local procedure OnAfterSetGLAccColumnFilters(var GLAccount: Record "G/L Account", var AccScheduleLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", StartDate: Date, EndDate: Date)
[IntegrationEvent(False,False)]
local procedure OnAfterSetCFAccColumnFilter(var CashFlowAccount: Record "Cash Flow Account", var AccScheduleLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", StartDate: Date, EndDate: Date)
[IntegrationEvent(False,False)]
local procedure OnAfterSetCostTypeColumnFilters(var CostType: Record "Cost Type", var AccScheduleLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout")
[IntegrationEvent(False,False)]
local procedure OnAfterSetGLAccGLEntryFilters(var GLAccount: Record "G/L Account", var GLEntry: Record "G/L Entry", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", UseBusUnitFilter: Boolean, UseDimFilter: Boolean)
[IntegrationEvent(False,False)]
local procedure OnAfterSetGLAccGLBudgetEntryFilters(var GLAcc: Record "G/L Account", var GLBudgetEntry: Record "G/L Budget Entry", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", UseBusUnitFilter: Boolean, UseDimFilter: Boolean)
[IntegrationEvent(False,False)]
local procedure OnAfterSetGLAccAnalysisViewEntryFilters(var GLAcc: Record "G/L Account", var AnalysisViewEntry: Record "Analysis View Entry", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout")
[IntegrationEvent(False,False)]
local procedure OnAfterSetGLAccAnalysisViewBudgetEntries(var GLAcc: Record "G/L Account", var AnalysisViewBudgetEntry: Record "Analysis View Budget Entry", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout")
[IntegrationEvent(False,False)]
local procedure OnAfterSetCostEntryFilters(var CostType: Record "Cost Type", var CostEntry: Record "Cost Entry", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", UseDimFilter: Boolean)
[IntegrationEvent(False,False)]
local procedure OnAfterSetCostTypeRowFilters(var CostType: Record "Cost Type", var AccSchedLine2: Record "Acc. Schedule Line")
[IntegrationEvent(False,False)]
local procedure OnAfterSetCostBudgetEntryFilters(var CostType: Record "Cost Type", var CostBudgetEntry: Record "Cost Budget Entry", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout")
[IntegrationEvent(False,False)]
local procedure OnBeforeCalcCell(var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean, var Result: Decimal, var IsHandled: Boolean)
[IntegrationEvent(True,False)]
local procedure OnBeforeCalcCellExit(var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean, var Result: Decimal)
[IntegrationEvent(True,False)]
local procedure OnBeforeCalcCellValue(var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", var CalcAddCurr: Boolean, var Result: Decimal, var IsHandled: Boolean, AccountScheduleLine: Record "Acc. Schedule Line", var TempAccSchedCellValue: Record "Acc. Sched. Cell Value" temporary)
[IntegrationEvent(True,False)]
local procedure OnBeforeCalcGLAcc(var GLAcc: Record "G/L Account", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean, var ColValue: Decimal, var IsHandled: Boolean)
[IntegrationEvent(True,False)]
local procedure OnBeforeCalcCFAcc(var CFAccount: Record "Cash Flow Account", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", var ColValue: Decimal, var IsHandled: Boolean)
[IntegrationEvent(True,False)]
local procedure OnBeforeCalcCostType(var CostType: Record "Cost Type", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean, var ColValue: Decimal, var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnBeforeCopyColumnsToTemp(NewColumnName: Code[10], var TempColumnLayout: Record "Column Layout", var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnBeforeFormatCellResult(AccSchedLine: Record "Acc. Schedule Line", ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean, var Result: Decimal, var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnBeforeEvaluateExpression(var AccScheduleLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", var MaxLevel: Integer)
[IntegrationEvent(False,False)]
local procedure OnBeforeLookupColumnName(CurrentColumnName: Code[10], var EntrdColumnName: Text[10], var Result: Boolean, var IsHandled: Boolean)
Parameters
Name
Type
Description
CurrentColumnName
Code[10]
EntrdColumnName
Text[10]
Result
Boolean
IsHandled
Boolean
OnBeforeGetCostAccSetup
[IntegrationEvent(False,False)]
local procedure OnBeforeGetCostAccSetup(var CostAccSetup: Record "Cost Accounting Setup", var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnBeforeIsExpressionFilter(Expression: Text, var Result: Boolean, var IsHandled: Boolean)
Parameters
Name
Type
Description
Expression
Text
Result
Boolean
IsHandled
Boolean
OnBeforeDrillDown
[IntegrationEvent(False,False)]
local procedure OnBeforeDrillDown(TempColumnLayout: Record "Column Layout" temporary, var AccScheduleLine: Record "Acc. Schedule Line", PeriodLength: Option, var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnBeforeTestBalance(var GLAccount: Record "G/L Account", var AccScheduleName: Record "Acc. Schedule Name", var AccScheduleLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", AmountType: Integer, var ColValue: Decimal, CalcAddCurr: Boolean, var TestBalance: Boolean, var GLEntry: Record "G/L Entry", var GLBudgetEntry: Record "G/L Budget Entry", var Balance: Decimal)
[IntegrationEvent(False,False)]
local procedure OnBeforeDrillDownFromOverviewPage(var TempColumnLayout: Record "Column Layout" temporary, var AccScheduleLine: Record "Acc. Schedule Line", PeriodLength: Option, var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnBeforeDrillDownOnGLAccount(var TempColumnLayout: Record "Column Layout" temporary, var AccScheduleLine: Record "Acc. Schedule Line", var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnBeforeSetGLAccRowFilters(var GLAcc: Record "G/L Account", var AccSchedLine2: Record "Acc. Schedule Line", var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnBeforeSetCFAccRowFilter(var CFAccount: Record "Cash Flow Account", var AccSchedLine2: Record "Acc. Schedule Line", var IsHandled: Boolean)
[IntegrationEvent(True,False)]
local procedure OnBeforeSetGLAccGLEntryFilters(var GLAcc: Record "G/L Account", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", UseBusUnitFilter: Boolean, UseDimFilter: Boolean, var IsHandled: Boolean, var GLEntry: Record "G/L Entry")
[IntegrationEvent(False,False)]
local procedure OnBeforeSetGLAccGLBudgetEntryFilters(var GLAcc: Record "G/L Account", var GLBudgetEntry: Record "G/L Budget Entry", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", UseBusUnitFilter: Boolean, UseDimFilter: Boolean, var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnCalcCellValueOnBeforeExit(var AccScheduleLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean, StartDate: Date, EndDate: Date, var Result: Decimal)
[IntegrationEvent(True,False)]
local procedure OnCalcCellValueOnElseTotalingType(AccSchedLine: Record "Acc. Schedule Line", AccountScheduleLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", var Result: Decimal)
[IntegrationEvent(False,False)]
local procedure OnConvDimTotalingFilterOnDimNoElseCase(DimNo: Integer, var DimCode: Code[20], AnalysisView: Record "Analysis View", CostAccountingSetup: Record "Cost Accounting Setup")
[IntegrationEvent(False,False)]
local procedure OnDrillDownOnGLAccountOnBeforeCopyFiltersEmptyAnalysisViewName(var AccScheduleLine: Record "Acc. Schedule Line", var TempColumnLayout: Record "Column Layout", var GLAcc: Record "G/L Account")
[IntegrationEvent(False,False)]
local procedure OnDrillDownOnGLAccountOnBeforeCopyFiltersWithAnalysisView(var AccScheduleLine: Record "Acc. Schedule Line", var TempColumnLayout: Record "Column Layout", var GLAcc: Record "G/L Account", var GLAccAnalysisView: Record "G/L Account (Analysis View)")
[IntegrationEvent(False,False)]
local procedure OnEvaluateExpressionOnBeforeCalcAccSchedLineCellValue(SourceAccSchedLine: Record "Acc. Schedule Line", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean, var IsHandled: Boolean, var CellValue: Decimal)
[IntegrationEvent(False,False)]
local procedure OnEvaluateExpressionOnBeforeCalcColumnLayoutCellValue(SourceColumnLayout: Record "Column Layout", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean, var IsHandled: Boolean, var CellValue: Decimal)
[IntegrationEvent(False,False)]
local procedure OnInsertGLAccountsOnBeforeAccSchedLineInsert(var AccSchedLine: Record "Acc. Schedule Line", GLAccount: Record "G/L Account")
[IntegrationEvent(False,False)]
local procedure OnCalcCellValueInAccSchedLinesOnBeforeShowError(SourceAccScheduleLine: Record "Acc. Schedule Line", var AccScheduleLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", CalcAddCurr: Boolean, var CellValue: Decimal, StartDate: Date, EndDate: Date, var Result: Decimal, var IsHandled: Boolean, Expression: Text, var DivisionError: Boolean, var PeriodError: Boolean)
[IntegrationEvent(False,False)]
local procedure OnSetGLAccAnalysisViewEntryFiltersOnBeforeAccSchedLineCopyFilter(var AccScheduleLine: Record "Acc. Schedule Line", AnalysisViewEntry: Record "Analysis View Entry")
[IntegrationEvent(False,False)]
local procedure OnCopyColumnsToTempOnAfterColumnLayoutInsert(AccSchedName: Record "Acc. Schedule Name", NewColumnName: Code[10], ColumnLayout: Record "Column Layout", var TempColumnLayout: Record "Column Layout" temporary)
[IntegrationEvent(False,False)]
local procedure OnAfterCheckTemplateName(CurrentSchedName: Code[10])
Parameters
Name
Type
Description
CurrentSchedName
Code[10]
OnCopyColumnsToTempOnBeforeFind
[IntegrationEvent(False,False)]
local procedure OnCopyColumnsToTempOnBeforeFind(AccSchedName: Record "Acc. Schedule Name", NewColumnName: Code[10], var TempColumnLayout: Record "Column Layout" temporary)
[IntegrationEvent(True,False)]
local procedure OnDrillDownTotalingTypeElseCase(var TempColumnLayout: Record "Column Layout" temporary, var AccSchedLine: Record "Acc. Schedule Line")
[IntegrationEvent(False,False)]
local procedure OnDrillDownOnGLAccCatFilterOnAfterGLAccSetFilterGroup2(var AccScheduleLine: Record "Acc. Schedule Line", var GLAccount: Record "G/L Account")
[IntegrationEvent(False,False)]
local procedure OnAfterCalcColumnDates(ColumnLayout: Record "Column Layout", var FromDate: Date, var ToDate: Date, var FiscalStartDate2: Date, var PeriodError: Boolean)
[IntegrationEvent(False,False)]
local procedure OnBeforeHasCostDimFilter(var AccScheduleLine: Record "Acc. Schedule Line", var Result: Boolean, var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnCalcCellOnAfterAccountScheduleLineCopyFilters(ColumnLayout: Record "Column Layout", var AccScheduleLine: Record "Acc. Schedule Line")
[IntegrationEvent(False,False)]
local procedure OnSetCFEntryFiltersOnAfterAccShedLineCopyFilter(var AccSchedLine: Record "Acc. Schedule Line", var CFForecastEntry: Record "Cash Flow Forecast Entry")
[IntegrationEvent(False,False)]
local procedure OnBeforeFormatCellAsText(var ColumnLayout2: Record "Column Layout", Value: Decimal, var IsHandled: Boolean)
[IntegrationEvent(False,False)]
local procedure OnCalcCFAccountOnAfterSetEntryFilters(var CFAccount: Record "Cash Flow Account", var AccSchedLine: Record "Acc. Schedule Line", var ColumnLayout: Record "Column Layout", var ColValue: Decimal)