Analyzing financial report lifecycle telemetry

APPLIES TO: Business Central 2025 release wave 1 (v26) and later.

Financial report lifecycle telemetry gathers data about the following lifecycle operations to definitions in financial reporting:

  • Financial report row definition created
  • Financial report row definition modified
  • Financial report row definition copied
  • Financial report row definition exported
  • Financial report row definition imported
  • Financial report row definition deleted
  • Financial report column definition created
  • Financial report column definition modified
  • Financial report column definition copied
  • Financial report column definition exported
  • Financial report column definition imported
  • Financial report column definition deleted
  • Financial report definition created
  • Financial report definition modified
  • Financial report definition copied
  • Financial report definition exported
  • Financial report definition imported
  • Financial report definition deleted

Learn more in Primary capabilities of financial reporting in the Business Central Application Help.

These events use normal verbosity (severityLevel 1) and TelemetryScope::All. The creation, modification, deletion, import, and export events documented here are emitted only in online environments. Copy events can also be emitted on-premises.

Import and export operations share an event ID for each definition type. The sample queries also filter the message to distinguish these operations.

General dimensions for all financial report lifecycle events

The following table explains general dimensions that are common to all financial report lifecycle events.

DimensionDescription or value
user_IdThe user telemetry ID for the user. From the user card, you can use user_Id to identify the user who triggered this telemetry event. Learn more in Assign a telemetry ID to users.

Common dimensions for all financial report lifecycle events

The following table explains custom dimensions that are common to all financial report lifecycle events.

DimensionDescription or value
aadTenantIdSpecifies the Microsoft Entra tenant ID used for Microsoft Entra authentication. For on-premises, if you aren't using Microsoft Entra authentication, this value is common.
companyNameThe current company name.
environmentNameSpecifies the name of the tenant environment. Learn more in Managing Environments.
environmentTypeSpecifies the environment type for the tenant, such as Production or Sandbox. Learn more in Environment Types.

Financial report row definition created: {Row Definition Code}

Occurs when a user creates a new financial report row definition.

General dimensions

DimensionDescription or value
messageFinancial Report Row Definition created: {Row Definition Code}

Custom dimensions

DimensionDescription or value
alRowDefinitionCodeThe code of the row definition that was created.
eventIdAL0000O81

Sample KQL code (financial report row definition created)

This KQL code can help you get started analyzing creation of financial report row definitions.

// Financial report row definition created: {Row Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000O81'
| where customDimensions.eventId == 'AL0000O81'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was created
, rowDefinitionCode=customDimensions.alRowDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report row definition modified: {Row Definition Code}

Occurs when a user modifies a financial report row definition.

General dimensions

DimensionDescription or value
messageFinancial Report Row Definition modified: {Row Definition Code}

Custom dimensions

DimensionDescription or value
alRowDefinitionCodeThe code of the row definition that was modified.
eventIdAL0000O82

Sample KQL code (row definition modified)

This KQL code can help you get started analyzing modifications to financial report row definitions.

// Financial report row definition modified: {Row Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000O82'
| where customDimensions.eventId == 'AL0000O82'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was modified
, rowDefinitionCode=customDimensions.alRowDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report row definition copied: {Row Definition Code}

Occurs when a user copies a financial report row definition.

General dimensions

DimensionDescription or value
messageFinancial Report Row Definition copied: {Row Definition Code}

Custom dimensions

DimensionDescription or value
alSourceRowDefinitionCodeThe code of the row definition that was copied.
alNewRowDefinitionCodeThe code of the copy of the row definition.
eventIdAL0000OKV

Sample KQL code (row definition copied)

This KQL code can help you get started analyzing copies taken on financial report row definitions.

// Financial report row definition copied: {Row Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000OKV'
| where customDimensions.eventId == 'AL0000OKV'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was copied
, sourceRowDefinitionCode = customDimensions.alSourceRowDefinitionCode
, newRowDefinitionCode = customDimensions.alNewRowDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report row definition imported: {Row Definition Code}

Occurs when a user imports a financial report row definition.

General dimensions

DimensionDescription or value
messageFinancial Report Row Definition imported: {Row Definition Code}

Custom dimensions

DimensionDescription or value
alRowDefinitionCodeThe code of the row definition that was imported.
eventIdAL0000ONP

Sample KQL code (row definition imported)

This KQL code can help you get started analyzing import actions for financial report row definitions.

// Financial report row definition imported: {Row Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000ONP'
| where customDimensions.eventId == 'AL0000ONP'
| where message startswith 'Financial Report Row Definition imported:'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was imported
, rowDefinitionCode=customDimensions.alRowDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report row definition exported: {Row Definition Code}

Occurs when a user exports a financial report row definition.

General dimensions

DimensionDescription or value
messageFinancial Report Row Definition exported: {Row Definition Code}

Custom dimensions

DimensionDescription or value
alRowDefinitionCodeThe code of the row definition that was exported.
eventIdAL0000ONP

Sample KQL code (row definition exported)

This KQL code can help you get started analyzing export actions for financial report row definitions.

// Financial report row definition exported: {Row Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000ONP'
| where customDimensions.eventId == 'AL0000ONP'
| where message startswith 'Financial Report Row Definition exported:'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was exported
, rowDefinitionCode=customDimensions.alRowDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report row definition deleted: {Row Definition Code}

Occurs when a user deletes a financial report row definition.

General dimensions

DimensionDescription or value
messageFinancial Report Row Definition deleted: {Row Definition Code}

Custom dimensions

DimensionDescription or value
alRowDefinitionCodeThe code of the row definition that was deleted.
eventIdAL0000O84

Sample KQL code (row definition deleted)

This KQL code can help you get started analyzing deletions of financial report row definitions.

// Financial report row definition deleted: {Row Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000O84'
| where customDimensions.eventId == 'AL0000O84'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was deleted
, rowDefinitionCode=customDimensions.alRowDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report column definition created: {Column Definition Code}

Occurs when a user creates a new financial report column definition.

General dimensions

DimensionDescription or value
messageFinancial Report Column Definition created: {Column Definition Code}

Custom dimensions

DimensionDescription or value
alColumnDefinitionCodeThe financial report column definition that was created.
eventIdAL0000O85

Sample KQL code (column definition created)

This KQL code can help you get started analyzing creation of financial report column definitions.

// Financial report column definition created: {Column Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000O85'
| where customDimensions.eventId == 'AL0000O85'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was created
, columnDefinitionCode=customDimensions.alColumnDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report column definition modified: {Column Definition Code}

Occurs when a user modifies a financial report column definition.

General dimensions

DimensionDescription or value
messageFinancial Report Column Definition modified: {Column Definition Code}

Custom dimensions

DimensionDescription or value
alColumnDefinitionCodeThe financial report column definition that was modified.
eventIdAL0000O86

Sample KQL code (column definition modified)

This KQL code can help you get started analyzing modifications to financial report column definitions.

// Financial report column definition modified: {Column Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000O86'
| where customDimensions.eventId == 'AL0000O86'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was modified
, columnDefinitionCode=customDimensions.alColumnDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report column definition copied: {Column Definition Code}

Occurs when a user copies a financial report column definition.

General dimensions

DimensionDescription or value
messageFinancial Report Column Definition copied: {Column Definition Code}

Custom dimensions

DimensionDescription or value
alSourceColDefinitionCodeThe financial report column definition that was copied.
alNewColDefinitionCodeThe financial report column definition of the copy.
eventIdAL0000OKW

Sample KQL code (column definition copied)

This KQL code can help you get started analyzing copies taken on financial report column definitions.

// Financial report column definition copied: {Column Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000OKW'
| where customDimensions.eventId == 'AL0000OKW'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was copied
, sourceColDefinitionCode = customDimensions.alSourceColDefinitionCode
, newColDefinitionCode = customDimensions.alNewColDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report column definition imported: {Column Definition Code}

Occurs when a user imports a financial report column definition.

General dimensions

DimensionDescription or value
messageFinancial Report Column Definition imported: {Column Definition Code}

Custom dimensions

DimensionDescription or value
alColumnDefinitionCodeThe financial report column definition that was imported.
eventIdAL0000ONQ

Sample KQL code (column definition imported)

This KQL code can help you get started analyzing import actions of financial report column definitions.

// Financial report column definition imported: {Column Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000ONQ'
| where customDimensions.eventId == 'AL0000ONQ'
| where message startswith 'Financial Report Column Definition imported:'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was imported
, columnDefinitionCode=customDimensions.alColumnDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report column definition exported: {Column Definition Code}

Occurs when a user exports a financial report column definition.

General dimensions

DimensionDescription or value
messageFinancial Report Column Definition exported: {Column Definition Code}

Custom dimensions

DimensionDescription or value
alColumnDefinitionCodeThe financial report column definition that was exported.
eventIdAL0000ONQ

Sample KQL code (column definition exported)

This KQL code can help you get started analyzing exports of financial report column definitions.

// Financial report column definition exported: {Column Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000ONQ'
| where customDimensions.eventId == 'AL0000ONQ'
| where message startswith 'Financial Report Column Definition exported:'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was exported
, columnDefinitionCode=customDimensions.alColumnDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report column definition deleted: {Column Definition Code}

Occurs when a user deletes a financial report column definition.

General dimensions

DimensionDescription or value
messageFinancial Report Column Definition deleted: {Column Definition Code}

Custom dimensions

DimensionDescription or value
alColumnDefinitionCodeThe financial report column definition that was deleted.
eventIdAL0000O88

Sample KQL code (column definition deleted)

This KQL code can help you get started analyzing deletions of financial report column definitions.

// Financial report column definition deleted: {Column Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000O88'
| where customDimensions.eventId == 'AL0000O88'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was deleted
, columnDefinitionCode=customDimensions.alColumnDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report definition created: {Report Definition Code}

Occurs when a user creates a new financial report definition.

General dimensions

DimensionDescription or value
messageFinancial Report created: {Report Definition Code}

Custom dimensions

DimensionDescription or value
alReportDefinitionCodeThe code for the financial report definition that was created.
eventIdAL0000O77

Sample KQL code (financial report definition created)

This KQL code can help you get started analyzing creation of financial report definitions.

// Financial report definition created: {Report Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000O77'
| where customDimensions.eventId == 'AL0000O77'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was created
, reportDefinitionCode=customDimensions.alReportDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report definition copied: {Report Definition Code}

Occurs when a user takes a copy of a financial report definition.

General dimensions

DimensionDescription or value
messageFinancial Report Definition copied: {Report Definition Code}

Custom dimensions

DimensionDescription or value
alSourceReportDefinitionCodeThe code for the financial report definition that was copied.
alNewReportDefinitionCodeThe code for the copy of the financial report definition.
eventIdAL0000OKX

Sample KQL code (financial report definition copied)

This KQL code can help you get started analyzing financial report definitions being copied.

// Financial report definition copied: {Report Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000OKX'
| where customDimensions.eventId == 'AL0000OKX'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was copied
, sourceReportDefinitionCode = customDimensions.alSourceReportDefinitionCode
, newReportDefinitionCode = customDimensions.alNewReportDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report definition imported: {Report Definition Code}

Occurs when a user imports a financial report definition.

General dimensions

DimensionDescription or value
messageFinancial Report Definition imported: {Report Definition Code}

Custom dimensions

DimensionDescription or value
alReportDefinitionCodeThe code for the financial report definition that was imported.
eventIdAL0000ONR

Sample KQL code (financial report definition imported)

This KQL code can help you get started analyzing imports of financial report definitions.

// Financial report definition imported: {Report Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000ONR'
| where customDimensions.eventId == 'AL0000ONR'
| where message startswith 'Financial Report Definition imported:'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was imported
, reportDefinitionCode=customDimensions.alReportDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report definition exported: {Report Definition Code}

Occurs when a user exports a financial report definition.

General dimensions

DimensionDescription or value
messageFinancial Report Definition exported: {Report Definition Code}

Custom dimensions

DimensionDescription or value
alReportDefinitionCodeThe financial report definition that was exported.
eventIdAL0000ONR

Sample KQL code (financial report definition exported)

This KQL code can help you get started analyzing export actions of financial report definitions.

// Financial report definition exported: {Report Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000ONR'
| where customDimensions.eventId == 'AL0000ONR'
| where message startswith 'Financial Report Definition exported:'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was exported
, reportDefinitionCode=customDimensions.alReportDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report definition modified: {Report Definition Code}

Occurs when a user modifies a financial report definition.

General dimensions

DimensionDescription or value
messageFinancial Report modified: {Report Definition Code}

Custom dimensions

DimensionDescription or value
alReportDefinitionCodeThe financial report definition that was modified.
eventIdAL0000O78

Sample KQL code (financial report definition modified)

This KQL code can help you get started analyzing modifications of financial report definitions.

// Financial report definition modified: {Report Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000O78'
| where customDimensions.eventId == 'AL0000O78'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was modified
, reportDefinitionCode=customDimensions.alReportDefinitionCode
// which user did it
, usertelemetryId = user_Id

Financial report definition deleted: {Report Definition Code}

Occurs when a user deletes a financial report definition.

General dimensions

DimensionDescription or value
messageFinancial Report deleted: {Report Definition Code}

Custom dimensions

DimensionDescription or value
alReportDefinitionCodeThe financial report definition that was deleted.
eventIdAL0000O80

Sample KQL code (financial report definition deleted)

This KQL code can help you get started analyzing deletions of financial report definitions.

// Financial report definition deleted: {Report Definition Code}
traces
| where timestamp > ago(5d) // adjust the time range as needed
| where customDimensions has 'AL0000O80'
| where customDimensions.eventId == 'AL0000O80'
| project timestamp
// in which environment/company did it happen
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
// which definition was deleted
, reportDefinitionCode=customDimensions.alReportDefinitionCode
// which user did it
, usertelemetryId = user_Id

Design your own financial reports
Row definitions in financial reporting
Column definitions in financial reporting
Primary capabilities of financial reporting
Analyzing financial report usage trace telemetry
Monitoring and Analyzing Telemetry
Enable Sending Telemetry to Application Insights