Table "G/L Entry"

ID 17

Namespace: Microsoft.Finance.GeneralLedger.Ledger

Stores all general ledger transactions with complete audit trail and dimensional analysis capabilities. Central table for financial reporting, analysis, and regulatory compliance with integrated VAT and tax tracking.

Remarks

Key relationships: G/L Account, Customer Ledger Entry, Vendor Ledger Entry, VAT Entry, Dimension Set Entry. Extensible via table extensions for additional financial tracking and compliance requirements. Primary keys: Entry No. Secondary keys: G/L Account No. + Posting Date, Transaction No.

Properties

Name	Value
Caption	G/L Entry
DrillDownPageID	Page Microsoft.Finance.GeneralLedger.Ledger."General Ledger Entries"
LookupPageID	Page Microsoft.Finance.GeneralLedger.Ledger."General Ledger Entries"
DataClassification	CustomerContent

Fields

Name	Type	Description
"Entry No."	Integer	Unique sequential identifier for the G/L entry.
"G/L Account No."	Code[20]	G/L account number that this transaction affects.
"Posting Date"	Date	Date when the transaction was posted to the general ledger.
"Document Type"	Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type"	Type of document that originated this G/L entry.
"Document No."	Code[20]	Number of the document that originated this G/L entry.
Description	Text[100]	Description text for the G/L entry transaction.
"Bal. Account No."	Code[20]	Balancing account number used in the original journal entry.
Amount	Decimal	Transaction amount in local currency (LCY).
"Source Currency Amount"	Decimal	Transaction amount in the original currency before conversion to LCY.
"Source Currency VAT Amount"	Decimal	VAT amount in the original currency before conversion to LCY.
"Source Currency Code"	Code[10]	Currency code of the original transaction before conversion to LCY.
"Global Dimension 1 Code"	Code[20]	Primary global dimension code for analytical reporting and filtering.
"Global Dimension 2 Code"	Code[20]	Secondary global dimension code for analytical reporting and filtering.
"User ID"	Code[50]	User ID of the person who posted this G/L entry.
"Source Code"	Code[10]	Source code indicating the journal or process that created this entry.
"System-Created Entry"	Boolean	Indicates whether this entry was created automatically by the system.
"Prior-Year Entry"	Boolean	Indicates whether this entry belongs to a prior fiscal year.
"Job No."	Code[20]	Project number associated with this G/L entry for project accounting.
Quantity	Decimal	Quantity associated with this G/L transaction for unit-based reporting.
"VAT Amount"	Decimal	VAT amount in local currency associated with this G/L entry.
"Business Unit Code"	Code[20]	Business unit code for multi-company consolidation and reporting.
"Journal Batch Name"	Code[10]	Journal batch name from the original journal entry.
"Reason Code"	Code[10]	Reason code explaining the purpose of this G/L entry.
"Gen. Posting Type"	Enum Microsoft.Foundation.Enums."General Posting Type"	General posting type indicating purchase, sale, or settlement transaction.
"Gen. Bus. Posting Group"	Code[20]	General business posting group for VAT and tax calculation purposes.
"Gen. Prod. Posting Group"	Code[20]	General product posting group for VAT and tax calculation purposes.
"Bal. Account Type"	Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Account Type"	Type of balancing account used in the original journal entry.
"Transaction No."	Integer	Transaction number grouping related G/L entries from the same posting.
"Debit Amount"	Decimal	Debit amount in local currency when transaction increases account balance.
"Credit Amount"	Decimal	Credit amount in local currency when transaction decreases account balance.
"Document Date"	Date	Date of the original source document.
"External Document No."	Code[35]	External document number from vendor or customer invoice.
"Source Type"	Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Source Type"	Type of source entity that originated this transaction.
"Source No."	Code[20]	Number of the source entity (customer, vendor, etc.) that originated this transaction.
"No. Series"	Code[20]	Number series used for automatic document numbering.
"Tax Area Code"	Code[20]	Tax area code for sales tax calculation and reporting.
"Tax Liable"	Boolean	Indicates whether this transaction is subject to tax.
"Tax Group Code"	Code[20]	Tax group code for sales tax calculation purposes.
"Use Tax"	Boolean	Indicates whether this is a use tax transaction.
"VAT Bus. Posting Group"	Code[20]	VAT business posting group for VAT calculation and reporting.
"VAT Prod. Posting Group"	Code[20]	VAT product posting group for VAT calculation and reporting.
"Additional-Currency Amount"	Decimal	Transaction amount in additional reporting currency.
"Add.-Currency Debit Amount"	Decimal	Debit amount in additional reporting currency.
"Add.-Currency Credit Amount"	Decimal	Credit amount in additional reporting currency.
"Close Income Statement Dim. ID"	Integer	Dimension set ID for close income statement process.
"IC Partner Code"	Code[20]	Intercompany partner code for intercompany transactions.
Reversed	Boolean	Indicates whether this entry has been reversed.
"Reversed by Entry No."	Integer	Entry number of the reversing entry that canceled this transaction.
"Reversed Entry No."	Integer	Entry number of the original entry that was reversed by this transaction.
"G/L Account Name"	Text[100]	Flow field displaying the name of the G/L account.
"Journal Templ. Name"	Code[10]	Journal template name from the original journal entry.
"VAT Reporting Date"	Date	VAT reporting date for VAT submission and compliance.
"G/L Register No."	Integer	G/L Register number for this entry.
"Dimension Set ID"	Integer	Dimension set ID linking to dimension combinations for this entry.
"Shortcut Dimension 3 Code"	Code[20]	Flow field showing shortcut dimension 3 code for quick dimension analysis.
"Shortcut Dimension 4 Code"	Code[20]	Flow field showing shortcut dimension 4 code for quick dimension analysis.
"Shortcut Dimension 5 Code"	Code[20]	Flow field showing shortcut dimension 5 code for quick dimension analysis.
"Shortcut Dimension 6 Code"	Code[20]	Flow field showing shortcut dimension 6 code for quick dimension analysis.
"Shortcut Dimension 7 Code"	Code[20]	Flow field showing shortcut dimension 7 code for quick dimension analysis.
"Shortcut Dimension 8 Code"	Code[20]	Flow field showing shortcut dimension 8 code for quick dimension analysis.
"Last Dim. Correction Entry No."	Integer	Entry number of the last dimension correction applied to this G/L entry.
"Last Dim. Correction Node"	Integer	Node identifier for the last dimension correction tracking.
"Dimension Changes Count"	Integer	Count of dimension changes applied to this G/L entry for audit tracking.
"Allocation Account No."	Code[20]	Allocation account number for cost and revenue allocation processes.
"Alloc. Journal Line SystemId"	Guid	System ID linking to the original allocation journal line.
"Prod. Order No."	Code[20]	Production order number for manufacturing cost tracking.
"FA Entry Type"	Option	Type of fixed asset entry linked to this G/L entry.
"FA Entry No."	Integer	Entry number of the related fixed asset ledger entry.
Comment	Text[250]	Additional comment text for the G/L entry.
"Non-Deductible VAT Amount"	Decimal	Non-deductible VAT amount in local currency.
"Non-Deductible VAT Amount ACY"	Decimal	Non-deductible VAT amount in additional reporting currency.
"Src. Curr. Non-Ded. VAT Amount"	Decimal	Non-deductible VAT amount in source currency.
"Account Id"	Guid	Flow field containing the system ID of the related G/L account.
"Last Modified DateTime"	DateTime	Timestamp of the last modification to this G/L entry record.
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

GetAdditionalReportingCurrencyCode

procedure GetAdditionalReportingCurrencyCode(): Code[10]

Returns

Type	Description
Code[10]

GetNextEntryNo

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

Returns

Type	Description
Integer

GetLastEntryNo

Gets the highest entry number from the G/L Entry table.

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

Returns

Type	Description
Integer	The last entry number used

GetLastEntry

Gets the last entry number and transaction number from the G/L Entry table.

[InherentPermissions(TableData,17,r)]
procedure GetLastEntry(var LastEntryNo: Integer; var LastTransactionNo: Integer)

Parameters

Name	Type	Description
LastEntryNo	Integer	Returns the last entry number used
LastTransactionNo	Integer	Returns the last transaction number used

GetCurrencyCode

Obsolete

This element will become obsolete from version 27.0. use GetAdditionalReportingCurrencyCode instead

Gets the additional reporting currency code from General Ledger Setup.

[Obsolete(use GetAdditionalReportingCurrencyCode instead,27.0)]
procedure GetCurrencyCode(): Code[10]

Returns

Type	Description
Code[10]	Additional reporting currency code

ShowValueEntries

Opens the Value Entries page showing item ledger entries related to this G/L entry.

procedure ShowValueEntries()

ShowDimensions

Opens the Dimension Set Entries page showing dimensions for this G/L entry.

procedure ShowDimensions()

UpdateDebitCredit

Updates debit and credit amounts based on the amount and correction flag.

procedure UpdateDebitCredit(Correction: Boolean)

Parameters

Name	Type	Description
Correction	Boolean	Indicates whether this is a correction entry

CopyFromGenJnlLine

Copies values from General Journal Line to G/L Entry fields.

procedure CopyFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")

Parameters

Name	Type	Description
GenJnlLine	Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"	General journal line to copy from

CopyPostingGroupsFromGLEntry

Copies posting groups from another G/L Entry record.

procedure CopyPostingGroupsFromGLEntry(GLEntry: Record "G/L Entry")

Parameters

Name	Type	Description
GLEntry	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Entry"	G/L entry to copy posting groups from

CopyPostingGroupsFromVATEntry

Copies posting groups from VAT Entry record.

procedure CopyPostingGroupsFromVATEntry(VATEntry: Record "VAT Entry")

Parameters

Name	Type	Description
VATEntry	Table Microsoft.Finance.VAT.Ledger."VAT Entry"	VAT entry to copy posting groups from

CopyPostingGroupsFromGenJnlLine

Copies posting groups from General Journal Line record.

procedure CopyPostingGroupsFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")

Parameters

Name	Type	Description
GenJnlLine	Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"	General journal line to copy posting groups from

CopyPostingGroupsFromDtldCVBuf

Copies posting groups from Detailed CV Ledger Entry Buffer record.

procedure CopyPostingGroupsFromDtldCVBuf(DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer"; GenPostingType: Option)

Parameters

Name	Type	Description
DtldCVLedgEntryBuf	Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer"	Detailed CV ledger entry buffer to copy from
GenPostingType	Option	General posting type option value

CopyFromDeferralPostBuffer

Copies values from Deferral Posting Buffer to G/L Entry fields.

procedure CopyFromDeferralPostBuffer(DeferralPostBuffer: Record "Deferral Posting Buffer")

Parameters

Name	Type	Description
DeferralPostBuffer	Table Microsoft.Finance.Deferral."Deferral Posting Buffer"	Deferral posting buffer to copy from

UpdateAccountID

Updates the Account ID field based on the G/L Account No.

procedure UpdateAccountID()

Events

OnAfterCopyGLEntryFromGenJnlLine

Integration event raised after copying G/L entry from general journal line. Enables extensions to modify additional G/L entry fields during posting.

[IntegrationEvent(False,False)]
local procedure OnAfterCopyGLEntryFromGenJnlLine(var GLEntry: Record "G/L Entry"; var GenJournalLine: Record "Gen. Journal Line")

Parameters

Name	Type	Description
GLEntry	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Entry"	G/L entry being created
GenJournalLine	Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"	Source general journal line

OnAfterCopyFromDeferralPostBuffer

Integration event raised after copying G/L entry values from deferral posting buffer. Enables extensions to modify G/L entry fields during deferral posting.

[IntegrationEvent(False,False)]
local procedure OnAfterCopyFromDeferralPostBuffer(var GLEntry: Record "G/L Entry"; DeferralPostingBuffer: Record "Deferral Posting Buffer")

Parameters

Name	Type	Description
GLEntry	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Entry"	G/L entry being updated
DeferralPostingBuffer	Table Microsoft.Finance.Deferral."Deferral Posting Buffer"	Source deferral posting buffer

OnAfterCopyPostingGroupsFromDtldCVBuf

Integration event raised after copying posting groups from detailed CV ledger entry buffer. Enables extensions to modify posting group assignments during CV entry processing.

[IntegrationEvent(False,False)]
local procedure OnAfterCopyPostingGroupsFromDtldCVBuf(var GLEntry: Record "G/L Entry"; DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer")

Parameters

Name	Type	Description
GLEntry	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Entry"	G/L entry being updated
DtldCVLedgEntryBuf	Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer"	Source detailed CV ledger entry buffer

OnAfterCopyPostingGroupsFromGLEntry

Integration event raised after copying posting groups from another G/L entry. Enables extensions to modify posting group assignments during G/L entry processing.

[IntegrationEvent(False,False)]
local procedure OnAfterCopyPostingGroupsFromGLEntry(var GLEntry: Record "G/L Entry"; FromGLEntry: Record "G/L Entry")

Parameters

Name	Type	Description
GLEntry	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Entry"	G/L entry being updated
FromGLEntry	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Entry"	Source G/L entry with posting groups to copy

OnAfterCopyPostingGroupsFromGenJnlLine

Integration event raised after copying posting groups from general journal line. Enables extensions to modify posting group assignments during journal posting.

[IntegrationEvent(False,False)]
local procedure OnAfterCopyPostingGroupsFromGenJnlLine(var GLEntry: Record "G/L Entry"; GenJournalLine: Record "Gen. Journal Line")

Parameters

Name	Type	Description
GLEntry	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Entry"	G/L entry being updated
GenJournalLine	Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line"	Source general journal line

OnAfterCopyPostingGroupsFromVATEntry

Integration event raised after copying posting groups from VAT entry. Enables extensions to modify posting group assignments during VAT processing.

[IntegrationEvent(False,False)]
local procedure OnAfterCopyPostingGroupsFromVATEntry(var GLEntry: Record "G/L Entry"; VATEntry: Record "VAT Entry")

Parameters

Name	Type	Description
GLEntry	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Entry"	G/L entry being updated
VATEntry	Table Microsoft.Finance.VAT.Ledger."VAT Entry"	Source VAT entry

OnAfterUpdateDebitCredit

Integration event raised after updating debit and credit amounts. Enables extensions to modify debit/credit calculations during posting.

[IntegrationEvent(False,False)]
local procedure OnAfterUpdateDebitCredit(var GLEntry: Record "G/L Entry"; Correction: Boolean)

Parameters

Name	Type	Description
GLEntry	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Entry"	G/L entry with updated debit/credit amounts
Correction	Boolean	Indicates whether this is a correction entry

OnBeforeShowValueEntries

Integration event raised before showing related value entries. Enables extensions to modify value entry filtering and presentation.

[IntegrationEvent(False,False)]
local procedure OnBeforeShowValueEntries(var ValueEntry: Record "Value Entry"; var GLItemLedgRelation: Record "G/L - Item Ledger Relation")

Parameters

Name	Type	Description
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"	Value entry record for filtering
GLItemLedgRelation	Table Microsoft.Inventory.Ledger."G/L - Item Ledger Relation"	G/L item ledger relation record

OnSkipGLEntryByReviewStatus

Integration event raised by the local functionality report G/L Account Statement. Enables apps to filter out G/L Entries based on their review status

[IntegrationEvent(False,False)]
procedure OnSkipGLEntryByReviewStatus(var GLEntry: Record "G/L Entry"; ReviewStatus: Option; EvaluationDate: Date; var Skip: Boolean)

Parameters

Name	Type	Description
GLEntry	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Entry"	G/L entry record for filtering
ReviewStatus	Option	Specifies whether to filter on reviewed or not reviewed entries
EvaluationDate	Date	Specifies the date to be used for filtering on review date
Skip	Boolean	Specifies true if and only if the report should skip the G/L entry based on its review status

See also

• Table