--- id: object/table/88 type: object title: Table 88 "Financial Report" summary: Table 88 "Financial Report" in Base Application (Microsoft.Finance.FinancialReports). 34 fields, 8 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC26-30. tier: official language: en tags: - table - base application versions: introduced: null last_changed: "30" deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: 715846e9d0b649e413f5a95f560e6c68fa519c071aba19649540e045dd4a715e evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/FinancialReport.Table.al title: src/Layers/W1/BaseApp/Finance/FinancialReports/FinancialReport.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: - https://learn.microsoft.com/dynamics365/business-central/across-setup-auditing - https://learn.microsoft.com/dynamics365/business-central/bi-account-categories - https://learn.microsoft.com/dynamics365/business-central/bi-design-financial-reports - https://learn.microsoft.com/dynamics365/business-central/bi-examples-custom-financial-reports - https://learn.microsoft.com/dynamics365/business-central/bi-how-to-set-up-and-publish-kpi-web-services-based-on-account-schedules - https://learn.microsoft.com/dynamics365/business-central/bi-how-work-account-schedule - https://learn.microsoft.com/dynamics365/business-central/bi-troubleshoot-financial-reports - https://learn.microsoft.com/dynamics365/business-central/bi - https://learn.microsoft.com/dynamics365/business-central/finance-financial-reporting-auditing - https://learn.microsoft.com/dynamics365/business-central/finance-financial-reporting-capabilities - https://learn.microsoft.com/dynamics365/business-central/finance-financial-reporting-faq - https://learn.microsoft.com/dynamics365/business-central/learn-accounting-bookkeeping-guide - https://learn.microsoft.com/dynamics365/business-central/sustainability-fin-reporting - https://learn.microsoft.com/dynamics365/business-central/walkthrough-making-cash-flow-forecasts-by-using-account-schedules objects: [] features: [] topics: - topic/business-central/analytics-business-intelligence-and-repo/built-in-reports/finance - topic/business-central/analytics-business-intelligence-and-repo/kpis-dashboards-and-financial-reports - topic/business-central/business-functionality/finance - topic/business-central/business-functionality/finance/financial-analytics - topic/business-central/business-functionality/finance/financial-analytics/financial-reporting - topic/business-central/business-functionality/finance/manage-cash-flow - topic/business-central/business-functionality/set-up-business-central - topic/business-central/business-functionality/set-up-business-central/set-up-finance - topic/business-central/business-functionality/sustainability-management/sustainability-analytics - topic/business-central/get-started/learn/business-process-walkthroughs localizations: [] videos: [] posts: [] guidelines: [] changes: - change/bcapps/12304 object_type: table object_id: 88 name: Financial Report namespace: Microsoft.Finance.FinancialReports app: Base Application extends: null first_version: "23" last_version: "30" present_in: - "23" - "24" - "25" - "26" - "27" - "28" - "29" - "30" changed_in: - "24" - "26" - "27" - "28" - "29" - "30" source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 34 procedures: 9 events: 0 subscribers: 0 relations: out: 8 referenced_by: 11 pages: 1 extended_by: 0 event_subscribers: 4 calls: 1 called_by: 0 implements: 0 --- # Table 88 "Financial Report" > Table 88 "Financial Report" in Base Application (Microsoft.Finance.FinancialReports). 34 fields, 8 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC26-30. Base Application · Microsoft.Finance.FinancialReports · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/FinancialReport.Table.al) · facts from BC29 Learn documents this table through its pages: [Page 108 "Financial Reports"](../page/108.md) (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 | 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 | Enum "Analysis Period Type" | Period Type caption | obsolete Pending 28.0; #if not CLEANSCHEMA30; enum [Enum 362 "Analysis Period Type"](../enum/362.md); 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 | Code[50] | Specifies the Excel Layout that will be used when exporting to Excel. | TableRelation [Table 764 "Fin. Report Excel Template"](../table/764.md) ("Fin. Report Excel Template"."Code" where("Financial Report Name" = field(Name))); DataClassification SystemMetadata | | 17 | NegativeAmountFormat | Enum "Analysis Negative Format" | Negative Amount Format caption | obsolete Pending 28.0; #if not CLEANSCHEMA30; enum [Enum 5001 "Analysis Negative Format"](../enum/5001.md); DataClassification SystemMetadata | | 18 | PeriodTypeDefault | Enum "Financial Report Period Type" | Specifies by which period amounts are displayed. | enum [Enum 1080 "Financial Report Period Type"](../enum/1080.md); DataClassification SystemMetadata | | 19 | NegativeAmountFormatDefault | Enum "Fin. Report Negative Format" | Specifies the default negative amount format for this financial report. | enum [Enum 1083 "Fin. Report Negative Format"](../enum/1083.md); DataClassification SystemMetadata | | 50 | Description | 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 | Code[10] | Specifies the row definition (code) to be used for this financial report. | TableRelation [Table 84 "Acc. Schedule Name"](../table/84.md) (Acc. Schedule Name); DataClassification SystemMetadata | | 52 | Financial Report Column Group | Code[10] | Specifies the column definition (code) to be used for this financial report. | TableRelation [Table 333 "Column Layout Name"](../table/333.md) (Column Layout Name); DataClassification SystemMetadata | | 53 | Internal Description | Text[500] | Specifies the internal description of this financial report. | | | 54 | Introductory Paragraph | Blob | — | | | 55 | Closing Paragraph | Blob | — | | | 56 | StartDateFilterFormula | DateFormula | Start Date Filter Formula caption | DataClassification SystemMetadata | | 57 | EndDateFilterFormula | DateFormula | End Date Filter Formula caption | DataClassification SystemMetadata | | 58 | DateFilterPeriodFormula | Code[20] | Date Filter Period Formula caption | DataClassification SystemMetadata | | 59 | DateFilterPeriodFormulaLID | Integer | Date Filter Period Formula Lang. ID caption | DataClassification SystemMetadata | | 60 | LogoPositionDefault | 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."](../enum/1082.md) | | 61 | DimPerspective | Code[10] | Specifies the dimension perspective to be used for the financial report. | TableRelation [Table 8363 "Dimension Perspective Name"](../table/8363.md) (Dimension Perspective Name) | | 62 | Last Run by User | 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 | Code[20] | Specifies the category code for the financial report. | TableRelation [Table 8391 "Financial Report Category"](../table/8391.md) (Financial Report Category) | | 64 | Status | 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"](../table/8395.md) (Financial Report Status) | | 65 | Status Blocked | 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"](../codeunit/1351.md) LogFinancialReportLifecycleDelete - OnAfterInsertEvent: [Codeunit 1351 "Telemetry Subscribers"](../codeunit/1351.md) LogFinancialReportLifecycleInsert - OnAfterModifyEvent: [Codeunit 1351 "Telemetry Subscribers"](../codeunit/1351.md) LogFinancialReportLifecycleModify - OnAfterRenameEvent: [Codeunit 1351 "Telemetry Subscribers"](../codeunit/1351.md) LogFinancialReportLifecycleRename ## Procedures - `GetIntroductoryParagraph(): Text`: Retrieves the introductory paragraph text from the BLOB field. Returns the formatted text content for display in financial reports. - `SetIntroductionParagraph(TextValue: Text)`: Sets the introductory paragraph text in the BLOB field. Stores formatted text content for inclusion in financial reports. - `GetClosingParagraph(): Text`: Retrieves the closing paragraph text from the BLOB field. Returns the formatted text content for display in financial reports. - `SetClosingParagraph(TextValue: Text)`: Sets the closing paragraph text in the BLOB field. Stores formatted text content for financial report footer display. - `GetEffectivePeriodType(): Enum "Analysis Period Type"` - `GetEffectiveNegativeAmountFormat(): Enum "Analysis Negative Format"` - `GetEffectiveLogoPosition(): Enum "Fin. Report Logo Position"` - `SetDefaultStatusFromGLSetup()` Plus 1 local procedures. ## Triggers OnInsert, OnRename, OnDelete ## Relations - lookup page [Page 108 "Financial Reports"](../page/108.md) - Financial Report Column Group: TableRelation [Table 333 "Column Layout Name"](../table/333.md) - Excel Template Code: TableRelation [Table 764 "Fin. Report Excel Template"](../table/764.md) - DimPerspective: TableRelation [Table 8363 "Dimension Perspective Name"](../table/8363.md) - CategoryCode: TableRelation [Table 8391 "Financial Report Category"](../table/8391.md) - Status Blocked: CalcFormula [Table 8395 "Financial Report Status"](../table/8395.md) - Status: TableRelation [Table 8395 "Financial Report Status"](../table/8395.md) - Financial Report Row Group: TableRelation [Table 84 "Acc. Schedule Name"](../table/84.md) ## Referenced by 11 fields in 8 objects relate to this table (TableRelation or CalcFormula). - [Table 98 "General Ledger Setup"](../table/98.md): 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"](../table/764.md): Financial Report Name - [Table 8360 "Financial Report Schedule"](../table/8360.md): Financial Report Name - [Table 8361 "Financial Report Export Log"](../table/8361.md): Financial Report Name - [Table 8362 "Financial Report Recipient"](../table/8362.md): Financial Report Name - [Table 8372 "Fin. Report Package Report"](../table/8372.md): Financial Report Name - [Table 8390 "Financial Report Audit Log"](../table/8390.md): Report Name - [Table 89 "Financial Report User Filters"](../table/89.md): Financial Report Name ## Pages and codeunits on this table - [Page 108 "Financial Reports"](../page/108.md) (source table) - [Codeunit 18 "Financial Report Mgt."](../codeunit/18.md) (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"](../codeunit/8.md) (1 call: `OnInsert → CheckAnalysisView`) ## Recent changes - 2026-10-06 [#12304 [Master]-Page cannot open because of FlowField 'Last Run By User'](../../changes/bcapps/12304.md) (main, BC30, fix) ## Across versions - Present in: BC23-30 - Changed (declaration) in: BC24, BC26-30 ## 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.