Report 6222 EUDR Sales Invoice

Sustainability, Microsoft.Sustainability.EUDR

src/Apps/W1/Sustainability/app/src/EUDR/EUDRSalesInvoice.Report.al1,919 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.Sustainability.EUDR;using Microsoft.Assembly.History;using Microsoft.Bank.BankAccount;using Microsoft.Bank.Setup;using Microsoft.CRM.Contact;using Microsoft.CRM.Interaction;using Microsoft.CRM.Segment;using Microsoft.CRM.Team;using Microsoft.Finance.Currency;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Calculation;using Microsoft.Finance.VAT.Clause;using Microsoft.Foundation.Address;using Microsoft.Foundation.Company;using Microsoft.Foundation.PaymentTerms;using Microsoft.Foundation.Reporting;using Microsoft.Foundation.Shipping;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;using Microsoft.Inventory.Tracking;using Microsoft.Projects.Project.Job;using Microsoft.Sales.Customer;using Microsoft.Sales.History;using Microsoft.Sales.Receivables;using Microsoft.Sales.Reminder;using Microsoft.Sales.Setup;using Microsoft.Utilities;using System.Email;using System.Globalization;using System.Reflection;using System.Text;using System.Utilities;/// <summary>/// Generates a standard format printable document for posted sales invoices with EUDR lot certification details./// </summary>report 6222 "EUDR Sales Invoice"{    Caption = 'EUDR Sales Invoice';    EnableHyperlinks = true;    Permissions = TableData "Sales Shipment Buffer" = rimd;    PreviewMode = PrintLayout;    WordMergeDataItem = Header;    DefaultRenderingLayout = "EUDRSalesInvoice.rdlc";    dataset    {        dataitem(Header; "Sales Invoice Header")        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.", "Sell-to Customer No.", "No. Printed";            RequestFilterHeading = 'Posted Sales Invoice';            column(CompanyAddress1; CompanyAddr[1])            {            }            column(CompanyAddress2; CompanyAddr[2])            {            }            column(CompanyAddress3; CompanyAddr[3])            {            }            column(CompanyAddress4; CompanyAddr[4])            {            }            column(CompanyAddress5; CompanyAddr[5])            {            }            column(CompanyAddress6; CompanyAddr[6])            {            }            column(CompanyAddress7; CompanyAddr[7])            {            }            column(CompanyAddress8; CompanyAddr[8])            {            }            column(CompanyHomePage; CompanyInfo."Home Page")            {            }            column(CompanyEMail; CompanyInfo."E-Mail")            {            }            column(CompanyPicture; DummyCompanyInfo.Picture)            {            }            column(CompanyPhoneNo; CompanyInfo."Phone No.")            {            }            column(CompanyPhoneNo_Lbl; CompanyInfoPhoneNoLbl)            {            }            column(CompanyGiroNo; CompanyInfo."Giro No.")            {            }            column(CompanyGiroNo_Lbl; CompanyInfoGiroNoLbl)            {            }            column(CompanyBankName; CompanyBankAccount.Name)            {            }            column(CompanyBankName_Lbl; CompanyInfoBankNameLbl)            {            }            column(CompanyBankBranchNo; CompanyBankAccount."Bank Branch No.")            {            }            column(CompanyBankBranchNo_Lbl; CompanyBankAccount.FieldCaption("Bank Branch No."))            {            }            column(CompanyBankAccountNo; CompanyBankAccount."Bank Account No.")            {            }            column(CompanyBankAccountNo_Lbl; CompanyInfoBankAccNoLbl)            {            }            column(CompanyIBAN; CompanyBankAccount.IBAN)            {            }            column(CompanyIBAN_Lbl; CompanyBankAccount.FieldCaption(IBAN))            {            }            column(CompanySWIFT; CompanyBankAccount."SWIFT Code")            {            }            column(CompanySWIFT_Lbl; CompanyBankAccount.FieldCaption("SWIFT Code"))            {            }            column(CompanyLogoPosition; CompanyLogoPosition)            {            }            column(CompanyRegistrationNumber; CompanyInfo.GetRegistrationNumber())            {            }            column(CompanyRegistrationNumber_Lbl; CompanyInfo.GetRegistrationNumberLbl())            {            }            column(CompanyVATRegNo; CompanyInfo.GetVATRegistrationNumber())            {            }            column(CompanyVATRegNo_Lbl; CompanyInfo.GetVATRegistrationNumberLbl())            {            }            column(CompanyVATRegistrationNo; CompanyInfo.GetVATRegistrationNumber())            {            }            column(CompanyVATRegistrationNo_Lbl; CompanyInfo.GetVATRegistrationNumberLbl())            {            }            column(CompanyLegalOffice; LegalOfficeTxt)            {            }            column(CompanyLegalOffice_Lbl; LegalOfficeLbl)            {            }            column(CompanyCustomGiro; CustomGiroTxt)            {            }            column(CompanyCustomGiro_Lbl; CustomGiroLbl)            {            }            column(CompanyLegalStatement; LegalStatementLbl)            {            }            column(DisplayAdditionalFeeNote; DisplayAdditionalFeeNoteVal)            {            }            column(EUDRSalesInvoice_Lbl; EUDRSalesInvoiceLbl)            {            }            column(PostingDate; Format("Posting Date"))            {            }            column(PostingDate_Lbl; FieldCaption("Posting Date"))            {            }            column(BillToName; "Bill-to Name")            {            }            column(BillToName_Lbl; FieldCaption("Bill-to Name"))            {            }            column(CustomerAddress1; CustAddr[1])            {            }            column(CustomerAddress2; CustAddr[2])            {            }            column(CustomerAddress3; CustAddr[3])            {            }            column(CustomerAddress4; CustAddr[4])            {            }            column(CustomerAddress5; CustAddr[5])            {            }            column(CustomerAddress6; CustAddr[6])            {            }            column(CustomerAddress7; CustAddr[7])            {            }            column(CustomerAddress8; CustAddr[8])            {            }            column(CustomerPostalBarCode; FormatAddr.PostalBarCode(1))            {            }            column(YourReference; "Your Reference")            {            }            column(YourReference_Lbl; FieldCaption("Your Reference"))            {            }            column(ShipmentMethodDescription; ShipmentMethod.Description)            {            }            column(ShipmentMethodDescription_Lbl; ShptMethodDescLbl)            {            }            column(ShipmentDate; Format("Shipment Date", 0, 4))            {            }            column(ShipmentDate_Lbl; FieldCaption("Shipment Date"))            {            }            column(Shipment_Lbl; ShipmentLbl)            {            }            column(ShowShippingAddress; ShowShippingAddr)            {            }            column(ShipToAddress_Lbl; ShiptoAddrLbl)            {            }            column(ShipToAddress1; ShipToAddr[1])            {            }            column(ShipToAddress2; ShipToAddr[2])            {            }            column(ShipToAddress3; ShipToAddr[3])            {            }            column(ShipToAddress4; ShipToAddr[4])            {            }            column(ShipToAddress5; ShipToAddr[5])            {            }            column(ShipToAddress6; ShipToAddr[6])            {            }            column(ShipToAddress7; ShipToAddr[7])            {            }            column(ShipToAddress8; ShipToAddr[8])            {            }            column(ShipToPhoneNo; Header."Ship-to Phone No.")            {            }            column(SellToContactPhoneNoLbl; SellToContactPhoneNoLbl)            {            }            column(SellToContactMobilePhoneNoLbl; SellToContactMobilePhoneNoLbl)            {            }            column(SellToContactEmailLbl; SellToContactEmailLbl)            {            }            column(BillToContactPhoneNoLbl; BillToContactPhoneNoLbl)            {            }            column(BillToContactMobilePhoneNoLbl; BillToContactMobilePhoneNoLbl)            {            }            column(BillToContactEmailLbl; BillToContactEmailLbl)            {            }            column(SellToContactPhoneNo; SellToContact."Phone No.")            {            }            column(SellToContactMobilePhoneNo; SellToContact."Mobile Phone No.")            {            }            column(SellToContactEmail; SellToContact."E-Mail")            {            }            column(BillToContactPhoneNo; BillToContact."Phone No.")            {            }            column(BillToContactMobilePhoneNo; BillToContact."Mobile Phone No.")            {            }            column(BillToContactEmail; BillToContact."E-Mail")            {            }            column(PaymentTermsDescription; PaymentTerms.Description)            {            }            column(PaymentTermsDescription_Lbl; PaymentTermsDescLbl)            {            }            column(PaymentMethodDescription; PaymentMethod.Description)            {            }            column(PaymentMethodDescription_Lbl; PaymentMethodDescLbl)            {            }            column(BilltoCustumerNo; "Bill-to Customer No.")            {            }            column(BilltoCustomerNo_Lbl; FieldCaption("Bill-to Customer No."))            {            }            column(DocumentDate; Format("Document Date", 0, 4))            {            }            column(DocumentDate_Lbl; FieldCaption("Document Date"))            {            }            column(DueDate; Format("Due Date", 0, 4))            {            }            column(DueDate_Lbl; FieldCaption("Due Date"))            {            }            column(DocumentNo; "No.")            {            }            column(DocumentNo_Lbl; InvNoLbl)            {            }            column(OrderNo; "Order No.")            {            }            column(OrderNo_Lbl; FieldCaption("Order No."))            {            }            column(PricesIncludingVAT; "Prices Including VAT")            {            }            column(PricesIncludingVAT_Lbl; FieldCaption("Prices Including VAT"))            {            }            column(PricesIncludingVATYesNo; Format("Prices Including VAT"))            {            }            column(SalesPerson_Lbl; SalespersonLbl)            {            }            column(SalesPersonBlank_Lbl; SalesPersonText)            {            }            column(SalesPersonName; SalespersonPurchaser.Name)            {            }            column(SelltoCustomerNo; "Sell-to Customer No.")            {            }            column(SelltoCustomerNo_Lbl; FieldCaption("Sell-to Customer No."))            {            }            column(VATRegistrationNo; GetCustomerVATRegistrationNumber())            {            }            column(VATRegistrationNo_Lbl; GetCustomerVATRegistrationNumberLbl())            {            }            column(GlobalLocationNumber; GetCustomerGlobalLocationNumber())            {            }            column(GlobalLocationNumber_Lbl; GetCustomerGlobalLocationNumberLbl())            {            }            column(SellToFaxNo; GetSellToCustomerFaxNo())            {            }            column(SellToPhoneNo; "Sell-to Phone No.")            {            }            column(PaymentReference; GetPaymentReference())            {            }            column(From_Lbl; FromLbl)            {            }            column(BilledTo_Lbl; BilledToLbl)            {            }            column(ChecksPayable_Lbl; ChecksPayableText)            {            }            column(PaymentReference_Lbl; GetPaymentReferenceLbl())            {            }            column(LegalEntityType; Cust.GetLegalEntityType())            {            }            column(LegalEntityType_Lbl; Cust.GetLegalEntityTypeLbl())            {            }            column(Copy_Lbl; CopyLbl)            {            }            column(EMail_Header_Lbl; EMailLbl)            {            }            column(HomePage_Header_Lbl; HomePageLbl)            {            }            column(InvoiceDiscountBaseAmount_Lbl; InvDiscBaseAmtLbl)            {            }            column(InvoiceDiscountAmount_Lbl; InvDiscountAmtLbl)            {            }            column(LineAmountAfterInvoiceDiscount_Lbl; LineAmtAfterInvDiscLbl)            {            }            column(LocalCurrency_Lbl; LocalCurrencyLbl)            {            }            column(ExchangeRateAsText; ExchangeRateText)            {            }            column(Page_Lbl; PageLbl)            {            }            column(SalesInvoiceLineDiscount_Lbl; SalesInvLineDiscLbl)            {            }            column(Questions_Lbl; QuestionsLbl)            {            }            column(Contact_Lbl; CompanyInfo.GetContactUsText())            {            }            column(DocumentTitle_Lbl; DocumentCaption())            {            }            column(YourDocumentTitle_Lbl; YourSalesInvoiceLbl)            {            }            column(Thanks_Lbl; ThanksLbl)            {            }            column(ShowWorkDescription; ShowWorkDescription)            {            }            column(RemainingAmount; RemainingAmount)            {            }            column(RemainingAmountText; RemainingAmountTxt)            {            }            column(Subtotal_Lbl; SubtotalLbl)            {            }            column(Total_Lbl; TotalLbl)            {            }            column(VATAmount_Lbl; VATAmtLbl)            {            }            column(VATBase_Lbl; VATBaseLbl)            {            }            column(VATAmountSpecification_Lbl; VATAmtSpecificationLbl)            {            }            column(VATClauses_Lbl; VATClausesLbl)            {            }            column(VATIdentifier_Lbl; VATIdentifierLbl)            {            }            column(VATPercentage_Lbl; VATPercentageLbl)            {            }            column(VATClause_Lbl; VATClause.TableCaption())            {            }            column(PackageTrackingNo; "Package Tracking No.")            {            }            column(PackageTrackingNo_Lbl; FieldCaption("Package Tracking No."))            {            }            column(ShippingAgentCode; "Shipping Agent Code")            {            }            column(ShippingAgentCode_Lbl; FieldCaption("Shipping Agent Code"))            {            }            column(PaymentInstructions_Txt; PaymentInstructionsTxt)            {            }            column(ExternalDocumentNo; "External Document No.")            {            }            column(ExternalDocumentNo_Lbl; FieldCaption("External Document No."))            {            }            dataitem(Line; "Sales Invoice Line")            {                DataItemLink = "Document No." = field("No.");                DataItemLinkReference = Header;                DataItemTableView = sorting("Document No.", "Line No.");                column(LineNo_Line; "Line No.")                {                }                column(AmountExcludingVAT_Line; Amount)                {                    AutoFormatExpression = GetCurrencyCode();                    AutoFormatType = 1;                }                column(AmountExcludingVAT_Line_Lbl; FieldCaption(Amount))                {                }                column(AmountIncludingVAT_Line; "Amount Including VAT")                {                    AutoFormatExpression = GetCurrencyCode();                    AutoFormatType = 1;                }                column(AmountIncludingVAT_Line_Lbl; FieldCaption("Amount Including VAT"))                {                    AutoFormatExpression = GetCurrencyCode();                    AutoFormatType = 1;                }                column(Description_Line; Description)                {                }                column(Description_Line_Lbl; FieldCaption(Description))                {                }                column(LineDiscountPercent_Line; "Line Discount %")                {                }                column(LineDiscountPercentText_Line; LineDiscountPctText)                {                }                column(LineAmount_Line; FormattedLineAmount)                {                    AutoFormatExpression = GetCurrencyCode();                    AutoFormatType = 1;                }                column(LineAmount_Line_Lbl; FieldCaption("Line Amount"))                {                }                column(ItemNo_Line; "No.")                {                }                column(ItemNo_Line_Lbl; FieldCaption("No."))                {                }                column(ItemReferenceNo_Line; "Item Reference No.")                {                }                column(ItemReferenceNo_Line_Lbl; FieldCaption("Item Reference No."))                {                }                column(ShipmentDate_Line; Format("Shipment Date"))                {                }                column(ShipmentDate_Line_Lbl; PostedShipmentDateLbl)                {                }                column(Quantity_Line; FormattedQuantity)                {                }                column(Quantity_Line_Lbl; FieldCaption(Quantity))                {                }                column(Type_Line; Format(Type))                {                }                column(UnitPrice; FormattedUnitPrice)                {                    AutoFormatExpression = GetCurrencyCode();                    AutoFormatType = 2;                }                column(UnitPrice_Lbl; FieldCaption("Unit Price"))                {                }                column(UnitOfMeasure; "Unit of Measure")                {                }                column(UnitOfMeasure_Lbl; FieldCaption("Unit of Measure"))                {                }                column(VATIdentifier_Line; "VAT Identifier")                {                }                column(VATIdentifier_Line_Lbl; FieldCaption("VAT Identifier"))                {                }                column(VATPct_Line; FormattedVATPct)                {                }                column(VATPct_Line_Lbl; FieldCaption("VAT %"))                {                }                column(TransHeaderAmount; TransHeaderAmount)                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(JobTaskNo_Lbl; JobTaskNoLbl)                {                }                column(JobTaskNo; JobTaskNo)                {                }                column(JobTaskDescription; JobTaskDescription)                {                }                column(JobTaskDesc_Lbl; JobTaskDescLbl)                {                }                column(JobNo_Lbl; JobNoLbl)                {                }                column(JobNo; JobNo)                {                }                column(Unit_Lbl; UnitLbl)                {                }                column(Qty_Lbl; QtyLbl)                {                }                column(Price_Lbl; PriceLbl)                {                }                column(PricePer_Lbl; PricePerLbl)                {                }                dataitem(ShipmentLine; "Sales Shipment Buffer")                {                    DataItemTableView = sorting("Document No.", "Line No.", "Entry No.");                    UseTemporary = true;                    column(DocumentNo_ShipmentLine; "Document No.")                    {                    }                    column(PostingDate_ShipmentLine; Format("Posting Date"))                    {                    }                    column(PostingDate_ShipmentLine_Lbl; FieldCaption("Posting Date"))                    {                    }                    column(Quantity_ShipmentLine; Quantity)                    {                        DecimalPlaces = 0 : 5;                    }                    column(Quantity_ShipmentLine_Lbl; FieldCaption(Quantity))                    {                    }                    trigger OnPreDataItem()                    begin                        if not DisplayShipmentInformation then                            CurrReport.Break();                        SetRange("Line No.", Line."Line No.");                    end;                }                dataitem(AssemblyLine; "Posted Assembly Line")                {                    DataItemTableView = sorting("Document No.", "Line No.");                    UseTemporary = true;                    column(LineNo_AssemblyLine; "No.")                    {                    }                    column(Description_AssemblyLine; Description)                    {                    }                    column(Quantity_AssemblyLine; Quantity)                    {                        DecimalPlaces = 0 : 5;                    }                    column(UnitOfMeasure_AssemblyLine; GetUOMText("Unit of Measure Code"))                    {                    }                    column(VariantCode_AssemblyLine; "Variant Code")                    {                    }                    trigger OnPreDataItem()                    var                        ValueEntry: Record "Value Entry";                    begin                        Clear(AssemblyLine);                        if not DisplayAssemblyInformation then                            CurrReport.Break();                        GetAssemblyLinesForDocument(                          AssemblyLine, ValueEntry."Document Type"::"Sales Invoice", Line."Document No.", Line."Line No.");                    end;                }                dataitem(EUDRLot; "Lot No. Information")                {                    DataItemTableView = sorting("Item No.", "Variant Code", "Lot No.");                    UseTemporary = true;                    column(LotNo_EUDRLot; "Lot No.")                    {                    }                    column(LotNo_EUDRLot_Lbl; FieldCaption("Lot No."))                    {                    }                    column(LotQuantity_EUDRLot; GetEUDRLotQuantity(Line, EUDRLot))                    {                    }                    column(LotQuantity_EUDRLot_Lbl; LotQuantityLbl)                    {                    }                    column(CertificationScheme_EUDRLot; "Certification Scheme")                    {                    }                    column(CertificationScheme_EUDRLot_Lbl; FieldCaption("Certification Scheme"))                    {                    }                    column(EUDRCertificateNo_EUDRLot; "EUDR Certificate No.")                    {                    }                    column(EUDRCertificateNo_EUDRLot_Lbl; FieldCaption("EUDR Certificate No."))                    {                    }                    trigger OnPreDataItem()                    begin                        LoadEUDRLotsForLine(Line);                    end;                }                trigger OnAfterGetRecord()                begin                    InitializeShipmentLine();                    if Type = Type::"G/L Account" then                        "No." := '';                    OnBeforeLineOnAfterGetRecord(Header, Line);                    if "Line Discount %" = 0 then                        LineDiscountPctText := ''                    else                        LineDiscountPctText := StrSubstNo('%1%', -Round("Line Discount %", 0.1));                    InsertVATAmountLine(VATAmountLine, Line);                    TransHeaderAmount += PrevLineAmount;                    PrevLineAmount := "Line Amount";                    TotalSubTotal += "Line Amount";                    TotalInvDiscAmount -= "Inv. Discount Amount";                    TotalAmount += Amount;                    TotalAmountVAT += "Amount Including VAT" - Amount;                    TotalAmountInclVAT += "Amount Including VAT";                    TotalPaymentDiscOnVAT += -("Line Amount" - "Inv. Discount Amount" - "Amount Including VAT");                    if FormatDocument.HideDocumentLine(HideLinesWithZeroQuantity, Line, FieldNo(Quantity)) then                        CurrReport.Skip();                    if FirstLineHasBeenOutput then                        Clear(DummyCompanyInfo.Picture);                    FirstLineHasBeenOutput := true;                    JobNo := "Job No.";                    JobTaskNo := "Job Task No.";                    if JobTaskNo <> '' then begin                        JobTaskNoLbl := ProjectTaskNoLbl;                        JobTaskDescription := GetJobTaskDescription(JobNo, JobTaskNo);                    end else begin                        JobTaskDescription := '';                        JobTaskNoLbl := '';                    end;                    if JobNo <> '' then                        JobNoLbl := ProjectNoLbl                    else                        JobNoLbl := '';                    FormatLineValues(Line);                end;                trigger OnPreDataItem()                begin                    VATAmountLine.DeleteAll();                    VATClauseLine.DeleteAll();                    ShipmentLine.Reset();                    ShipmentLine.DeleteAll();                    MoreLines := Find('+');                    while MoreLines and (Description = '') and ("No." = '') and (Quantity = 0) and (Amount = 0) do                        MoreLines := Next(-1) <> 0;                    if not MoreLines then                        CurrReport.Break();                    SetFilter("Line No.", '<=%1', "Line No.");                    TransHeaderAmount := 0;                    PrevLineAmount := 0;                    FirstLineHasBeenOutput := false;                    DummyCompanyInfo.Picture := CompanyInfo.Picture;                    OnAfterLineOnPreDataItem(Header, Line);                end;            }            dataitem(WorkDescriptionLines; "Integer")            {                DataItemTableView = sorting(Number) where(Number = filter(1 .. 99999));                column(WorkDescriptionLineNumber; Number)                {                }                column(WorkDescriptionLine; WorkDescriptionLine)                {                }                trigger OnAfterGetRecord()                var                    TypeHelper: Codeunit "Type Helper";                begin                    if WorkDescriptionInstream.EOS then                        CurrReport.Break();                    WorkDescriptionLine := TypeHelper.ReadAsTextWithSeparator(WorkDescriptionInstream, TypeHelper.LFSeparator());                    if WorkDescriptionLine = '' then                        CurrReport.Break();                end;                trigger OnPostDataItem()                begin                    Clear(WorkDescriptionInstream)                end;                trigger OnPreDataItem()                begin                    if not ShowWorkDescription then                        CurrReport.Break();                    Header."Work Description".CreateInStream(WorkDescriptionInstream, TEXTENCODING::UTF8);                end;            }            dataitem(VATAmountLine; "VAT Amount Line")            {                DataItemTableView = sorting("VAT Identifier", "VAT Calculation Type", "Tax Group Code", "Use Tax", Positive);                UseTemporary = true;                column(InvoiceDiscountAmount_VATAmountLine; "Invoice Discount Amount")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(InvoiceDiscountAmount_VATAmountLine_Lbl; FieldCaption("Invoice Discount Amount"))                {                }                column(InvoiceDiscountBaseAmount_VATAmountLine; "Inv. Disc. Base Amount")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(InvoiceDiscountBaseAmount_VATAmountLine_Lbl; FieldCaption("Inv. Disc. Base Amount"))                {                }                column(LineAmount_VatAmountLine; "Line Amount")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(LineAmount_VatAmountLine_Lbl; FieldCaption("Line Amount"))                {                }                column(VATAmount_VatAmountLine; "VAT Amount")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(VATAmount_VatAmountLine_Lbl; FieldCaption("VAT Amount"))                {                }                column(VATAmountLCY_VATAmountLine; VATAmountLCY)                {                }                column(VATAmountLCY_VATAmountLine_Lbl; VATAmountLCYLbl)                {                }                column(VATBase_VatAmountLine; "VAT Base")                {                    AutoFormatExpression = Line.GetCurrencyCode();                    AutoFormatType = 1;                }                column(VATBase_VatAmountLine_Lbl; FieldCaption("VAT Base"))                {                }                column(VATBaseLCY_VATAmountLine; VATBaseLCY)                {                }                column(VATBaseLCY_VATAmountLine_Lbl; VATBaseLCYLbl)                {                }                column(VATIdentifier_VatAmountLine; "VAT Identifier")                {                }                column(VATIdentifier_VatAmountLine_Lbl; FieldCaption("VAT Identifier"))                {                }                column(VATPct_VatAmountLine; "VAT %")                {                    DecimalPlaces = 0 : 5;                }                column(VATPct_VatAmountLine_Lbl; FieldCaption("VAT %"))                {                }                column(NoOfVATIdentifiers; Count)                {                }                trigger OnAfterGetRecord()                begin                    VATBaseLCY :=                      GetBaseLCY(                        Header."Posting Date", Header."Currency Code",                        Header."Currency Factor");                    VATAmountLCY :=                      GetAmountLCY(                        Header."Posting Date", Header."Currency Code",                        Header."Currency Factor");                    TotalVATBaseLCY += VATBaseLCY;                    TotalVATAmountLCY += VATAmountLCY;                    TotalVATBaseOnVATAmtLine += "VAT Base";                    TotalVATAmountOnVATAmtLine += "VAT Amount";                    if ShowVATClause("VAT Clause Code") and ShouldInsertVATClauseLine() then begin                        VATClauseLine := VATAmountLine;                        if VATClauseLine.Insert() then;                    end;                end;                trigger OnPreDataItem()                begin                    Clear(VATBaseLCY);                    Clear(VATAmountLCY);                    TotalVATBaseLCY := 0;                    TotalVATAmountLCY := 0;                    TotalVATBaseOnVATAmtLine := 0;                    TotalVATAmountOnVATAmtLine := 0;                end;            }            dataitem(VATClauseLine; "VAT Amount Line")            {                DataItemTableView = sorting("VAT Identifier", "VAT Calculation Type", "Tax Group Code", "Use Tax", Positive);                UseTemporary = true;                column(VATClausesHeader; VATClausesText)                {                }                column(VATIdentifier_VATClauseLine; "VAT Identifier")                {                }                column(Code_VATClauseLine; VATClause.Code)                {                }                column(Code_VATClauseLine_Lbl; VATClause.FieldCaption(Code))                {                }                column(Description_VATClauseLine; VATClauseText)                {                }                column(Description2_VATClauseLine; VATClause."Description 2")                {                }                column(VATAmount_VATClauseLine; "VAT Amount")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(NoOfVATClauses; Count)                {                }                trigger OnAfterGetRecord()                begin                    if "VAT Clause Code" = '' then                        CurrReport.Skip();                    if not VATClause.Get("VAT Clause Code") then                        CurrReport.Skip();                    VATClauseText := VATClause.GetDescriptionText(Header);                end;                trigger OnPreDataItem()                begin                    if Count = 0 then                        VATClausesText := ''                    else                        VATClausesText := VATClausesLbl;                end;            }            dataitem(ReportTotalsLine; "Report Totals Buffer")            {                DataItemTableView = sorting("Line No.");                UseTemporary = true;                column(Description_ReportTotalsLine; Description)                {                }                column(Amount_ReportTotalsLine; Amount)                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(AmountFormatted_ReportTotalsLine; "Amount Formatted")                {                    AutoFormatExpression = Header."Currency Code";                    AutoFormatType = 1;                }                column(FontBold_ReportTotalsLine; "Font Bold")                {                }                column(FontUnderline_ReportTotalsLine; "Font Underline")                {                }                trigger OnPreDataItem()                begin                    CreateReportTotalLines();                end;            }            dataitem(LineFee; "Integer")            {                DataItemTableView = sorting(Number) order(ascending) where(Number = filter(1 ..));                column(LineFeeCaptionText; TempLineFeeNoteOnReportHist.ReportText)                {                }                trigger OnAfterGetRecord()                begin                    if not DisplayAdditionalFeeNoteVal then                        CurrReport.Break();                    if Number = 1 then begin                        if not TempLineFeeNoteOnReportHist.FindSet() then                            CurrReport.Break()                    end else                        if TempLineFeeNoteOnReportHist.Next() = 0 then                            CurrReport.Break();                end;            }            dataitem(PaymentReportingArgument; "Payment Reporting Argument")            {                DataItemTableView = sorting(Key);                UseTemporary = true;                column(PaymentServiceLogo; Logo)                {                }                column(PaymentServiceLogo_UrlText; "URL Caption")                {                }                column(PaymentServiceLogo_Url; GetTargetURL())                {                }                column(PaymentServiceText_UrlText; "URL Caption")                {                }                column(PaymentServiceText_Url; GetTargetURL())                {                }            }            dataitem(LeftHeader; "Name/Value Buffer")            {                DataItemTableView = sorting(ID);                UseTemporary = true;                column(LeftHeaderName; Name)                {                }                column(LeftHeaderValue; Value)                {                }            }            dataitem(RightHeader; "Name/Value Buffer")            {                DataItemTableView = sorting(ID);                UseTemporary = true;                column(RightHeaderName; Name)                {                }                column(RightHeaderValue; Value)                {                }            }            dataitem(LetterText; "Integer")            {                DataItemTableView = sorting(Number) where(Number = const(1));                column(GreetingText; GreetingLbl)                {                }                column(BodyText; BodyLbl)                {                }                column(ClosingText; ClosingLbl)                {                }                column(PmtDiscText; PmtDiscText)                {                }                trigger OnPreDataItem()                begin                    PmtDiscText := '';                    if Header."Payment Discount %" <> 0 then                        PmtDiscText := StrSubstNo(PmtDiscTxt, Header."Pmt. Discount Date", Header."Payment Discount %");                end;            }            dataitem(Totals; "Integer")            {                DataItemTableView = sorting(Number) where(Number = const(1));                column(TotalNetAmount; Format(TotalAmount, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code")))                {                }                column(TotalVATBaseLCY; TotalVATBaseLCY)                {                }                column(TotalAmountIncludingVAT; Format(TotalAmountInclVAT, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code")))                {                }                column(TotalVATAmount; Format(TotalAmountVAT, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code")))                {                }                column(TotalVATAmountLCY; TotalVATAmountLCY)                {                }                column(TotalInvoiceDiscountAmount; Format(TotalInvDiscAmount, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code")))                {                }                column(TotalPaymentDiscountOnVAT; TotalPaymentDiscOnVAT)                {                }                column(TotalVATAmountText; VATAmountLine.VATAmountText())                {                }                column(TotalExcludingVATText; TotalExclVATText)                {                }                column(TotalIncludingVATText; TotalInclVATText)                {                }                column(TotalSubTotal; Format(TotalSubTotal, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code")))                {                }                column(TotalSubTotalMinusInvoiceDiscount; Format(TotalSubTotal + TotalInvDiscAmount, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code")))                {                }                column(TotalText; TotalText)                {                }                column(TotalAmountExclInclVAT; Format(TotalAmountExclInclVATValue, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code")))                {                }                column(TotalAmountExclInclVATText; TotalAmountExclInclVATTextValue)                {                }                column(TotalVATBaseOnVATAmtLine; TotalVATBaseOnVATAmtLine)                {                }                column(TotalVATAmountOnVATAmtLine; TotalVATAmountOnVATAmtLine)                {                }                column(CurrencyCode; CurrCode)                {                }                column(CurrencySymbol; CurrSymbol)                {                }                trigger OnPreDataItem()                begin                    if Header."Prices Including VAT" then begin                        TotalAmountExclInclVATTextValue := TotalExclVATText;                        TotalAmountExclInclVATValue := TotalAmount;                    end else begin                        TotalAmountExclInclVATTextValue := TotalInclVATText;                        TotalAmountExclInclVATValue := TotalAmountInclVAT;                    end;                end;            }            trigger OnAfterGetRecord()            var                CurrencyExchangeRate: Record "Currency Exchange Rate";                PaymentServiceSetup: Record "Payment Service Setup";                Currency: Record Currency;                GeneralLedgerSetup: Record "General Ledger Setup";            begin                CurrReport.Language := LanguageMgt.GetLanguageIdOrDefault("Language Code");                CurrReport.FormatRegion := LanguageMgt.GetFormatRegionOrDefault("Format Region");                FormatAddr.SetLanguageCode("Language Code");                if not IsReportInPreviewMode() then                    CODEUNIT.Run(CODEUNIT::"Sales Inv.-Printed", Header);                OnHeaderOnAfterGetRecordOnAfterUpdateNoPrinted(IsReportInPreviewMode(), Header);                CalcFields("Work Description");                ShowWorkDescription := "Work Description".HasValue;                ChecksPayableText := StrSubstNo(ChecksPayableLbl, CompanyInfo.Name);                FormatAddressFields(Header);                FormatDocumentFields(Header);                if SellToContact.Get("Sell-to Contact No.") then;                if BillToContact.Get("Bill-to Contact No.") then;                if not CompanyBankAccount.Get(Header."Company Bank Account Code") then                    CompanyBankAccount.CopyBankFieldsFromCompanyInfo(CompanyInfo);                FillLeftHeader();                FillRightHeader();                if not Cust.Get("Bill-to Customer No.") then                    Clear(Cust);                if "Currency Code" <> '' then begin                    CurrencyExchangeRate.FindCurrency("Posting Date", "Currency Code", 1);                    CalculatedExchRate :=                      Round(1 / "Currency Factor" * CurrencyExchangeRate."Exchange Rate Amount", 0.000001);                    ExchangeRateText := StrSubstNo(ExchangeRateTxt, CalculatedExchRate, CurrencyExchangeRate."Exchange Rate Amount");                    CurrCode := "Currency Code";                    if Currency.Get("Currency Code") then                        CurrSymbol := Currency.GetCurrencySymbol();                end else                    if GeneralLedgerSetup.Get() then begin                        CurrCode := GeneralLedgerSetup."LCY Code";                        CurrSymbol := GeneralLedgerSetup.GetCurrencySymbol();                    end;                GetLineFeeNoteOnReportHist("No.");                PaymentServiceSetup.CreateReportingArgs(PaymentReportingArgument, Header);                CalcFields("Amount Including VAT");                RemainingAmount := GetRemainingAmount();                if RemainingAmount = 0 then                    RemainingAmountTxt := AlreadyPaidLbl                else                    if RemainingAmount <> "Amount Including VAT" then                        RemainingAmountTxt := StrSubstNo(PartiallyPaidLbl, Format(RemainingAmount, 0, '<Precision,2><Standard Format,0>'))                    else                        RemainingAmountTxt := '';                OnAfterGetSalesHeader(Header);                TotalSubTotal := 0;                TotalInvDiscAmount := 0;                TotalAmount := 0;                TotalAmountVAT := 0;                TotalAmountInclVAT := 0;                TotalPaymentDiscOnVAT := 0;                if ("Order No." = '') and "Prepayment Invoice" then                    "Order No." := "Prepayment Order No.";            end;            trigger OnPreDataItem()            begin                FirstLineHasBeenOutput := false;            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(LogInteraction; LogInteractionVal)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Log Interaction';                        Enabled = LogInteractionEnable;                        ToolTip = 'Specifies that interactions with the contact are logged.';                    }                    field(DisplayAsmInformation; DisplayAssemblyInformation)                    {                        ApplicationArea = Assembly;                        Caption = 'Show Assembly Components';                        ToolTip = 'Specifies if you want the report to include information about components that were used in linked assembly orders that supplied the item(s) being sold. (Only possible for RDLC report layout.)';                    }                    field(DisplayShptInformation; DisplayShipmentInformation)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Show Shipments';                        ToolTip = 'Specifies that shipments are shown on the document.';                    }                    field(DisplayAdditionalFeeNote; DisplayAdditionalFeeNoteVal)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Show Additional Fee Note';                        ToolTip = 'Specifies if you want notes about additional fees to be shown on the document.';                    }                    field(HideLinesWithZeroQuantityControl; HideLinesWithZeroQuantity)                    {                        ApplicationArea = Basic, Suite;                        ToolTip = 'Specifies if the lines with zero quantity are printed.';                        Caption = 'Hide lines with zero quantity';                    }                }            }        }        actions        {        }        trigger OnInit()        begin            LogInteractionVal := LogInteractionTemplateExists();            LogInteractionEnable := LogInteractionVal;        end;    }    rendering    {        layout("EUDRSalesInvoice.rdlc")        {            Type = RDLC;            LayoutFile = 'src/EUDR/EUDRSalesInvoice.rdlc';            Caption = 'EUDR Sales Invoice (RDLC)';            Summary = 'Prints the standard sales invoice information with EUDR certification scheme and certificate number per line and lot.';        }    }    labels    {    }    trigger OnInitReport()    var        IsHandled: Boolean;    begin        GLSetup.Get();        CompanyInfo.SetAutoCalcFields(Picture);        CompanyInfo.Get();        SalesSetup.Get();        CompanyInfo.VerifyAndSetPaymentInfo();        if SalesSetup.GetLegalStatement() <> '' then            LegalStatementLbl := SalesSetup.GetLegalStatement();        IsHandled := false;        OnInitReportForGlobalVariable(IsHandled, LegalOfficeTxt, LegalOfficeLbl, CustomGiroTxt, CustomGiroLbl, LegalStatementLbl);    end;    trigger OnPostReport()    begin        if LogInteractionVal and not IsReportInPreviewMode() then            if Header.FindSet() then                repeat                    if Header."Bill-to Contact No." <> '' then                        SegManagement.LogDocument(                          4, Header."No.", 0, 0, DATABASE::Contact, Header."Bill-to Contact No.", Header."Salesperson Code",                          Header."Campaign No.", Header."Posting Description", '')                    else                        SegManagement.LogDocument(                          4, Header."No.", 0, 0, DATABASE::Customer, Header."Bill-to Customer No.", Header."Salesperson Code",                          Header."Campaign No.", Header."Posting Description", '');                until Header.Next() = 0;    end;    trigger OnPreReport()    begin        if Header.GetFilters = '' then            Error(NoFilterSetErr);        CompanyLogoPosition := SalesSetup."Logo Position on Documents";    end;    var        GLSetup: Record "General Ledger Setup";        DummyCompanyInfo: Record "Company Information";        Cust: Record Customer;        RespCenter: Record "Responsibility Center";        VATClause: Record "VAT Clause";        SellToContact: Record Contact;        BillToContact: Record Contact;        LanguageMgt: Codeunit Language;        FormatAddr: Codeunit "Format Address";        FormatDocument: Codeunit "Format Document";        SegManagement: Codeunit SegManagement;        AutoFormat: Codeunit "Auto Format";        WorkDescriptionInstream: InStream;        JobNo: Code[20];        JobTaskNo: Code[20];        WorkDescriptionLine: Text;        ChecksPayableText: Text;        SalesPersonText: Text[50];        RemainingAmountTxt: Text;        JobNoLbl: Text;        JobTaskNoLbl: Text;        TotalAmountExclInclVATTextValue: Text;        MoreLines: Boolean;        ShowWorkDescription: Boolean;        TransHeaderAmount: Decimal;        LogInteractionEnable: Boolean;        CompanyLogoPosition: Integer;        CalculatedExchRate: Decimal;        PaymentInstructionsTxt: Text;        ExchangeRateText: Text;        PrevLineAmount: Decimal;        SalespersonLbl: Label 'Salesperson';        CompanyInfoBankAccNoLbl: Label 'Account No.';        CompanyInfoBankNameLbl: Label 'Bank';        CompanyInfoGiroNoLbl: Label 'Giro No.';        CompanyInfoPhoneNoLbl: Label 'Phone No.';        CopyLbl: Label 'Copy';        EMailLbl: Label 'Email';        HomePageLbl: Label 'Home Page';        InvDiscBaseAmtLbl: Label 'Invoice Discount Base Amount';        InvDiscountAmtLbl: Label 'Invoice Discount';        InvNoLbl: Label 'Invoice No.';        LineAmtAfterInvDiscLbl: Label 'Payment Discount on VAT';        LocalCurrencyLbl: Label 'Local Currency';        PageLbl: Label 'Page';        PaymentMethodDescLbl: Label 'Payment Method';        PostedShipmentDateLbl: Label 'Shipment Date';        SalesInvLineDiscLbl: Label 'Discount %';        SalesInvoiceLbl: Label 'Invoice';        YourSalesInvoiceLbl: Label 'Your Invoice';        ShipmentLbl: Label 'Shipment';        SubtotalLbl: Label 'Subtotal';        TotalLbl: Label 'Total';        VATAmtSpecificationLbl: Label 'VAT Amount Specification';        VATAmtLbl: Label 'VAT Amount';        VATAmountLCYLbl: Label 'VAT Amount (LCY)';        VATBaseLbl: Label 'VAT Base';        VATBaseLCYLbl: Label 'VAT Base (LCY)';        VATClausesLbl: Label 'VAT Clause';        VATIdentifierLbl: Label 'VAT Identifier';        VATPercentageLbl: Label 'VAT %';        SellToContactPhoneNoLbl: Label 'Sell-to Contact Phone No.';        SellToContactMobilePhoneNoLbl: Label 'Sell-to Contact Mobile Phone No.';        SellToContactEmailLbl: Label 'Sell-to Contact E-Mail';        BillToContactPhoneNoLbl: Label 'Bill-to Contact Phone No.';        BillToContactMobilePhoneNoLbl: Label 'Bill-to Contact Mobile Phone No.';        BillToContactEmailLbl: Label 'Bill-to Contact E-Mail';        ExchangeRateTxt: Label 'Exchange rate: %1/%2', Comment = '%1 and %2 are both amounts.';        NoFilterSetErr: Label 'You must specify one or more filters to avoid accidentally printing all documents.';        GreetingLbl: Label 'Hello';        ClosingLbl: Label 'Sincerely';        PmtDiscTxt: Label 'If we receive the payment before %1, you are eligible for a %2% payment discount.', Comment = '%1 Discount Due Date %2 = value of Payment Discount % ';        BodyLbl: Label 'Thank you for your business. Your invoice is attached to this message.';        AlreadyPaidLbl: Label 'The invoice has been paid.';        PartiallyPaidLbl: Label 'The invoice has been partially paid. The remaining amount is %1', Comment = '%1=an amount';        FromLbl: Label 'From';        BilledToLbl: Label 'Billed to';        ChecksPayableLbl: Label 'Please make checks payable to %1', Comment = '%1 = company name';        QuestionsLbl: Label 'Questions?';        ThanksLbl: Label 'Thank You!';        ProjectNoLbl: Label 'Project No.';        ProjectTaskNoLbl: Label 'Project Task No.';        JobTaskDescription: Text[100];        JobTaskDescLbl: Label 'Project Task Description';        UnitLbl: Label 'Unit';        VATClausesText: Text;        QtyLbl: Label 'Qty', Comment = 'Short form of Quantity';        PriceLbl: Label 'Price';        PricePerLbl: Label 'Price per';        LCYTxt: label ' (LCY)';        EUDRSalesInvoiceLbl: Label 'EUDR Sales Invoice';        LotQuantityLbl: Label 'Quantity';        VATClauseText: Text;        LegalOfficeTxt, LegalOfficeLbl, CustomGiroTxt, CustomGiroLbl, LegalStatementLbl : Text;    protected var        CompanyInfo: Record "Company Information";        CompanyBankAccount: Record "Bank Account";        PaymentMethod: Record "Payment Method";        SalespersonPurchaser: Record "Salesperson/Purchaser";        SalesSetup: Record "Sales & Receivables Setup";        ShipmentMethod: Record "Shipment Method";        PaymentTerms: Record "Payment Terms";        TempLineFeeNoteOnReportHist: Record "Line Fee Note on Report Hist." temporary;        CompanyAddr: array[8] of Text[100];        CustAddr: array[8] of Text[100];        ShipToAddr: array[8] of Text[100];        FormattedLineAmount: Text;        FormattedQuantity: Text;        FormattedUnitPrice: Text;        FormattedVATPct: Text;        LineDiscountPctText: Text;        PmtDiscText: Text;        TotalExclVATText: Text[50];        TotalInclVATText: Text[50];        TotalSubTotal: Decimal;        VATBaseLCY: Decimal;        VATAmountLCY: Decimal;        DisplayAssemblyInformation: Boolean;        DisplayShipmentInformation: Boolean;        DisplayAdditionalFeeNoteVal: Boolean;        FirstLineHasBeenOutput: Boolean;        ShowShippingAddr: Boolean;        TotalText: Text[50];        LogInteractionVal: Boolean;        TotalAmount: Decimal;        TotalAmountInclVAT: Decimal;        TotalAmountVAT: Decimal;        TotalInvDiscAmount: Decimal;        TotalPaymentDiscOnVAT: Decimal;        RemainingAmount: Decimal;        TotalAmountExclInclVATValue: Decimal;        TotalVATBaseLCY: Decimal;        TotalVATAmountLCY: Decimal;        TotalVATBaseOnVATAmtLine: Decimal;        TotalVATAmountOnVATAmtLine: Decimal;        CurrCode: Text[10];        CurrSymbol: Text[10];        PaymentTermsDescLbl: Label 'Payment Terms';        ShptMethodDescLbl: Label 'Shipment Method';        ShiptoAddrLbl: Label 'Ship-to Address';        HideLinesWithZeroQuantity: Boolean;    local procedure LogInteractionTemplateExists(): Boolean    begin        exit(SegManagement.FindInteractionTemplateCode(Enum::"Interaction Log Entry Document Type"::"Sales Inv.") <> '');    end;    local procedure InitializeShipmentLine()    var        SalesShipmentHeader: Record "Sales Shipment Header";    begin        if not DisplayShipmentInformation then            exit;        if Line.Type = Line.Type::" " then            exit;        if Line."Shipment No." <> '' then            if SalesShipmentHeader.Get(Line."Shipment No.") then                exit;        ShipmentLine.GetLinesForSalesInvoiceLine(Line, Header);        ShipmentLine.Reset();        ShipmentLine.SetRange("Line No.", Line."Line No.");        if not ShipmentLine.IsEmpty() then begin            ShipmentLine.CalcSums(Quantity);            if ShipmentLine.Quantity <> Line.Quantity then begin                ShipmentLine.DeleteAll();                exit;            end;        end;    end;    local procedure LoadEUDRLotsForLine(SalesInvoiceLine: Record "Sales Invoice Line")    var        ItemLedgerEntry: Record "Item Ledger Entry";        LotNoInformation: Record "Lot No. Information";        ValueEntry: Record "Value Entry";    begin        EUDRLot.DeleteAll();        if SalesInvoiceLine.Type <> SalesInvoiceLine.Type::Item then            exit;        if not SalesInvoiceLine."EUDR Relevant" then            exit;        ValueEntry.SetRange("Document Type", ValueEntry."Document Type"::"Sales Invoice");        ValueEntry.SetRange("Document No.", SalesInvoiceLine."Document No.");        ValueEntry.SetRange("Document Line No.", SalesInvoiceLine."Line No.");        ValueEntry.SetRange("Item No.", SalesInvoiceLine."No.");        ValueEntry.SetFilter("Item Ledger Entry No.", '<>%1', 0);        if ValueEntry.FindSet() then            repeat                if ItemLedgerEntry.Get(ValueEntry."Item Ledger Entry No.") then                    if ItemLedgerEntry."Lot No." <> '' then                        if LotNoInformation.Get(ItemLedgerEntry."Item No.", ItemLedgerEntry."Variant Code", ItemLedgerEntry."Lot No.") then                            if not EUDRLot.Get(LotNoInformation."Item No.", LotNoInformation."Variant Code", LotNoInformation."Lot No.") then begin                                EUDRLot := LotNoInformation;                                EUDRLot.Insert();                            end;            until ValueEntry.Next() = 0;    end;    local procedure GetEUDRLotQuantity(SalesInvoiceLine: Record "Sales Invoice Line"; LotNoInformation: Record "Lot No. Information"): Decimal    var        ItemLedgerEntry: Record "Item Ledger Entry";        ValueEntry: Record "Value Entry";        LotQuantity: Decimal;    begin        ValueEntry.SetRange("Document Type", ValueEntry."Document Type"::"Sales Invoice");        ValueEntry.SetRange("Document No.", SalesInvoiceLine."Document No.");        ValueEntry.SetRange("Document Line No.", SalesInvoiceLine."Line No.");        ValueEntry.SetRange("Item No.", SalesInvoiceLine."No.");        ValueEntry.SetFilter("Item Ledger Entry No.", '<>%1', 0);        if ValueEntry.FindSet() then            repeat                if ItemLedgerEntry.Get(ValueEntry."Item Ledger Entry No.") then                    if (ItemLedgerEntry."Item No." = LotNoInformation."Item No.") and                       (ItemLedgerEntry."Variant Code" = LotNoInformation."Variant Code") and                       (ItemLedgerEntry."Lot No." = LotNoInformation."Lot No.")                    then                        LotQuantity -= ValueEntry."Invoiced Quantity";            until ValueEntry.Next() = 0;        exit(LotQuantity);    end;    local procedure DocumentCaption(): Text[250]    var        DocCaption: Text;    begin        OnBeforeGetDocumentCaption(Header, DocCaption);        if DocCaption <> '' then            exit(CopyStr(DocCaption, 1, 250));        exit(SalesInvoiceLbl);    end;    /// <summary>    /// Initializes the report request options for the standard sales invoice report.    /// </summary>    /// <param name="NewLogInteraction">Specifies whether to log the interaction.</param>    /// <param name="DisplayAsmInfo">Specifies whether to display assembly information.</param>    procedure InitializeRequest(NewLogInteraction: Boolean; DisplayAsmInfo: Boolean)    begin        LogInteractionVal := NewLogInteraction;        DisplayAssemblyInformation := DisplayAsmInfo;    end;    protected procedure IsReportInPreviewMode(): Boolean    var        MailManagement: Codeunit "Mail Management";    begin        exit(CurrReport.Preview() or MailManagement.IsHandlingGetEmailBody());    end;    local procedure GetUOMText(UOMCode: Code[10]): Text[50]    var        UnitOfMeasure: Record "Unit of Measure";        UOMDescription: Text[50];    begin        if not UnitOfMeasure.Get(UOMCode) then            exit(UOMCode);        UOMDescription := UnitOfMeasure.Description;        OnAfterGetUOMText(UOMCode, UOMDescription);        exit(UOMDescription);    end;    local procedure CreateReportTotalLines()    begin        ReportTotalsLine.DeleteAll();        if (TotalInvDiscAmount <> 0) or (TotalAmountVAT <> 0) then            ReportTotalsLine.Add(SubtotalLbl, TotalSubTotal, true, false, false, Header."Currency Code");        if TotalInvDiscAmount <> 0 then begin            ReportTotalsLine.Add(InvDiscountAmtLbl, TotalInvDiscAmount, false, false, false, Header."Currency Code");            if TotalAmountVAT <> 0 then                if Header."Prices Including VAT" then                    ReportTotalsLine.Add(TotalInclVATText, TotalAmountInclVAT, true, false, false, Header."Currency Code")                else                    ReportTotalsLine.Add(TotalExclVATText, TotalAmount, true, false, false, Header."Currency Code");        end;        if TotalAmountVAT <> 0 then begin            ReportTotalsLine.Add(VATAmountLine.VATAmountText(), TotalAmountVAT, false, true, false, Header."Currency Code");            if TotalVATAmountLCY <> TotalAmountVAT then                ReportTotalsLine.Add(VATAmountLine.VATAmountText() + LCYTxt, TotalVATAmountLCY, false, true, false);        end;    end;    local procedure GetLineFeeNoteOnReportHist(SalesInvoiceHeaderNo: Code[20])    var        LineFeeNoteOnReportHist: Record "Line Fee Note on Report Hist.";        CustLedgerEntry: Record "Cust. Ledger Entry";        Customer: Record Customer;    begin        TempLineFeeNoteOnReportHist.DeleteAll();        CustLedgerEntry.SetRange("Document Type", CustLedgerEntry."Document Type"::Invoice);        CustLedgerEntry.SetRange("Document No.", SalesInvoiceHeaderNo);        if not CustLedgerEntry.FindFirst() then            exit;        if not Customer.Get(CustLedgerEntry."Customer No.") then            exit;        LineFeeNoteOnReportHist.SetRange("Cust. Ledger Entry No", CustLedgerEntry."Entry No.");        LineFeeNoteOnReportHist.SetRange("Language Code", Customer."Language Code");        if LineFeeNoteOnReportHist.FindSet() then            repeat                TempLineFeeNoteOnReportHist.Init();                TempLineFeeNoteOnReportHist.Copy(LineFeeNoteOnReportHist);                TempLineFeeNoteOnReportHist.Insert();            until LineFeeNoteOnReportHist.Next() = 0        else begin            LineFeeNoteOnReportHist.SetRange("Language Code", LanguageMgt.GetUserLanguageCode());            if LineFeeNoteOnReportHist.FindSet() then                repeat                    TempLineFeeNoteOnReportHist.Init();                    TempLineFeeNoteOnReportHist.Copy(LineFeeNoteOnReportHist);                    TempLineFeeNoteOnReportHist.Insert();                until LineFeeNoteOnReportHist.Next() = 0;        end;    end;    local procedure FillLeftHeader()    begin        LeftHeader.DeleteAll();        FillNameValueTable(LeftHeader, Header.FieldCaption("External Document No."), Header."External Document No.");        FillNameValueTable(LeftHeader, Header.FieldCaption("Bill-to Customer No."), Header."Bill-to Customer No.");        FillNameValueTable(LeftHeader, Header.GetCustomerVATRegistrationNumberLbl(), Header.GetCustomerVATRegistrationNumber());        FillNameValueTable(LeftHeader, Header.GetCustomerGlobalLocationNumberLbl(), Header.GetCustomerGlobalLocationNumber());        FillNameValueTable(LeftHeader, InvNoLbl, Header."No.");        FillNameValueTable(LeftHeader, Header.FieldCaption("Order No."), Header."Order No.");        FillNameValueTable(LeftHeader, Header.FieldCaption("Document Date"), Format(Header."Document Date", 0, 4));        FillNameValueTable(LeftHeader, Header.FieldCaption("Due Date"), Format(Header."Due Date", 0, 4));        FillNameValueTable(LeftHeader, PaymentTermsDescLbl, PaymentTerms.Description);        FillNameValueTable(LeftHeader, PaymentMethodDescLbl, PaymentMethod.Description);        FillNameValueTable(LeftHeader, Cust.GetLegalEntityTypeLbl(), Cust.GetLegalEntityType());        FillNameValueTable(LeftHeader, ShptMethodDescLbl, ShipmentMethod.Description);        OnAfterFillLeftHeader(LeftHeader, Header);    end;    local procedure FillRightHeader()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeFillRightHeader(Header, SalespersonPurchaser, SalesPersonText, RightHeader, IsHandled);        if not IsHandled then begin            RightHeader.DeleteAll();            FillNameValueTable(RightHeader, EMailLbl, CompanyInfo."E-Mail");            FillNameValueTable(RightHeader, HomePageLbl, CompanyInfo."Home Page");            FillNameValueTable(RightHeader, CompanyInfoPhoneNoLbl, CompanyInfo."Phone No.");            FillNameValueTable(RightHeader, CompanyInfo.GetRegistrationNumberLbl(), CompanyInfo.GetRegistrationNumber());            FillNameValueTable(RightHeader, CompanyInfo.GetVATRegistrationNumberLbl(), CompanyInfo.GetVATRegistrationNumber());            FillNameValueTable(RightHeader, CompanyInfoBankNameLbl, CompanyBankAccount.Name);            FillNameValueTable(RightHeader, CompanyInfoGiroNoLbl, CompanyInfo."Giro No.");            FillNameValueTable(RightHeader, CompanyBankAccount.FieldCaption(IBAN), CompanyBankAccount.IBAN);            FillNameValueTable(RightHeader, CompanyBankAccount.FieldCaption("SWIFT Code"), CompanyBankAccount."SWIFT Code");            FillNameValueTable(RightHeader, Header.GetPaymentReferenceLbl(), Header.GetPaymentReference());            OnAfterFillRightHeader(RightHeader, Header);        end;    end;    local procedure FillNameValueTable(var NameValueBuffer: Record "Name/Value Buffer"; Name: Text; Value: Text)    var        KeyIndex: Integer;    begin        if Value <> '' then begin            Clear(NameValueBuffer);            if NameValueBuffer.FindLast() then                KeyIndex := NameValueBuffer.ID + 1;            NameValueBuffer.Init();            NameValueBuffer.ID := KeyIndex;            NameValueBuffer.Name := CopyStr(Name, 1, MaxStrLen(NameValueBuffer.Name));            NameValueBuffer.Value := CopyStr(Value, 1, MaxStrLen(NameValueBuffer.Value));            NameValueBuffer.Insert();        end;    end;    local procedure FormatAddressFields(var SalesInvoiceHeader: Record "Sales Invoice Header")    begin        FormatAddr.GetCompanyAddr(SalesInvoiceHeader."Responsibility Center", RespCenter, CompanyInfo, CompanyAddr);        FormatAddr.SalesInvBillTo(CustAddr, SalesInvoiceHeader);        ShowShippingAddr := FormatAddr.SalesInvShipTo(ShipToAddr, CustAddr, SalesInvoiceHeader);    end;    local procedure FormatDocumentFields(SalesInvoiceHeader: Record "Sales Invoice Header")    begin        FormatDocument.SetTotalLabels(SalesInvoiceHeader.GetCurrencySymbol(), TotalText, TotalInclVATText, TotalExclVATText);        FormatDocument.SetSalesPerson(SalespersonPurchaser, SalesInvoiceHeader."Salesperson Code", SalesPersonText);        FormatDocument.SetPaymentTerms(PaymentTerms, SalesInvoiceHeader."Payment Terms Code", SalesInvoiceHeader."Language Code");        FormatDocument.SetPaymentMethod(PaymentMethod, SalesInvoiceHeader."Payment Method Code", SalesInvoiceHeader."Language Code");        FormatDocument.SetShipmentMethod(ShipmentMethod, SalesInvoiceHeader."Shipment Method Code", SalesInvoiceHeader."Language Code");        OnAfterFormatDocumentFields(SalesInvoiceHeader);    end;    local procedure GetJobTaskDescription(NewJobNo: Code[20]; NewJobTaskNo: Code[20]): Text[100]    var        JobTask: Record "Job Task";    begin        JobTask.SetRange("Job No.", NewJobNo);        JobTask.SetRange("Job Task No.", NewJobTaskNo);        if JobTask.FindFirst() then            exit(JobTask.Description);        exit('');    end;    [IntegrationEvent(false, false)]    local procedure OnAfterLineOnPreDataItem(var SalesInvoiceHeader: Record "Sales Invoice Header"; var SalesInvoiceLine: Record "Sales Invoice Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFillLeftHeader(var LeftHeader: Record "Name/Value Buffer"; SalesInvoiceHeader: Record "Sales Invoice Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFillRightHeader(var RightHeader: Record "Name/Value Buffer"; SalesInvoiceHeader: Record "Sales Invoice Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeLineOnAfterGetRecord(var SalesInvoiceHeader: Record "Sales Invoice Header"; var SalesInvoiceLine: Record "Sales Invoice Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetDocumentCaption(SalesInvoiceHeader: Record "Sales Invoice Header"; var DocCaption: Text)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAfterGetSalesHeader(SalesInvoiceHeader: Record "Sales Invoice Header")    begin    end;    local procedure ShowVATClause(VATClauseCode: Code[20]): Boolean    begin        if VATClauseCode = '' then            exit(false);        exit(true);    end;    local procedure InsertVATAmountLine(var VATAmountLine2: Record "VAT Amount Line"; SalesInvoiceLine: Record "Sales Invoice Line")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeVATAmountLineInsertLine(VATAmountLine2, SalesInvoiceLine, IsHandled);        if IsHandled then            exit;        VATAmountLine2.Init();        VATAmountLine2."VAT Identifier" := SalesInvoiceLine."VAT Identifier";        VATAmountLine2."VAT Calculation Type" := SalesInvoiceLine."VAT Calculation Type";        VATAmountLine2."Tax Group Code" := SalesInvoiceLine."Tax Group Code";        VATAmountLine2."VAT %" := SalesInvoiceLine."VAT %";        VATAmountLine2."VAT Base" := SalesInvoiceLine.Amount;        VATAmountLine2."Amount Including VAT" := SalesInvoiceLine."Amount Including VAT";        VATAmountLine2."Line Amount" := SalesInvoiceLine."Line Amount";        if SalesInvoiceLine."Allow Invoice Disc." then            VATAmountLine2."Inv. Disc. Base Amount" := SalesInvoiceLine."Line Amount";        VATAmountLine2."Invoice Discount Amount" := SalesInvoiceLine."Inv. Discount Amount";        VATAmountLine2."VAT Clause Code" := SalesInvoiceLine."VAT Clause Code";        VATAmountLine2.InsertLine();    end;    local procedure FormatLineValues(CurrLine: Record "Sales Invoice Line")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeFormatLineValues(CurrLine, FormattedQuantity, FormattedUnitPrice, FormattedVATPct, FormattedLineAmount, IsHandled);        if not IsHandled then            FormatDocument.SetSalesInvoiceLine(CurrLine, FormattedQuantity, FormattedUnitPrice, FormattedVATPct, FormattedLineAmount);    end;    local procedure ShouldInsertVATClauseLine(): Boolean    var        TempVATClauseLine: Record "VAT Amount Line" temporary;    begin        if VATAmountLine."VAT Amount" <> 0 then            exit(true);        TempVATClauseLine.Copy(VATClauseLine, true);        TempVATClauseLine.SetRange("VAT Identifier", VATAmountLine."VAT Identifier");        TempVATClauseLine.SetRange("VAT Clause Code", VATAmountLine."VAT Clause Code");        TempVATClauseLine.SetRange("VAT Amount", VATAmountLine."VAT Amount");        exit(TempVATClauseLine.IsEmpty());    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFormatLineValues(SalesInvoiceLine: Record "Sales Invoice Line"; var FormattedQuantity: Text; var FormattedUnitPrice: Text; var FormattedVATPercentage: Text; var FormattedLineAmount: Text; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFormatDocumentFields(var SalesInvoiceHeader: Record "Sales Invoice Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeVATAmountLineInsertLine(var VATAmountLine: Record "VAT Amount Line"; SalesInvoiceLine: Record "Sales Invoice Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFillRightHeader(var SalesInvoiceHeader: Record "Sales Invoice Header"; SalespersonPurchaser: Record "Salesperson/Purchaser"; var SalesPersonText: Text[50]; var RightHeader: Record "Name/Value Buffer"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetUOMText(UOMCode: Code[10]; var UOMDescription: Text[50])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInitReportForGlobalVariable(var IsHandled: Boolean; var LegalOfficeTxt: Text; var LegalOfficeLbl: Text; var CustomGiroTxt: Text; var CustomGiroLbl: Text; var LegalStatementLbl: Text)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnHeaderOnAfterGetRecordOnAfterUpdateNoPrinted(ReportInPreviewMode: Boolean; var SalesInvoiceHeader: Record "Sales Invoice Header")    begin    end;}