---
id: object/report/840
type: object
title: Report 840 "Suggest Worksheet Lines"
summary: Report 840 "Suggest Worksheet Lines" in Base Application (Microsoft.CashFlow.Worksheet). 8 public procedures, 20 events. Present since at least BC23, still in BC30, changed in BC24-26.
tier: official
language: en
tags:
  - report
  - base application
versions:
  introduced: null
  last_changed: "26"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 06d0bc96727315f8a990b8f41a4adc352b5707fca640ba600288c7398f1f0e92
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/CashFlow/Worksheet/SuggestWorksheetLines.Report.al
    title: src/Layers/W1/BaseApp/CashFlow/Worksheet/SuggestWorksheetLines.Report.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations:
    - localization/be
    - localization/es
  videos: []
  posts: []
  guidelines: []
object_type: report
object_id: 840
name: Suggest Worksheet Lines
namespace: Microsoft.CashFlow.Worksheet
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "25"
  - "26"
source_major: "29"
obsolete: null
countries:
  - be
  - es
ms_search_form_ids: []
counts:
  fields: 0
  procedures: 64
  events: 20
  subscribers: 0
relations:
  out: 0
  referenced_by: 0
  pages: 0
  extended_by: 1
  event_subscribers: 0
  calls: 1
  called_by: 0
  implements: 0
---

# Report 840 "Suggest Worksheet Lines"

> Report 840 "Suggest Worksheet Lines" in Base Application (Microsoft.CashFlow.Worksheet). 8 public procedures, 20 events. Present since at least BC23, still in BC30, changed in BC24-26.

Base Application · Microsoft.CashFlow.Worksheet · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/CashFlow/Worksheet/SuggestWorksheetLines.Report.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Suggest Worksheet Lines |
| Permissions | TableData "Dimension Set ID Filter Line" = rimd, TableData "Cash Flow Forecast Entry" = rimd |

## Events published

- `OnCFAccountForBudgetOnAfterGetRecordOnAfterGLBudgEntrySetFilters(var GLBudgEntry: Record "G/L Budget Entry")` (integration)
- `OnGetTaxPayableDateFromSourceOnBeforeExit(SourceTableNum: Integer; SalesHeader: Record "Sales Header"; PurchaseHeader: Record "Purchase Header"; VATEntry: Record "VAT Entry"; var DocumentDate: Date)` (integration)
- `OnInsertCFLineForCustLedgerEntryOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; CustLedgerEntry: Record "Cust. Ledger Entry")` (integration)
- `OnBeforeSetCashFlowDate(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; var IsHandled: Boolean; SelectionCashFlowForecast: Record "Cash Flow Forecast")` (integration)
- `OnBeforeNoOptionsChosen(var Result: Boolean; var IsHandled: Boolean)` (integration)
- `OnJobPlanningLineOnAfterGetRecordOnBeforeInsertCFLineForJobPlanningLine(JobPlanningLine: Record "Job Planning Line")` (integration)
- `OnAfterGetRecursiveLimit(var Limit: Integer)` (integration)
- `OnAfterInitializeRequest(var ConsiderSource: array[16] of Boolean; var CashFlowNo: Code[20]; var GLBudgName: Code[10]; var Summarized: Boolean)` (integration)
- `OnAfterInitCFLineForFixedAssetsBudget(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; FADepreciationBook: Record "FA Depreciation Book"; InvestmentFixedAsset: Record "Fixed Asset")` (integration)
- `OnInsertTempCFWorksheetLineOnBeforeCalculateCFAmountAndCFDate(var TempCashFlowWorksheetLine: Record "Cash Flow Worksheet Line" temporary; var IsHandled: Boolean)` (integration)
- `OnInsertCFLineForPurchaseLineOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; var PurchaseHeader: Record "Purchase Header"; var PurchaseLine: Record "Purchase Line")` (integration)
- `OnInsertCFLineForManualRevenueOnBeforeInsertManualData(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; CashFlowManualRevenue: Record "Cash Flow Manual Revenue")` (integration)
- `OnInsertCFLineForManualExpenseOnBeforeInsertManualData(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; CashFlowManualExpense: Record "Cash Flow Manual Expense")` (integration)
- `OnInsertCFLineForJobPlanningLineOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; Job: Record Job; CashFlowForecast: Record "Cash Flow Forecast"; JobPlanningLine: Record "Job Planning Line")` (integration)
- `OnAfterGetTaxAmountFromSource(SourceTableNum: Integer; SalesHeader: Record "Sales Header"; PurchaseHeader: Record "Purchase Header"; VATEntry: Record "VAT Entry"; var TaxAmount: Decimal)` (integration)
- `OnInsertCFLineForFixedAssetsDisposalOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; SaleFixedAsset: Record "Fixed Asset")` (integration)
- `OnInsertCFLineForSalesLineOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; SalesLine: Record "Sales Line")` (integration)
- `OnInsertCFLineForVendorLedgEntryOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; VendorLedgerEntry: Record "Vendor Ledger Entry")` (integration)
- `OnInsertCFLineForGLAccountOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; CashFlowAccount: Record "Cash Flow Account")` (integration)
- `OnDeleteEntriesOnBeforeDeleteAllCashFlowForecastEntry(var CashFlowForecastEntry: Record "Cash Flow Forecast Entry"; var TempCashFlowForecast: Record "Cash Flow Forecast" temporary)` (integration)

## Procedures

- `InsertTempCFWorksheetLine(CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; MaxPmtTolerance: Decimal)`
- `InsertCFLineForTax(SourceTableNum: Integer)`
- `GetSubPostingGLAccounts(var GLAccount: Record "G/L Account"; var TempGLAccount: Record "G/L Account" temporary)`
- `SetCashFlowDate(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowDate: Date)`
- `InitializeRequest(NewConsiderSource: array[16] of Boolean; CFNo: Code[20]; NewGLBudgetName: Code[10]; GroupByDocumentType: Boolean)`
- `ClearCircularRefData()`
- `SetSummarized(NewSummarized: Boolean)`
- `GetSummarized(): Boolean`

Plus 36 local procedures.

## Triggers

OnPreReport

## Extended by

- [Report extension 6485 "Serv. Suggest Worksheet Lines"](../reportextension/6485.md)

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 841 "Cash Flow Management"](../codeunit/841.md) (2 calls: `GetTaxAmountFromSource → GetTaxAmountFromPurchaseOrder`, `GetTaxAmountFromSource → GetTaxAmountFromSalesOrder`)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24-26

## Countries that replace it

[BE](../../localizations/be.md), [ES](../../localizations/es.md)

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "report", object_name: "Suggest Worksheet Lines")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.