Table "G/L Entry"
ID 17
Namespace: Microsoft.Finance.GeneralLedger.Ledger
Properties
Fields
Name
Type
Description
"Entry No."
Integer
"G/L Account No."
Code[20]
"Posting Date"
Date
"Document Type"
Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type"
"Document No."
Code[20]
Description
Text[100]
"Bal. Account No."
Code[20]
Amount
Decimal
"Source Currency Amount"
Decimal
"Source Currency VAT Amount"
Decimal
"Source Currency Code"
Code[10]
"Global Dimension 1 Code"
Code[20]
"Global Dimension 2 Code"
Code[20]
"User ID"
Code[50]
"Source Code"
Code[10]
"System-Created Entry"
Boolean
"Prior-Year Entry"
Boolean
"Job No."
Code[20]
Quantity
Decimal
"VAT Amount"
Decimal
"Business Unit Code"
Code[20]
"Journal Batch Name"
Code[10]
"Reason Code"
Code[10]
"Gen. Posting Type"
Enum Microsoft.Foundation.Enums."General Posting Type"
"Gen. Bus. Posting Group"
Code[20]
"Gen. Prod. Posting Group"
Code[20]
"Bal. Account Type"
Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Account Type"
"Transaction No."
Integer
"Debit Amount"
Decimal
"Credit Amount"
Decimal
"Document Date"
Date
"External Document No."
Code[35]
"Source Type"
Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Source Type"
"Source No."
Code[20]
"No. Series"
Code[20]
"Tax Area Code"
Code[20]
"Tax Liable"
Boolean
"Tax Group Code"
Code[20]
"Use Tax"
Boolean
"VAT Bus. Posting Group"
Code[20]
"VAT Prod. Posting Group"
Code[20]
"Additional-Currency Amount"
Decimal
"Add.-Currency Debit Amount"
Decimal
"Add.-Currency Credit Amount"
Decimal
"Close Income Statement Dim. ID"
Integer
"IC Partner Code"
Code[20]
Reversed
Boolean
"Reversed by Entry No."
Integer
"Reversed Entry No."
Integer
"G/L Account Name"
Text[100]
"Journal Templ. Name"
Code[10]
"VAT Reporting Date"
Date
"Dimension Set ID"
Integer
"Shortcut Dimension 3 Code"
Code[20]
"Shortcut Dimension 4 Code"
Code[20]
"Shortcut Dimension 5 Code"
Code[20]
"Shortcut Dimension 6 Code"
Code[20]
"Shortcut Dimension 7 Code"
Code[20]
"Shortcut Dimension 8 Code"
Code[20]
"Last Dim. Correction Entry No."
Integer
"Last Dim. Correction Node"
Integer
"Dimension Changes Count"
Integer
"Allocation Account No."
Code[20]
"Alloc. Journal Line SystemId"
Guid
"Prod. Order No."
Code[20]
"FA Entry Type"
Option
"FA Entry No."
Integer
Comment
Text[250]
"Non-Deductible VAT Amount"
Decimal
"Non-Deductible VAT Amount ACY"
Decimal
"Src. Curr. Non-Ded. VAT Amount"
Decimal
"Account Id"
Guid
"Last Modified DateTime"
DateTime
SystemId
Guid
SystemCreatedAt
DateTime
SystemCreatedBy
Guid
SystemModifiedAt
DateTime
SystemModifiedBy
Guid
SystemRowVersion
BigInteger
Methods
GetLastEntryNo
[InherentPermissions(TableData,17,r)]
procedure GetLastEntryNo(): IntegerReturns
GetLastEntry
[InherentPermissions(TableData,17,r)]
procedure GetLastEntry(var LastEntryNo: Integer, var LastTransactionNo: Integer)Parameters
Name
Type
Description
LastEntryNo
Integer
LastTransactionNo
Integer
GetCurrencyCode
This element will become obsolete from version 27.0. use GetAdditionalReportingCurrencyCode instead
[Obsolete(use GetAdditionalReportingCurrencyCode instead,27.0)]
procedure GetCurrencyCode(): Code[10]Returns
Type
Description
Code[10]
ShowValueEntries
procedure ShowValueEntries()
ShowDimensions
procedure ShowDimensions()
UpdateDebitCredit
procedure UpdateDebitCredit(Correction: Boolean)Parameters
Name
Type
Description
Correction
Boolean
CopyFromGenJnlLine
procedure CopyFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")Parameters
CopyPostingGroupsFromGLEntry
procedure CopyPostingGroupsFromGLEntry(GLEntry: Record "G/L Entry")Parameters
CopyPostingGroupsFromVATEntry
procedure CopyPostingGroupsFromVATEntry(VATEntry: Record "VAT Entry")Parameters
CopyPostingGroupsFromGenJnlLine
procedure CopyPostingGroupsFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")Parameters
CopyPostingGroupsFromDtldCVBuf
procedure CopyPostingGroupsFromDtldCVBuf(DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer", GenPostingType: Option)Parameters
CopyFromDeferralPostBuffer
procedure CopyFromDeferralPostBuffer(DeferralPostBuffer: Record "Deferral Posting Buffer")Parameters
UpdateAccountID
procedure UpdateAccountID()
Events
OnAfterCopyGLEntryFromGenJnlLine
[IntegrationEvent(False,False)]
local procedure OnAfterCopyGLEntryFromGenJnlLine(var GLEntry: Record "G/L Entry", var GenJournalLine: Record "Gen. Journal Line")Parameters
OnAfterCopyFromDeferralPostBuffer
[IntegrationEvent(False,False)]
local procedure OnAfterCopyFromDeferralPostBuffer(var GLEntry: Record "G/L Entry", DeferralPostingBuffer: Record "Deferral Posting Buffer")Parameters
OnAfterCopyPostingGroupsFromDtldCVBuf
[IntegrationEvent(False,False)]
local procedure OnAfterCopyPostingGroupsFromDtldCVBuf(var GLEntry: Record "G/L Entry", DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer")Parameters
OnAfterCopyPostingGroupsFromGLEntry
[IntegrationEvent(False,False)]
local procedure OnAfterCopyPostingGroupsFromGLEntry(var GLEntry: Record "G/L Entry", FromGLEntry: Record "G/L Entry")Parameters
OnAfterCopyPostingGroupsFromGenJnlLine
[IntegrationEvent(False,False)]
local procedure OnAfterCopyPostingGroupsFromGenJnlLine(var GLEntry: Record "G/L Entry", GenJournalLine: Record "Gen. Journal Line")Parameters
OnAfterCopyPostingGroupsFromVATEntry
[IntegrationEvent(False,False)]
local procedure OnAfterCopyPostingGroupsFromVATEntry(var GLEntry: Record "G/L Entry", VATEntry: Record "VAT Entry")Parameters
OnAfterUpdateDebitCredit
[IntegrationEvent(False,False)]
local procedure OnAfterUpdateDebitCredit(var GLEntry: Record "G/L Entry", Correction: Boolean)Parameters
OnBeforeShowValueEntries
[IntegrationEvent(False,False)]
local procedure OnBeforeShowValueEntries(var ValueEntry: Record "Value Entry", var GLItemLedgRelation: Record "G/L - Item Ledger Relation")Parameters
See also