Report 81 Import Budget from Excel

Base Application, Microsoft.Finance.GeneralLedger.Budget

src/Layers/W1/BaseApp/Finance/GeneralLedger/Budget/ImportBudgetfromExcel.Report.al12 procedures and triggers, in source order. Copyright (c) Microsoft Corporation. MIT

BudgetBuf.OnAfterGetRecord line 37, trigger

  1. 47raisesOnBudgetBufOnAfterGetRecordOnBeforeSetDimFilters
  2. 49callsSetBudgetDimFilter
  3. 51callsSetBudgetDimFilter
  4. 53callsSetBudgetDimFilter
  5. 55callsSetBudgetDimFilter
  6. 57callsSetBudgetDimFilter
  7. 59callsSetBudgetDimFilter
  8. 61callsSetBudgetDimFilter
  9. 63callsSetBudgetDimFilter
  10. 65writesTable 96 G/L Budget Entry DeleteAll(true)
  11. 70callsIsPostingAccount
  12. 82writesTable 36950 Dimension Set Entry DeleteAll(true)
  13. 84callsInsertGLBudgetDimensions
  14. 85callsCodeunit 408 DimensionManagement GetDimensionSetID
  15. 86raisesOnBudgetBufOnAfterGetRecordOnBeforeGLBudgetEntryInsert
  16. 87writesTable 96 G/L Budget Entry Insert(true)
  17. 88raisesOnBudgetBufOnAfterGetRecordOnAfterGLBudgetEntryInsert

BudgetBuf.OnPostDataItem line 92, trigger

  1. 101callsTable 363 Analysis View AnalysisviewBudgetReset
  2. 102writesTable 363 Analysis View Modify

BudgetBuf.OnPreDataItem line 107, trigger

  1. 115callsCodeunit 27 Confirm Management GetResponseOrDefault
  2. 120writesTable 95 G/L Budget Name Insert
  3. 123raisesOnBeforeCheckGLBudgetNameBlackedIsHandled
  4. 129callsCodeunit 27 Confirm Management GetResponseOrDefault
  5. 136raisesOnBeforeGetLastEntryNoBeforeImportIsHandled
  6. 139callsTable 96 G/L Budget Entry GetLastEntryNo

OnQueryClosePage line 190, trigger

  1. 196callsCodeunit 419 File Management UploadFile

OnPostReport line 207, trigger

  1. 210writesTable 370 Excel Buffer DeleteAll

OnPreReport line 214, trigger

  1. 218raisesOnBeforeOnPreReport
  2. 223callsTable 370 Excel Buffer SelectSheetsName
  3. 229writesTable 348 Dimension Insert
  4. 238writesTable 348 Dimension Insert
  5. 245writesTable 15 G/L Account Insert
  6. 260callsTable 370 Excel Buffer OpenBook
  7. 261callsTable 370 Excel Buffer SetReadDateTimeInUtcDate
  8. 262callsTable 370 Excel Buffer ReadSheet
  9. 263callsTable 370 Excel Buffer SetReadDateTimeInUtcDate
  10. 265callsAnalyzeData

AnalyzeData line 348, local

  1. 381raisesOnAnalyzeDataOnBeforeCheckHeaderRowNoIsHandled
  2. 389writesTable 370 Excel Buffer Insert
  3. 392raisesOnAnalyzeDataOnAfterCheckHeaderRowNo
  4. 397raisesOnAnalyzeDataOnBeforeCheckHeaderRowNo2IsHandled
  5. 405callsIncreaseAndCheckCountDim
  6. 410raisesOnAnalyzeDataOnAfterCheckHeaderRowNo2
  7. 415raisesOnAnalyzeDataOnBeforeGLBudgetEntrySetFiltersIsHandled
  8. 435raisesOnAnalyzeDataOnAfterGLBudgetEntrySetFilters
  9. 441raisesOnAnalyzeDataOnBeforeConditionalTempExcelBufInsertIsHandled
  10. 450callsIncreaseAndCheckCountDim
  11. 452writesTable 370 Excel Buffer Insert
  12. 459writesTable 370 Excel Buffer Insert
  13. 462raisesOnAnalyzeDataOnAfterConditionalTempExcelBufInsert
  14. 533callsApplyFilteredDimensionsToBudgetBuf
  15. 538raisesOnAnalyzeDataOnBeforeInsertBudgetBufIsHandled
  16. 544raisesOnAnalyzeDataOnBeforeCombinationMustBeUniqueErrorIsHandled
  17. 549raisesOnAnalyzeDataOnAfterCaseText014

InsertGLBudgetDimensions line 583, local

  1. 588raisesOnBeforeInsertGLBudgetDimensionsIsHandled
  2. 592callsInsertGLBudgetDim
  3. 593callsInsertGLBudgetDim
  4. 594callsInsertGLBudgetDim
  5. 595callsInsertGLBudgetDim
  6. 596callsInsertGLBudgetDim
  7. 597callsInsertGLBudgetDim
  8. 598callsInsertGLBudgetDim
  9. 599callsInsertGLBudgetDim

InsertGLBudgetDim line 602, local

  1. 608raisesOnBeforeInsertGLBudgetDimIsHandled
  2. 616validatesTable 36950 Dimension Set Entry Dimension Value Code
  3. 617validatesTable 36950 Dimension Set Entry Dimension Value ID
  4. 618writesTable 36950 Dimension Set Entry Modify(true)
  5. 621validatesTable 36950 Dimension Set Entry Dimension Code
  6. 622validatesTable 36950 Dimension Set Entry Dimension Value Code
  7. 623validatesTable 36950 Dimension Set Entry Dimension Value ID
  8. 624writesTable 36950 Dimension Set Entry Insert
  9. 644raisesOnAfterInsertGLBudgetDim

SetBudgetDimFilter line 681

  1. 699raisesOnAfterSetBudgetDimFilter

ApplyFilteredDimensionsToBudgetBuf line 712, local

  1. 716callsProcessFilteredDimension
  2. 717callsProcessFilteredDimension
  3. 718callsProcessFilteredDimension
  4. 719callsProcessFilteredDimension
  5. 720callsProcessFilteredDimension
  6. 721callsProcessFilteredDimension
  7. 722callsProcessFilteredDimension

ProcessFilteredDimension line 725, local

  1. 748callsGetBudgetBufferDimensionValue
  2. 749callsSetBudgetBufferDimensionValue
  3. 756callsSetBudgetBufferDimensionValue