Report 19 VAT- VIES Declaration Tax Auth

Base Application, Microsoft.Finance.VAT.Reporting

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;}