Report 19 VAT- VIES Declaration Tax Auth
src/Layers/W1/BaseApp/Finance/VAT/Reporting/VATVIESDeclarationTaxAuth.Report.al377 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.Reporting;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Ledger;using Microsoft.Foundation.Address;using Microsoft.Foundation.Company;using System.Utilities;/// <summary>/// Generates VIES (VAT Information Exchange System) declaration report for tax authority submission./// Produces formatted report of intra-community EU sales transactions for regulatory compliance and audit purposes./// </summary>report 19 "VAT- VIES Declaration Tax Auth"{ ApplicationArea = VAT; Caption = 'VAT- VIES Declaration Tax Auth'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("Integer"; "Integer") { DataItemTableView = sorting(Number) order(ascending) where(Number = filter(1 ..)); column(CompanyAddr1; CompanyAddr[1]) { } column(CompanyAddr2; CompanyAddr[2]) { } column(CompanyAddr3; CompanyAddr[3]) { } column(CompanyAddr4; CompanyAddr[4]) { } column(CompanyAddr5; CompanyAddr[5]) { } column(PeriodDate; Format(EndDate, 0, 6)) { } column(CompanyInfoVATRegNo; CompanyInfo."VAT Registration No.") { } column(CompanyAddr6; CompanyAddr[6]) { } column(CompanyAddr7; CompanyAddr[7]) { } column(CompanyAddr8; CompanyAddr[8]) { } column(CountryRegionCode; VATEntriesBaseAmtSum.EU_Country_Region_Code) { } column(VATRegNo; VATEntriesBaseAmtSum.VAT_Registration_No) { } column(TotalValueofItemSupplies; -TotalValueofItemSupplies) { } column(EU3PartyItemTradeAmt; -EU3PartyItemTradeAmt) { AutoFormatType = 1; } column(CountryBlank; CountryBlank) { } column(ShowError; ShowError) { } column(CountryCode; VATEntriesBaseAmtSum.Country_Region_Code) { } column(BilltoPaytoNo; VATEntriesBaseAmtSum.Bill_to_Pay_to_No) { } column(TotalValueofServiceSupplies; -TotalValueofServiceSupplies) { } column(EU3PartyServiceTradeAmt; -EU3PartyServiceTradeAmt) { AutoFormatType = 1; } column(ErrorText; ErrorText) { } column(HeaderText; HeaderText) { } column(CompanyInfoBusinessIdentityCode; BusinessIdentityCodeTxt) { } column(CompanyInfoRegisteredHomeCity; RegisteredHomeCityTxt) { } column(BusinessIdentityCodeCaption; BusinessIdentityCodeLbl) { } column(RegHomeCityCaption; RegisteredHomeCityLbl) { } column(ServiceSuppliesCode4Caption; ServiceSuppliesCode4CaptionTxt) { } trigger OnAfterGetRecord() begin TotalValueofServiceSupplies := 0; TotalValueofItemSupplies := 0; EU3PartyItemTradeAmt := 0; EU3PartyServiceTradeAmt := 0; if not VATEntriesBaseAmtSum.Read() then CurrReport.Break(); if VATEntriesBaseAmtSum.EU_Service then begin if UseAmtsInAddCurr then TotalValueofServiceSupplies := VATEntriesBaseAmtSum.Sum_Additional_Currency_Base else TotalValueofServiceSupplies := VATEntriesBaseAmtSum.Sum_Base end else if UseAmtsInAddCurr then TotalValueofItemSupplies := VATEntriesBaseAmtSum.Sum_Additional_Currency_Base else TotalValueofItemSupplies := VATEntriesBaseAmtSum.Sum_Base; if VATEntriesBaseAmtSum.EU_3_Party_Trade then begin EU3PartyItemTradeAmt := TotalValueofItemSupplies; EU3PartyServiceTradeAmt := TotalValueofServiceSupplies; end; CountryBlank := true; if not ((VATEntriesBaseAmtSum.Sum_Base <> 0) or (VATEntriesBaseAmtSum.Sum_Additional_Currency_Base <> 0)) and (VATEntriesBaseAmtSum.Bill_to_Pay_to_No <> '') and (VATEntriesBaseAmtSum.EU_Country_Region_Code <> '') then CountryBlank := false; if VATEntriesBaseAmtSum.Country_Region_Code = CompanyInfo."Country/Region Code" then CurrReport.Skip(); ShowError := false; ErrorText := ''; if VATEntriesBaseAmtSum.VAT_Registration_No = '' then begin ShowError := true; ErrorText := StrSubstNo(Text001, VATEntriesBaseAmtSum.Bill_to_Pay_to_No); end; end; trigger OnPreDataItem() begin if (StartDate = 0D) or (EndDate = 0D) then Error(Text002); FormatAddr.Company(CompanyAddr, CompanyInfo); CompanyInfo.TestField("VAT Registration No."); VATEntriesBaseAmtSum.SetFilter(VAT_Registration_No, VATRegistrationNoFilter); VATEntriesBaseAmtSum.SetFilter(VAT_Date, '%1..%2', StartDate, EndDate); VATEntriesBaseAmtSum.Open(); end; } } requestpage { AboutTitle = 'About VAT- VIES Declaration Tax Auth'; AboutText = 'The **VAT-VIES Declaration Tax Auth** report generates a declaration of intra-community sales to VAT-registered customers in the EU. It helps support compliance with EU tax requirements by compiling sales data for submission to the VIES system. Use it for submitting required intra-EU sales reports to tax authorities, especially when accurate VAT numbers and country codes are essential.'; SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(ShowAmountsInAddReportingCurrency; UseAmtsInAddCurr) { ApplicationArea = Basic, Suite; Caption = 'Show Amounts in Add. Reporting Currency'; MultiLine = true; ToolTip = 'Specifies if the reported amounts are shown in the additional reporting currency.'; } field(StartingDate; StartDate) { ApplicationArea = Basic, Suite; Caption = 'Start date'; ToolTip = 'Specifies the start date for the report.'; } field(EndingDate; EndDate) { ApplicationArea = Basic, Suite; Caption = 'End date'; ToolTip = 'Specifies the end date for the report.'; } field(VATRegistrationNoFilter; VATRegistrationNoFilter) { ApplicationArea = Basic, Suite; Caption = 'VAT. Registration No. Filter'; ToolTip = 'Specifies a VAT registration number, in order to limit the report to one or more customers or vendors.'; } } } } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Finance/VAT/Reporting/VATVIESDeclarationTaxAuth.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { CUSTOMSCaption = 'CUSTOMS', Comment = 'Uppercase of the translation customers'; VIES_DECLARATIONCaption = 'VIES DECLARATION'; TAXCaption = 'TAX'; Country_Region_Codes_Caption = 'Country/Region Codes:'; Name_and_Address_Caption = 'Name and Address'; BECaption = 'BE'; BelgiumCaption = 'Belgium'; DECaption = 'DE'; GermanyCaption = 'Germany'; ELCaption = 'EL'; GreeceCaption = 'Greece'; ESCaption = 'ES'; SpainCaption = 'Spain'; FRCaption = 'FR'; FranceCaption = 'France'; GBCaption = 'UK'; EnglandCaption = 'United Kingdom'; IECaption = 'IE'; IrelandCaption = 'Ireland'; PeriodCaption = 'Period'; ITCaption = 'IT'; ItalyCaption = 'Italy'; LUCaption = 'LU'; LuxembourgCaption = 'Luxembourg'; Seller_s_VAT_Registration_No_Caption = 'Seller''s VAT Registration No.'; NLCaption = 'NL'; NetherlandsCaption = 'Netherlands'; PTCaption = 'PT'; PortugalCaption = 'Portugal'; Total_Sales_to_EUCaption = 'Total Sales to EU in the Period (in thousands)'; DKCaption = 'DK'; DenmarkCaption = 'Denmark'; SECaption = 'SE'; ATCaption = 'AT'; FICaption = 'FI'; SwedenCaption = 'Sweden'; FinlandCaption = 'Finland'; AustriaCaption = 'Austria'; CYCaption = 'CY'; EECaption = 'EE'; HUCaption = 'HU'; CyprusCaption = 'Cyprus'; CzechRepublicCaption = 'Czech Republic'; HungaryCaption = 'Hungary'; EstoniaCaption = 'Estonia'; LTCaption = 'LT'; LithuaniaCaption = 'Lithuania'; LVCaption = 'LV'; LatviaCaption = 'Latvia'; MTCaption = 'MT'; MaltaCaption = 'Malta'; PLCaption = 'PL'; PolandCaption = 'Poland'; ROCaption = 'RO'; RomaniaCaption = 'Romania'; SKCaption = 'SK'; SlovakRepublicCaption = 'Slovakia'; SLCaption = 'SL'; SloveniaCaption = 'Slovenia'; BGCaption = 'BG'; BulgariaCaption = 'Bulgaria'; CZCaption = 'CZ'; CountryRegionCodeCaption = 'Customer Country/Region Code'; Customers_VAT_Registration_No_Caption = 'Customer VAT Registration No.'; TotalValueofItemSuppliesCaption = 'Total Value of Item Supplies'; CodeCaption = 'Code'; EU3PartyItemTradeAmtCaption = 'EU 3-Party Item Trade Amount'; TotalValueOfServiceSuppliesCaption = 'Total Value of Service Supplies'; EU3PartyServiceTradeAmtCaption = 'EU 3-Party Service Trade Amount'; V0Caption = '0', Locked = true; ErrorTextCaption = 'Warning!'; DateCaption = 'Date'; SignatureCaption = 'Signature'; } trigger OnInitReport() var IsHandled: Boolean; begin GLSetup.Get(); CompanyInfo.Get(); IsHandled := false; OnAfterInitReportForGlobalVariable(IsHandled, BusinessIdentityCodeTxt, BusinessIdentityCodeLbl, RegisteredHomeCityTxt, RegisteredHomeCityLbl, ServiceSuppliesCode4CaptionTxt); end; trigger OnPreReport() begin if UseAmtsInAddCurr then HeaderText := StrSubstNo(Text000, GLSetup."Additional Reporting Currency") else begin GLSetup.TestField("LCY Code"); HeaderText := StrSubstNo(Text000, GLSetup."LCY Code"); end; end; var GLSetup: Record "General Ledger Setup"; CompanyInfo: Record "Company Information"; FormatAddr: Codeunit "Format Address"; VATEntriesBaseAmtSum: Query "VAT Entries Base Amt. Sum"; CompanyAddr: array[8] of Text[100]; StartDate: Date; EndDate: Date; EU3PartyItemTradeAmt: Decimal; EU3PartyServiceTradeAmt: Decimal; ErrorText: Text[250]; UseAmtsInAddCurr: Boolean; TotalValueofServiceSupplies: Decimal; TotalValueofItemSupplies: Decimal; HeaderText: Text[50]; CountryBlank: Boolean; ShowError: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'All amounts are in %1.'; Text001: Label 'The VAT Registration No. is not filled in for all VAT entries where for Customer %1 on one or more entries.';#pragma warning restore AA0470 Text002: Label 'Start and end date must be filled in.';#pragma warning restore AA0074 VATRegistrationNoFilter: Text[250]; BusinessIdentityCodeTxt: Text; BusinessIdentityCodeLbl: Text; RegisteredHomeCityTxt: Text; RegisteredHomeCityLbl: Text; ServiceSuppliesCode4CaptionTxt: Text; /// <summary> /// Initializes VIES declaration tax authority report with currency and period parameters. /// Configures report criteria including currency display, date range, and VAT registration filtering. /// </summary> /// <param name="NewUseAmtsInAddCurr">True to display amounts in additional reporting currency, false for local currency</param> /// <param name="NewStartDate">Start date for VIES declaration period</param> /// <param name="NedEndDate">End date for VIES declaration period</param> /// <param name="SetVATRegistrationNoFilter">VAT registration number filter for specific customers</param> procedure InitializeRequest(NewUseAmtsInAddCurr: Boolean; NewStartDate: Date; NedEndDate: Date; SetVATRegistrationNoFilter: Text[250]) begin UseAmtsInAddCurr := NewUseAmtsInAddCurr; StartDate := NewStartDate; EndDate := NedEndDate; VATRegistrationNoFilter := SetVATRegistrationNoFilter; end; [IntegrationEvent(false, false)] local procedure OnAfterInitReportForGlobalVariable(var IsHandled: Boolean; var BusinessIdentityCodeTxt: Text; var BusinessIdentityCodeLbl: Text; var RegisteredHomeCityTxt: Text; var RegisteredHomeCityLbl: Text; var ServiceSuppliesCode4CaptionTxt: Text) begin end;}