Table 88 "Financial Report"
Base Application · Microsoft.Finance.FinancialReports
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC265 fields added, 4 fields changed
- BC274 fields added
- BC288 fields added, 5 procedures added
- BC291 fields changed
- BC302 fields added, 1 fields changed
Neighbourhood 32 connected objects and pages
Base Application · Microsoft.Finance.FinancialReports · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 108 “Financial Reports” (14 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Financial Report |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 2 | Name Δ BC26 | Code[10] | Specifies the unique name (code) of the financial report. | NotBlank |
| 3 | UseAmountsInAddCurrency | Boolean | Use Amounts in Additional Currency caption | DataClassification SystemMetadata |
| 4 | PeriodType Δ BC28 | Enum “Analysis Period Type” | Period Type caption | obsolete Pending 28.0; #if not CLEANSCHEMA30; enum Enum 362 “Analysis Period Type”; DataClassification SystemMetadata |
| 5 | ShowLinesWithShowNo | Boolean | Show All Lines caption | DataClassification SystemMetadata |
| 6 | Dim1Filter | Text[2048] | Dimension 1 Filter caption | DataClassification SystemMetadata |
| 7 | Dim2Filter | Text[2048] | Dimension 2 Filter caption | DataClassification SystemMetadata |
| 8 | Dim3Filter | Text[2048] | Dimension 3 Filter caption | DataClassification SystemMetadata |
| 9 | Dim4Filter | Text[2048] | Dimension 4 Filter caption | DataClassification SystemMetadata |
| 10 | CostCenterFilter | Text[2048] | Cost Center Filter caption | DataClassification SystemMetadata |
| 11 | CostObjectFilter | Text[2048] | Cost Object Filter caption | DataClassification SystemMetadata |
| 12 | CashFlowFilter | Text[2048] | Cash Flow Filter caption | DataClassification SystemMetadata |
| 13 | GLBudgetFilter | Text[2048] | G/L Budget Filter caption | DataClassification SystemMetadata |
| 14 | CostBudgetFilter | Text[2048] | Cost Budget Filter caption | DataClassification SystemMetadata |
| 15 | DateFilter | Text[2048] | Date Filter caption | DataClassification SystemMetadata |
| 16 | Excel Template Code + BC26 | Code[50] | Specifies the Excel Layout that will be used when exporting to Excel. | TableRelation Table 764 “Fin. Report Excel Template” (“Fin. Report Excel Template”.“Code” where(“Financial Report Name” = field(Name))); DataClassification SystemMetadata |
| 17 | NegativeAmountFormat + BC26 Δ BC28 | Enum “Analysis Negative Format” | Negative Amount Format caption | obsolete Pending 28.0; #if not CLEANSCHEMA30; enum Enum 5001 “Analysis Negative Format”; DataClassification SystemMetadata |
| 18 | PeriodTypeDefault + BC28 | Enum “Financial Report Period Type” | Specifies by which period amounts are displayed. | enum Enum 1080 “Financial Report Period Type”; DataClassification SystemMetadata |
| 19 | NegativeAmountFormatDefault + BC28 | Enum “Fin. Report Negative Format” | Specifies the default negative amount format for this financial report. | enum Enum 1083 “Fin. Report Negative Format”; DataClassification SystemMetadata |
| 50 | Description Δ BC26 | Text[80] | Specifies a title of the financial report. The text is shown as a title on the final report when you run it to get a PDF or to print it. | |
| 51 | Financial Report Row Group Δ BC26 | Code[10] | Specifies the row definition (code) to be used for this financial report. | TableRelation Table 84 “Acc. Schedule Name” (Acc. Schedule Name); DataClassification SystemMetadata |
| 52 | Financial Report Column Group Δ BC26 | Code[10] | Specifies the column definition (code) to be used for this financial report. | TableRelation Table 333 “Column Layout Name” (Column Layout Name); DataClassification SystemMetadata |
| 53 | Internal Description + BC26 Δ BC28 | Text[500] | Specifies the internal description of this financial report. | |
| 54 | Introductory Paragraph + BC26 | Blob | — | |
| 55 | Closing Paragraph + BC26 | Blob | — | |
| 56 | StartDateFilterFormula + BC27 | DateFormula | Start Date Filter Formula caption | DataClassification SystemMetadata |
| 57 | EndDateFilterFormula + BC27 | DateFormula | End Date Filter Formula caption | DataClassification SystemMetadata |
| 58 | DateFilterPeriodFormula + BC27 | Code[20] | Date Filter Period Formula caption | DataClassification SystemMetadata |
| 59 | DateFilterPeriodFormulaLID + BC27 | Integer | Date Filter Period Formula Lang. ID caption | DataClassification SystemMetadata |
| 60 | LogoPositionDefault + BC28 | Enum “Fin. Report Logo Position Def.” | Specifies how your company logo is displayed on the financial report. | enum Enum 1082 “Fin. Report Logo Position Def.” |
| 61 | DimPerspective + BC28 Δ BC29 | Code[10] | Specifies the dimension perspective to be used for the financial report. | TableRelation Table 8363 “Dimension Perspective Name” (Dimension Perspective Name) |
| 62 | Last Run by User + BC28 Δ BC30 | DateTime | Specifies the last date-time this report was run by you. | FlowField: max(“Financial Report Audit Log”.SystemCreatedAt where( “Report Name” = field(Name), User = filter(‘%user’))); not editable |
| 63 | CategoryCode + BC28 | Code[20] | Specifies the category code for the financial report. | TableRelation Table 8391 “Financial Report Category” (Financial Report Category) |
| 64 | Status + BC28 | Code[10] | Specifies the status code for the financial report. The status code helps you organize the lifecycle of your financial reports. | TableRelation Table 8395 “Financial Report Status” (Financial Report Status) |
| 65 | Status Blocked + BC28 | Boolean | Specifies the status code is a blocked status. | FlowField: exist(“Financial Report Status” where(“Code” = field(Status), “Blocked” = const(true))); not editable |
Keys
- Key1: Name (clustered)
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 1351 “Telemetry Subscribers” LogFinancialReportLifecycleDelete
- OnAfterInsertEvent: Codeunit 1351 “Telemetry Subscribers” LogFinancialReportLifecycleInsert
- OnAfterModifyEvent: Codeunit 1351 “Telemetry Subscribers” LogFinancialReportLifecycleModify
- OnAfterRenameEvent: Codeunit 1351 “Telemetry Subscribers” LogFinancialReportLifecycleRename
Procedures
GetIntroductoryParagraph(): Text+ BC26: Retrieves the introductory paragraph text from the BLOB field. Returns the formatted text content for display in financial reports.SetIntroductionParagraph(TextValue: Text)+ BC26: Sets the introductory paragraph text in the BLOB field. Stores formatted text content for inclusion in financial reports.GetClosingParagraph(): Text+ BC26: Retrieves the closing paragraph text from the BLOB field. Returns the formatted text content for display in financial reports.SetClosingParagraph(TextValue: Text)+ BC26: Sets the closing paragraph text in the BLOB field. Stores formatted text content for financial report footer display.GetEffectivePeriodType(): Enum "Analysis Period Type"+ BC28GetEffectiveNegativeAmountFormat(): Enum "Analysis Negative Format"+ BC28GetEffectiveLogoPosition(): Enum "Fin. Report Logo Position"+ BC28SetDefaultStatusFromGLSetup()+ BC28
Plus 1 local procedures.
Triggers
OnInsert, OnRename, OnDelete
Relations
- lookup page Page 108 “Financial Reports”
- Financial Report Column Group: TableRelation Table 333 “Column Layout Name”
- Excel Template Code: TableRelation Table 764 “Fin. Report Excel Template”
- DimPerspective: TableRelation Table 8363 “Dimension Perspective Name”
- CategoryCode: TableRelation Table 8391 “Financial Report Category”
- Status Blocked: CalcFormula Table 8395 “Financial Report Status”
- Status: TableRelation Table 8395 “Financial Report Status”
- Financial Report Row Group: TableRelation Table 84 “Acc. Schedule Name”
Referenced by
11 fields in 8 objects relate to this table (TableRelation or CalcFormula).
- Table 98 “General Ledger Setup”: Fin. Rep. for Balance Sheet, Fin. Rep. for Cash Flow Stmt, Fin. Rep. for Income Stmt., Fin. Rep. for Retained Earn.
- Table 764 “Fin. Report Excel Template”: Financial Report Name
- Table 8360 “Financial Report Schedule”: Financial Report Name
- Table 8361 “Financial Report Export Log”: Financial Report Name
- Table 8362 “Financial Report Recipient”: Financial Report Name
- Table 8372 “Fin. Report Package Report”: Financial Report Name
- Table 8390 “Financial Report Audit Log”: Report Name
- Table 89 “Financial Report User Filters”: Financial Report Name
Pages and codeunits on this table
- Page 108 “Financial Reports” (source table)
- Codeunit 18 “Financial Report Mgt.” (codeunit runs on it)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 8 “AccSchedManagement” (1 call:
OnInsert → CheckAnalysisView)
Recent changes
- 2026-10-06 #12304 [Master]-Page cannot open because of FlowField ‘Last Run By User’ (main, BC30, fix)
Deprecations
- field NegativeAmountFormat: Pending 28.0 (#if not CLEANSCHEMA30), “This field has been replaced by the NegativeAmountFormatDefault field.”
- field PeriodType: Pending 28.0 (#if not CLEANSCHEMA30), “This field has been replaced by the PeriodTypeDefault field.”
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "table", object_name: "Financial Report"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.