---
title: "Report 29 Export Acc. Sched. to Excel, extension points 29"
author: "JOP-AL"
url: https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/points/
object: https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/
app: "Base Application"
major: 29
source: https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/
checked: 2026-11-20
changed: 2026-10-05
subject: "Microsoft Dynamics 365 Business Central"
license: "Metadata from Microsoft's symbol packages. AL source MIT, Copyright (c) Microsoft Corporation. Selection and wording © 2026 JOP-AL. https://jonas-paprotka.de/licenses/"
---

# Report 29 Export Acc. Sched. to Excel, extension points 29

JOP-AL, https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/points/

15 procedures and triggers with a step in src/Layers/W1/BaseApp/Finance/FinancialReports/ExportAccSchedtoExcel.Report.al, in source order, read from the text, not from a run.

## Integer.OnAfterGetRecord

[Line 37](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L37), trigger.

- [46](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L46) calls `UploadExistingTemplate`
- [48](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L48) calls `UploadClientFile`
- [56](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L56) raises `OnIntegerOnAfterGetRecordOnAfterAccSchedLineSetFilter`
- [59](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L59) calls [Codeunit 8 AccSchedManagement](https://jonas-paprotka.de/ref/codeunit/8-accschedmanagement/) `CheckAnalysisView`
- [64](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L64) calls `PopulateExcelBuffer`
- [66](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L66) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `UpdateBookExcel`
- [67](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L67) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `WriteSheet`
- [70](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L70) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `CreateBook`
- [71](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L71) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `WriteSheet`
- [75](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L75) calls [Codeunit 8 AccSchedManagement](https://jonas-paprotka.de/ref/codeunit/8-accschedmanagement/) `CheckPerspectiveAnalysisView`
- [82](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L82) calls [Codeunit 8363 DimPerspectiveAccSchMgtHandler](https://jonas-paprotka.de/ref/codeunit/8363-dimperspectiveaccschmgthandler/) `SetDimPerspectiveName`
- [84](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L84) calls [Codeunit 8363 DimPerspectiveAccSchMgtHandler](https://jonas-paprotka.de/ref/codeunit/8363-dimperspectiveaccschmgthandler/) `SetDimPerspectiveLine`
- [85](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L85) calls [Codeunit 8 AccSchedManagement](https://jonas-paprotka.de/ref/codeunit/8-accschedmanagement/) `ForceRecalculate`
- [86](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L86) calls `WriteSheetPerDefinition`
- [95](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L95) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `CloseBook`
- [97](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L97) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `OpenExcelWithName`
- [99](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L99) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `CloseBook`
- [101](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L101) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `OpenExcelWithName`
- [101](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L101) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `CreateFileNameWithExtension`

## OnPostReport

[Line 117](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L117), trigger.

- [121](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L121) calls [Codeunit 8390 Financial Report Auditing](https://jonas-paprotka.de/ref/codeunit/8390-financial-report-auditing/) `LogReportUsage`

## WriteSheetPerDefinition

[Line 195](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L195), local.

- [197](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L197) calls `PopulateExcelBuffer`
- [201](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L201) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SelectOrAddSheet`
- [202](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L202) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `WriteSheet`

## PopulateExcelBuffer

[Line 205](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L205), local.

- [214](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L214) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) DeleteAll
- [217](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L217) calls `EnterCell`
- [218](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L218) calls `EnterFilterInCell`
- [221](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L221) calls `EnterFilterInCell`
- [224](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L224) calls `EnterFilterInCell`
- [227](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L227) calls `EnterFilterInCell`
- [230](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L230) calls `EnterFilterInCell`
- [233](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L233) calls `EnterFilterInCell`
- [237](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L237) calls [Table 88 Financial Report](https://jonas-paprotka.de/ref/table/88-financial-report/) `GetIntroductoryParagraph`
- [240](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L240) calls `EnterCellBlobValue`
- [246](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L246) calls `EnterFilterInCell`
- [247](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L247) calls `GetDimFilterCaption`
- [251](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L251) calls `EnterFilterInCell`
- [252](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L252) calls `GetDimFilterCaption`
- [256](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L256) calls `EnterFilterInCell`
- [257](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L257) calls `GetDimFilterCaption`
- [261](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L261) calls `EnterFilterInCell`
- [262](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L262) calls `GetDimFilterCaption`
- [264](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L264) calls `InsertBlankRowAndFillCells`
- [266](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L266) calls `EnterFilterInCell`
- [269](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L269) calls `EnterFilterInCell`
- [275](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L275) calls `InsertBlankRowAndFillCells`
- [276](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L276) calls `InsertBlankRowAndFillCells`
- [279](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L279) calls `InsertBlankRowAndFillCells`
- [283](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L283) calls `EnterCell`
- [284](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L284) calls [Codeunit 8 AccSchedManagement](https://jonas-paprotka.de/ref/codeunit/8-accschedmanagement/) `CalcColumnHeader`
- [290](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L290) calls `ShouldIncludeRow`
- [293](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L293) calls `EnterCell`
- [298](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L298) calls `EnterCell`
- [304](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L304) calls `CalcColumnValue`
- [306](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L306) calls `EnterCell`
- [307](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L307) calls [Codeunit 9200 Matrix Management](https://jonas-paprotka.de/ref/codeunit/9200-matrix-management/) `FormatAmount`
- [315](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L315) calls [Table 88 Financial Report](https://jonas-paprotka.de/ref/table/88-financial-report/) `GetClosingParagraph`
- [318](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L318) calls `EnterCellBlobValue`

## CalcColumnValue

[Line 322](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L322), local.

- [324](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L324) raises `OnBeforeCalcColumnValue`
- [328](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L328) calls [Codeunit 8 AccSchedManagement](https://jonas-paprotka.de/ref/codeunit/8-accschedmanagement/) `CalcCell`
- [329](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L329) calls [Codeunit 8 AccSchedManagement](https://jonas-paprotka.de/ref/codeunit/8-accschedmanagement/) `GetDivisionError`
- [332](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L332) raises `OnAferCalcColumnValue`

## EnterFilterInCell

[Line 335](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L335), local.

- [339](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L339) calls `EnterCell`
- [340](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L340) calls `EnterCell`

## EnterCell

[Line 344](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L344), local.

- [347](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L347) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Row No.`
- [348](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L348) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Column No.`
- [362](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L362) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert

## EnterCellBlobValue

[Line 365](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L365), local.

- [370](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L370) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Row No.`
- [371](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L371) validates [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `Column No.`
- [375](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L375) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert

## GetDimFilterCaption

[Line 378](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L378), local.

- [400](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L400) calls [Table 348 Dimension](https://jonas-paprotka.de/ref/table/348-dimension/) `GetMLFilterCaption`

## SetUseExistingTemplate

[Line 442](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L442).

- [451](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L451) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `InStreamExportToServerFile`
- [457](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L457) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `CreateFileNameWithExtension`

## GetSavedStream

[Line 475](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L475).

- [477](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L477) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SaveToStream`

## UploadExistingTemplate

[Line 480](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L480), local.

- [488](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L488) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `IsAllowedPath`
- [489](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L489) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `BLOBImportFromServerFile`
- [490](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L490) calls [Codeunit 4100 Temp Blob](https://jonas-paprotka.de/ref/codeunit/4100-temp-blob/) `CreateInStream`
- [491](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L491) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `GetSheetsNameListFromStream`

## UploadClientFile

[Line 502](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L502), local.

- [504](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L504) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `UploadFile`
- [505](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L505) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `GetFileName`
- [509](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L509) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SelectSheetsName`

## ShouldIncludeRow

[Line 516](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L516), local.

- [524](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L524) calls `CalcColumnValue`

## InsertBlankRowAndFillCells

[Line 538](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L538), local.

- [546](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L546) calls `EnterCell`
- [551](https://jonas-paprotka.de/ref/report/29-export-acc-sched-to-excel/source/#L551) calls `EnterCell`

## Source

AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at 4303e5e584d3aa5d9e98cbc615525a5396ad6ed7.

JOP-AL, 2026-11-20.
