Table 254 VAT Entry
src/Layers/W1/BaseApp/Finance/VAT/Ledger/VATEntry.Table.al1,414 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;}