Report 88 VAT- VIES Declaration Disk
src/Layers/W1/BaseApp/Finance/VAT/Reporting/VATVIESDeclarationDisk.Report.al315 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 Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;using System.IO;/// <summary>/// Generates VIES (VAT Information Exchange System) declaration files for EU VAT reporting compliance./// Exports EU sales data to disk file format required by tax authorities for intra-community trade reporting./// </summary>report 88 "VAT- VIES Declaration Disk"{ Caption = 'VAT- VIES Declaration Disk'; Permissions = TableData "VAT Entry" = rimd; ProcessingOnly = true; UsageCategory = ReportsAndAnalysis; AllowScheduling = false; dataset { dataitem("VAT Entry"; "VAT Entry") { DataItemTableView = sorting(Type, "Country/Region Code", "VAT Registration No.", "VAT Bus. Posting Group", "VAT Prod. Posting Group", "VAT Reporting Date") where(Type = const(Sale)); RequestFilterFields = "VAT Bus. Posting Group", "VAT Prod. Posting Group", "VAT Reporting Date"; trigger OnAfterGetRecord() var VATEntry: Record "VAT Entry"; TotalValueOfItemSupplies: Decimal; TotalValueOfServiceSupplies: Decimal; GroupTotal: Boolean; begin if "EU Service" then begin if UseAmtsInAddCurr then TotalValueOfServiceSupplies := "Additional-Currency Base" else TotalValueOfServiceSupplies := Base end else if UseAmtsInAddCurr then TotalValueOfItemSupplies := "Additional-Currency Base" else TotalValueOfItemSupplies := Base; if "EU 3-Party Trade" then begin EU3PartyItemTradeAmt := EU3PartyItemTradeAmt + TotalValueOfItemSupplies; EU3PartyServiceTradeAmt := EU3PartyServiceTradeAmt + TotalValueOfServiceSupplies; end; TotalValueofItemSuppliesTotal += TotalValueOfItemSupplies; TotalValueofServiceSuppliesTot += TotalValueOfServiceSupplies; VATEntry.Copy("VAT Entry"); if VATEntry.Next() = 1 then begin if (VATEntry."Country/Region Code" <> "Country/Region Code") or (VATEntry."VAT Registration No." <> "VAT Registration No.") then GroupTotal := true; end else GroupTotal := true; if GroupTotal then begin WriteGrTotalsToFile(TotalValueofServiceSuppliesTot, TotalValueofItemSuppliesTotal, EU3PartyServiceTradeAmt, EU3PartyItemTradeAmt, "VAT Reporting Date"); EU3PartyItemTradeTotalAmt += EU3PartyItemTradeAmt; EU3PartyServiceTradeTotalAmt += EU3PartyServiceTradeAmt; TotalValueofItemSuppliesTotal := 0; TotalValueofServiceSuppliesTot := 0; EU3PartyItemTradeAmt := 0; EU3PartyServiceTradeAmt := 0; end; end; trigger OnPostDataItem() begin VATFile.Write( Format( '10' + DecimalNumeralZeroFormat(NoOfGrTotal, 9) + DecimalNumeralZeroFormat(EU3PartyItemTradeTotalAmt, 15) + DecimalNumeralSign(-EU3PartyItemTradeTotalAmt) + DecimalNumeralZeroFormat(EU3PartyServiceTradeTotalAmt, 15) + DecimalNumeralSign(-EU3PartyServiceTradeTotalAmt), 80)); VATFile.Close(); end; trigger OnPreDataItem() begin Clear(VATFile); VATFile.TextMode := true; VATFile.WriteMode := true; VATFile.Create(FileName); CompanyInfo.Get(); GeneralLedgerSetup.Get(); VATRegNo := ConvertStr(CompanyInfo."VAT Registration No.", Text001, ' '); VATFile.Write(Format('00' + Format(VATRegNo, 8) + Text002, 80)); VATFile.Write(Format('0100001', 80)); NoOfGrTotal := 0; Period := GetRangeMax("VAT Reporting Date"); InternalReferenceNo := Format(Period, 4, 2) + '000000'; end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(UseAmtsInAddCurr; 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.'; } } } } actions { } } labels { } trigger OnPostReport() var IsHandled: Boolean; begin IsHandled := false; OnBeforeOnPostReport(FileName, ToFileNameTxt, HideFileDialog, IsHandled); if IsHandled then exit; if not HideFileDialog then begin FileManagement.DownloadHandler(FileName, '', '', FileManagement.GetToFilterText('', FileName), ToFileNameTxt); FileManagement.DeleteServerFile(FileName); end end; trigger OnPreReport() begin FileName := FileManagement.ServerTempFileName('txt'); end; var CompanyInfo: Record "Company Information"; Country: Record "Country/Region"; Cust: Record Customer; GeneralLedgerSetup: Record "General Ledger Setup"; FileManagement: Codeunit "File Management"; VATFile: File; TotalValueofServiceSuppliesTot: Decimal; TotalValueofItemSuppliesTotal: Decimal; EU3PartyServiceTradeAmt: Decimal; EU3PartyItemTradeAmt: Decimal; EU3PartyItemTradeTotalAmt: Decimal; EU3PartyServiceTradeTotalAmt: Decimal; NoOfGrTotal: Integer; FileName: Text; VATRegNo: Code[20]; InternalReferenceNo: Text[10]; Period: Date; UseAmtsInAddCurr: Boolean; ToFileNameTxt: Label 'Default.txt'; HideFileDialog: Boolean;#pragma warning disable AA0074 Text001: Label 'WwWw'; Text002: Label 'LIST';#pragma warning disable AA0470 Text003: Label '%1 was not filled in for all VAT entries in which %2 = %3.'; Text004: Label 'It is not possible to display %1 in a field with a length of %2.';#pragma warning restore AA0470#pragma warning restore AA0074 local procedure DecimalNumeralSign(DecimalNumeral: Decimal): Text[1] begin if DecimalNumeral >= 0 then exit('+'); exit('-'); end; local procedure DecimalNumeralZeroFormat(DecimalNumeral: Decimal; Length: Integer): Text[250] begin exit(TextZeroFormat(DelChr(Format(Round(Abs(DecimalNumeral), 1, '<'), 0, 1)), Length)); end; local procedure TextZeroFormat(Text: Text[250]; Length: Integer): Text[250] begin if StrLen(Text) > Length then Error( Text004, Text, Length); exit(PadStr('', Length - StrLen(Text), '0') + Text); end; local procedure WriteGrTotalsToFile(TotalValueofServiceSupplies: Decimal; TotalValueofItemSupplies: Decimal; EU3PartyServiceTradeAmt: Decimal; EU3PartyItemTradeAmt: Decimal; VATDate: Date) begin if (Round(Abs(TotalValueofItemSupplies), 1, '<') <> 0) or (Round(Abs(TotalValueofServiceSupplies), 1, '<') <> 0) or (Round(Abs(EU3PartyItemTradeAmt), 1, '<') <> 0) or (Round(Abs(EU3PartyServiceTradeAmt), 1, '<') <> 0) then begin if "VAT Entry"."VAT Registration No." = '' then begin "VAT Entry".Type := "VAT Entry".Type::Sale; Error( Text003, "VAT Entry".FieldCaption("VAT Registration No."), "VAT Entry".FieldCaption(Type), "VAT Entry".Type); end; Cust.Get(GetCustomerNoToCheck("VAT Entry")); Cust.TestField("Country/Region Code"); Country.Get(Cust."Country/Region Code"); Cust.TestField("VAT Registration No."); Country.Get("VAT Entry"."Country/Region Code"); Country.TestField("EU Country/Region Code"); NoOfGrTotal := NoOfGrTotal + 1; InternalReferenceNo := IncStr(InternalReferenceNo); ModifyVATEntryInternalRefNo("VAT Entry"."Country/Region Code", "VAT Entry"."Bill-to/Pay-to No.", InternalReferenceNo, VATDate); VATFile.Write( Format( '02' + Format(InternalReferenceNo, 10) + DecimalNumeralZeroFormat(Date2DMY(Period, 3) mod 100, 2) + DecimalNumeralZeroFormat(Date2DMY(Period, 2), 2) + DecimalNumeralZeroFormat(Date2DMY(Period, 1), 2) + Format(VATRegNo, 8) + Format(Country."EU Country/Region Code", 2) + Format("VAT Entry"."VAT Registration No.", 12) + DecimalNumeralZeroFormat(TotalValueofItemSupplies, 15) + DecimalNumeralSign(-TotalValueofItemSupplies) + '0' + DecimalNumeralZeroFormat(TotalValueofServiceSupplies, 15) + DecimalNumeralSign(-TotalValueofServiceSupplies) + '0' + DecimalNumeralZeroFormat(EU3PartyItemTradeAmt, 15) + DecimalNumeralSign(-EU3PartyItemTradeAmt) + '0' + DecimalNumeralZeroFormat(EU3PartyServiceTradeAmt, 15) + DecimalNumeralSign(-EU3PartyServiceTradeAmt), 120)); end; end; local procedure GetCustomerNoToCheck(VATEntry: Record "VAT Entry"): Code[20] var CustLedgerEntry: Record "Cust. Ledger Entry"; DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry"; begin if GeneralLedgerSetup."Bill-to/Sell-to VAT Calc." = GeneralLedgerSetup."Bill-to/Sell-to VAT Calc."::"Bill-to/Pay-to No." then exit(VATEntry."Bill-to/Pay-to No."); DetailedCustLedgEntry.SetRange("Customer No.", VATEntry."Bill-to/Pay-to No."); DetailedCustLedgEntry.SetRange("Document Type", VATEntry."Document Type"); DetailedCustLedgEntry.SetRange("Document No.", VATEntry."Document No."); DetailedCustLedgEntry.SetRange("Posting Date", VATEntry."Posting Date"); DetailedCustLedgEntry.FindFirst(); CustLedgerEntry.Get(DetailedCustLedgEntry."Cust. Ledger Entry No."); exit(CustLedgerEntry."Sell-to Customer No."); end; /// <summary> /// Returns the name of the generated VIES declaration file. /// Provides access to the filename for external processing or verification purposes. /// </summary> /// <returns>Complete filename with path for the generated VIES declaration file</returns> procedure GetFileName(): Text[1024] begin exit(FileName); end; /// <summary> /// Initializes VIES declaration report with file dialog visibility preferences. /// Configures whether to display file save dialog during report execution. /// </summary> /// <param name="NewHideFileDialog">True to suppress file dialog, false to show file selection dialog</param> procedure InitializeRequest(NewHideFileDialog: Boolean) begin HideFileDialog := NewHideFileDialog; end; local procedure ModifyVATEntryInternalRefNo(CountryRegionCode: Code[10]; BillToPayToNo: Code[20]; InternalRefNo: Text[30]; VATDate: Date) var VATEntry: Record "VAT Entry"; begin VATEntry.SetRange("Country/Region Code", CountryRegionCode); VATEntry.SetRange("Bill-to/Pay-to No.", BillToPayToNo); VATEntry.SetRange("VAT Reporting Date", VATDate); VATEntry.ModifyAll("Internal Ref. No.", InternalRefNo); end; /// <summary> /// Integration event raised before executing post-report file operations. /// Enables custom file handling and processing logic for VIES declaration output. /// </summary> /// <param name="FileName">Generated filename for VIES declaration file</param> /// <param name="ToFileNameTxt">Target filename text for file operations</param> /// <param name="HideFileDialog">Whether file dialog is hidden during processing</param> /// <param name="IsHandled">Set to true to skip standard post-report processing</param> [IntegrationEvent(false, false)] local procedure OnBeforeOnPostReport(var FileName: Text; ToFileNameTxt: Text; HideFileDialog: Boolean; var IsHandled: Boolean) begin end;}