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

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

9 procedures and triggers with a step in src/Layers/W1/BaseApp/Inventory/Analysis/ImportItemBudgetfromExcel.Report.al, in source order, read from the text, not from a run.

## ItemBudgetBuf.OnAfterGetRecord

[Line 27](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L27), trigger.

- [31](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L31) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Entry No.`
- [32](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L32) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Analysis Area`
- [33](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L33) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Budget Name`
- [34](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L34) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Item No.`
- [35](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L35) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Location Code`
- [36](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L36) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Date`
- [37](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L37) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Description`
- [38](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L38) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Source Type`
- [39](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L39) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Source No.`
- [40](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L40) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Sales Amount`
- [41](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L41) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Quantity`
- [42](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L42) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Cost Amount`
- [43](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L43) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Global Dimension 1 Code`
- [44](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L44) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Global Dimension 2 Code`
- [45](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L45) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Budget Dimension 1 Code`
- [46](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L46) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Budget Dimension 2 Code`
- [47](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L47) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `Budget Dimension 3 Code`
- [48](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L48) validates [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) `User ID`
- [49](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L49) writes [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) Insert(true)

## ItemBudgetBuf.OnPreDataItem

[Line 59](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L59), trigger.

- [66](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L66) writes [Table 7134 Item Budget Entry](https://jonas-paprotka.de/ref/table/7134-item-budget-entry/) DeleteAll(true)

## ToItemBudgetName.OnLookup

[Line 95](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L95), trigger.

- [102](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L102) runs [Page 7132 Item Budget Names](https://jonas-paprotka.de/ref/page/7132-item-budget-names/)

## OnQueryClosePage

[Line 164](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L164), trigger.

- [170](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L170) calls [Codeunit 419 File Management](https://jonas-paprotka.de/ref/codeunit/419-file-management/) `UploadFile`
- [174](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L174) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `SelectSheetsName`

## OnPostReport

[Line 185](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L185), trigger.

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

## OnPreReport

[Line 191](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L191), trigger.

- [201](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L201) writes [Table 7132 Item Budget Name](https://jonas-paprotka.de/ref/table/7132-item-budget-name/) Insert
- [216](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L216) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `OpenBook`
- [217](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L217) calls [Table 370 Excel Buffer](https://jonas-paprotka.de/ref/table/370-excel-buffer/) `ReadSheet`
- [219](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L219) calls `AnalyseData`

## AnalyseData

[Line 275](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L275), local.

- [314](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L314) calls `ConvertFiltersToValue`
- [325](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L325) calls [Codeunit 7130 Item Budget Management](https://jonas-paprotka.de/ref/codeunit/7130-item-budget-management/) `DimCodeNotAllowed`
- [328](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L328) calls [Codeunit 7130 Item Budget Management](https://jonas-paprotka.de/ref/codeunit/7130-item-budget-management/) `DimCodeNotAllowed`
- [331](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L331) calls [Codeunit 7130 Item Budget Management](https://jonas-paprotka.de/ref/codeunit/7130-item-budget-management/) `SetLineAndColumnDim`
- [338](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L338) calls `IsGlobalDimFilter`
- [340](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L340) calls `CheckFilterRowNo`
- [346](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L346) calls `IsGlobalDimFilter`
- [348](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L348) calls `CheckFilterRowNo`
- [354](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L354) calls `IsBudgetDimFilter`
- [356](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L356) calls `CheckFilterRowNo`
- [362](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L362) calls `IsBudgetDimFilter`
- [364](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L364) calls `CheckFilterRowNo`
- [370](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L370) calls `IsBudgetDimFilter`
- [372](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L372) calls `CheckFilterRowNo`
- [380](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L380) calls `CheckFilterRowNo`
- [388](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L388) calls `CheckFilterRowNo`
- [396](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L396) calls `CheckFilterRowNo`
- [406](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L406) calls `CheckFilterRowNo`
- [416](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L416) calls `CheckFilterRowNo`
- [424](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L424) calls `CheckFilterRowNo`
- [437](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L437) raises `OnAnalyseDataOnBeforeGetCurrColumnDimValue`, IsHandled
- [439](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L439) calls `GetCurrColumnDimValue`
- [442](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L442) raises `OnAnalyseDataOnBeforeProcessImportedMatrixCell`, IsHandled
- [444](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L444) calls `ExchangeFiltersWithDimValue`

## ConvertFiltersToValue

[Line 571](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L571), local.

- [609](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L609) calls `GetGLSetup`

## IsGlobalDimFilter

[Line 647](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L647), local.

- [651](https://jonas-paprotka.de/ref/report/7131-import-item-budget-from-excel/source/#L651) calls `GetGLSetup`

## Source

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

JOP-AL, 2026-11-20.
