Table 254 VAT Entry
- App
- Base Application
- Namespace
- Microsoft.Finance.VAT.Ledger
- Versions
- 17-28
Fields, 74Keys, 13Procedures, 12Events, 7Obsolete, 1
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/Finance/VAT/Ledger/VATEntry.Table.al1414 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace Microsoft.Finance.VAT.Ledger;
using Microsoft.Finance.Currency;
using Microsoft.Finance.GeneralLedger.Account;
using Microsoft.Finance.GeneralLedger.Journal;
using Microsoft.Finance.GeneralLedger.Ledger;
using Microsoft.Finance.GeneralLedger.Setup;
using Microsoft.Finance.SalesTax;
using Microsoft.Finance.VAT.Calculation;
using Microsoft.Finance.VAT.Registration;
using Microsoft.Finance.VAT.Setup;
using Microsoft.Foundation.Address;
using Microsoft.Foundation.AuditCodes;
using Microsoft.Foundation.Enums;
using Microsoft.Foundation.NoSeries;
using Microsoft.Purchases.History;
using Microsoft.Purchases.Vendor;
using Microsoft.Sales.Customer;
using Microsoft.Sales.FinanceCharge;
using Microsoft.Sales.History;
using Microsoft.Sales.Reminder;
using Microsoft.Utilities;
using System.Security.AccessControl;
using System.Utilities;
/// <summary>
/// Central ledger table for recording VAT transactions with comprehensive support for multiple VAT calculation methods.
/// Stores detailed VAT information including unrealized VAT, non-deductible VAT, and multi-currency processing for audit and reporting.
/// </summary>
/// <remarks>
/// Primary transaction table for VAT ledger functionality with integration to G/L entries and support for VAT settlements.
/// Extensibility: VAT entry creation, G/L account adjustment, and unrealized VAT processing events available.
/// </remarks>
table 254 "VAT Entry"
{
Caption = 'VAT Entry';
LookupPageID = "VAT Entries";
Permissions = TableData "Sales Invoice Header" = rm,
TableData "Sales Cr.Memo Header" = rm,
#if not CLEAN28
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,
TableData "VAT Entry" = m;
DataClassification = CustomerContent;
fields
{
/// <summary>
/// Unique sequential identifier for the VAT entry used for referencing and linking with other records.
/// </summary>
field(1; "Entry No."; Integer)
{
Caption = 'Entry No.';
Editable = false;
ToolTip = 'Specifies the number of the entry, as assigned from the specified number series when the entry was created.';
}
/// <summary>
/// General business posting group for linking transactions to appropriate general ledger accounts.
/// </summary>
field(2; "Gen. Bus. Posting Group"; Code[20])
{
Caption = 'Gen. Bus. Posting Group';
Editable = false;
TableRelation = "Gen. Business Posting Group";
ToolTip = 'Specifies the vendor''s or customer''s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup.';
}
/// <summary>
/// General product posting group for linking item or service transactions to appropriate general ledger accounts.
/// </summary>
field(3; "Gen. Prod. Posting Group"; Code[20])
{
Caption = 'Gen. Prod. Posting Group';
Editable = false;
TableRelation = "Gen. Product Posting Group";
ToolTip = 'Specifies the item''s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup.';
}
/// <summary>
/// Date when the VAT entry was posted to the ledger for financial reporting and audit trail purposes.
/// </summary>
field(4; "Posting Date"; Date)
{
Caption = 'Posting Date';
Editable = false;
ToolTip = 'Specifies the VAT entry''s posting date.';
}
/// <summary>
/// Document number from the source transaction that generated this VAT entry.
/// </summary>
field(5; "Document No."; Code[20])
{
Caption = 'Document No.';
Editable = false;
ToolTip = 'Specifies the document number on the VAT entry.';
}
/// <summary>
/// Type of document that generated this VAT entry, such as invoice, credit memo, or payment.
/// </summary>
field(6; "Document Type"; Enum "Gen. Journal Document Type")
{
Caption = 'Document Type';
Editable = false;
ToolTip = 'Specifies the document type that the VAT entry belongs to.';
}
/// <summary>
/// Posting type indicating whether this is a purchase, sale, or settlement VAT entry.
/// </summary>
field(7; Type; Enum "General Posting Type")
{
Caption = 'Type';
Editable = false;
ToolTip = 'Specifies the type of the VAT entry.';
trigger OnValidate()
begin
if Type = Type::Settlement then
Error(Text000, FieldCaption(Type), Type);
end;
}
/// <summary>
/// Base amount on which the VAT calculation is performed, excluding the VAT amount itself.
/// </summary>
field(8; Base; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Base';
Editable = false;
ToolTip = 'Specifies the amount that the VAT amount (the amount shown in the Amount field) is calculated from.';
}
/// <summary>
/// VAT amount calculated from the base amount using the applicable VAT rate and calculation method.
/// </summary>
field(9; Amount; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Amount';
Editable = false;
ToolTip = 'Specifies the amount of the VAT entry in LCY.';
}
/// <summary>
/// Method used for calculating VAT, such as normal VAT, reverse charge, or sales tax.
/// </summary>
field(10; "VAT Calculation Type"; Enum "Tax Calculation Type")
{
Caption = 'VAT Calculation Type';
Editable = false;
ToolTip = 'Specifies how VAT will be calculated for purchases or sales of items with this particular combination of VAT business posting group and VAT product posting group.';
}
/// <summary>
/// Customer or vendor number associated with this VAT entry for bill-to or pay-to identification.
/// </summary>
field(12; "Bill-to/Pay-to No."; Code[20])
{
Caption = 'Bill-to/Pay-to No.';
TableRelation = if (Type = const(Purchase)) Vendor
else
if (Type = const(Sale)) Customer;
ToolTip = 'Specifies the number of the bill-to customer or pay-to vendor that the entry is linked to.';
trigger OnValidate()
begin
Validate(Type);
if "Bill-to/Pay-to No." = '' then begin
"Country/Region Code" := '';
"VAT Registration No." := '';
end else
case Type of
Type::Purchase:
begin
Vend.Get("Bill-to/Pay-to No.");
"Country/Region Code" := Vend."Country/Region Code";
"VAT Registration No." := Vend."VAT Registration No.";
end;
Type::Sale:
begin
Cust.Get("Bill-to/Pay-to No.");
"Country/Region Code" := Cust."Country/Region Code";
"VAT Registration No." := Cust."VAT Registration No.";
end;
end;
end;
}
/// <summary>
/// Indicates whether this transaction involves three-party trade within the European Union.
/// </summary>
field(13; "EU 3-Party Trade"; Boolean)
{
Caption = 'EU 3-Party Trade';
ToolTip = 'Specifies if the transaction is related to trade with a third party within the EU.';
trigger OnValidate()
begin
Validate(Type);
end;
}
/// <summary>
/// User ID of the person who created this VAT entry for audit trail and responsibility tracking.
/// </summary>
field(14; "User ID"; Code[50])
{
Caption = 'User ID';
DataClassification = EndUserIdentifiableInformation;
Editable = false;
TableRelation = User."User Name";
}
/// <summary>
/// Source code indicating the journal or process that generated this VAT entry.
/// </summary>
field(15; "Source Code"; Code[10])
{
Caption = 'Source Code';
Editable = false;
TableRelation = "Source Code";
}
/// <summary>
/// Reason code providing additional context for why this VAT entry was created.
/// </summary>
field(16; "Reason Code"; Code[10])
{
Caption = 'Reason Code';
Editable = false;
TableRelation = "Reason Code";
}
/// <summary>
/// Entry number of the VAT settlement entry that closed this VAT entry during VAT return processing.
/// </summary>
field(17; "Closed by Entry No."; Integer)
{
Caption = 'Closed by Entry No.';
Editable = false;
TableRelation = "VAT Entry";
ToolTip = 'Specifies the number of the VAT entry that has closed the entry, if the VAT entry was closed with the Calc. and Post VAT Settlement batch job.';
}
/// <summary>
/// Indicates whether this VAT entry has been closed through VAT settlement processing.
/// </summary>
field(18; Closed; Boolean)
{
Caption = 'Closed';
Editable = false;
ToolTip = 'Specifies whether the VAT entry has been closed by the Calc. and Post VAT Settlement batch job.';
}
/// <summary>
/// Country or region code of the customer or vendor associated with this VAT entry.
/// </summary>
field(19; "Country/Region Code"; Code[10])
{
Caption = 'Country/Region Code';
TableRelation = "Country/Region";
ToolTip = 'Specifies the country/region of the address.';
trigger OnValidate()
begin
Validate(Type);
Validate("VAT Registration No.");
end;
}
/// <summary>
/// Internal reference number used for cross-referencing with other systems or processes.
/// </summary>
field(20; "Internal Ref. No."; Text[30])
{
Caption = 'Internal Ref. No.';
Editable = false;
ToolTip = 'Specifies the internal reference number for the line.';
}
/// <summary>
/// Transaction number linking this VAT entry with related general ledger and other ledger entries.
/// </summary>
field(21; "Transaction No."; Integer)
{
Caption = 'Transaction No.';
Editable = false;
TableRelation = "G/L Transaction";
ToolTip = 'Specifies the transaction number that groups related G/L entries from the same posting.';
}
/// <summary>
/// Unrealized VAT amount when using unrealized VAT functionality for payment-based VAT recognition.
/// </summary>
field(22; "Unrealized Amount"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Unrealized Amount';
Editable = false;
ToolTip = 'Specifies the unrealized VAT amount for this line if you use unrealized VAT.';
}
/// <summary>
/// Unrealized base amount when using unrealized VAT functionality for payment-based recognition.
/// </summary>
field(23; "Unrealized Base"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Unrealized Base';
Editable = false;
ToolTip = 'Specifies the unrealized base amount if you use unrealized VAT.';
}
/// <summary>
/// Remaining unrealized VAT amount that has not yet been realized through payment processing.
/// </summary>
field(24; "Remaining Unrealized Amount"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Remaining Unrealized Amount';
Editable = false;
ToolTip = 'Specifies the amount that remains unrealized in the VAT entry.';
}
/// <summary>
/// Remaining unrealized base amount that has not yet been realized through payment processing.
/// </summary>
field(25; "Remaining Unrealized Base"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Remaining Unrealized Base';
Editable = false;
ToolTip = 'Specifies the amount of base that remains unrealized in the VAT entry.';
}
/// <summary>
/// External document number from the source document that generated this VAT entry.
/// </summary>
field(26; "External Document No."; Code[35])
{
Caption = 'External Document No.';
Editable = false;
}
/// <summary>
/// Number series code used for generating the document number of this VAT entry.
/// </summary>
field(28; "No. Series"; Code[20])
{
Caption = 'No. Series';
Editable = false;
TableRelation = "No. Series";
}
/// <summary>
/// Tax area code for sales tax calculations in jurisdictions using sales tax instead of VAT.
/// </summary>
field(29; "Tax Area Code"; Code[20])
{
Caption = 'Tax Area Code';
Editable = false;
TableRelation = "Tax Area";
}
/// <summary>
/// Indicates whether the customer or vendor is liable for tax calculations.
/// </summary>
field(30; "Tax Liable"; Boolean)
{
Caption = 'Tax Liable';
Editable = false;
}
/// <summary>
/// Tax group code for categorizing items or services for sales tax calculations.
/// </summary>
field(31; "Tax Group Code"; Code[20])
{
Caption = 'Tax Group Code';
Editable = false;
TableRelation = "Tax Group";
}
/// <summary>
/// Indicates whether this transaction involves use tax calculations for cross-border sales.
/// </summary>
field(32; "Use Tax"; Boolean)
{
Caption = 'Use Tax';
Editable = false;
}
/// <summary>
/// Tax jurisdiction code specifying which tax authority has jurisdiction over this transaction.
/// </summary>
field(33; "Tax Jurisdiction Code"; Code[10])
{
Caption = 'Tax Jurisdiction Code';
Editable = false;
TableRelation = "Tax Jurisdiction";
}
/// <summary>
/// Tax group code that was actually used for calculating tax on this specific transaction.
/// </summary>
field(34; "Tax Group Used"; Code[20])
{
Caption = 'Tax Group Used';
Editable = false;
TableRelation = "Tax Group";
}
/// <summary>
/// Type of tax applied to this transaction, such as sales tax or excise tax.
/// </summary>
field(35; "Tax Type"; Option)
{
Caption = 'Tax Type';
Editable = false;
OptionCaption = 'Sales Tax,Excise Tax';
OptionMembers = "Sales Tax","Excise Tax";
}
/// <summary>
/// Indicates whether this transaction involves tax calculated on top of existing tax amounts.
/// </summary>
field(36; "Tax on Tax"; Boolean)
{
Caption = 'Tax on Tax';
Editable = false;
}
/// <summary>
/// Connection number linking this VAT entry to related sales tax calculation entries.
/// </summary>
field(37; "Sales Tax Connection No."; Integer)
{
Caption = 'Sales Tax Connection No.';
Editable = false;
}
/// <summary>
/// Reference to the related unrealized VAT entry when using unrealized VAT functionality.
/// </summary>
field(38; "Unrealized VAT Entry No."; Integer)
{
Caption = 'Unrealized VAT Entry No.';
Editable = false;
TableRelation = "VAT Entry";
}
/// <summary>
/// VAT business posting group specifying the VAT treatment for the customer or vendor type.
/// </summary>
field(39; "VAT Bus. Posting Group"; Code[20])
{
Caption = 'VAT Bus. Posting Group';
Editable = false;
TableRelation = "VAT Business Posting Group";
ToolTip = 'Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.';
}
/// <summary>
/// VAT product posting group specifying the VAT treatment for the item or service type.
/// </summary>
field(40; "VAT Prod. Posting Group"; Code[20])
{
Caption = 'VAT Prod. Posting Group';
Editable = false;
TableRelation = "VAT Product Posting Group";
ToolTip = 'Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.';
}
/// <summary>
/// VAT amount in the additional reporting currency for multi-currency reporting requirements.
/// </summary>
field(43; "Additional-Currency Amount"; Decimal)
{
AccessByPermission = TableData Currency = R;
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Additional-Currency Amount';
Editable = false;
ToolTip = 'Specifies the amount of the VAT entry. The amount is in the additional reporting currency.';
}
/// <summary>
/// Base amount in the additional reporting currency for multi-currency reporting requirements.
/// </summary>
field(44; "Additional-Currency Base"; Decimal)
{
AccessByPermission = TableData Currency = R;
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Additional-Currency Base';
Editable = false;
ToolTip = 'Specifies the amount that the VAT amount is calculated from if you post in an additional reporting currency.';
}
/// <summary>
/// Unrealized VAT amount in the additional reporting currency for unrealized VAT functionality.
/// </summary>
field(45; "Add.-Currency Unrealized Amt."; Decimal)
{
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Add.-Currency Unrealized Amt.';
Editable = false;
}
/// <summary>
/// Unrealized base amount in the additional reporting currency for unrealized VAT functionality.
/// </summary>
field(46; "Add.-Currency Unrealized Base"; Decimal)
{
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Add.-Currency Unrealized Base';
Editable = false;
}
/// <summary>
/// VAT base discount percentage applied to the base amount before VAT calculation.
/// </summary>
field(48; "VAT Base Discount %"; Decimal)
{
AutoFormatType = 0;
Caption = 'VAT Base Discount %';
DecimalPlaces = 0 : 5;
Editable = false;
MaxValue = 100;
MinValue = 0;
}
/// <summary>
/// Remaining unrealized amount in the additional reporting currency that has not yet been realized.
/// </summary>
field(49; "Add.-Curr. Rem. Unreal. Amount"; Decimal)
{
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Add.-Curr. Rem. Unreal. Amount';
Editable = false;
}
/// <summary>
/// Remaining unrealized base amount in the additional reporting currency that has not yet been realized.
/// </summary>
field(50; "Add.-Curr. Rem. Unreal. Base"; Decimal)
{
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Add.-Curr. Rem. Unreal. Base';
Editable = false;
}
/// <summary>
/// Difference between calculated and manually entered VAT amounts for VAT correction purposes.
/// </summary>
field(51; "VAT Difference"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'VAT Difference';
Editable = false;
ToolTip = 'Specifies the difference between the calculated VAT amount and a VAT amount that you have entered manually.';
}
/// <summary>
/// VAT difference amount in the additional reporting currency for multi-currency VAT corrections.
/// </summary>
field(52; "Add.-Curr. VAT Difference"; Decimal)
{
AccessByPermission = TableData Currency = R;
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Add.-Curr. VAT Difference';
Editable = false;
ToolTip = 'Specifies, in the additional reporting currency, the VAT difference that arises when you make a correction to a VAT amount on a sales or purchase document.';
}
/// <summary>
/// Ship-to or order address code for identifying delivery or order address variations.
/// </summary>
field(53; "Ship-to/Order Address Code"; Code[10])
{
Caption = 'Ship-to/Order Address Code';
TableRelation = if (Type = const(Purchase)) "Order Address".Code where("Vendor No." = field("Bill-to/Pay-to No."))
else
if (Type = const(Sale)) "Ship-to Address".Code where("Customer No." = field("Bill-to/Pay-to No."));
ToolTip = 'Specifies the address code of the ship-to customer or order-from vendor that the entry is linked to.';
}
/// <summary>
/// Date of the original document that generated this VAT entry for audit trail purposes.
/// </summary>
field(54; "Document Date"; Date)
{
Caption = 'Document Date';
Editable = false;
ToolTip = 'Specifies the date when the related document was created.';
}
/// <summary>
/// VAT registration number of the customer or vendor for VAT reporting and compliance.
/// </summary>
field(55; "VAT Registration No."; Text[20])
{
Caption = 'VAT Registration No.';
ToolTip = 'Specifies the VAT registration number of the customer or vendor that the entry is linked to.';
trigger OnValidate()
var
VATRegNoFormat: Record "VAT Registration No. Format";
begin
VATRegNoFormat.Test("VAT Registration No.", "Country/Region Code", '', 0);
end;
}
/// <summary>
/// Indicates whether this VAT entry has been reversed as part of a correction transaction.
/// </summary>
field(56; Reversed; Boolean)
{
Caption = 'Reversed';
ToolTip = 'Specifies if the entry has been part of a reverse transaction.';
}
/// <summary>
/// Entry number of the VAT entry that reversed this entry for audit trail and correction tracking.
/// </summary>
field(57; "Reversed by Entry No."; Integer)
{
BlankZero = true;
Caption = 'Reversed by Entry No.';
TableRelation = "VAT Entry";
ToolTip = 'Specifies the number of the correcting entry. If the field Specifies a number, the entry cannot be reversed again.';
}
/// <summary>
/// Entry number of the original VAT entry that was reversed by this correction entry.
/// </summary>
field(58; "Reversed Entry No."; Integer)
{
BlankZero = true;
Caption = 'Reversed Entry No.';
TableRelation = "VAT Entry";
ToolTip = 'Specifies the number of the original entry that was undone by the reverse transaction.';
}
/// <summary>
/// Indicates whether this VAT entry represents an EU service transaction for VAT reporting purposes.
/// </summary>
field(59; "EU Service"; Boolean)
{
Caption = 'EU Service';
Editable = false;
ToolTip = 'Specifies if this VAT entry is to be reported as a service in the periodic VAT reports.';
}
/// <summary>
/// Base amount before payment discount application for accurate VAT calculation tracking.
/// </summary>
field(60; "Base Before Pmt. Disc."; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Base Before Pmt. Disc.';
Editable = false;
}
/// <summary>
/// VAT amount in the source currency of the original transaction for multi-currency processing.
/// </summary>
field(70; "Source Currency VAT Amount"; Decimal)
{
AccessByPermission = TableData Currency = R;
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Source Currency VAT Amount';
Editable = false;
}
/// <summary>
/// Base amount in the source currency of the original transaction for multi-currency processing.
/// </summary>
field(71; "Source Currency VAT Base"; Decimal)
{
AccessByPermission = TableData Currency = R;
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Source Currency VAT Base';
Editable = false;
}
/// <summary>
/// Currency code of the source transaction when different from the local currency.
/// </summary>
field(74; "Source Currency Code"; Code[10])
{
Caption = 'Source Currency Code';
TableRelation = Currency;
DataClassification = SystemMetadata;
}
/// <summary>
/// Exchange rate factor used for converting from source currency to local currency.
/// </summary>
field(75; "Source Currency Factor"; Decimal)
{
AutoFormatType = 0;
Caption = 'Source Currency Factor';
DataClassification = SystemMetadata;
}
/// <summary>
/// Journal template name used for creating this VAT entry through journal posting.
/// </summary>
field(78; "Journal Templ. Name"; Code[10])
{
Caption = 'Journal Template Name';
}
/// <summary>
/// Journal batch name used for creating this VAT entry through journal posting.
/// </summary>
field(79; "Journal Batch Name"; Code[10])
{
Caption = 'Journal Batch Name';
}
/// <summary>
/// Realized VAT amount when unrealized VAT is converted to realized through payment processing.
/// </summary>
field(81; "Realized Amount"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Realized Amount';
Editable = false;
}
/// <summary>
/// Realized base amount when unrealized VAT is converted to realized through payment processing.
/// </summary>
field(82; "Realized Base"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Realized Base';
Editable = false;
}
/// <summary>
/// Realized VAT amount in additional currency when unrealized VAT is converted through payment processing.
/// </summary>
field(83; "Add.-Curr. Realized Amount"; Decimal)
{
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Add.-Curr. Realized Amount';
Editable = false;
}
/// <summary>
/// Realized base amount in additional currency when unrealized VAT is converted through payment processing.
/// </summary>
field(84; "Add.-Curr. Realized Base"; Decimal)
{
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Add.-Curr. Realized Base';
Editable = false;
}
/// <summary>
/// General ledger account number associated with this VAT entry for financial reporting integration.
/// </summary>
field(85; "G/L Acc. No."; Code[20])
{
Caption = 'G/L Account No.';
TableRelation = "G/L Account";
}
/// <summary>
/// VAT reporting date used for VAT return preparation and regulatory compliance reporting.
/// </summary>
field(86; "VAT Reporting Date"; Date)
{
Caption = 'VAT Date';
ToolTip = 'Specifies the VAT date on the VAT entry. This is either the date that the document was created or posted, depending on your setting on the General Ledger Setup page.';
trigger OnValidate()
var
VATDateReportingMgt: Codeunit "VAT Reporting Date Mgt";
begin
if (Rec."VAT Reporting Date" = xRec."VAT Reporting Date") and (CurrFieldNo <> 0) then
exit;
// if type settlement then we error
Validate(Type);
if not VATDateReportingMgt.IsVATDateModifiable() then
Error(VATDateNotModifiableErr);
if Closed then
Error(VATDateModifiableClosedErr);
VATDateReportingMgt.ResetVATReturnPeriodWarning();
VATDateReportingMgt.CheckDateAllowed("VAT Reporting Date", Rec.FieldNo("VAT Reporting Date"), false);
VATDateReportingMgt.CheckDateAllowed(xRec."VAT Reporting Date", Rec.FieldNo("VAT Reporting Date"), true, false);
VATDateReportingMgt.UpdateLinkedEntries(Rec);
end;
}
field(95; "G/L Register No."; Integer)
{
Caption = 'G/L Register No.';
Editable = false;
TableRelation = "G/L Register";
ToolTip = 'Specifies the G/L register number that groups related G/L entries from the same posting.';
}
/// <summary>
/// Percentage of VAT that is non-deductible based on business use or regulatory restrictions.
/// </summary>
field(6200; "Non-Deductible VAT %"; Decimal)
{
AutoFormatType = 0;
Caption = 'Non-Deductible VAT %';
DecimalPlaces = 0 : 5;
Editable = false;
}
/// <summary>
/// Base amount for non-deductible VAT calculation when VAT cannot be fully reclaimed.
/// </summary>
field(6201; "Non-Deductible VAT Base"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Non-Deductible VAT Base';
Editable = false;
ToolTip = 'Specifies the amount of VAT that is not deducted due to the type of goods or services purchased.';
}
/// <summary>
/// Non-deductible VAT amount that cannot be reclaimed and must be treated as cost.
/// </summary>
field(6202; "Non-Deductible VAT Amount"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Non-Deductible VAT Amount';
Editable = false;
ToolTip = 'Specifies the amount of the transaction for which VAT is not applied, due to the type of goods or services purchased.';
}
/// <summary>
/// Non-deductible VAT base amount in the additional currency for multi-currency reporting.
/// </summary>
field(6203; "Non-Deductible VAT Base ACY"; Decimal)
{
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Non-Deductible VAT Base ACY';
Editable = false;
ToolTip = 'Specifies the amount of VAT that is not deducted due to the type of goods or services purchased. The amount is in the additional reporting currency.';
}
/// <summary>
/// Non-deductible VAT amount in the additional currency for multi-currency reporting.
/// </summary>
field(6204; "Non-Deductible VAT Amount ACY"; Decimal)
{
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Non-Deductible VAT Amount ACY';
Editable = false;
ToolTip = 'Specifies the amount of the transaction for which VAT is not applied, due to the type of goods or services purchased. The amount is in the additional reporting currency.';
}
/// <summary>
/// Difference between calculated and manually entered non-deductible VAT amounts for correction purposes.
/// </summary>
field(6205; "Non-Deductible VAT Diff."; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Non-Deductible VAT Difference';
Editable = false;
ToolTip = 'Specifies the difference between the calculated Non-Deductible VAT amount and a Non-Deductible VAT amount that you have entered manually.';
}
/// <summary>
/// Non-deductible VAT difference amount in the additional currency for multi-currency corrections.
/// </summary>
field(6206; "Non-Deductible VAT Diff. ACY"; Decimal)
{
AutoFormatExpression = GetCurrencyCode();
AutoFormatType = 1;
Caption = 'Non-Deductible VAT Difference ACY';
Editable = false;
}
}
keys
{
key(Key1; "Entry No.")
{
Clustered = true;
}
key(Key2; Type, Closed, "VAT Bus. Posting Group", "VAT Prod. Posting Group", "Posting Date", "G/L Acc. No.", "VAT Reporting Date")
{
SumIndexFields = Base, Amount, "Additional-Currency Base", "Additional-Currency Amount", "Remaining Unrealized Amount", "Remaining Unrealized Base", "Add.-Curr. Rem. Unreal. Amount", "Add.-Curr. Rem. Unreal. Base";
}
key(Key3; Type, Closed, "Tax Jurisdiction Code", "Use Tax", "Posting Date")
{
SumIndexFields = Base, Amount, "Unrealized Amount", "Unrealized Base", "Remaining Unrealized Amount";
}
key(Key4; Type, "Country/Region Code", "VAT Registration No.", "VAT Bus. Posting Group", "VAT Prod. Posting Group", "Posting Date")
{
SumIndexFields = Base, "Additional-Currency Base";
}
key(Key5; "Document No.", "Posting Date")
{
}
key(Key6; "Transaction No.")
{
}
key(Key7; "Tax Jurisdiction Code", "Tax Group Used", "Tax Type", "Use Tax", "Posting Date")
{
}
key(Key8; Type, "Bill-to/Pay-to No.", "Transaction No.")
{
MaintainSQLIndex = false;
}
key(Key9; Type, Closed, "VAT Bus. Posting Group", "VAT Prod. Posting Group", "Tax Jurisdiction Code", "Use Tax", "Posting Date", "G/L Acc. No.")
{
SumIndexFields = Base, Amount, "Unrealized Amount", "Unrealized Base", "Additional-Currency Base", "Additional-Currency Amount", "Add.-Currency Unrealized Amt.", "Add.-Currency Unrealized Base", "Remaining Unrealized Amount";
}
key(Key10; "Posting Date", Type, Closed, "VAT Bus. Posting Group", "VAT Prod. Posting Group", Reversed, "G/L Acc. No.", "VAT Reporting Date")
{
SumIndexFields = Base, Amount, "Unrealized Amount", "Unrealized Base", "Additional-Currency Base", "Additional-Currency Amount", "Add.-Currency Unrealized Amt.", "Add.-Currency Unrealized Base", "Remaining Unrealized Amount";
}
key(Key11; "Document Date")
{
}
key(Key12; "G/L Acc. No.")
{
}
key(Key13; Type, Closed, "VAT Bus. Posting Group", "VAT Prod. Posting Group", Reversed, "Posting Date", "G/L Acc. No.", "VAT Reporting Date")
{
}
}
fieldgroups
{
fieldgroup(DropDown; "Entry No.", "Posting Date", "Document Type", "Document No.", "Posting Date")
{
}
}
var
Cust: Record Customer;
Vend: Record Vendor;
GLSetup: Record "General Ledger Setup";
NonDeductibleVAT: Codeunit "Non-Deductible VAT";
#pragma warning disable AA0074
#pragma warning disable AA0470
Text000: Label 'You cannot change the contents of this field when %1 is %2.';
#pragma warning restore AA0470
#pragma warning restore AA0074
ConfirmAdjustQst: Label 'Do you want to fill the G/L Account No. field in VAT entries that are linked to G/L Entries?';
ProgressMsg: Label 'Processed entries: @2@@@@@@@@@@@@@@@@@\';
AdjustTitleMsg: Label 'Adjust G/L account number in VAT entries.\';
NoGLAccNoOnVATEntriesErr: Label 'The VAT Entry table with filter <%1> must not contain records.', Comment = '%1 - the filter expression applied to VAT entry record.';
VATDateNotModifiableErr: Label 'Modification of the VAT Date on the VAT Entry is restricted by the current setting for VAT Reporting Date Usage in the General Ledger Setup.';
VATDateModifiableClosedErr: Label 'The VAT Entry is marked as closed, modification of the VAT Date is therefore not allowed.';
internal procedure SetVATDateFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")
begin
if GenJnlLine."VAT Reporting Date" = 0D then
"VAT Reporting Date" := GLSetup.GetVATDate(GenJnlLine."Posting Date", GenJnlLine."Document Date")
else
"VAT Reporting Date" := GenJnlLine."VAT Reporting Date";
end;
[InherentPermissions(PermissionObjectType::TableData, Database::"VAT Entry", 'r')]
/// <summary>
/// Retrieves the highest entry number from the VAT Entry table.
/// </summary>
/// <returns>Last VAT entry number used in the system</returns>
procedure GetLastEntryNo(): Integer;
var
FindRecordManagement: Codeunit "Find Record Management";
begin
exit(FindRecordManagement.GetLastEntryIntFieldValue(Rec, FieldNo("Entry No.")))
end;
local procedure GetCurrencyCode(): Code[10]
begin
GLSetup.GetRecordOnce();
exit(GLSetup."Additional Reporting Currency");
end;
/// <summary>
/// Calculates the unrealized VAT portion based on payment settlement and unrealized VAT configuration.
/// </summary>
/// <param name="SettledAmount">Amount being settled in the current payment</param>
/// <param name="Paid">Total amount paid so far</param>
/// <param name="Full">Full invoice amount</param>
/// <param name="TotalUnrealVATAmountFirst">Total unrealized VAT amount for first payment method</param>
/// <param name="TotalUnrealVATAmountLast">Total unrealized VAT amount for last payment method</param>
/// <returns>Calculated unrealized VAT amount to be realized</returns>
procedure GetUnrealizedVATPart(SettledAmount: Decimal; Paid: Decimal; Full: Decimal; TotalUnrealVATAmountFirst: Decimal; TotalUnrealVATAmountLast: Decimal): Decimal
var
UnrealizedVATType: Option " ",Percentage,First,Last,"First (Fully Paid)","Last (Fully Paid)";
begin
if (Type <> Type::" ") and
(Amount = 0) and
(Base = 0)
then begin
UnrealizedVATType := GetUnrealizedVATType();
if (UnrealizedVATType = UnrealizedVATType::" ") or
(("Remaining Unrealized Amount" = 0) and
("Remaining Unrealized Base" = 0))
then
exit(0);
if Abs(Paid) = Abs(Full) then
exit(1);
case UnrealizedVATType of
UnrealizedVATType::Percentage:
begin
if Abs(Full) = Abs(Paid) - Abs(SettledAmount) then
exit(1);
if Full = 0 then
exit(Abs(SettledAmount) / (Abs(Paid) + Abs(SettledAmount)));
exit(Abs(SettledAmount) / (Abs(Full) - (Abs(Paid) - Abs(SettledAmount))));
end;
UnrealizedVATType::First:
begin
if "VAT Calculation Type" = "VAT Calculation Type"::"Reverse Charge VAT" then
exit(1);
if Abs(Paid) < Abs(TotalUnrealVATAmountFirst) then
exit(Abs(SettledAmount) / Abs(TotalUnrealVATAmountFirst));
exit(1);
end;
UnrealizedVATType::"First (Fully Paid)":
begin
if "VAT Calculation Type" = "VAT Calculation Type"::"Reverse Charge VAT" then
exit(1);
if Abs(Paid) < Abs(TotalUnrealVATAmountFirst) then
exit(0);
exit(1);
end;
UnrealizedVATType::"Last (Fully Paid)":
exit(0);
UnrealizedVATType::Last:
begin
if "VAT Calculation Type" = "VAT Calculation Type"::"Reverse Charge VAT" then
exit(0);
if Abs(Paid) > Abs(Full) - Abs(TotalUnrealVATAmountLast) then
exit((Abs(Paid) - (Abs(Full) - Abs(TotalUnrealVATAmountLast))) / Abs(TotalUnrealVATAmountLast));
exit(0);
end;
end;
end else
exit(0);
end;
/// <summary>
/// Retrieves the unrealized VAT type configuration for this VAT entry.
/// </summary>
/// <returns>Unrealized VAT type setting from VAT posting setup or tax jurisdiction</returns>
procedure GetUnrealizedVATType() UnrealizedVATType: Integer
var
VATPostingSetup: Record "VAT Posting Setup";
TaxJurisdiction: Record "Tax Jurisdiction";
begin
if "VAT Calculation Type" = "VAT Calculation Type"::"Sales Tax" then begin
TaxJurisdiction.Get("Tax Jurisdiction Code");
UnrealizedVATType := TaxJurisdiction."Unrealized VAT Type";
end else begin
VATPostingSetup.Get("VAT Bus. Posting Group", "VAT Prod. Posting Group");
UnrealizedVATType := VATPostingSetup."Unrealized VAT Type";
end;
end;
/// <summary>
/// Copies VAT-related data from a General Journal Line to populate this VAT entry.
/// </summary>
/// <param name="GenJnlLine">General journal line containing source data for VAT entry creation</param>
procedure CopyFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")
begin
SetVATDateFromGenJnlLine(GenJnlLine);
CopyPostingGroupsFromGenJnlLine(GenJnlLine);
CopyPostingDataFromGenJnlLine(GenJnlLine);
Type := GenJnlLine."Gen. Posting Type";
"VAT Calculation Type" := GenJnlLine."VAT Calculation Type";
"Ship-to/Order Address Code" := GenJnlLine."Ship-to/Order Address Code";
"EU 3-Party Trade" := GenJnlLine."EU 3-Party Trade";
"User ID" := CopyStr(UserId(), 1, MaxStrLen("User ID"));
"No. Series" := GenJnlLine."Posting No. Series";
"VAT Base Discount %" := GenJnlLine."VAT Base Discount %";
"Bill-to/Pay-to No." := GenJnlLine."Bill-to/Pay-to No.";
"Country/Region Code" := GenJnlLine."Country/Region Code";
"VAT Registration No." := GenJnlLine."VAT Registration No.";
NonDeductibleVAT.Copy(Rec, GenJnlLine);
OnAfterCopyFromGenJnlLine(Rec, GenJnlLine);
end;
/// <summary>
/// Copies posting-related data from a General Journal Line to this VAT entry.
/// </summary>
/// <param name="GenJnlLine">General journal line containing posting data</param>
procedure CopyPostingDataFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")
begin
"Posting Date" := GenJnlLine."Posting Date";
if GenJnlLine."VAT Reporting Date" = 0D then
"VAT Reporting Date" := GLSetup.GetVATDate(GenJnlLine."Posting Date", GenJnlLine."Document Date")
else
"VAT Reporting Date" := GenJnlLine."VAT Reporting Date";
"Document Type" := GenJnlLine."Document Type";
"Document Date" := GenJnlLine."Document Date";
"Document No." := GenJnlLine."Document No.";
"External Document No." := GenJnlLine."External Document No.";
"Source Code" := GenJnlLine."Source Code";
"Reason Code" := GenJnlLine."Reason Code";
"Journal Templ. Name" := GenJnlLine."Journal Template Name";
"Journal Batch Name" := GenJnlLine."Journal Batch Name";
end;
local procedure CopyPostingGroupsFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")
begin
"Gen. Bus. Posting Group" := GenJnlLine."Gen. Bus. Posting Group";
"Gen. Prod. Posting Group" := GenJnlLine."Gen. Prod. Posting Group";
"VAT Bus. Posting Group" := GenJnlLine."VAT Bus. Posting Group";
"VAT Prod. Posting Group" := GenJnlLine."VAT Prod. Posting Group";
"Tax Area Code" := GenJnlLine."Tax Area Code";
"Tax Liable" := GenJnlLine."Tax Liable";
"Tax Group Code" := GenJnlLine."Tax Group Code";
"Use Tax" := GenJnlLine."Use Tax";
end;
/// <summary>
/// Sets the G/L Account No. field for this VAT entry by creating missing VAT Entry - G/L Entry links.
/// </summary>
/// <param name="WithUI">Whether to show user interface elements during processing</param>
procedure SetGLAccountNo(WithUI: Boolean)
var
Response: Boolean;
begin
Response := false;
SetGLAccountNoWithResponse(WithUI, WithUI, Response);
end;
/// <summary>
/// Sets the G/L Account No. field for this VAT entry with user response handling.
/// </summary>
/// <param name="WithUI">Whether to show user interface elements during processing</param>
/// <param name="ShowConfirm">Whether to show confirmation dialogs to user</param>
/// <param name="Response">User response from any confirmation dialogs</param>
procedure SetGLAccountNoWithResponse(WithUI: Boolean; ShowConfirm: Boolean; var Response: Boolean)
var
VATEntryLocal: Record "VAT Entry";
ConfirmManagement: Codeunit "Confirm Management";
Window: Dialog;
EntryNosByGLAccountNo: Dictionary of [Code[20], List of [Integer]];
EntryNos: List of [Integer];
GLAccountNoToSet: Code[20];
NoOfRecords: Integer;
Index: Integer;
LastShownProgress: Integer;
Progress: Integer;
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeSetGLAccountNo(Rec, IsHandled, Response, WithUI, ShowConfirm);
if IsHandled then
exit;
VATEntryLocal.Copy(Rec);
VATEntryLocal.SetRange("G/L Acc. No.", '');
if WithUI then begin
if GuiAllowed() then begin
if ShowConfirm and not Response then
Response := ConfirmManagement.GetResponseOrDefault(ConfirmAdjustQst, false);
end else
// Background execution has no user to confirm with; proceed so the report can run unattended.
Response := true;
if not Response then
exit;
if GuiAllowed() then begin
NoOfRecords := VATEntryLocal.Count();
Window.Open(AdjustTitleMsg + ProgressMsg);
end;
end;
// Pass 1: read-only resolve target G/L Acc. No. per VAT entry and group entry numbers
// by target account; the writes happen in pass 2, avoiding Halloween risk.
VATEntryLocal.SetLoadFields("G/L Acc. No.", "Entry No.", "Transaction No.", "Gen. Bus. Posting Group", "Gen. Prod. Posting Group", "VAT Bus. Posting Group", "VAT Prod. Posting Group", "Tax Area Code", "Tax Liable", "Tax Group Code", "Use Tax");
Index := 0;
if VATEntryLocal.FindSet() then
repeat
if TryGetGLAccountNoForVATEntry(VATEntryLocal, GLAccountNoToSet) then begin
if not EntryNosByGLAccountNo.Get(GLAccountNoToSet, EntryNos) then begin
Clear(EntryNos);
EntryNosByGLAccountNo.Add(GLAccountNoToSet, EntryNos);
end;
EntryNos.Add(VATEntryLocal."Entry No.");
EntryNosByGLAccountNo.Set(GLAccountNoToSet, EntryNos);
end;
Index += 1;
if WithUI and GuiAllowed() and (NoOfRecords > 0) then begin
Progress := Round(Index / NoOfRecords * 10000, 1);
// Throttle UI round-trips: only refresh on whole-percent changes.
if Progress >= LastShownProgress + 100 then begin
Window.Update(2, Progress);
LastShownProgress := Progress;
end;
end;
until VATEntryLocal.Next() = 0;
// Pass 2: one ModifyAll per (target account, chunk of Entry No.) instead of one Modify
// per row; collapses N database round-trips to ceil(N / ChunkSize) per distinct account.
ApplyBatchedGLAccountNoUpdates(EntryNosByGLAccountNo);
if WithUI and GuiAllowed() then
Window.Close();
IsHandled := false;
OnAfterSetGLAccountNo(Rec, IsHandled, WithUI);
if IsHandled then
exit;
CheckGLAccountNoFilled();
end;
/// <summary>
/// Validates that all VAT entries in the current filter have their G/L Account No. field populated.
/// </summary>
procedure CheckGLAccountNoFilled()
var
VATEntryLocal: Record "VAT Entry";
GLEntryVATLink: Record "G/L Entry - VAT Entry Link";
begin
VATEntryLocal.Copy(Rec);
VATEntryLocal.ReadIsolation := IsolationLevel::ReadCommitted;
VATEntryLocal.SetCurrentKey("G/L Acc. No.");
VATEntryLocal.SetRange("G/L Acc. No.", '');
VATEntryLocal.SetLoadFields("Entry No.");
if not VATEntryLocal.FindSet() then
exit;
repeat
GLEntryVATLink.Reset();
GLEntryVATLink.SetRange("VAT Entry No.", VATEntryLocal."Entry No.");
GLEntryVATLink.SetFilter("G/L Entry No.", '<>%1', 0);
if not GLEntryVATLink.IsEmpty() then
Error(NoGLAccNoOnVATEntriesErr, VATEntryLocal.GetFilters());
until VATEntryLocal.Next() = 0;
end;
local procedure TryGetGLAccountNoForVATEntry(var VATEntry: Record "VAT Entry"; var GLAccountNo: Code[20]): Boolean
var
GLEntry: Record "G/L Entry";
GLEntryVATEntryLink: Record "G/L Entry - VAT Entry Link";
begin
GLEntryVATEntryLink.SetCurrentKey("VAT Entry No.");
GLEntryVATEntryLink.SetRange("VAT Entry No.", VATEntry."Entry No.");
if not GLEntryVATEntryLink.FindFirst() then begin
if not AddMissingGLEntryVATEntryLink(VATEntry, GLEntry, GLEntryVATEntryLink) then
exit(false);
end else begin
GLEntry.SetLoadFields("G/L Account No.");
if not GLEntry.Get(GLEntryVATEntryLink."G/L Entry No.") then
exit(false);
end;
GLAccountNo := GLEntry."G/L Account No.";
exit(true);
end;
local procedure ApplyBatchedGLAccountNoUpdates(EntryNosByGLAccountNo: Dictionary of [Code[20], List of [Integer]])
var
VATEntryUpdate: Record "VAT Entry";
EntryNoFilter: TextBuilder;
EntryNos: List of [Integer];
GLAccountNo: Code[20];
EntryNo: Integer;
EntryNoTxt: Text;
InChunk: Integer;
ChunkSize: Integer;
MaxEntryNoFilterLength: Integer;
TotalChunkDuration: Duration;
ChunkCount: Integer;
AvgChunkDurationMs: Integer;
TelemetryTxt: Label 'Adjust G/L Account No. on VAT entries: average modify time per chunk is %1 ms.', Locked = true;
TelemetryCategoryTok: Label 'AL VAT Entry G/L Reconciliation', Locked = true;
begin
ChunkSize := 100;
MaxEntryNoFilterLength := 900;
foreach GLAccountNo in EntryNosByGLAccountNo.Keys() do begin
EntryNos := EntryNosByGLAccountNo.Get(GLAccountNo);
InChunk := 0;
foreach EntryNo in EntryNos do begin
// Format with XML-invariant style to avoid locale thousand separators in the filter string.
EntryNoTxt := Format(EntryNo, 0, 9);
// Flush when adding the next entry would exceed the chunk size or the safe filter length.
if (InChunk = ChunkSize) or
((InChunk > 0) and ((EntryNoFilter.Length() + 1 + StrLen(EntryNoTxt)) > MaxEntryNoFilterLength)) then begin
FlushBatchedGLAccountNoUpdate(VATEntryUpdate, EntryNoFilter, GLAccountNo, TotalChunkDuration, ChunkCount);
InChunk := 0;
end;
if InChunk > 0 then
EntryNoFilter.Append('|');
EntryNoFilter.Append(EntryNoTxt);
InChunk += 1;
end;
FlushBatchedGLAccountNoUpdate(VATEntryUpdate, EntryNoFilter, GLAccountNo, TotalChunkDuration, ChunkCount);
end;
if ChunkCount > 0 then begin
AvgChunkDurationMs := Round((TotalChunkDuration div 1) / ChunkCount, 1);
Session.LogMessage('0000PVR', StrSubstNo(TelemetryTxt, AvgChunkDurationMs), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', TelemetryCategoryTok);
end;
end;
local procedure FlushBatchedGLAccountNoUpdate(var VATEntryUpdate: Record "VAT Entry"; var EntryNoFilter: TextBuilder; GLAccountNo: Code[20]; var TotalChunkDuration: Duration; var ChunkCount: Integer)
var
StartTime: DateTime;
begin
if EntryNoFilter.Length() = 0 then
exit;
StartTime := CurrentDateTime();
VATEntryUpdate.Reset();
// Re-apply the empty-account filter from pass 1 so a concurrent writer between passes
// cannot have its G/L Acc. No. overwritten by this batch update.
VATEntryUpdate.SetRange("G/L Acc. No.", '');
VATEntryUpdate.SetFilter("Entry No.", EntryNoFilter.ToText());
VATEntryUpdate.ModifyAll("G/L Acc. No.", GLAccountNo, false);
// Persist each batch so a long-running adjustment that times out can resume from where it
// left off instead of restarting from scratch and never completing.
Commit();
EntryNoFilter.Clear();
TotalChunkDuration += CurrentDateTime() - StartTime;
ChunkCount += 1;
end;
local procedure AddMissingGLEntryVATEntryLink(var VATEntry: Record "VAT Entry"; var GLEntry: Record "G/L Entry"; var GLEntryVATEntryLink: Record "G/L Entry - VAT Entry Link"): Boolean
begin
GLEntry.SetCurrentKey("Transaction No.");
GLEntry.SetRange("Transaction No.", VATEntry."Transaction No.");
GLEntry.SetRange("Gen. Bus. Posting Group", VATEntry."Gen. Bus. Posting Group");
GLEntry.SetRange("Gen. Prod. Posting Group", VATEntry."Gen. Prod. Posting Group");
GLEntry.SetRange("VAT Bus. Posting Group", VATEntry."VAT Bus. Posting Group");
GLEntry.SetRange("VAT Prod. Posting Group", VATEntry."VAT Prod. Posting Group");
GLEntry.SetRange("Tax Area Code", VATEntry."Tax Area Code");
GLEntry.SetRange("Tax Liable", VATEntry."Tax Liable");
GLEntry.SetRange("Tax Group Code", VATEntry."Tax Group Code");
GLEntry.SetRange("Use Tax", VATEntry."Use Tax");
if not GLEntry.FindFirst() then
exit(false);
GLEntryVATEntryLink.InsertLinkSelf(GLEntry."Entry No.", VATEntry."Entry No.");
exit(true);
end;
/// <summary>
/// Copies amount fields from another VAT entry, optionally with opposite sign for reversals.
/// </summary>
/// <param name="VATEntry">Source VAT entry to copy amounts from</param>
/// <param name="WithOppositeSign">Whether to reverse the sign of copied amounts</param>
procedure CopyAmountsFromVATEntry(VATEntry: Record "VAT Entry"; WithOppositeSign: Boolean)
var
Sign: Decimal;
begin
if WithOppositeSign then
Sign := -1
else
Sign := 1;
Base := Sign * VATEntry.Base;
Amount := Sign * VATEntry.Amount;
"Unrealized Amount" := Sign * VATEntry."Unrealized Amount";
"Unrealized Base" := Sign * VATEntry."Unrealized Base";
"Remaining Unrealized Amount" := Sign * VATEntry."Remaining Unrealized Amount";
"Remaining Unrealized Base" := Sign * VATEntry."Remaining Unrealized Base";
"Additional-Currency Amount" := Sign * VATEntry."Additional-Currency Amount";
"Additional-Currency Base" := Sign * VATEntry."Additional-Currency Base";
"Add.-Currency Unrealized Amt." := Sign * VATEntry."Add.-Currency Unrealized Amt.";
"Add.-Currency Unrealized Base" := Sign * VATEntry."Add.-Currency Unrealized Base";
"Add.-Curr. Rem. Unreal. Amount" := Sign * VATEntry."Add.-Curr. Rem. Unreal. Amount";
"Add.-Curr. Rem. Unreal. Base" := Sign * VATEntry."Add.-Curr. Rem. Unreal. Base";
"VAT Difference" := Sign * VATEntry."VAT Difference";
"Add.-Curr. VAT Difference" := Sign * VATEntry."Add.-Curr. VAT Difference";
"Realized Amount" := Sign * "Realized Amount";
"Realized Base" := Sign * "Realized Base";
"Add.-Curr. Realized Amount" := Sign * "Add.-Curr. Realized Amount";
"Add.-Curr. Realized Base" := Sign * "Add.-Curr. Realized Base";
OnAfterOnCopyAmountsFromVATEntry(VATEntry, WithOppositeSign, Rec);
end;
/// <summary>
/// Resets all unrealized VAT amount fields to zero for this VAT entry.
/// </summary>
procedure SetUnrealAmountsToZero()
begin
"Unrealized Amount" := 0;
"Unrealized Base" := 0;
"Remaining Unrealized Amount" := 0;
"Remaining Unrealized Base" := 0;
"Add.-Currency Unrealized Amt." := 0;
"Add.-Currency Unrealized Base" := 0;
"Add.-Curr. Rem. Unreal. Amount" := 0;
"Add.-Curr. Rem. Unreal. Base" := 0;
"Realized Amount" := 0;
"Realized Base" := 0;
"Add.-Curr. Realized Amount" := 0;
"Add.-Curr. Realized Base" := 0;
end;
/// <summary>
/// Integration event raised after copying data from General Journal Line to VAT Entry.
/// </summary>
/// <param name="VATEntry">VAT entry record that was populated from journal line</param>
/// <param name="GenJournalLine">Source general journal line</param>
[IntegrationEvent(false, false)]
procedure OnAfterCopyFromGenJnlLine(var VATEntry: Record "VAT Entry"; GenJournalLine: Record "Gen. Journal Line")
begin
end;
/// <summary>
/// Integration event raised after copying amounts from another VAT entry.
/// </summary>
/// <param name="VATEntry">Source VAT entry providing the amounts</param>
/// <param name="WithOppositeSign">Whether amounts were copied with opposite sign</param>
/// <param name="RecVATEntry">Target VAT entry that received the copied amounts</param>
[IntegrationEvent(false, false)]
local procedure OnAfterOnCopyAmountsFromVATEntry(var VATEntry: Record "VAT Entry"; WithOppositeSign: Boolean; var RecVATEntry: Record "VAT Entry")
begin
end;
/// <summary>
/// Integration event raised before setting G/L Account No. on VAT entry.
/// </summary>
/// <param name="VATEntry">VAT entry being processed</param>
/// <param name="IsHandled">Set to true to skip standard processing</param>
/// <param name="Response">User response from confirmation dialogs</param>
/// <param name="WithUI">Whether UI elements should be shown</param>
/// <param name="ShowConfirm">Whether confirmation dialogs should be displayed</param>
[IntegrationEvent(false, false)]
local procedure OnBeforeSetGLAccountNo(var VATEntry: Record "VAT Entry"; var IsHandled: Boolean; var Response: Boolean; WithUI: Boolean; ShowConfirm: Boolean)
begin
end;
/// <summary>
/// Integration event raised after setting G/L Account No. on VAT entry.
/// </summary>
/// <param name="VATEntry">VAT entry that was processed</param>
/// <param name="IsHandled">Whether the operation was handled by subscriber</param>
/// <param name="WithUI">Whether UI elements were shown during processing</param>
[IntegrationEvent(false, false)]
local procedure OnAfterSetGLAccountNo(var VATEntry: Record "VAT Entry"; var IsHandled: Boolean; WithUI: Boolean)
begin
end;
}