Table 376 "G/L Account (Analysis View)"
Base Application · Microsoft.Finance.Analysis
Across versions
- BC23present
- BC2412 fields changed
- BC25unchanged
- BC261 fields changed
- BC27unchanged
- BC2814 fields changed, 1 procedures added
- BC2920 fields changed
- BC30unchanged
Neighbourhood 19 connected objects and pages
Base Application · Microsoft.Finance.Analysis · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 569 “Chart of Accs. (Analysis View)” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | G/L Account (Analysis View) |
| 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 |
|---|---|---|---|---|
| 1 | No. Δ BC29 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | TableRelation Table 15 “G/L Account”, Table 841 “Cash Flow Account” (if (“Account Source” = const(“G/L Account”)) “G/L Account” else if (“Account Source” = const(“Cash Flow Account”)) “Cash Flow Account”); NotBlank |
| 2 | Name Δ BC29 | Text[100] | Specifies the name of the general ledger account. | |
| 3 | Search Name | Code[100] | — | |
| 4 | Account Type Δ BC29 | Enum “G/L Account Type” | Specifies the purpose of the account. Total: Used to total a series of balances on accounts from many different account groupings. To use Total, leave this field blank. Begin-Total: A marker for the beginning of a series of accounts to be totaled that ends with an End-Total account. End-Total: A tot… | enum Enum 16 “G/L Account Type” |
| 5 | Account Source | Enum “Analysis Account Source” | — | enum Enum 7133 “Analysis Account Source” |
| 6 | Global Dimension 1 Code | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 7 | Global Dimension 2 Code | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 9 | Income/Balance Δ BC26 Δ BC29 | Enum “G/L Account Report Type” | Specifies whether a general ledger account is an income statement account or a balance sheet account. | enum Enum 20 “G/L Account Report Type” |
| 10 | Debit/Credit | Option | — | OptionCaption: Both,Debit,Credit |
| 11 | No. 2 | Code[20] | — | |
| 12 | Comment | Boolean | — | FlowField: exist(“Comment Line” where(“Table Name” = const(“G/L Account”), “No.” = field(“No.”))); not editable |
| 13 | Blocked | Boolean | — | |
| 14 | Direct Posting Δ BC29 | Boolean | Specifies whether you will be able to post directly or only indirectly to this general ledger account. | |
| 16 | Reconciliation Account | Boolean | — | |
| 17 | New Page | Boolean | — | |
| 18 | No. of Blank Lines | Integer | — | |
| 19 | Indentation | Integer | — | |
| 26 | Last Date Modified | Date | — | not editable |
| 27 | Cash Flow Forecast Filter | Code[20] | — | TableRelation Table 840 “Cash Flow Forecast” (Cash Flow Forecast); FlowFilter |
| 28 | Date Filter | Date | — | FlowFilter |
| 29 | Global Dimension 1 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); FlowFilter |
| 30 | Global Dimension 2 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))); FlowFilter |
| 31 | Balance at Date Δ BC24 Δ BC28 Δ BC29 | Decimal | Specifies the G/L account balance on the last date included in the Date Filter field. | FlowField: sum(“Analysis View Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dime…; not editable |
| 32 | Net Change Δ BC24 Δ BC28 Δ BC29 | Decimal | Specifies the net change in the account balance during the time period in the Date Filter field. | FlowField: sum(“Analysis View Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dime…; not editable |
| 33 | Budgeted Amount Δ BC24 Δ BC28 Δ BC29 | Decimal | Specifies either the G/L account’s total budget or, if you have specified a name in the Budget Name field, a specific budget. | FlowField: sum(“Analysis View Budget Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Budget Name” = field(“Budget Filter”), “Business Unit Code” = field(“Business Unit Filter”), “G/L Account No.” = field(“No.”), “G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = … |
| 34 | Totaling Δ BC29 | Text[250] | Specifies an account interval or a list of account numbers. The entries of the account will be totaled to give a total balance. How entries are totaled depends on the value in the Account Type field. | TableRelation Table 15 “G/L Account”, Table 841 “Cash Flow Account” (if (“Account Source” = const(“G/L Account”)) “G/L Account” else if (“Account Source” = const(“Cash Flow Account”)) “Cash Flow Account”) |
| 35 | Budget Filter | Code[10] | — | TableRelation Table 95 “G/L Budget Name” (G/L Budget Name); FlowFilter |
| 36 | Balance Δ BC24 Δ BC28 Δ BC29 | Decimal | Specifies the balance on this account. | FlowField: sum(“Analysis View Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field(“Dime…; not editable |
| 37 | Budgeted at Date Δ BC24 Δ BC28 | Decimal | — | FlowField: sum(“Analysis View Budget Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Budget Name” = field(“Budget Filter”), “Business Unit Code” = field(“Business Unit Filter”), “G/L Account No.” = field(“No.”), “G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = … |
| 40 | Consol. Debit Acc. Δ BC29 | Code[20] | Specifies the account number in a consolidated company to transfer credit balances. | |
| 41 | Consol. Credit Acc. Δ BC29 | Code[20] | Specifies the account number in a consolidated company to transfer credit balances. | |
| 42 | Business Unit Filter | Code[20] | — | TableRelation Table 220 “Business Unit” (Business Unit); FlowFilter |
| 43 | Gen. Posting Type Δ BC29 | Option | Specifies the type of transaction. | OptionCaption: ,Purchase,Sale |
| 44 | Gen. Bus. Posting Group Δ BC29 | Code[20] | Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 45 | Gen. Prod. Posting Group Δ BC29 | Code[20] | Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. | TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group) |
| 47 | Debit Amount Δ BC28 | Decimal | — | FlowField: sum(“Analysis View Entry”.“Debit Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(Totaling), “Dimension 1 Value Code” = field(“Dime…; not editable |
| 48 | Credit Amount Δ BC28 | Decimal | — | FlowField: sum(“Analysis View Entry”.“Credit Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(Totaling), “Dimension 1 Value Code” = field(“Dim…; not editable |
| 49 | Automatic Ext. Texts | Boolean | — | |
| 52 | Budgeted Debit Amount Δ BC24 Δ BC28 | Decimal | — | FlowField: sum(“Analysis View Budget Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Budget Name” = field(“Budget Filter”), “Business Unit Code” = field(“Business Unit Filter”), “G/L Account No.” = field(“No.”), “G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = … |
| 53 | Budgeted Credit Amount Δ BC24 Δ BC28 | Decimal | — | FlowField: - sum(“Analysis View Budget Entry”.Amount where(“Analysis View Code” = field(“Analysis View Filter”), “Budget Name” = field(“Budget Filter”), “Business Unit Code” = field(“Business Unit Filter”), “G/L Account No.” = field(“No.”), “G/L Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” … |
| 54 | Tax Area Code | Code[20] | — | TableRelation Table 318 “Tax Area” (Tax Area) |
| 55 | Tax Liable | Boolean | — | |
| 56 | Tax Group Code | Code[20] | — | TableRelation Table 321 “Tax Group” (Tax Group) |
| 57 | VAT Bus. Posting Group Δ BC29 | Code[20] | Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 58 | VAT Prod. Posting Group Δ BC29 | Code[20] | Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. | TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group) |
| 60 | Additional-Currency Net Change Δ BC24 Δ BC28 Δ BC29 | Decimal | Specifies the net change in the account balance. | FlowField: sum(“Analysis View Entry”.“Add.-Curr. Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” …; not editable |
| 61 | Add.-Currency Balance at Date Δ BC24 Δ BC28 Δ BC29 | Decimal | Specifies the G/L account balance, in the additional reporting currency, on the last date included in the Date Filter field. | FlowField: sum(“Analysis View Entry”.“Add.-Curr. Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” …; not editable |
| 62 | Additional-Currency Balance Δ BC24 Δ BC28 Δ BC29 | Decimal | Specifies the balance on this account, in the additional reporting currency. | FlowField: sum(“Analysis View Entry”.“Add.-Curr. Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” …; not editable |
| 63 | Exchange Rate Adjustment | Option | — | OptionCaption: No Adjustment,Adjust Amount,Adjust Additional-Currency Amount |
| 64 | Add.-Currency Debit Amount Δ BC24 Δ BC28 | Decimal | — | FlowField: sum(“Analysis View Entry”.“Add.-Curr. Debit Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value …; not editable |
| 65 | Add.-Currency Credit Amount Δ BC24 Δ BC28 | Decimal | — | FlowField: sum(“Analysis View Entry”.“Add.-Curr. Credit Amount” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value…; not editable |
| 66 | Analysis View Filter | Code[10] | — | TableRelation Table 363 “Analysis View” (Analysis View); FlowFilter |
| 67 | Dimension 1 Filter | Code[20] | — | FlowFilter |
| 68 | Dimension 2 Filter | Code[20] | — | FlowFilter |
| 69 | Dimension 3 Filter | Code[20] | — | FlowFilter |
| 70 | Dimension 4 Filter | Code[20] | — | FlowFilter |
Keys
- Key1: No., Account Source (clustered)
- Key2: Search Name
- Key3: Reconciliation Account
- Key4: Gen. Bus. Posting Group
- Key5: Gen. Prod. Posting Group
Events published
OnBeforeGetCaptionClass(var GLAccountAnalysisView: Record "G/L Account (Analysis View)"; AnalysisViewDimType: Integer; var Result: Text[250]; var IsHandled: Boolean)(integration): Integration event for customizing caption class generation for analysis view dimensions.
Procedures
GetCaptionClass(AnalysisViewDimType: Integer): Text[250]: Returns the caption class string for dimension fields based on analysis view configuration.CopyDimFilters(var AccSchedLine: Record "Acc. Schedule Line"): Copies dimension filters from account schedule line to this analysis view record.SetDimFilters(DimFilter1: Text; DimFilter2: Text; DimFilter3: Text; DimFilter4: Text): Sets dimension filters for analysis view filtering.
Plus 1 local procedures.
Relations
- No.: TableRelation Table 15 “G/L Account” (conditional)
- Totaling: TableRelation Table 15 “G/L Account” (conditional)
- Business Unit Filter: TableRelation Table 220 “Business Unit”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- Tax Group Code: TableRelation Table 321 “Tax Group”
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
- Analysis View Filter: TableRelation Table 363 “Analysis View”
- Add.-Currency Balance at Date: CalcFormula Table 365 “Analysis View Entry”
- Add.-Currency Credit Amount: CalcFormula Table 365 “Analysis View Entry”
- Add.-Currency Debit Amount: CalcFormula Table 365 “Analysis View Entry”
- Additional-Currency Balance: CalcFormula Table 365 “Analysis View Entry”
- Additional-Currency Net Change: CalcFormula Table 365 “Analysis View Entry”
- Balance: CalcFormula Table 365 “Analysis View Entry”
- Balance at Date: CalcFormula Table 365 “Analysis View Entry”
- Credit Amount: CalcFormula Table 365 “Analysis View Entry”
- Debit Amount: CalcFormula Table 365 “Analysis View Entry”
- Net Change: CalcFormula Table 365 “Analysis View Entry”
- Budgeted Amount: CalcFormula Table 366 “Analysis View Budget Entry”
- Budgeted at Date: CalcFormula Table 366 “Analysis View Budget Entry”
- Budgeted Credit Amount: CalcFormula Table 366 “Analysis View Budget Entry”
- Budgeted Debit Amount: CalcFormula Table 366 “Analysis View Budget Entry”
- Cash Flow Forecast Filter: TableRelation Table 840 “Cash Flow Forecast”
- No.: TableRelation Table 841 “Cash Flow Account” (conditional)
- Totaling: TableRelation Table 841 “Cash Flow Account” (conditional)
- Budget Filter: TableRelation Table 95 “G/L Budget Name”
- Comment: CalcFormula Table 97 “Comment Line”
Pages and codeunits on this table
- Page 569 “Chart of Accs. (Analysis View)” (source table)
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: "table", object_name: "G/L Account (Analysis View)"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.