Report 29 "Export Acc. Sched. to Excel"

Base Application · Microsoft.Finance.FinancialReports · BC23-30 · source at ea08af5e · facts from BC29

Properties

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) + BC26 + BC28: 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]) + BC26 + BC28: 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]) + BC26 + BC28
• 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") + BC26: 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) + BC26: 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) + BC26: Retrieves the saved Excel data as an output stream for custom processing. Provides access to generated Excel content for further manipulation or transmission.
• SetRunForExport() + BC28

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” (6 calls: SetUseExistingTemplate → CreateFileNameWithExtension, SetUseExistingTemplate → InstreamExportToServerFile, UploadClientFile → GetFileName, …)
• Codeunit 8 “AccSchedManagement” (3 calls: CalcColumnValue → CalcCell, CalcColumnValue → GetDivisionError, PopulateExcelBuffer → CalcColumnHeader)
• Codeunit 4100 “Temp Blob” (1 call: UploadExistingTemplate → CreateInStream)
• Codeunit 8390 “Financial Report Auditing” (1 call: OnPostReport → LogReportUsage)
• Codeunit 9200 “Matrix Management” (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 (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 (main, BC30, fix)
• 2026-07-15 #9129 [Master]-Bug 641503 Financial Reporting - Duplicate Rows in Financial Report Excel Export After Adding GL Budget Dimension (main, BC30, fix)

Countries that replace it

CA, MX, US

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.