---
id: object/report/29
type: object
title: Report 29 "Export Acc. Sched. to Excel"
summary: Report 29 "Export Acc. Sched. to Excel" in Base Application (Microsoft.Finance.FinancialReports). 10 public procedures, 3 events. Present since at least BC23, still in BC30, changed in BC26-28.
tier: official
language: en
tags:
  - report
  - base application
versions:
  introduced: null
  last_changed: "28"
  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: c3ea0244afe4592ba29bf38ca58cd4b057dc93dff569ff21840cc2b49ca0d94f
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/ExportAccSchedtoExcel.Report.al
    title: src/Layers/W1/BaseApp/Finance/FinancialReports/ExportAccSchedtoExcel.Report.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations:
    - localization/ca
    - localization/mx
    - localization/us
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/11574
    - change/bcapps/9906
    - change/bcapps/9129
object_type: report
object_id: 29
name: Export Acc. Sched. to Excel
namespace: Microsoft.Finance.FinancialReports
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "26"
  - "27"
  - "28"
source_major: "29"
obsolete: null
countries:
  - ca
  - mx
  - us
ms_search_form_ids: []
counts:
  fields: 0
  procedures: 24
  events: 3
  subscribers: 0
relations:
  out: 0
  referenced_by: 0
  pages: 0
  extended_by: 0
  event_subscribers: 0
  calls: 5
  called_by: 0
  implements: 0
---

# Report 29 "Export Acc. Sched. to Excel"

> Report 29 "Export Acc. Sched. to Excel" in Base Application (Microsoft.Finance.FinancialReports). 10 public procedures, 3 events. Present since at least BC23, still in BC30, changed in BC26-28.

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

## Properties

| Property | Value |
|---|---|
| Caption | Export Acc. Sched. to Excel |

## Events published

- `OnBeforeCalcColumnValue(var UseAmtsInAddCurr: Boolean; var ColumnLayout: Record "Column Layout")` (integration): Integration event raised before calculating column values during Excel export. Enables custom modification of currency settings and column layout parameters.
- `OnAferCalcColumnValue(var UseAmtsInAddCurr: Boolean; var ColumnLayout: Record "Column Layout")` (integration): Integration event raised after calculating column values during Excel export. Enables custom post-processing of currency settings and calculated column data.
- `OnIntegerOnAfterGetRecordOnAfterAccSchedLineSetFilter(var AccScheduleLine: Record "Acc. Schedule Line")` (integration): Integration event raised after applying filters to account schedule lines during data processing. Enables custom filter modification and additional filter criteria application.

## Procedures

- `SetOptions(var AccSchedLine2: Record "Acc. Schedule Line"; ColumnLayoutName2: Code[10]; UseAmtsInAddCurr2: Boolean)`: Sets account schedule export options including account schedule lines, column layout, and currency settings. Configures the basic export parameters for Excel generation without financial report context.
- `SetOptions(var AccSchedLine2: Record "Acc. Schedule Line"; ColumnLayoutName2: Code[10]; UseAmtsInAddCurr2: Boolean; FinancialReportName: Code[10])`: Sets comprehensive account schedule export options including financial report context. Configures all export parameters for Excel generation with financial report integration.
- `SetOptions(var AccSchedLine2: Record "Acc. Schedule Line"; ColumnLayoutName2: Code[10]; UseAmtsInAddCurr2: Boolean; FinancialReportName: Code[10]; DimPerspectiveNameText: Code[10])`
- `SetUpdateExistingWorksheet(UpdateExistingWorksheet: Boolean)`: Controls whether to update an existing Excel worksheet or create a new one. Enables modification of existing workbooks while preserving non-data content.
- `SetFileNameSilent(NewFileName: Text)`: Sets the output file path for silent Excel export without user interaction. Enables automated export scenarios where file path is predetermined.
- `SetTestMode(NewTestMode: Boolean)`: Enables or disables test mode for Excel export operations. Test mode allows validation and debugging without full file generation.
- `SetUseExistingTemplate(var FinReportExcelTemplate: Record "Fin. Report Excel Template")`: Configures the export to use an existing Excel template for formatting and layout. Enables template-based Excel generation with predefined formatting and structure.
- `SetSaveToStream(NewSaveToStream: Boolean)`: Configures the export to save Excel data to a stream instead of a file. Enables in-memory Excel processing and custom output handling.
- `GetSavedStream(var OutStream: OutStream)`: Retrieves the saved Excel data as an output stream for custom processing. Provides access to generated Excel content for further manipulation or transmission.
- `SetRunForExport()`

Plus 11 local procedures.

## Triggers

OnPreReport, OnPostReport

## 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 419 "File Management"](../codeunit/419.md) (6 calls: `SetUseExistingTemplate → CreateFileNameWithExtension`, `SetUseExistingTemplate → InstreamExportToServerFile`, `UploadClientFile → GetFileName`, …)
- [Codeunit 8 "AccSchedManagement"](../codeunit/8.md) (3 calls: `CalcColumnValue → CalcCell`, `CalcColumnValue → GetDivisionError`, `PopulateExcelBuffer → CalcColumnHeader`)
- [Codeunit 4100 "Temp Blob"](../codeunit/4100.md) (1 call: `UploadExistingTemplate → CreateInStream`)
- [Codeunit 8390 "Financial Report Auditing"](../codeunit/8390.md) (1 call: `OnPostReport → LogReportUsage`)
- [Codeunit 9200 "Matrix Management"](../codeunit/9200.md) (1 call: `PopulateExcelBuffer → FormatAmount`)

## Recent changes

- 2026-09-22 [#11574 [main] Bugs 650415 Financial Report Open in Excel fails with duplicate Excel Buffer cell when LCY Code is empty](../../changes/bcapps/11574.md) (main, BC30, fix)
- 2026-08-05 [#9906 [Bug Fix] #641100: Export Acc. Sched. to Excel - log report usage in OnPostReport to avoid modal page in write transaction](../../changes/bcapps/9906.md) (main, BC30, fix)
- 2026-07-15 [#9129 [Master]-Bug 641503 Financial Reporting - Duplicate Rows in Financial Report Excel Export After Adding GL Budget Dimension](../../changes/bcapps/9129.md) (main, BC30, fix)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC26-28

## Countries that replace it

[CA](../../localizations/ca.md), [MX](../../localizations/mx.md), [US](../../localizations/us.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: "Export Acc. Sched. to Excel")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.