tableFinanceofficial - Microsoftderived - from the source, no model text

Table 88 "Financial Report"

Base Application · Microsoft.Finance.FinancialReports

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC25unchanged
  4. BC265 fields added, 4 fields changed
  5. BC274 fields added
  6. BC288 fields added, 5 procedures added
  7. BC291 fields changed
  8. BC302 fields added, 1 fields changed

Neighbourhood 32 connected objects and pages

Table 8395 "Financial Report Status" (relates to, 2 links)Financial Report StatusTable 333 "Column Layout Name" (relates to)Table 764 "Fin. Report Excel Template" (relates to)Fin. Report Excel TemplateTable 8363 "Dimension Perspective Name" (relates to)Dimension Perspective NameTable 8391 "Financial Report Category" (relates to)Financial Report CategoryTable 84 "Acc. Schedule Name" (relates to)Acc. Schedule NamePage 108 "Financial Reports" (pages and codeunits on it, 2 links)Financial ReportsCodeunit 18 "Financial Report Mgt." (pages and codeunits on it)Financial Report Mgt.Codeunit 1351 "Telemetry Subscribers" (event subscribers, 4 links)Telemetry SubscribersCodeunit 8 "AccSchedManagement" (calls)AccSchedManagementTable 98 "General Ledger Setup" (referenced by, 4 links)General Ledger SetupTable 764 "Fin. Report Excel Template" (referenced by)Table 8360 "Financial Report Schedule" (referenced by)Financial Report ScheduleTable 8361 "Financial Report Export Log" (referenced by)Financial Report Export LogTable 8362 "Financial Report Recipient" (referenced by)Financial Report RecipientTable 8372 "Fin. Report Package Report" (referenced by)Table 8390 "Financial Report Audit Log" (referenced by)Financial Report Audit LogTable 89 "Financial Report User Filters" (referenced by)Accounting and bookkeeping (Learn pages)Audit changes to your setup (Learn pages)Auditing and financial reporting (Learn pages)Build financial reports using financial data and account categories (Learn pages)Create custom financial reports (Learn pages)Design your own financial reports (Learn pages)Financial analytics (Learn pages)Financial Reporting FAQ (Learn pages)Make cash flow forecasts using financial reports (Learn pages)Organize report data using account categories (Learn pages)Primary capabilities of financial reporting (Learn pages)Set Up and Publish KPI Web Services Based on Financial Reports (Learn pages)Sustainability financial reporting (Learn pages)Troubleshoot Financial Reporting (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

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" + BC28
  • GetEffectiveNegativeAmountFormat(): Enum "Analysis Negative Format" + BC28
  • GetEffectiveLogoPosition(): Enum "Fin. Report Logo Position" + BC28
  • SetDefaultStatusFromGLSetup() + BC28

Plus 1 local procedures.

Triggers

OnInsert, OnRename, OnDelete

Relations

Referenced by

11 fields in 8 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

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.

Recent changes

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.

Evidence 1 sources