Table "G/L Register"

ID 45

Namespace: Microsoft.Finance.GeneralLedger.Ledger

Stores register information for G/L entry posting batches with audit trail and navigation capabilities. Provides sequential numbering and date tracking for all G/L entry transactions.

Remarks

Key relationships: G/L Entry, VAT Entry, Source Code. Primary key: No. Extensible via table extensions for additional posting batch tracking requirements. Used for audit trail, batch navigation, and posting verification.

Properties

Name	Value
Caption	G/L Register
LookupPageID	Page Microsoft.Finance.GeneralLedger.Ledger."G/L Registers"
Permissions	TableData "G/L Register" = rimd
DataClassification	CustomerContent

Fields

Name	Type	Description
"No."	Integer	Sequential register number for G/L entry posting batches.
"From Entry No."	Integer	First G/L entry number in this posting batch.
"To Entry No."	Integer	Last G/L entry number in this posting batch.
"Creation Date"	Date	The Creation Date field has been replaced with the SystemCreateAt field but needs to be kept for historical audit purposes.
"Source Code"	Code[10]	Source code indicating the journal or process that created this register.
"User ID"	Code[50]	User ID of the person who posted this register.
"Journal Batch Name"	Code[10]	Journal batch name from the original journal that created this register.
"From VAT Entry No."	Integer	First VAT entry number in this posting batch.
"To VAT Entry No."	Integer	Last VAT entry number in this posting batch.
Reversed	Boolean	Indicates whether this register has been reversed.
"Creation Time"	Time	The Creation Time field has been replaced with the SystemCreateAt field but needs to be kept for historical audit purposes.
"Journal Templ. Name"	Code[10]	Journal template name from the original journal that created this register.
"No. of Transactions"	Integer	Number of G/L transactions in this register.
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemCreatedByUserName	Text[50]
SystemCreatedByFullName	Text[80]
SystemModifiedByUserName	Text[50]
SystemModifiedByFullName	Text[80]
SystemRowVersion	BigInteger

Methods

GetNextRegisterNo

procedure GetNextRegisterNo(UseLegacyPosting: Boolean): Integer

Parameters

Name	Type	Description
UseLegacyPosting	Boolean

Returns

Type	Description
Integer

GetNextEntryNo

[InherentPermissions(TableData,45,r)]
procedure GetNextEntryNo(): Integer

Returns

Type	Description
Integer

GetLastEntryNo

Retrieves the last (highest) register number from the G/L Register table.

[InherentPermissions(TableData,45,r)]
procedure GetLastEntryNo(): Integer

Returns

Type	Description
Integer	Integer: The highest register number, or 0 if no registers exist.

Initialize

Initializes a new G/L Register record with the specified parameters.

procedure Initialize(NextRegNo: Integer; FromEntryNo: Integer; FromVATEntryNo: Integer; SourceCode: Code[10]; BatchName: Code[10]; TemplateName: Code[10])

Parameters

Name	Type	Description
NextRegNo	Integer	Next sequential register number to assign.
FromEntryNo	Integer	Starting G/L entry number for this register.
FromVATEntryNo	Integer	Starting VAT entry number for this register.
SourceCode	Code[10]	Source code identifying the posting process.
BatchName	Code[10]	Journal batch name from the posting process.
TemplateName	Code[10]	Journal template name from the posting process.

UpdateGLEntriesWithRegisterNo

procedure UpdateGLEntriesWithRegisterNo()

Events

OnInitializeOnAfterGLRegisterInit

Integration event raised after initializing a G/L Register record.

[IntegrationEvent(False,False)]
local procedure OnInitializeOnAfterGLRegisterInit(var GLRegister: Record "G/L Register"; TemplateName: Code[10])

Parameters

Name	Type	Description
GLRegister	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Register"	G/L Register record being initialized.
TemplateName	Code[10]	Journal template name used for initialization.

See also

• Table