---
id: object/table/45
type: object
title: Table 45 "G/L Register"
summary: Table 45 "G/L Register" in Base Application (Microsoft.Finance.GeneralLedger.Ledger). 13 fields, 5 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC26, BC29.
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: 4ea8faad9dff57d213d707cc56186e785264e8206cca76b3bc307f920e900bd6
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/GeneralLedger/Ledger/GLRegister.Table.al
    title: src/Layers/W1/BaseApp/Finance/GeneralLedger/Ledger/GLRegister.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/finance-how-to-analyze-gl-entries
    - https://learn.microsoft.com/dynamics365/business-central/finance-troubleshooting-correcting-dimensions
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/finance/work-with-the-chart-of-accounts-and-gene
    - topic/business-central/business-functionality/finance/working-with-dimensions
  localizations:
    - localization/au
    - localization/es
    - localization/nz
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 45
name: G/L Register
namespace: Microsoft.Finance.GeneralLedger.Ledger
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"
  - "29"
source_major: "29"
obsolete: null
countries:
  - au
  - es
  - nz
ms_search_form_ids: []
counts:
  fields: 13
  procedures: 6
  events: 1
  subscribers: 0
relations:
  out: 7
  referenced_by: 13
  pages: 1
  extended_by: 1
  event_subscribers: 0
  calls: 2
  called_by: 0
  implements: 0
---

# Table 45 "G/L Register"

> Table 45 "G/L Register" in Base Application (Microsoft.Finance.GeneralLedger.Ledger). 13 fields, 5 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC26, BC29.

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

Learn documents this table through its pages: [Page 116 "G/L Registers"](../page/116.md) (2 Learn pages).

## Properties

| Property | Value |
|---|---|
| Caption | G/L Register |
| DataClassification | CustomerContent |
| Permissions | TableData "G/L Register" = rimd |

## 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. | Integer | Specifies the number of the general ledger register. |  |
| 2 | From Entry No. | Integer | Specifies the first general ledger entry number in the register. | TableRelation [Table 17 "G/L Entry"](../table/17.md) (G/L Entry) |
| 3 | To Entry No. | Integer | Specifies the last general ledger entry number in the register. | TableRelation [Table 17 "G/L Entry"](../table/17.md) (G/L Entry) |
| 4 | Creation Date | Date | Specifies the date when the entries in the register were posted. |  |
| 5 | Source Code | Code[10] | Specifies the source code for the entries in the register. | TableRelation [Table 230 "Source Code"](../table/230.md) (Source Code) |
| 6 | User ID | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. | TableRelation User."User Name"; DataClassification EndUserIdentifiableInformation |
| 7 | Journal Batch Name | Code[10] | Specifies the batch name of the general journal that the entries were posted from. |  |
| 8 | From VAT Entry No. | Integer | Specifies the first VAT entry number in the register. | TableRelation [Table 254 "VAT Entry"](../table/254.md) (VAT Entry) |
| 9 | To VAT Entry No. | Integer | Specifies the last entry number in the register. | TableRelation [Table 254 "VAT Entry"](../table/254.md) (VAT Entry) |
| 10 | Reversed | Boolean | Specifies if the register has been reversed (undone) from the Reverse Entries window. |  |
| 11 | Creation Time | Time | Specifies the time when the entries in the register were posted. |  |
| 12 | Journal Templ. Name | Code[10] | Journal Template Name <small>caption</small> |  |
| 13 | No. of Transactions | Integer | Specifies the number of general ledger transactions in this register. | FlowField: count("G/L Transaction" where("G/L Register No." = field("No."))); not editable |

## Keys

- Key1: No. (clustered)
- Key2: Creation Date
- Key3: Source Code, Journal Batch Name, Creation Date
- key4: From Entry No., To Entry No.
- key5: Source Code, Journal Batch Name, SystemCreatedAt
- key6: SystemCreatedAt

## Events published

- `OnInitializeOnAfterGLRegisterInit(var GLRegister: record "G/L Register"; TemplateName: Code[10])` (integration): Integration event raised after initializing a G/L Register record.

## Procedures

- `GetNextRegisterNo(UseLegacyPosting: Boolean): Integer`
- `GetNextEntryNo(): Integer`
- `GetLastEntryNo(): Integer`: Retrieves the last (highest) register number from the G/L Register table.
- `Initialize(NextRegNo: Integer; FromEntryNo: Integer; FromVATEntryNo: Integer; SourceCode: Code[10]; BatchName: Code[10]; TemplateName: Code[10])`: Initializes a new G/L Register record with the specified parameters.
- `UpdateGLEntriesWithRegisterNo()`

## Relations

- lookup page [Page 116 "G/L Registers"](../page/116.md)
- From Entry No.: TableRelation [Table 17 "G/L Entry"](../table/17.md)
- To Entry No.: TableRelation [Table 17 "G/L Entry"](../table/17.md)
- Source Code: TableRelation [Table 230 "Source Code"](../table/230.md)
- From VAT Entry No.: TableRelation [Table 254 "VAT Entry"](../table/254.md)
- To VAT Entry No.: TableRelation [Table 254 "VAT Entry"](../table/254.md)
- No. of Transactions: CalcFormula [Table 57 "G/L Transaction"](../table/57.md)

## Referenced by

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

- [Table 17 "G/L Entry"](../table/17.md): G/L Register No.
- [Table 179 "Reversal Entry"](../table/179.md): G/L Register No.
- [Table 181 "Posted Gen. Journal Line"](../table/181.md): G/L Register No.
- [Table 21 "Cust. Ledger Entry"](../table/21.md): G/L Register No.
- [Table 25 "Vendor Ledger Entry"](../table/25.md): G/L Register No.
- [Table 254 "VAT Entry"](../table/254.md): G/L Register No.
- [Table 379 "Detailed Cust. Ledg. Entry"](../table/379.md): G/L Register No.
- [Table 380 "Detailed Vendor Ledg. Entry"](../table/380.md): G/L Register No.
- [Table 5222 "Employee Ledger Entry"](../table/5222.md): G/L Register No.
- [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md): G/L Register No.
- [Table 5617 "FA Register"](../table/5617.md): G/L Register No.
- [Table 5823 "G/L - Item Ledger Relation"](../table/5823.md): G/L Register No.
- [Table 87 "Date Compr. Register"](../table/87.md): Register No.

## Pages and codeunits on this table

- [Page 116 "G/L Registers"](../page/116.md) (source table)
- [Codeunit 235 "G/L Reg.-Gen. Ledger"](../codeunit/235.md) (codeunit runs on it)
- [Codeunit 236 "G/L Reg.-Cust.Ledger"](../codeunit/236.md) (codeunit runs on it)
- [Codeunit 237 "G/L Reg.-Vend.Ledger"](../codeunit/237.md) (codeunit runs on it)
- [Codeunit 238 "G/L Reg.-VAT Entries"](../codeunit/238.md) (codeunit runs on it)
- [Codeunit 377 "G/L Reg.-Bank Account Ledger"](../codeunit/377.md) (codeunit runs on it)
- [Codeunit 5619 "G/L Reg.-FALedger"](../codeunit/5619.md) (codeunit runs on it)
- [Codeunit 5649 "G/L Reg.-Maint.Ledger"](../codeunit/5649.md) (codeunit runs on it)
- [Codeunit 6788 "G/L Reg.-Withholding Entries"](../codeunit/6788.md) (codeunit runs on it)

## Extended by

- [Table extension 6795 "Withholding G/L Register Ext"](../tableextension/6795.md)

## 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 703 "Find Record Management"](../codeunit/703.md) (1 call: `GetLastEntryNo → GetLastEntryIntFieldValue`)
- [Codeunit 9500 "Sequence No. Mgt."](../codeunit/9500.md) (1 call: `GetNextEntryNo → GetNextSeqNo`)

## Across versions

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

## Countries that replace it

[AU](../../localizations/au.md), [ES](../../localizations/es.md), [NZ](../../localizations/nz.md)

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: "G/L Register")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.
