Report 130 EC Sales List

Base Application, Microsoft.Finance.VAT.Reporting

src/Layers/W1/BaseApp/Finance/VAT/Reporting/ECSalesList.Report.al367 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;/// <summary>/// Generates European Community Sales List report for EU trade reporting requirements./// Provides detailed listing of sales to EU customers with VAT registration numbers and transaction values./// </summary>report 130 "EC Sales List"{    ApplicationArea = BasicEU;    Caption = 'EC Sales List';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Country/Region"; "Country/Region")        {            DataItemTableView = sorting("EU Country/Region Code") where("EU Country/Region Code" = filter(<> ''));            column(CompanyAddr1; CompanyAddr[1])            {            }            column(CompanyAddr2; CompanyAddr[2])            {            }            column(CompanyAddr3; CompanyAddr[3])            {            }            column(CompanyAddr4; CompanyAddr[4])            {            }            column(CompanyAddr5; CompanyAddr[5])            {            }            column(CompanyAddr6; CompanyAddr[6])            {            }            column(CompanyAddr7; CompanyAddr[7])            {            }            column(CompanyAddr8; CompanyAddr[8])            {            }            column(CompanyInfoPhoneNo; CompanyInfo."Phone No.")            {            }            column(CompanyInfoHomePage; CompanyInfo."Home Page")            {            }            column(CompanyInfoEMail; CompanyInfo."E-Mail")            {            }            column(CompanyInfoVATRegistrationNo; CompanyInfo."VAT Registration No.")            {            }            column(PageCaption; StrSubstNo(Text001, ''))            {            }            column(GLSetupLCYCode; StrSubstNo(Text000, GLSetup."LCY Code"))            {            }            column(VATEntryTableCaptionFilter; "VAT Entry".TableCaption + ': ' + VATEntryFilter)            {            }            column(VATEntryFilter; VATEntryFilter)            {            }            column(ThirdPartyTrade; ThirdPartyTrade)            {            }            column(NotEUTrdPartyAmtTotal; FormatNotEUTrdPartyAmt)            {            }            column(NotEUTrdPartyAmtServiceTotal; FormatNotEUTrdPartyAmtService)            {            }            column(FORMATTRUE; Format(true))            {            }            column(EUTrdPartyAmtTotal; FormatEUTrdPartyAmt)            {            }            column(EUTrdPartyAmtServiceTotal; FormatEUTrdPartyAmtService)            {            }            column(ECSalesListCaption; ECSalesListCaptionLbl)            {            }            column(CompanyInfoPhoneNoCaption; CompanyInfoPhoneNoCaptionLbl)            {            }            column(CompanyInfoHomePageCaption; CompanyInfoHomePageCaptionLbl)            {            }            column(CompanyInfoVATRegistrationNoCaption; CompanyInfoVATRegistrationNoCaptionLbl)            {            }            column(TotalValueofItemSuppliesCaption; TotalValueofItemSuppliesCaptionLbl)            {            }            column(EU3PartyTradeCaption; EU3PartyTradeCaptionLbl)            {            }            column(TotalValueofServiceSuppliesCaption; TotalValueofServiceSuppliesCaptionLbl)            {            }            column(EU3PartyItemTradeAmtCaption; EU3PartyItemTradeAmtCaptionLbl)            {            }            column(EUPartySrvcTradeAmtCaption; EUPartySrvcTradeAmtCaptionLbl)            {            }            column(NumberoflinesThispageCaption; NumberoflinesThispageCaptionLbl)            {            }            column(NumberoflinesAllpagesCaption; NumberoflinesAllpagesCaptionLbl)            {            }            column(CompanyInfoEMailCaption; CompanyInfoEMailCaptionLbl)            {            }            dataitem("VAT Entry"; "VAT Entry")            {                DataItemLink = "Country/Region Code" = field(Code);                DataItemTableView = sorting(Type, "Country/Region Code", "VAT Registration No.", "VAT Bus. Posting Group", "VAT Prod. Posting Group", "VAT Reporting Date") where(Type = const(Sale), "Country/Region Code" = filter(<> ''));                RequestFilterFields = "VAT Bus. Posting Group", "VAT Prod. Posting Group", "VAT Reporting Date";                column(VATRegNo_VATEntry; "VAT Registration No.")                {                }                column(VATRegNo_VATEntryCaption; FieldCaption("VAT Registration No."))                {                }                column(CountryRegionEUCountryRegionCode; "Country/Region"."EU Country/Region Code")                {                }                column(CountryRegionEUCountryRegionCodeCaption; "Country/Region".FieldCaption("EU Country/Region Code"))                {                }                column(NotEUTrdPartyAmt; NotEUTrdPartyAmt)                {                }                column(Grouping; Grouping)                {                    OptionCaption = 'NotEUTrdPartyAmt,NotEUTrdPartyAmtService,EUTrdPartyAmt,EUTrdPartyAmtService';                }                column(NotEUTrdPartyAmtService; NotEUTrdPartyAmtService)                {                }                column(EUTrdPartyAmt; EUTrdPartyAmt)                {                }                column(EUTrdPartyAmtService; EUTrdPartyAmtService)                {                }                trigger OnAfterGetRecord()                begin                    if ResetVATEntry then begin                        ResetVATEntry := false;                        EUTrdPartyAmtService := 0;                        NotEUTrdPartyAmtService := 0;                        EUTrdPartyAmt := 0;                        NotEUTrdPartyAmt := 0                    end;                    if "EU Service" then                        if "EU 3-Party Trade" then                            EUTrdPartyAmtService += Base                        else                            NotEUTrdPartyAmtService += Base                    else                        if "EU 3-Party Trade" then                            EUTrdPartyAmt += Base                        else                            NotEUTrdPartyAmt += Base;                    OnBeforeSetGrouping(ReportLayout, NotEUTrdPartyAmt, Grouping, NotEUTrdPartyAmtService, EUTrdPartyAmt, EUTrdPartyAmtService);                    if ReportLayout = ReportLayout::"Separate &Lines" then begin                        if NotEUTrdPartyAmt <> 0 then                            Grouping := Grouping::NotEUTrdPartyAmt;                        if NotEUTrdPartyAmtService <> 0 then                            Grouping := Grouping::NotEUTrdPartyAmtService;                        if EUTrdPartyAmt <> 0 then                            Grouping := Grouping::EUTrdPartyAmt;                        if EUTrdPartyAmtService <> 0 then                            Grouping := Grouping::EUTrdPartyAmtService                    end;                    if not (VATEntry.Next() = 0) then begin                        if VATEntry."VAT Registration No." = "VAT Registration No." then                            if ReportLayout = ReportLayout::"Separate &Lines" then begin                                if (VATEntry."EU Service" = "EU Service") and (VATEntry."EU 3-Party Trade" = "EU 3-Party Trade") then                                    CurrReport.Skip()                            end else                                CurrReport.Skip();                        ResetVATEntry := true;                        OnAfterVATEntryNext(ResetVATEntry, "VAT Entry");                    end;                    TotalEUTrdPartyAmtService += Round(EUTrdPartyAmtService, 1);                    TotalNotEUTrdPartyAmtService += Round(NotEUTrdPartyAmtService, 1);                    TotalEUTrdPartyAmt += Round(EUTrdPartyAmt, 1);                    TotalNotEUTrdPartyAmt += Round(NotEUTrdPartyAmt, 1);                    FormatEUTrdPartyAmtService := FormatAmt(TotalEUTrdPartyAmtService);                    FormatNotEUTrdPartyAmtService := FormatAmt(TotalNotEUTrdPartyAmtService);                    FormatEUTrdPartyAmt := FormatAmt(TotalEUTrdPartyAmt);                    FormatNotEUTrdPartyAmt := FormatAmt(TotalNotEUTrdPartyAmt);                end;                trigger OnPreDataItem()                begin                    ResetVATEntry := true;                    VATEntry.SetCurrentKey(                      Type, "Country/Region Code", "VAT Registration No.", "VAT Bus. Posting Group", "VAT Prod. Posting Group", "VAT Reporting Date");                    VATEntry.CopyFilters("VAT Entry");                    if VATEntry.FindSet() then;                end;            }            trigger OnPreDataItem()            begin                CompanyInfo.Get();                FormatAddr.Company(CompanyAddr, CompanyInfo);                ThirdPartyTrade := (ReportLayout = ReportLayout::"Separate &Lines");            end;        }    }    requestpage    {        AboutTitle = 'About EC Sales List';        AboutText = 'The **EC Sales List** report summarizes sales of goods and services to VAT-registered customers in other EU countries for tax reporting. Use it for preparing and submitting EC Sales declarations to EU tax authorities, ensuring compliance with intra-EU VAT reporting requirements.';        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(ReportLayout; ReportLayout)                    {                        ApplicationArea = BasicEU;                        Caption = 'Print Third Party Trade as';                        OptionCaption = 'Separate Lines,Column with Amount';                        ToolTip = 'Specifies if you want the report to show third party trade as a separate line for each customer or as an additional column.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Finance/VAT/Reporting/ECSalesList.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        CompanyInfo.Get();        FormatAddr.Company(CompanyAddr, CompanyInfo);        VATEntryFilter := "VAT Entry".GetFilters();        GLSetup.Get();    end;    var        GLSetup: Record "General Ledger Setup";        CompanyInfo: Record "Company Information";        VATEntry: Record "VAT Entry";        FormatAddr: Codeunit "Format Address";        VATEntryFilter: Text;        CompanyAddr: array[8] of Text[100];        EUTrdPartyAmt: Decimal;        NotEUTrdPartyAmt: Decimal;        EUTrdPartyAmtService: Decimal;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'All amounts are in whole %1.';#pragma warning restore AA0470#pragma warning restore AA0074        NotEUTrdPartyAmtService: Decimal;        ReportLayout: Option "Separate &Lines","Column with &Amount";#pragma warning disable AA0074#pragma warning disable AA0470        Text001: Label 'Page %1';#pragma warning restore AA0470#pragma warning restore AA0074        ThirdPartyTrade: Boolean;        ResetVATEntry: Boolean;        Grouping: Option NotEUTrdPartyAmt,NotEUTrdPartyAmtService,EUTrdPartyAmt,EUTrdPartyAmtService;        TotalNotEUTrdPartyAmt: Decimal;        TotalEUTrdPartyAmt: Decimal;        TotalNotEUTrdPartyAmtService: Decimal;        TotalEUTrdPartyAmtService: Decimal;        FormatNotEUTrdPartyAmt: Text[30];        FormatEUTrdPartyAmt: Text[30];        FormatNotEUTrdPartyAmtService: Text[30];        FormatEUTrdPartyAmtService: Text[30];        ECSalesListCaptionLbl: Label 'EC Sales List';        CompanyInfoPhoneNoCaptionLbl: Label 'Phone No.';        CompanyInfoHomePageCaptionLbl: Label 'Home Page';        CompanyInfoVATRegistrationNoCaptionLbl: Label 'VAT Registration No.';        TotalValueofItemSuppliesCaptionLbl: Label 'Total Value of Item Supplies';        EU3PartyTradeCaptionLbl: Label 'EU 3-Party Trade';        TotalValueofServiceSuppliesCaptionLbl: Label 'Total Value of Service Supplies';        EU3PartyItemTradeAmtCaptionLbl: Label 'EU 3-Party Item Trade Amount';        EUPartySrvcTradeAmtCaptionLbl: Label 'EU 3-Party Service Trade Amount';        NumberoflinesThispageCaptionLbl: Label 'Number of lines (this page)';        NumberoflinesAllpagesCaptionLbl: Label 'Number of lines (all pages)';        CompanyInfoEMailCaptionLbl: Label 'Email';    local procedure FormatAmt(AmountToPrint: Decimal): Text[30]    var        TextAmt: Text[30];    begin        TextAmt := Format(Round(-AmountToPrint, 1), 0, '<Integer Thousand><Decimals>');        if AmountToPrint > 0 then            TextAmt := '(' + TextAmt + ')';        exit(TextAmt);    end;    /// <summary>    /// Initializes report layout option for EU sales list generation.    /// Configures report format and display preferences.    /// </summary>    /// <param name="NewReportLayout">Report layout option to apply</param>    procedure InitializeRequest(NewReportLayout: Option)    begin        ReportLayout := NewReportLayout;    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeSetGrouping(ReportLayout: Option "Separate &Lines","Column with &Amount"; NotEUTrdPartyAmt: Decimal; Grouping: Option NotEUTrdPartyAmt,NotEUTrdPartyAmtService,EUTrdPartyAmt,EUTrdPartyAmtService; NotEUTrdPartyAmtService: Decimal; EUTrdPartyAmt: Decimal; EUTrdPartyAmtService: Decimal)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAfterVATEntryNext(ResetVATEntry: Boolean; "VAT Entry": Record "VAT Entry")    begin    end;}