Report "Suggest Worksheet Lines"

ID 840
Namespace: Microsoft.CashFlow.Worksheet

Properties

Name Value
Caption Suggest Worksheet Lines
Permissions TableData "Dimension Set ID Filter Line" = rimd, TableData "Cash Flow Forecast Entry" = rimd
ProcessingOnly True

Methods

InsertTempCFWorksheetLine

procedure InsertTempCFWorksheetLine(CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", MaxPmtTolerance: Decimal)

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
MaxPmtTolerance Decimal

InsertCFLineForTax

procedure InsertCFLineForTax(SourceTableNum: Integer)

Parameters

Name Type Description
SourceTableNum Integer

GetSubPostingGLAccounts

procedure GetSubPostingGLAccounts(var GLAccount: Record "G/L Account", var TempGLAccount: Record "G/L Account" temporary)

Parameters

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

SetCashFlowDate

procedure SetCashFlowDate(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", CashFlowDate: Date)

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
CashFlowDate Date

InitializeRequest

procedure InitializeRequest(NewConsiderSource: array[16] of Boolean, CFNo: Code[20], NewGLBudgetName: Code[10], GroupByDocumentType: Boolean)

Parameters

Name Type Description
NewConsiderSource array[16] of Boolean
CFNo Code[20]
NewGLBudgetName Code[10]
GroupByDocumentType Boolean

ClearCircularRefData

procedure ClearCircularRefData()

SetSummarized

procedure SetSummarized(NewSummarized: Boolean)

Parameters

Name Type Description
NewSummarized Boolean

GetSummarized

procedure GetSummarized(): Boolean

Returns

Type Description
Boolean

Events

OnCFAccountForBudgetOnAfterGetRecordOnAfterGLBudgEntrySetFilters

[IntegrationEvent(False,False)]
local procedure OnCFAccountForBudgetOnAfterGetRecordOnAfterGLBudgEntrySetFilters(var GLBudgEntry: Record "G/L Budget Entry")

Parameters

Name Type Description
GLBudgEntry Table Microsoft.Finance.GeneralLedger.Budget."G/L Budget Entry"

OnGetTaxPayableDateFromSourceOnBeforeExit

[IntegrationEvent(False,False)]
local procedure OnGetTaxPayableDateFromSourceOnBeforeExit(SourceTableNum: Integer, SalesHeader: Record "Sales Header", PurchaseHeader: Record "Purchase Header", VATEntry: Record "VAT Entry", var DocumentDate: Date)

Parameters

Name Type Description
SourceTableNum Integer
SalesHeader Table Microsoft.Sales.Document."Sales Header"
PurchaseHeader Table Microsoft.Purchases.Document."Purchase Header"
VATEntry Table Microsoft.Finance.VAT.Ledger."VAT Entry"
DocumentDate Date

OnInsertCFLineForCustLedgerEntryOnBeforeInsertTempCFWorksheetLine

[IntegrationEvent(False,False)]
local procedure OnInsertCFLineForCustLedgerEntryOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", CashFlowForecast: Record "Cash Flow Forecast", CustLedgerEntry: Record "Cust. Ledger Entry")

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
CashFlowForecast Table Microsoft.CashFlow.Forecast."Cash Flow Forecast"
CustLedgerEntry Table Microsoft.Sales.Receivables."Cust. Ledger Entry"

OnBeforeSetCashFlowDate

[IntegrationEvent(False,False)]
local procedure OnBeforeSetCashFlowDate(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", var IsHandled: Boolean, SelectionCashFlowForecast: Record "Cash Flow Forecast")

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
IsHandled Boolean
SelectionCashFlowForecast Table Microsoft.CashFlow.Forecast."Cash Flow Forecast"

OnBeforeNoOptionsChosen

[IntegrationEvent(False,False)]
local procedure OnBeforeNoOptionsChosen(var Result: Boolean, var IsHandled: Boolean)

Parameters

Name Type Description
Result Boolean
IsHandled Boolean

OnJobPlanningLineOnAfterGetRecordOnBeforeInsertCFLineForJobPlanningLine

[IntegrationEvent(False,False)]
local procedure OnJobPlanningLineOnAfterGetRecordOnBeforeInsertCFLineForJobPlanningLine(JobPlanningLine: Record "Job Planning Line")

Parameters

Name Type Description
JobPlanningLine Table Microsoft.Projects.Project.Planning."Job Planning Line"

OnAfterGetRecursiveLimit

[IntegrationEvent(False,False)]
local procedure OnAfterGetRecursiveLimit(var Limit: Integer)

Parameters

Name Type Description
Limit Integer

OnAfterInitializeRequest

[IntegrationEvent(False,False)]
local procedure OnAfterInitializeRequest(var ConsiderSource: array[16] of Boolean, var CashFlowNo: Code[20], var GLBudgName: Code[10], var Summarized: Boolean)

Parameters

Name Type Description
ConsiderSource array[16] of Boolean
CashFlowNo Code[20]
GLBudgName Code[10]
Summarized Boolean

OnAfterInitCFLineForFixedAssetsBudget

[IntegrationEvent(False,False)]
local procedure OnAfterInitCFLineForFixedAssetsBudget(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", FADepreciationBook: Record "FA Depreciation Book", InvestmentFixedAsset: Record "Fixed Asset")

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
FADepreciationBook Table Microsoft.FixedAssets.Depreciation."FA Depreciation Book"
InvestmentFixedAsset Table Microsoft.FixedAssets.FixedAsset."Fixed Asset"

OnInsertTempCFWorksheetLineOnBeforeCalculateCFAmountAndCFDate

[IntegrationEvent(False,False)]
local procedure OnInsertTempCFWorksheetLineOnBeforeCalculateCFAmountAndCFDate(var TempCashFlowWorksheetLine: Record "Cash Flow Worksheet Line" temporary, var IsHandled: Boolean)

Parameters

Name Type Description
TempCashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
IsHandled Boolean

OnInsertCFLineForPurchaseLineOnBeforeInsertTempCFWorksheetLine

[IntegrationEvent(False,False)]
local procedure OnInsertCFLineForPurchaseLineOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", var PurchaseHeader: Record "Purchase Header", var PurchaseLine: Record "Purchase Line")

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
PurchaseHeader Table Microsoft.Purchases.Document."Purchase Header"
PurchaseLine Table Microsoft.Purchases.Document."Purchase Line"

OnInsertCFLineForManualRevenueOnBeforeInsertManualData

[IntegrationEvent(False,False)]
local procedure OnInsertCFLineForManualRevenueOnBeforeInsertManualData(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", CashFlowForecast: Record "Cash Flow Forecast", CashFlowManualRevenue: Record "Cash Flow Manual Revenue")

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
CashFlowForecast Table Microsoft.CashFlow.Forecast."Cash Flow Forecast"
CashFlowManualRevenue Table Microsoft.CashFlow.Setup."Cash Flow Manual Revenue"

OnInsertCFLineForManualExpenseOnBeforeInsertManualData

[IntegrationEvent(False,False)]
local procedure OnInsertCFLineForManualExpenseOnBeforeInsertManualData(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", CashFlowForecast: Record "Cash Flow Forecast", CashFlowManualExpense: Record "Cash Flow Manual Expense")

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
CashFlowForecast Table Microsoft.CashFlow.Forecast."Cash Flow Forecast"
CashFlowManualExpense Table Microsoft.CashFlow.Setup."Cash Flow Manual Expense"

OnInsertCFLineForJobPlanningLineOnBeforeInsertTempCFWorksheetLine

[IntegrationEvent(False,False)]
local procedure OnInsertCFLineForJobPlanningLineOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", Job: Record Job, CashFlowForecast: Record "Cash Flow Forecast", JobPlanningLine: Record "Job Planning Line")

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
Job Table Microsoft.Projects.Project.Job.Job
CashFlowForecast Table Microsoft.CashFlow.Forecast."Cash Flow Forecast"
JobPlanningLine Table Microsoft.Projects.Project.Planning."Job Planning Line"

OnAfterGetTaxAmountFromSource

[IntegrationEvent(False,False)]
local procedure OnAfterGetTaxAmountFromSource(SourceTableNum: Integer, SalesHeader: Record "Sales Header", PurchaseHeader: Record "Purchase Header", VATEntry: Record "VAT Entry", var TaxAmount: Decimal)

Parameters

Name Type Description
SourceTableNum Integer
SalesHeader Table Microsoft.Sales.Document."Sales Header"
PurchaseHeader Table Microsoft.Purchases.Document."Purchase Header"
VATEntry Table Microsoft.Finance.VAT.Ledger."VAT Entry"
TaxAmount Decimal

OnInsertCFLineForFixedAssetsDisposalOnBeforeInsertTempCFWorksheetLine

[IntegrationEvent(False,False)]
local procedure OnInsertCFLineForFixedAssetsDisposalOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", CashFlowForecast: Record "Cash Flow Forecast", SaleFixedAsset: Record "Fixed Asset")

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
CashFlowForecast Table Microsoft.CashFlow.Forecast."Cash Flow Forecast"
SaleFixedAsset Table Microsoft.FixedAssets.FixedAsset."Fixed Asset"

OnInsertCFLineForSalesLineOnBeforeInsertTempCFWorksheetLine

[IntegrationEvent(False,False)]
local procedure OnInsertCFLineForSalesLineOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", CashFlowForecast: Record "Cash Flow Forecast", SalesLine: Record "Sales Line")

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
CashFlowForecast Table Microsoft.CashFlow.Forecast."Cash Flow Forecast"
SalesLine Table Microsoft.Sales.Document."Sales Line"

OnInsertCFLineForVendorLedgEntryOnBeforeInsertTempCFWorksheetLine

[IntegrationEvent(False,False)]
local procedure OnInsertCFLineForVendorLedgEntryOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", CashFlowForecast: Record "Cash Flow Forecast", VendorLedgerEntry: Record "Vendor Ledger Entry")

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
CashFlowForecast Table Microsoft.CashFlow.Forecast."Cash Flow Forecast"
VendorLedgerEntry Table Microsoft.Purchases.Payables."Vendor Ledger Entry"

OnInsertCFLineForGLAccountOnBeforeInsertTempCFWorksheetLine

[IntegrationEvent(False,False)]
local procedure OnInsertCFLineForGLAccountOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line", CashFlowForecast: Record "Cash Flow Forecast", CashFlowAccount: Record "Cash Flow Account")

Parameters

Name Type Description
CashFlowWorksheetLine Table Microsoft.CashFlow.Worksheet."Cash Flow Worksheet Line"
CashFlowForecast Table Microsoft.CashFlow.Forecast."Cash Flow Forecast"
CashFlowAccount Table Microsoft.CashFlow.Account."Cash Flow Account"

OnDeleteEntriesOnBeforeDeleteAllCashFlowForecastEntry

[IntegrationEvent(True,False)]
local procedure OnDeleteEntriesOnBeforeDeleteAllCashFlowForecastEntry(var CashFlowForecastEntry: Record "Cash Flow Forecast Entry", var TempCashFlowForecast: Record "Cash Flow Forecast" temporary)

Parameters

Name Type Description
CashFlowForecastEntry Table Microsoft.CashFlow.Forecast."Cash Flow Forecast Entry"
TempCashFlowForecast Table Microsoft.CashFlow.Forecast."Cash Flow Forecast"

See also