Report 7131 Import Item Budget from Excel

Base Application, Microsoft.Inventory.Analysis

src/Layers/W1/BaseApp/Inventory/Analysis/ImportItemBudgetfromExcel.Report.al9 procedures and triggers, in source order. Copyright (c) Microsoft Corporation. MIT

ItemBudgetBuf.OnAfterGetRecord line 27, trigger

  1. 31validatesTable 7134 Item Budget Entry Entry No.
  2. 32validatesTable 7134 Item Budget Entry Analysis Area
  3. 33validatesTable 7134 Item Budget Entry Budget Name
  4. 34validatesTable 7134 Item Budget Entry Item No.
  5. 35validatesTable 7134 Item Budget Entry Location Code
  6. 36validatesTable 7134 Item Budget Entry Date
  7. 37validatesTable 7134 Item Budget Entry Description
  8. 38validatesTable 7134 Item Budget Entry Source Type
  9. 39validatesTable 7134 Item Budget Entry Source No.
  10. 40validatesTable 7134 Item Budget Entry Sales Amount
  11. 41validatesTable 7134 Item Budget Entry Quantity
  12. 42validatesTable 7134 Item Budget Entry Cost Amount
  13. 43validatesTable 7134 Item Budget Entry Global Dimension 1 Code
  14. 44validatesTable 7134 Item Budget Entry Global Dimension 2 Code
  15. 45validatesTable 7134 Item Budget Entry Budget Dimension 1 Code
  16. 46validatesTable 7134 Item Budget Entry Budget Dimension 2 Code
  17. 47validatesTable 7134 Item Budget Entry Budget Dimension 3 Code
  18. 48validatesTable 7134 Item Budget Entry User ID
  19. 49writesTable 7134 Item Budget Entry Insert(true)

ItemBudgetBuf.OnPreDataItem line 59, trigger

  1. 66writesTable 7134 Item Budget Entry DeleteAll(true)

ToItemBudgetName.OnLookup line 95, trigger

  1. 102runsPage 7132 Item Budget Names

OnQueryClosePage line 164, trigger

  1. 170callsCodeunit 419 File Management UploadFile
  2. 174callsTable 370 Excel Buffer SelectSheetsName

OnPostReport line 185, trigger

  1. 187writesTable 370 Excel Buffer DeleteAll

OnPreReport line 191, trigger

  1. 201writesTable 7132 Item Budget Name Insert
  2. 216callsTable 370 Excel Buffer OpenBook
  3. 217callsTable 370 Excel Buffer ReadSheet
  4. 219callsAnalyseData

AnalyseData line 275, local

  1. 314callsConvertFiltersToValue
  2. 325callsCodeunit 7130 Item Budget Management DimCodeNotAllowed
  3. 328callsCodeunit 7130 Item Budget Management DimCodeNotAllowed
  4. 331callsCodeunit 7130 Item Budget Management SetLineAndColumnDim
  5. 338callsIsGlobalDimFilter
  6. 340callsCheckFilterRowNo
  7. 346callsIsGlobalDimFilter
  8. 348callsCheckFilterRowNo
  9. 354callsIsBudgetDimFilter
  10. 356callsCheckFilterRowNo
  11. 362callsIsBudgetDimFilter
  12. 364callsCheckFilterRowNo
  13. 370callsIsBudgetDimFilter
  14. 372callsCheckFilterRowNo
  15. 380callsCheckFilterRowNo
  16. 388callsCheckFilterRowNo
  17. 396callsCheckFilterRowNo
  18. 406callsCheckFilterRowNo
  19. 416callsCheckFilterRowNo
  20. 424callsCheckFilterRowNo
  21. 437raisesOnAnalyseDataOnBeforeGetCurrColumnDimValueIsHandled
  22. 439callsGetCurrColumnDimValue
  23. 442raisesOnAnalyseDataOnBeforeProcessImportedMatrixCellIsHandled
  24. 444callsExchangeFiltersWithDimValue

ConvertFiltersToValue line 571, local

  1. 609callsGetGLSetup

IsGlobalDimFilter line 647, local

  1. 651callsGetGLSetup