Share via

Table "VAT Entry"

  • Reference
ID 254
Namespace: Microsoft.Finance.VAT.Ledger

Properties

Name Value
Caption VAT Entry
LookupPageID Microsoft.Finance.VAT.Ledger."VAT Entries"
Permissions TableData "Sales Invoice Header" = rm, TableData "Sales Cr.Memo Header" = rm, #if not CLEAN25 TableData Microsoft.Service.History."Service Invoice Header" = rm, TableData Microsoft.Service.History."Service Cr.Memo Header" = rm, #endif TableData "Issued Reminder Header" = rm, TableData "Issued Fin. Charge Memo Header" = rm, TableData "Purch. Inv. Header" = rm, TableData "Purch. Cr. Memo Hdr." = rm, TableData "G/L Entry" = rm
DataClassification CustomerContent

Fields

Name Type Description
"Entry No." Integer
"Gen. Bus. Posting Group" Code[20]
"Gen. Prod. Posting Group" Code[20]
"Posting Date" Date
"Document No." Code[20]
"Document Type" Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type"
Type Microsoft.Foundation.Enums."General Posting Type"
Base Decimal
Amount Decimal
"VAT Calculation Type" Microsoft.Foundation.Enums."Tax Calculation Type"
"Bill-to/Pay-to No." Code[20]
"EU 3-Party Trade" Boolean
"User ID" Code[50]
"Source Code" Code[10]
"Reason Code" Code[10]
"Closed by Entry No." Integer
Closed Boolean
"Country/Region Code" Code[10]
"Internal Ref. No." Text[30]
"Transaction No." Integer
"Unrealized Amount" Decimal
"Unrealized Base" Decimal
"Remaining Unrealized Amount" Decimal
"Remaining Unrealized Base" Decimal
"External Document No." Code[35]
"No. Series" Code[20]
"Tax Area Code" Code[20]
"Tax Liable" Boolean
"Tax Group Code" Code[20]
"Use Tax" Boolean
"Tax Jurisdiction Code" Code[10]
"Tax Group Used" Code[20]
"Tax Type" Option
"Tax on Tax" Boolean
"Sales Tax Connection No." Integer
"Unrealized VAT Entry No." Integer
"VAT Bus. Posting Group" Code[20]
"VAT Prod. Posting Group" Code[20]
"Additional-Currency Amount" Decimal
"Additional-Currency Base" Decimal
"Add.-Currency Unrealized Amt." Decimal
"Add.-Currency Unrealized Base" Decimal
"VAT Base Discount %" Decimal
"Add.-Curr. Rem. Unreal. Amount" Decimal
"Add.-Curr. Rem. Unreal. Base" Decimal
"VAT Difference" Decimal
"Add.-Curr. VAT Difference" Decimal
"Ship-to/Order Address Code" Code[10]
"Document Date" Date
"VAT Registration No." Text[20]
Reversed Boolean
"Reversed by Entry No." Integer
"Reversed Entry No." Integer
"EU Service" Boolean
"Base Before Pmt. Disc." Decimal
"Source Currency VAT Amount" Decimal
"Source Currency VAT Base" Decimal
"Source Currency Code" Code[10]
"Source Currency Factor" Decimal
"Journal Templ. Name" Code[10]
"Journal Batch Name" Code[10]
"Realized Amount" Decimal
"Realized Base" Decimal
"Add.-Curr. Realized Amount" Decimal
"Add.-Curr. Realized Base" Decimal
"G/L Acc. No." Code[20]
"VAT Reporting Date" Date
"Non-Deductible VAT %" Decimal
"Non-Deductible VAT Base" Decimal
"Non-Deductible VAT Amount" Decimal
"Non-Deductible VAT Base ACY" Decimal
"Non-Deductible VAT Amount ACY" Decimal
"Non-Deductible VAT Diff." Decimal
"Non-Deductible VAT Diff. ACY" Decimal
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

GetLastEntryNo

procedure GetLastEntryNo(): Integer

Returns

Type Description
Integer

GetUnrealizedVATPart

procedure GetUnrealizedVATPart(SettledAmount: Decimal, Paid: Decimal, Full: Decimal, TotalUnrealVATAmountFirst: Decimal, TotalUnrealVATAmountLast: Decimal): Decimal

Parameters

Name Type Description
SettledAmount Decimal
Paid Decimal
Full Decimal
TotalUnrealVATAmountFirst Decimal
TotalUnrealVATAmountLast Decimal

Returns

Type Description
Decimal

GetUnrealizedVATType

procedure GetUnrealizedVATType(): Integer

Returns

Type Description
Integer

CopyFromGenJnlLine

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

Parameters

Name Type Description
GenJnlLine Record "Gen. Journal Line"

CopyPostingDataFromGenJnlLine

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

Parameters

Name Type Description
GenJnlLine Record "Gen. Journal Line"

SetGLAccountNo

procedure SetGLAccountNo(WithUI: Boolean)

Parameters

Name Type Description
WithUI Boolean

SetGLAccountNoWithResponse

procedure SetGLAccountNoWithResponse(WithUI: Boolean, ShowConfirm: Boolean, var Response: Boolean)

Parameters

Name Type Description
WithUI Boolean
ShowConfirm Boolean
Response Boolean

CheckGLAccountNoFilled

procedure CheckGLAccountNoFilled()

CopyAmountsFromVATEntry

procedure CopyAmountsFromVATEntry(VATEntry: Record "VAT Entry", WithOppositeSign: Boolean)

Parameters

Name Type Description
VATEntry Record "VAT Entry"
WithOppositeSign Boolean

SetUnrealAmountsToZero

procedure SetUnrealAmountsToZero()

Events

OnAfterCopyFromGenJnlLine

[IntegrationEvent(False,False)]
procedure OnAfterCopyFromGenJnlLine(var VATEntry: Record "VAT Entry", GenJournalLine: Record "Gen. Journal Line")

Parameters

Name Type Description
VATEntry Record "VAT Entry"
GenJournalLine Record "Gen. Journal Line"

OnAfterCopyAmountsFromVATEntry

Obsolete

This element will become obsolete from version 24.0. Use the OnAfterOnCopyAmountsFromVATEntry method instead

[Obsolete(Use the OnAfterOnCopyAmountsFromVATEntry method instead,24.0)]
[IntegrationEvent(False,False)]
procedure OnAfterCopyAmountsFromVATEntry(var VATEntry: Record "VAT Entry", WithOppositeSign: Boolean)

Parameters

Name Type Description
VATEntry Record "VAT Entry"
WithOppositeSign Boolean

OnAfterOnCopyAmountsFromVATEntry

[IntegrationEvent(False,False)]
local procedure OnAfterOnCopyAmountsFromVATEntry(var VATEntry: Record "VAT Entry", WithOppositeSign: Boolean, var RecVATEntry: Record "VAT Entry")

Parameters

Name Type Description
VATEntry Record "VAT Entry"
WithOppositeSign Boolean
RecVATEntry Record "VAT Entry"

OnBeforeSetGLAccountNo

[IntegrationEvent(False,False)]
local procedure OnBeforeSetGLAccountNo(var VATEntry: Record "VAT Entry", var IsHandled: Boolean, var Response: Boolean, WithUI: Boolean, ShowConfirm: Boolean)

Parameters

Name Type Description
VATEntry Record "VAT Entry"
IsHandled Boolean
Response Boolean
WithUI Boolean
ShowConfirm Boolean

OnAfterSetGLAccountNo

[IntegrationEvent(False,False)]
local procedure OnAfterSetGLAccountNo(var VATEntry: Record "VAT Entry", var IsHandled: Boolean, WithUI: Boolean)

Parameters

Name Type Description
VATEntry Record "VAT Entry"
IsHandled Boolean
WithUI Boolean

See also