Report 82 "Export Budget to Excel"

Base Application · Microsoft.Finance.GeneralLedger.Budget · BC23-30 · source at ea08af5e · facts from BC29

Properties

Events published

• OnAfterEnterDimFilter(var GLBudgetEntry: Record "G/L Budget Entry"; var ExcelBuffer: Record "Excel Buffer"; var RowNo: Integer) (integration): Integration event raised after entering dimension filters in the Excel export. Allows subscribers to perform additional processing after dimension filters are applied.
• OnAfterCopyFilterGLAccount(var GLAccount: Record "G/L Account") (integration): Integration event raised after copying filters to the G/L Account record. Allows subscribers to modify account filters before processing the export.
• OnBeforeEnterRangeForDimension(var DimensionRange: array[2, 8] of Integer; var BusUnit: Record "Business Unit"; var DimValue: Record "Dimension Value"; var RowNo: Integer; var IsHandled: Boolean; i: Integer; var GLBudgetEntry: Record "G/L Budget Entry"; var ExcelBuffer: Record "Excel Buffer") (integration): Integration event raised before entering range information for dimensions in the Excel export. Allows subscribers to customize dimension range processing and layout.
• OnBeforeInsertTempPeriods(var TempPeriod: Record Date temporary; StartDate: Date; NoOfPeriods: Integer; PeriodLength: DateFormula; var IsHandled: Boolean) (integration): Integration event raised before inserting temporary period records for the export. Allows subscribers to customize period generation and date calculations.
• OnBeforeGetDimValueCode(DimCode: Code[20]; var Result: Code[20]; var IsHandled: Boolean; var GLBudgetEntry: Record "G/L Budget Entry") (integration): Integration event raised before retrieving dimension value codes during export processing. Allows subscribers to customize dimension value retrieval logic.
• OnEnterDimValueOnAfterCalcShouldGetDimValueCode(DimValueCode: Code[20]; ColDimIndex: Integer; BusUnitDimIndex: Integer; var ShouldGetDimValueCode: Boolean) (integration): Integration event raised after calculating whether dimension value code should be retrieved. Allows subscribers to modify the logic for when dimension values are processed.
• OnGLBudgetEntryPreDataItemOnAfterSelectedDimSetFilters(var ColumnDimCode: array[8] of Code[20]; var i: Integer) (integration): Integration event raised after setting dimension filters in the G/L Budget Entry PreDataItem processing. Allows subscribers to modify column dimension codes and processing parameters.
• OnGLBudgetEntryOnPostDataItemOnBeforeSetHeaderDim(HeaderRowNo: Integer; ColNo: Integer; i: Integer; var ExcelBuffer: Record "Excel Buffer" temporary; var IsHandled: Boolean) (integration): Integration event raised before setting header dimensions in the G/L Budget Entry PostDataItem processing. Allows subscribers to customize dimension header layout and formatting in the Excel export.

Procedures

• SetParameters(NewStartDate: Date; NewNoOfPeriods: Integer; NewPeriodLength: DateFormula; NewRoundingFactor: Option "None","1","1000","1000000"): Sets the parameters for budget export including date range, periods, and rounding options. Configures the report settings for Excel export generation.
• SetFileNameSilent(NewFileName: Text): Sets the output file name for the Excel export when running in silent mode. Used for automated export processes without user interaction.
• SetTestMode(NewTestMode: Boolean): Enables or disables test mode for the budget export report. Test mode suppresses certain operations for automated testing scenarios.

Plus 15 local procedures.

Triggers

OnPreReport

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "report", object_name: "Export Budget to Excel"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.