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

# Report 82 "Export Budget to Excel"

> Report 82 "Export Budget to Excel" in Base Application (Microsoft.Finance.GeneralLedger.Budget). 3 public procedures, 8 events. Present since at least BC23, still in BC30.

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

## Properties

| Property | Value |
|---|---|
| Caption | Export Budget to Excel |

## Events published

- `OnAfterEnterDimFilter(var GLBudgetEntry: Record "G/L Budget Entry"; var ExcelBuffer: Record "Excel Buffer"; var RowNo: Integer)` (integration): Integration event raised after entering dimension filters in the Excel export. Allows subscribers to perform additional processing after dimension filters are applied.
- `OnAfterCopyFilterGLAccount(var GLAccount: Record "G/L Account")` (integration): Integration event raised after copying filters to the G/L Account record. Allows subscribers to modify account filters before processing the export.
- `OnBeforeEnterRangeForDimension(var DimensionRange: array[2, 8] of Integer; var BusUnit: Record "Business Unit"; var DimValue: Record "Dimension Value"; var RowNo: Integer; var IsHandled: Boolean; i: Integer; var GLBudgetEntry: Record "G/L Budget Entry"; var ExcelBuffer: Record "Excel Buffer")` (integration): Integration event raised before entering range information for dimensions in the Excel export. Allows subscribers to customize dimension range processing and layout.
- `OnBeforeInsertTempPeriods(var TempPeriod: Record Date temporary; StartDate: Date; NoOfPeriods: Integer; PeriodLength: DateFormula; var IsHandled: Boolean)` (integration): Integration event raised before inserting temporary period records for the export. Allows subscribers to customize period generation and date calculations.
- `OnBeforeGetDimValueCode(DimCode: Code[20]; var Result: Code[20]; var IsHandled: Boolean; var GLBudgetEntry: Record "G/L Budget Entry")` (integration): Integration event raised before retrieving dimension value codes during export processing. Allows subscribers to customize dimension value retrieval logic.
- `OnEnterDimValueOnAfterCalcShouldGetDimValueCode(DimValueCode: Code[20]; ColDimIndex: Integer; BusUnitDimIndex: Integer; var ShouldGetDimValueCode: Boolean)` (integration): Integration event raised after calculating whether dimension value code should be retrieved. Allows subscribers to modify the logic for when dimension values are processed.
- `OnGLBudgetEntryPreDataItemOnAfterSelectedDimSetFilters(var ColumnDimCode: array[8] of Code[20]; var i: Integer)` (integration): Integration event raised after setting dimension filters in the G/L Budget Entry PreDataItem processing. Allows subscribers to modify column dimension codes and processing parameters.
- `OnGLBudgetEntryOnPostDataItemOnBeforeSetHeaderDim(HeaderRowNo: Integer; ColNo: Integer; i: Integer; var ExcelBuffer: Record "Excel Buffer" temporary; var IsHandled: Boolean)` (integration): Integration event raised before setting header dimensions in the G/L Budget Entry PostDataItem processing. Allows subscribers to customize dimension header layout and formatting in the Excel export.

## Procedures

- `SetParameters(NewStartDate: Date; NewNoOfPeriods: Integer; NewPeriodLength: DateFormula; NewRoundingFactor: Option "None","1","1000","1000000")`: Sets the parameters for budget export including date range, periods, and rounding options. Configures the report settings for Excel export generation.
- `SetFileNameSilent(NewFileName: Text)`: Sets the output file name for the Excel export when running in silent mode. Used for automated export processes without user interaction.
- `SetTestMode(NewTestMode: Boolean)`: Enables or disables test mode for the budget export report. Test mode suppresses certain operations for automated testing scenarios.

Plus 15 local procedures.

## Triggers

OnPreReport

## Across versions

- Present in: BC23-30
- Changed (declaration) in: none

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). 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 Budget to Excel")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.