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

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

7 procedures and triggers with a step in src/Layers/W1/BaseApp/CostAccounting/Budget/ImportCostBudgetfromExcel.Report.al, in source order, read from the text, not from a run.

## TempCostBudgetBuffer.OnAfterGetRecord

[Line 23](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L23), trigger.

- [38](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L38) writes [Table 1109 Cost Budget Entry](https://jonas-paprotka.de/ref/table/1109-cost-budget-entry/) DeleteAll(true)
- [43](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L43) calls `IsLineTypeCostType`
- [54](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L54) writes [Table 1109 Cost Budget Entry](https://jonas-paprotka.de/ref/table/1109-cost-budget-entry/) Insert(true)

## TempCostBudgetBuffer.OnPreDataItem

[Line 65](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L65), trigger.

- [73](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L73) raises `OnPreDataItemOnBeforeCostBudgetNameInsert`
- [74](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L74) writes [Table 1110 Cost Budget Name](https://jonas-paprotka.de/ref/table/1110-cost-budget-name/) Insert
- [79](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L79) calls [Table 1109 Cost Budget Entry](https://jonas-paprotka.de/ref/table/1109-cost-budget-entry/) `GetLastEntryNo`

## OnQueryClosePage

[Line 123](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L123), trigger.

- [128](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L128) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `UploadFile`
- [132](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L132) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SelectSheetsName`

## OnPostReport

[Line 143](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L143), trigger.

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

## OnPreReport

[Line 149](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L149), trigger.

- [158](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L158) writes [Table 1103 Cost Type](https://jonas-paprotka.de/ref/table/1103-cost-type/) Insert
- [168](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L168) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `OpenBook`
- [169](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L169) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `ReadSheet`
- [171](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L171) calls `AnalyzeData`

## AnalyzeData

[Line 219](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L219), local.

- [249](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L249) calls `InsertTempExcelBuffer`
- [254](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L254) calls `InsertTempExcelBuffer`
- [260](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L260) calls `InsertTempExcelBuffer`
- [270](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L270) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert

## InsertTempExcelBuffer

[Line 350](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L350), local.

- [354](https://jonas-paprotka.de/ref/report/1143-import-cost-budget-from-excel/source/#L354) writes [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) Insert

## Source

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

JOP-AL, 2026-11-20.
