---
title: "Report 81 Import Budget from Excel, extension points 29"
author: "JOP-AL"
url: https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/points/
object: https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/
app: "Base Application"
major: 29
source: https://jonas-paprotka.de/ref/report/81-import-budget-from-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 81 Import Budget from Excel, extension points 29

JOP-AL, https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/points/

12 procedures and triggers with a step in src/Layers/W1/BaseApp/Finance/GeneralLedger/Budget/ImportBudgetfromExcel.Report.al, in source order, read from the text, not from a run.

## BudgetBuf.OnAfterGetRecord

[Line 37](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L37), trigger.

- [47](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L47) raises `OnBudgetBufOnAfterGetRecordOnBeforeSetDimFilters`
- [49](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L49) calls `SetBudgetDimFilter`
- [51](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L51) calls `SetBudgetDimFilter`
- [53](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L53) calls `SetBudgetDimFilter`
- [55](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L55) calls `SetBudgetDimFilter`
- [57](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L57) calls `SetBudgetDimFilter`
- [59](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L59) calls `SetBudgetDimFilter`
- [61](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L61) calls `SetBudgetDimFilter`
- [63](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L63) calls `SetBudgetDimFilter`
- [65](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L65) writes [Table 96 G/L Budget Entry](https://jonas-paprotka.de/ref/table/96-g-l-budget-entry/) DeleteAll(true)
- [70](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L70) calls `IsPostingAccount`
- [82](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L82) writes [Table 36950 Dimension Set Entry](https://jonas-paprotka.de/ref/table/36950-dimension-set-entry/) DeleteAll(true)
- [84](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L84) calls `InsertGLBudgetDimensions`
- [85](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L85) calls [Codeunit 408 DimensionManagement](https://jonas-paprotka.de/ref/codeunit/408-dimensionmanagement/) `GetDimensionSetID`
- [86](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L86) raises `OnBudgetBufOnAfterGetRecordOnBeforeGLBudgetEntryInsert`
- [87](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L87) writes [Table 96 G/L Budget Entry](https://jonas-paprotka.de/ref/table/96-g-l-budget-entry/) Insert(true)
- [88](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L88) raises `OnBudgetBufOnAfterGetRecordOnAfterGLBudgetEntryInsert`

## BudgetBuf.OnPostDataItem

[Line 92](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L92), trigger.

- [101](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L101) calls [Table 363 Analysis View](https://jonas-paprotka.de/ref/table/363-analysis-view/) `AnalysisviewBudgetReset`
- [102](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L102) writes [Table 363 Analysis View](https://jonas-paprotka.de/ref/table/363-analysis-view/) Modify

## BudgetBuf.OnPreDataItem

[Line 107](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L107), trigger.

- [115](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L115) calls [Codeunit 27 Confirm Management](https://jonas-paprotka.de/ref/codeunit/27-confirm-management/) `GetResponseOrDefault`
- [120](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L120) writes [Table 95 G/L Budget Name](https://jonas-paprotka.de/ref/table/95-g-l-budget-name/) Insert
- [123](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L123) raises `OnBeforeCheckGLBudgetNameBlacked`, IsHandled
- [129](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L129) calls [Codeunit 27 Confirm Management](https://jonas-paprotka.de/ref/codeunit/27-confirm-management/) `GetResponseOrDefault`
- [136](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L136) raises `OnBeforeGetLastEntryNoBeforeImport`, IsHandled
- [139](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L139) calls [Table 96 G/L Budget Entry](https://jonas-paprotka.de/ref/table/96-g-l-budget-entry/) `GetLastEntryNo`

## OnQueryClosePage

[Line 190](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L190), trigger.

- [196](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L196) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `UploadFile`

## OnPostReport

[Line 207](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L207), trigger.

- [210](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L210) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) DeleteAll

## OnPreReport

[Line 214](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L214), trigger.

- [218](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L218) raises `OnBeforeOnPreReport`
- [223](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L223) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SelectSheetsName`
- [229](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L229) writes [Table 348 Dimension](https://jonas-paprotka.de/ref/table/348-dimension/) Insert
- [238](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L238) writes [Table 348 Dimension](https://jonas-paprotka.de/ref/table/348-dimension/) Insert
- [245](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L245) writes [Table 15 G/L Account](https://jonas-paprotka.de/ref/table/15-g-l-account/) Insert
- [260](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L260) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `OpenBook`
- [261](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L261) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SetReadDateTimeInUtcDate`
- [262](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L262) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `ReadSheet`
- [263](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L263) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SetReadDateTimeInUtcDate`
- [265](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L265) calls `AnalyzeData`

## AnalyzeData

[Line 348](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L348), local.

- [381](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L381) raises `OnAnalyzeDataOnBeforeCheckHeaderRowNo`, IsHandled
- [389](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L389) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert
- [392](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L392) raises `OnAnalyzeDataOnAfterCheckHeaderRowNo`
- [397](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L397) raises `OnAnalyzeDataOnBeforeCheckHeaderRowNo2`, IsHandled
- [405](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L405) calls `IncreaseAndCheckCountDim`
- [410](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L410) raises `OnAnalyzeDataOnAfterCheckHeaderRowNo2`
- [415](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L415) raises `OnAnalyzeDataOnBeforeGLBudgetEntrySetFilters`, IsHandled
- [435](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L435) raises `OnAnalyzeDataOnAfterGLBudgetEntrySetFilters`
- [441](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L441) raises `OnAnalyzeDataOnBeforeConditionalTempExcelBufInsert`, IsHandled
- [450](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L450) calls `IncreaseAndCheckCountDim`
- [452](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L452) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert
- [459](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L459) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert
- [462](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L462) raises `OnAnalyzeDataOnAfterConditionalTempExcelBufInsert`
- [533](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L533) calls `ApplyFilteredDimensionsToBudgetBuf`
- [538](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L538) raises `OnAnalyzeDataOnBeforeInsertBudgetBuf`, IsHandled
- [544](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L544) raises `OnAnalyzeDataOnBeforeCombinationMustBeUniqueError`, IsHandled
- [549](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L549) raises `OnAnalyzeDataOnAfterCaseText014`

## InsertGLBudgetDimensions

[Line 583](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L583), local.

- [588](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L588) raises `OnBeforeInsertGLBudgetDimensions`, IsHandled
- [592](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L592) calls `InsertGLBudgetDim`
- [593](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L593) calls `InsertGLBudgetDim`
- [594](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L594) calls `InsertGLBudgetDim`
- [595](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L595) calls `InsertGLBudgetDim`
- [596](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L596) calls `InsertGLBudgetDim`
- [597](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L597) calls `InsertGLBudgetDim`
- [598](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L598) calls `InsertGLBudgetDim`
- [599](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L599) calls `InsertGLBudgetDim`

## InsertGLBudgetDim

[Line 602](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L602), local.

- [608](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L608) raises `OnBeforeInsertGLBudgetDim`, IsHandled
- [616](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L616) validates [Table 36950 Dimension Set Entry](https://jonas-paprotka.de/ref/table/36950-dimension-set-entry/) `Dimension Value Code`
- [617](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L617) validates [Table 36950 Dimension Set Entry](https://jonas-paprotka.de/ref/table/36950-dimension-set-entry/) `Dimension Value ID`
- [618](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L618) writes [Table 36950 Dimension Set Entry](https://jonas-paprotka.de/ref/table/36950-dimension-set-entry/) Modify(true)
- [621](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L621) validates [Table 36950 Dimension Set Entry](https://jonas-paprotka.de/ref/table/36950-dimension-set-entry/) `Dimension Code`
- [622](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L622) validates [Table 36950 Dimension Set Entry](https://jonas-paprotka.de/ref/table/36950-dimension-set-entry/) `Dimension Value Code`
- [623](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L623) validates [Table 36950 Dimension Set Entry](https://jonas-paprotka.de/ref/table/36950-dimension-set-entry/) `Dimension Value ID`
- [624](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L624) writes [Table 36950 Dimension Set Entry](https://jonas-paprotka.de/ref/table/36950-dimension-set-entry/) Insert
- [644](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L644) raises `OnAfterInsertGLBudgetDim`

## SetBudgetDimFilter

[Line 681](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L681).

- [699](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L699) raises `OnAfterSetBudgetDimFilter`

## ApplyFilteredDimensionsToBudgetBuf

[Line 712](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L712), local.

- [716](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L716) calls `ProcessFilteredDimension`
- [717](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L717) calls `ProcessFilteredDimension`
- [718](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L718) calls `ProcessFilteredDimension`
- [719](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L719) calls `ProcessFilteredDimension`
- [720](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L720) calls `ProcessFilteredDimension`
- [721](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L721) calls `ProcessFilteredDimension`
- [722](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L722) calls `ProcessFilteredDimension`

## ProcessFilteredDimension

[Line 725](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L725), local.

- [748](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L748) calls `GetBudgetBufferDimensionValue`
- [749](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L749) calls `SetBudgetBufferDimensionValue`
- [756](https://jonas-paprotka.de/ref/report/81-import-budget-from-excel/source/#L756) calls `SetBudgetBufferDimensionValue`

## Source

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

JOP-AL, 2026-11-20.
