Table "VAT Entry"
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,
TableData "Service Invoice Header" = rm,
TableData "Service Cr.Memo Header" = rm,
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
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
GetUnrealizedVATType
procedure GetUnrealizedVATType(): Integer
Returns
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
|
|
See also