---
id: object/table/376
type: object
title: Table 376 "G/L Account (Analysis View)"
summary: Table 376 "G/L Account (Analysis View)" in Base Application (Microsoft.Finance.Analysis). 56 fields, 3 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC26, BC28-29.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "29"
  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: 65144e2c80cfafee8e8bc2f3b67ed02b908783b348b9c930cd2364f68fa8c51c
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/Analysis/GLAccountAnalysisView.Table.al
    title: src/Layers/W1/BaseApp/Finance/Analysis/GLAccountAnalysisView.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/finance-chart-of-accounts
    - https://learn.microsoft.com/dynamics365/business-central/finance-general-ledger
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/finance/financial-analytics/built-in-finance-analysis-tools
    - topic/business-central/business-functionality/finance/work-with-the-chart-of-accounts-and-gene
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 376
name: G/L Account (Analysis View)
namespace: Microsoft.Finance.Analysis
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"
  - "28"
  - "29"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 56
  procedures: 5
  events: 1
  subscribers: 0
relations:
  out: 33
  referenced_by: 0
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 376 "G/L Account (Analysis View)"

> Table 376 "G/L Account (Analysis View)" in Base Application (Microsoft.Finance.Analysis). 56 fields, 3 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC26, BC28-29.

Base Application · Microsoft.Finance.Analysis · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/Analysis/GLAccountAnalysisView.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 569 "Chart of Accs. (Analysis View)"](../page/569.md) (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. | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | TableRelation [Table 15 "G/L Account"](../table/15.md), [Table 841 "Cash Flow Account"](../table/841.md) (if ("Account Source" = const("G/L Account")) "G/L Account" else if ("Account Source" = const("Cash Flow Account")) "Cash Flow Account"); NotBlank |
| 2 | Name | Text[100] | Specifies the name of the general ledger account. |  |
| 3 | Search Name | Code[100] | — |  |
| 4 | Account Type | 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"](../enum/16.md) |
| 5 | Account Source | Enum "Analysis Account Source" | — | enum [Enum 7133 "Analysis Account Source"](../enum/7133.md) |
| 6 | Global Dimension 1 Code | Code[20] | — | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1))) |
| 7 | Global Dimension 2 Code | Code[20] | — | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2))) |
| 9 | Income/Balance | 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"](../enum/20.md) |
| 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 | 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"](../table/840.md) (Cash Flow Forecast); FlowFilter |
| 28 | Date Filter | Date | — | FlowFilter |
| 29 | Global Dimension 1 Filter | Code[20] | — | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1))); FlowFilter |
| 30 | Global Dimension 2 Filter | Code[20] | — | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2))); FlowFilter |
| 31 | Balance at Date | 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 | 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 | 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 | 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/15.md), [Table 841 "Cash Flow Account"](../table/841.md) (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"](../table/95.md) (G/L Budget Name); FlowFilter |
| 36 | Balance | 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 | 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. | Code[20] | Specifies the account number in a consolidated company to transfer credit balances. |  |
| 41 | Consol. Credit Acc. | 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"](../table/220.md) (Business Unit); FlowFilter |
| 43 | Gen. Posting Type | Option | Specifies the type of transaction. | OptionCaption: ,Purchase,Sale |
| 44 | Gen. Bus. Posting Group | 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"](../table/250.md) (Gen. Business Posting Group) |
| 45 | Gen. Prod. Posting Group | 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"](../table/251.md) (Gen. Product Posting Group) |
| 47 | Debit Amount | 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 | 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 | 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 | 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"](../table/318.md) (Tax Area) |
| 55 | Tax Liable | Boolean | — |  |
| 56 | Tax Group Code | Code[20] | — | TableRelation [Table 321 "Tax Group"](../table/321.md) (Tax Group) |
| 57 | VAT Bus. Posting Group | 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"](../table/323.md) (VAT Business Posting Group) |
| 58 | VAT Prod. Posting Group | 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"](../table/324.md) (VAT Product Posting Group) |
| 60 | Additional-Currency Net Change | 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 | 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 | 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 | 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 | 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"](../table/363.md) (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"](../table/15.md) (conditional)
- Totaling: TableRelation [Table 15 "G/L Account"](../table/15.md) (conditional)
- Business Unit Filter: TableRelation [Table 220 "Business Unit"](../table/220.md)
- Gen. Bus. Posting Group: TableRelation [Table 250 "Gen. Business Posting Group"](../table/250.md)
- Gen. Prod. Posting Group: TableRelation [Table 251 "Gen. Product Posting Group"](../table/251.md)
- Tax Area Code: TableRelation [Table 318 "Tax Area"](../table/318.md)
- Tax Group Code: TableRelation [Table 321 "Tax Group"](../table/321.md)
- VAT Bus. Posting Group: TableRelation [Table 323 "VAT Business Posting Group"](../table/323.md)
- VAT Prod. Posting Group: TableRelation [Table 324 "VAT Product Posting Group"](../table/324.md)
- Global Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Global Dimension 1 Filter: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Global Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Global Dimension 2 Filter: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Analysis View Filter: TableRelation [Table 363 "Analysis View"](../table/363.md)
- Add.-Currency Balance at Date: CalcFormula [Table 365 "Analysis View Entry"](../table/365.md)
- Add.-Currency Credit Amount: CalcFormula [Table 365 "Analysis View Entry"](../table/365.md)
- Add.-Currency Debit Amount: CalcFormula [Table 365 "Analysis View Entry"](../table/365.md)
- Additional-Currency Balance: CalcFormula [Table 365 "Analysis View Entry"](../table/365.md)
- Additional-Currency Net Change: CalcFormula [Table 365 "Analysis View Entry"](../table/365.md)
- Balance: CalcFormula [Table 365 "Analysis View Entry"](../table/365.md)
- Balance at Date: CalcFormula [Table 365 "Analysis View Entry"](../table/365.md)
- Credit Amount: CalcFormula [Table 365 "Analysis View Entry"](../table/365.md)
- Debit Amount: CalcFormula [Table 365 "Analysis View Entry"](../table/365.md)
- Net Change: CalcFormula [Table 365 "Analysis View Entry"](../table/365.md)
- Budgeted Amount: CalcFormula [Table 366 "Analysis View Budget Entry"](../table/366.md)
- Budgeted at Date: CalcFormula [Table 366 "Analysis View Budget Entry"](../table/366.md)
- Budgeted Credit Amount: CalcFormula [Table 366 "Analysis View Budget Entry"](../table/366.md)
- Budgeted Debit Amount: CalcFormula [Table 366 "Analysis View Budget Entry"](../table/366.md)
- Cash Flow Forecast Filter: TableRelation [Table 840 "Cash Flow Forecast"](../table/840.md)
- No.: TableRelation [Table 841 "Cash Flow Account"](../table/841.md) (conditional)
- Totaling: TableRelation [Table 841 "Cash Flow Account"](../table/841.md) (conditional)
- Budget Filter: TableRelation [Table 95 "G/L Budget Name"](../table/95.md)
- Comment: CalcFormula [Table 97 "Comment Line"](../table/97.md)

## Pages and codeunits on this table

- [Page 569 "Chart of Accs. (Analysis View)"](../page/569.md) (source table)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC26, BC28-29

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). 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.