Table 17 "G/L Entry"

Base Application · Microsoft.Finance.GeneralLedger.Ledger · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 20 “General Ledger Entries” (6 Learn pages), Page 30018 “APIV2 - G/L Entries” (2), Page 2583 “Dim. Correct Ledger Entries” (1), Page 2584 “Dim Correct Posted Ledg Entr” (1), Page 22207 “Review G/L Entries” (1).

Properties

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.

Keys

• Key1: Entry No. (clustered)
• Key2: G/L Account No., Posting Date
• Key3: G/L Account No., Global Dimension 1 Code, Global Dimension 2 Code, Posting Date, VAT Reporting Date, Source Currency Code
• Key4: G/L Account No., Business Unit Code, Posting Date
• Key5: G/L Account No., Business Unit Code, Global Dimension 1 Code, Global Dimension 2 Code, Posting Date
• Key6: Document No., Posting Date
• Key7: Transaction No.
• Key8: IC Partner Code
• Key9: G/L Account No., Job No., Posting Date
• Key10: Posting Date, G/L Account No., Dimension Set ID
• Key11: Gen. Bus. Posting Group, Gen. Prod. Posting Group
• Key12: VAT Bus. Posting Group, VAT Prod. Posting Group
• Key13: Dimension Set ID

Events published

• OnAfterCopyGLEntryFromGenJnlLine(var GLEntry: Record "G/L Entry"; var GenJournalLine: Record "Gen. Journal Line") (integration): Integration event raised after copying G/L entry from general journal line. Enables extensions to modify additional G/L entry fields during posting.
• OnAfterCopyFromDeferralPostBuffer(var GLEntry: Record "G/L Entry"; DeferralPostingBuffer: Record "Deferral Posting Buffer") (integration): Integration event raised after copying G/L entry values from deferral posting buffer. Enables extensions to modify G/L entry fields during deferral posting.
• OnAfterCopyPostingGroupsFromDtldCVBuf(var GLEntry: Record "G/L Entry"; DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer") (integration): Integration event raised after copying posting groups from detailed CV ledger entry buffer. Enables extensions to modify posting group assignments during CV entry processing.
• OnAfterCopyPostingGroupsFromGLEntry(var GLEntry: Record "G/L Entry"; FromGLEntry: Record "G/L Entry") (integration): Integration event raised after copying posting groups from another G/L entry. Enables extensions to modify posting group assignments during G/L entry processing.
• OnAfterCopyPostingGroupsFromGenJnlLine(var GLEntry: Record "G/L Entry"; GenJournalLine: Record "Gen. Journal Line") (integration): Integration event raised after copying posting groups from general journal line. Enables extensions to modify posting group assignments during journal posting.
• OnAfterCopyPostingGroupsFromVATEntry(var GLEntry: Record "G/L Entry"; VATEntry: Record "VAT Entry") (integration): Integration event raised after copying posting groups from VAT entry. Enables extensions to modify posting group assignments during VAT processing.
• OnAfterUpdateDebitCredit(var GLEntry: Record "G/L Entry"; Correction: Boolean) (integration): Integration event raised after updating debit and credit amounts. Enables extensions to modify debit/credit calculations during posting.
• OnBeforeShowValueEntries(var ValueEntry: Record "Value Entry"; var GLItemLedgRelation: Record "G/L - Item Ledger Relation") (integration): Integration event raised before showing related value entries. Enables extensions to modify value entry filtering and presentation.
• OnSkipGLEntryByReviewStatus(var GLEntry: Record "G/L Entry"; ReviewStatus: Option All,Reviewed,"Not Reviewed"; EvaluationDate: Date; var Skip: Boolean) + BC28 (integration): 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
  • subscribers: Codeunit 22200 “Review G/L Entry” OnSkipGLEntryByReviewStatus

Trigger event subscribers

• OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertGLEntry
• OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” OnModifyGLEntry

Procedures

• GetAdditionalReportingCurrencyCode(): Code[10] + BC27
• GetNextEntryNo(): Integer + BC29
• GetLastEntryNo(): Integer Δ BC26: Gets the highest entry number from the G/L Entry table.
• GetLastEntry(var LastEntryNo: Integer; var LastTransactionNo: Integer) Δ BC26: Gets the last entry number and transaction number from the G/L Entry table.
• GetCurrencyCode(): Code[10] Δ BC27 (obsolete 27.0: use GetAdditionalReportingCurrencyCode instead): Gets the additional reporting currency code from General Ledger Setup.
• ShowValueEntries(): Opens the Value Entries page showing item ledger entries related to this G/L entry.
• ShowDimensions(): Opens the Dimension Set Entries page showing dimensions for this G/L entry.
• UpdateDebitCredit(Correction: Boolean): Updates debit and credit amounts based on the amount and correction flag.
• CopyFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line"): Copies values from General Journal Line to G/L Entry fields.
• CopyPostingGroupsFromGLEntry(GLEntry: Record "G/L Entry"): Copies posting groups from another G/L Entry record.
• CopyPostingGroupsFromVATEntry(VATEntry: Record "VAT Entry"): Copies posting groups from VAT Entry record.
• CopyPostingGroupsFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line"): Copies posting groups from General Journal Line record.
• CopyPostingGroupsFromDtldCVBuf(DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer"; GenPostingType: Option " ",Purchase,Sale,Settlement): Copies posting groups from Detailed CV Ledger Entry Buffer record.
• CopyFromDeferralPostBuffer(DeferralPostBuffer: Record "Deferral Posting Buffer"): Copies values from Deferral Posting Buffer to G/L Entry fields.
• UpdateAccountID(): Updates the Account ID field based on the G/L Account No.

Plus 2 local procedures.

Triggers

OnInsert, OnModify, OnRename

Relations

• drill-down page Page 20 “General Ledger Entries”
• lookup page Page 20 “General Ledger Entries”
• Account Id: CalcFormula Table 15 “G/L Account”
• G/L Account Name: CalcFormula Table 15 “G/L Account”
• Account Id: TableRelation Table 15 “G/L Account”
• Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
• G/L Account No.: TableRelation Table 15 “G/L Account”
• Job No.: TableRelation Table 167 “Job”
• Reversed by Entry No.: TableRelation Table 17 “G/L Entry”
• Reversed Entry No.: TableRelation Table 17 “G/L Entry”
• Bal. Account No.: TableRelation Table 18 “Customer” (conditional)
• Source No.: TableRelation Table 18 “Customer” (conditional)
• Business Unit Code: TableRelation Table 220 “Business Unit”
• Bal. Account No.: TableRelation Table 23 “Vendor” (conditional)
• Source No.: TableRelation Table 23 “Vendor” (conditional)
• Source Code: TableRelation Table 230 “Source Code”
• Reason Code: TableRelation Table 231 “Reason Code”
• Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
• Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
• Bal. Account No.: TableRelation Table 270 “Bank Account” (conditional)
• Source No.: TableRelation Table 270 “Bank Account” (conditional)
• No. Series: TableRelation Table 308 “No. Series”
• 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 2 Code: TableRelation Table 349 “Dimension Value”
• Source Currency Code: TableRelation Table 4 “Currency”
• IC Partner Code: TableRelation Table 413 “IC Partner”
• G/L Register No.: TableRelation Table 45 “G/L Register”
• Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
• Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
• Source No.: TableRelation Table 5200 “Employee” (conditional)
• Source No.: TableRelation Table 5600 “Fixed Asset” (conditional)
• FA Entry No.: TableRelation Table 5601 “FA Ledger Entry” (conditional)
• FA Entry No.: TableRelation Table 5625 “Maintenance Ledger Entry” (conditional)
• Transaction No.: TableRelation Table 57 “G/L Transaction”

Referenced by

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

• Table 15 “G/L Account”: Add.-Currency Balance at Date, Add.-Currency Credit Amount, Add.-Currency Debit Amount, Additional-Currency Balance, Additional-Currency Net Change, Balance, Balance at Date, Credit Amount, Debit Amount, Net Change, Source Curr. Balance at Date, Source Currency Balance, Source Currency Net Change, VAT Amt.
• Table 589 “G/L Account Source Currency”: Balance at Date, Entries Exists, Source Curr. Balance at Date, Source Currency Net Change
• Table 1105 “Cost Register”: From G/L Entry No., To G/L Entry No.
• Table 1570 “G/L Entry Posting Preview”: Reversed by Entry No., Reversed Entry No.
• Table 17 “G/L Entry”: Reversed by Entry No., Reversed Entry No.
• Table 45 “G/L Register”: From Entry No., To Entry No.
• Table 6845 “Spend Request To G/L Link”: Posting Description, G/L Entry No.
• Table 1003 “Job Planning Line”: Ledger Entry No.
• Table 1005 “Job WIP G/L Entry”: G/L Entry No.
• Table 1101 “Cost Journal Line”: G/L Entry No.
• Table 1104 “Cost Entry”: G/L Entry No.
• Table 1293 “Payment Application Proposal”: Applies-to Entry No.
• Table 1294 “Applied Payment Entry”: Applies-to Entry No.
• Table 169 “Job Ledger Entry”: Ledger Entry No.
• Table 1692 “Posted Bank Deposit Line”: Entry No.
• Table 179 “Reversal Entry”: Entry No.
• Table 210 “Job Journal Line”: Ledger Entry No.
• Table 253 “G/L Entry - VAT Entry Link”: G/L Entry No.
• Table 5137 “Job Planning Line Archive”: Ledger Entry No.
• Table 5509 “Attachment Entity Buffer”: G/L Entry No.
• Table 5601 “FA Ledger Entry”: G/L Entry No.
• Table 5625 “Maintenance Ledger Entry”: G/L Entry No.
• Table 57 “G/L Transaction”: No. of G/L Entries
• Table 5823 “G/L - Item Ledger Relation”: G/L Entry No.
• Table 6090 “FA Ledg. Entry w. Issue”: G/L Entry No.
• Table 6260 “Sust. Jnl. Line G/L Entry”: G/L Entry No.
• Table 6261 “Sust. G/L - Sust. Ledger Rel.”: G/L Entry No.
• Table 8066 “Cust. Sub. Contract Deferral”: G/L Entry No.
• Table 8072 “Vend. Sub. Contract Deferral”: G/L Entry No.
• Table 9153 “My Account”: Acc. Balance

Pages and codeunits on this table

• Page 122 “G/L Entries Preview” (source table)
• Page 1574 “G/L Entries Preview Flat Subf.” (source table)
• Page 19 “G/L Entries Part” (source table)
• Page 20 “General Ledger Entries” (source table)
• Page 20018 “APIV1 - G/L Entries” (source table)
• Page 22207 “Review G/L Entries” (source table)
• Page 2583 “Dim. Correct Ledger Entries” (source table)
• Page 2584 “Dim Correct Posted Ledg Entr” (source table)
• Page 30018 “APIV2 - G/L Entries” (source table)
• Page 563 “G/L Entries Dimension Overview” (source table)
• Page 9241 “G/L Entries Dim. Overv. Matrix” (source table)
• Codeunit 115 “G/L Entry-Edit” (codeunit runs on it)

Extended by

• Table extension 22211 “G/L Entry Review”
• Table extension 8067 “G/L Entry”

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” (2 calls: GetLastEntry → GetLastEntryIntFieldValues, GetLastEntryNo → GetLastEntryIntFieldValue)
• Codeunit 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)
• Codeunit 9500 “Sequence No. Mgt.” (1 call: GetNextEntryNo → GetNextSeqNo)

Countries that replace it

AU, BE, CA, CH, ES, FI, FR, IT, MX, NL, NZ, RU, US

Deprecations

• procedure GetCurrencyCode: Pending 27.0 (#if not CLEAN27), “use GetAdditionalReportingCurrencyCode instead”

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 Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.