Codeunit 140 EC Sales List Suggest Lines

Base Application, Microsoft.Finance.VAT.Reporting

src/Layers/W1/BaseApp/Finance/VAT/Reporting/ECSalesListSuggestLines.Codeunit.al179 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.Foundation.Company;using System.Utilities;/// <summary>/// Generates ECSL (European Community Sales List) report lines by analyzing VAT entries for EU transactions./// Creates summarized lines by customer VAT registration number and transaction type for EU trade reporting./// </summary>codeunit 140 "EC Sales List Suggest Lines"{    TableNo = "VAT Report Header";    trigger OnRun()    var        ECSLVATReportLine: Record "ECSL VAT Report Line";    begin        ErrorMessage.SetContext(Rec);        ErrorMessage.ClearLog();        if not Rec.IsPeriodValid() then begin            ErrorMessage.LogMessage(Rec, Rec.FieldNo("No."), ErrorMessage."Message Type"::Error, InvalidPeriodErr);            exit;        end;        VATReportHeader := Rec;        ECSLVATReportLine.ClearLines(Rec);        PopulateVatEntryLines();    end;    var        VATReportHeader: Record "VAT Report Header";        ErrorMessage: Record "Error Message";        InvalidPeriodErr: Label 'The period is not valid.';    local procedure PopulateVatEntryLines()    var        CompanyInformation: Record "Company Information";        EUVATEntries: Query "EU VAT Entries";    begin        CompanyInformation.Get();        EUVATEntries.SetRange(VATReportingDate, VATReportHeader."Start Date", VATReportHeader."End Date");        EUVATEntries.SetFilter(CountryCode, '<>%1', CompanyInformation."Country/Region Code");        OnPopulateVatEntryLinesOnAfterEUVATEntriesSetFilters(VATReportHeader, EUVATEntries);        EUVATEntries.Open();        while EUVATEntries.Read() do            AddOrUpdateECLLine(EUVATEntries);        RowsTotalCorrection();        DeleteZeroAmountLines();    end;    local procedure GetECLLine(var ECSLVATReportLine: Record "ECSL VAT Report Line"; EUVATEntries: Query "EU VAT Entries")    var        LastId: Integer;        TrnIndicator: Integer;    begin        ECSLVATReportLine.SetRange("Report No.", VATReportHeader."No.");        ECSLVATReportLine.SetRange("Country Code", EUVATEntries.CountryCode);        ECSLVATReportLine.SetRange("Customer VAT Reg. No.", EUVATEntries.VAT_Registration_No);        TrnIndicator := GetIndicatorCode(EUVATEntries.EU_3_Party_Trade, EUVATEntries.EU_Service);        ECSLVATReportLine.SetRange("Transaction Indicator", TrnIndicator);        if not ECSLVATReportLine.FindFirst() then begin            ECSLVATReportLine.Reset();            ECSLVATReportLine.SetRange("Report No.", VATReportHeader."No.");            if ECSLVATReportLine.FindLast() then                LastId := ECSLVATReportLine."Line No.";            ECSLVATReportLine.Init();            ECSLVATReportLine."Line No." := LastId + 1;            ECSLVATReportLine.Validate("Report No.", VATReportHeader."No.");            ECSLVATReportLine.Validate("Country Code", EUVATEntries.CountryCode);            ECSLVATReportLine.Validate("Customer VAT Reg. No.", EUVATEntries.VAT_Registration_No);            ECSLVATReportLine.Validate("Transaction Indicator", TrnIndicator);            ECSLVATReportLine.Insert();        end;    end;    local procedure AddOrUpdateECLLine(EUVATEntries: Query "EU VAT Entries")    var        ECSLVATReportLine: Record "ECSL VAT Report Line";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeAddOrUpdateECLLine(EUVATEntries, ECSLVATReportLine, IsHandled);        if IsHandled then            exit;        GetECLLine(ECSLVATReportLine, EUVATEntries);        ECSLVATReportLine."Total Value Of Supplies" += EUVATEntries.Base;        AddToRepLineRelation(EUVATEntries, ECSLVATReportLine);        ECSLVATReportLine.Modify(true);    end;    local procedure GetIndicatorCode(EU3rdPartyTrade: Boolean; EUService: Boolean): Integer    begin        if EUService then            exit(3);        if EU3rdPartyTrade then            exit(2);        exit(0);    end;    local procedure AddToRepLineRelation(EUVATEntries: Query "EU VAT Entries"; ECSLVATReportLine: Record "ECSL VAT Report Line")    var        ECSLVATReportLineRelation: Record "ECSL VAT Report Line Relation";    begin        ECSLVATReportLineRelation.Validate("ECSL Report No.", VATReportHeader."No.");        ECSLVATReportLineRelation.Validate("ECSL Line No.", ECSLVATReportLine."Line No.");        ECSLVATReportLineRelation.Validate("VAT Entry No.", EUVATEntries.Entry_No);        ECSLVATReportLineRelation.Insert(true);    end;    local procedure RowsTotalCorrection()    var        ECSLVATReportLine: Record "ECSL VAT Report Line";    begin        ECSLVATReportLine.SetRange("Report No.", VATReportHeader."No.");        if not ECSLVATReportLine.FindSet() then            exit;        repeat            ECSLVATReportLine."Total Value Of Supplies" := -Round(ECSLVATReportLine."Total Value Of Supplies", 1);            ECSLVATReportLine.Modify(true);        until ECSLVATReportLine.Next() = 0;    end;    local procedure DeleteZeroAmountLines()    var        ECSLVATReportLine: Record "ECSL VAT Report Line";        ECSLVATReportLineRelation: Record "ECSL VAT Report Line Relation";    begin        ECSLVATReportLineRelation.SetRange("ECSL Report No.", ECSLVATReportLine."Report No.");        ECSLVATReportLine.SetRange("Report No.", VATReportHeader."No.");        ECSLVATReportLine.SetRange("Total Value Of Supplies", 0);        if not ECSLVATReportLine.FindSet() then            exit;        repeat            ECSLVATReportLineRelation.SetRange("ECSL Line No.", ECSLVATReportLine."Line No.");            ECSLVATReportLineRelation.DeleteAll();        until ECSLVATReportLine.Next() = 0;        ECSLVATReportLine.DeleteAll();    end;    /// <summary>    /// Integration event raised before adding or updating an ECSL line during line suggestion.    /// Allows customization of ECSL line creation logic and data population.    /// </summary>    /// <param name="EUVATEntries">Query record containing EU VAT entry data</param>    /// <param name="ECSLVATReportLine">ECSL report line being processed</param>    /// <param name="IsHandled">Set to true to skip standard processing</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeAddOrUpdateECLLine(EUVATEntries: Query "EU VAT Entries"; var ECSLVATReportLine: Record "ECSL VAT Report Line"; var IsHandled: Boolean)    begin    end;    /// <summary>    /// Integration event raised after setting filters on EU VAT entries query during line population.    /// Allows additional filtering or modification of VAT entry selection criteria.    /// </summary>    /// <param name="VATReportHeader">VAT report header containing period and configuration information</param>    /// <param name="EUVATEntries">EU VAT entries query with filters applied</param>    [IntegrationEvent(false, false)]    local procedure OnPopulateVatEntryLinesOnAfterEUVATEntriesSetFilters(var VATReportHeader: Record "VAT Report Header"; var EUVATEntries: Query "EU VAT Entries")    begin    end;}