Report 5911 Service - Invoice

Base Application, Microsoft.Service.History

src/Layers/W1/BaseApp/Service/History/ServiceInvoice.Report.al1,168 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.Service.History;using Microsoft.Bank.BankAccount;using Microsoft.CRM.Team;using Microsoft.Finance.Dimension;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.Inventory.Ledger;using Microsoft.Inventory.Location;using Microsoft.Sales.Customer;using Microsoft.Sales.History;using Microsoft.Sales.Receivables;using Microsoft.Sales.Reminder;using Microsoft.Service.Item;using Microsoft.Service.Setup;using Microsoft.Utilities;using System.Email;using System.Globalization;using System.Utilities;report 5911 "Service - Invoice"{    DefaultLayout = RDLC;    RDLCLayout = './Service/History/ServiceInvoice.rdlc';    Caption = 'Service - Invoice';    Permissions = TableData "Sales Shipment Buffer" = rimd;    WordMergeDataItem = "Service Invoice Header";    dataset    {        dataitem("Service Invoice Header"; "Service Invoice Header")        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.", "Customer No.", "No. Printed";            RequestFilterHeading = 'Posted Service Invoice';            column(No_ServiceInvHeader; "No.")            {            }            column(InvDiscountAmountCaption; InvDiscountAmountCaptionLbl)            {            }            column(DisplayAdditionalFeeNote; DisplayAdditionalFeeNote)            {            }            dataitem(CopyLoop; "Integer")            {                DataItemTableView = sorting(Number);                dataitem(PageLoop; "Integer")                {                    DataItemTableView = sorting(Number) where(Number = const(1));                    column(CompanyInfo2Picture; CompanyInfo2.Picture)                    {                    }                    column(CompanyInfo1Picture; CompanyInfo1.Picture)                    {                    }                    column(CompanyInfoPicture; CompanyInfo3.Picture)                    {                    }                    column(ReportTitleCopyText; StrSubstNo(DocumentCaption(), CopyText))                    {                    }                    column(CustAddr1; CustAddr[1])                    {                    }                    column(CompanyAddr1; CompanyAddr[1])                    {                    }                    column(CustAddr2; CustAddr[2])                    {                    }                    column(CompanyAddr2; CompanyAddr[2])                    {                    }                    column(CustAddr3; CustAddr[3])                    {                    }                    column(CompanyAddr3; CompanyAddr[3])                    {                    }                    column(CustAddr4; CustAddr[4])                    {                    }                    column(CompanyAddr4; CompanyAddr[4])                    {                    }                    column(CustAddr5; CustAddr[5])                    {                    }                    column(CompanyInfoPhoneNo; CompanyInfo."Phone No.")                    {                    }                    column(CustAddr6; CustAddr[6])                    {                    }                    column(CompanyInfoFaxNo; CompanyInfo."Fax No.")                    {                    }                    column(CompanyInfoVATRegNo; CompanyInfo."VAT Registration No.")                    {                    }                    column(CompanyInfoGiroNo; CompanyInfo."Giro No.")                    {                    }                    column(CompanyInfoBankName; CompanyBankAccount.Name)                    {                    }                    column(CompanyInfoBankAccountNo; CompanyBankAccount."Bank Account No.")                    {                    }                    column(BillToCustNo_ServInvHeader; "Service Invoice Header"."Bill-to Customer No.")                    {                    }                    column(BillToCustNo_ServInvHeaderCaption; "Service Invoice Header".FieldCaption("Bill-to Customer No."))                    {                    }                    column(PostingDate_ServInvHeader; Format("Service Invoice Header"."Posting Date"))                    {                    }                    column(VATNoText; VATNoText)                    {                    }                    column(VATRegNo_ServInvHeader; "Service Invoice Header"."VAT Registration No.")                    {                    }                    column(DueDate_ServInvHeader; Format("Service Invoice Header"."Due Date"))                    {                    }                    column(SalesPersonText; SalesPersonText)                    {                    }                    column(SalesPurchPersonName; SalesPurchPerson.Name)                    {                    }                    column(No1_ServiceInvHeader; "Service Invoice Header"."No.")                    {                    }                    column(ReferenceText; ReferenceText)                    {                    }                    column(YorRef_ServInvHeader; "Service Invoice Header"."Your Reference")                    {                    }                    column(OrderNoText; OrderNoText)                    {                    }                    column(OrderNo_ServInvHeader; "Service Invoice Header"."Order No.")                    {                    }                    column(CustAddr7; CustAddr[7])                    {                    }                    column(CustAddr8; CustAddr[8])                    {                    }                    column(CompanyAddr5; CompanyAddr[5])                    {                    }                    column(CompanyAddr6; CompanyAddr[6])                    {                    }                    column(CompanyAddr7; CompanyAddr[7])                    {                    }                    column(CompanyAddr8; CompanyAddr[8])                    {                    }                    column(DocDate_ServInvHeader; Format("Service Invoice Header"."Document Date", 0, 4))                    {                    }                    column(PricesInclVAT_ServInvHeader; "Service Invoice Header"."Prices Including VAT")                    {                    }                    column(PricesInclVAT_ServInvHeaderCaption; "Service Invoice Header".FieldCaption("Prices Including VAT"))                    {                    }                    column(PageCaption; StrSubstNo(Text005, ''))                    {                    }                    column(OutputNo; OutputNo)                    {                    }                    column(PricesInclVAT1_ServInvHeader; Format("Service Invoice Header"."Prices Including VAT"))                    {                    }                    column(CompanyInfoPhoneNoCaption; CompanyInfoPhoneNoCaptionLbl)                    {                    }                    column(CompanyInfoFaxNoCaption; CompanyInfoFaxNoCaptionLbl)                    {                    }                    column(CompanyInfoVATRegistrationNoCaption; CompanyInfoVATRegistrationNoCaptionLbl)                    {                    }                    column(CompanyInfoGiroNoCaption; CompanyInfoGiroNoCaptionLbl)                    {                    }                    column(CompanyInfoBankNameCaption; CompanyInfoBankNameCaptionLbl)                    {                    }                    column(CompanyInfoBankAccountNoCaption; CompanyInfoBankAccountNoCaptionLbl)                    {                    }                    column(AmountCaption; AmountCaptionLbl)                    {                    }                    column(ServiceInvoiceHeaderDueDateCaption; ServiceInvoiceHeaderDueDateCaptionLbl)                    {                    }                    column(InvoiceNoCaption; InvoiceNoCaptionLbl)                    {                    }                    column(ServiceInvoiceHeaderPostingDateCaption; ServiceInvoiceHeaderPostingDateCaptionLbl)                    {                    }                    column(CompanyBankBranchNo; CompanyBankAccount."Bank Branch No.")                    {                    }                    column(CompanyBankBranchNo_Lbl; CompanyBankAccount.FieldCaption("Bank Branch No."))                    {                    }                    dataitem(DimensionLoop1; "Integer")                    {                        DataItemLinkReference = "Service Invoice Header";                        DataItemTableView = sorting(Number);                        column(DimText; DimText)                        {                        }                        column(Number_IntegerLine; Number)                        {                        }                        column(HeaderDimensionsCaption; HeaderDimensionsCaptionLbl)                        {                        }                        trigger OnAfterGetRecord()                        begin                            DimText := DimTxtArr[Number];                        end;                        trigger OnPreDataItem()                        begin                            if not ShowInternalInfo then                                CurrReport.Break();                            FindDimTxt("Service Invoice Header"."Dimension Set ID");                            SetRange(Number, 1, DimTxtArrLength);                        end;                    }                    dataitem("Service Invoice Line"; "Service Invoice Line")                    {                        DataItemLink = "Document No." = field("No.");                        DataItemLinkReference = "Service Invoice Header";                        DataItemTableView = sorting("Document No.", "Service Item Line No.");                        column(TypeInt; TypeInt)                        {                        }                        column(BaseDisc_ServInvHeader; "Service Invoice Header"."VAT Base Discount %")                        {                        }                        column(TotalLineAmount; TotalLineAmount)                        {                        }                        column(TotalAmount; TotalAmount)                        {                        }                        column(TotalAmountInclVAT; TotalAmountInclVAT)                        {                        }                        column(TotalInvDiscAmount; TotalInvDiscAmount)                        {                        }                        column(LineNo_ServInvLine; "Line No.")                        {                        }                        column(LineAmt_ServInvLine; "Line Amount")                        {                            AutoFormatExpression = GetCurrencyCode();                            AutoFormatType = 1;                        }                        column(Description_ServInvLine; Description)                        {                        }                        column(No_ServInvLine; "No.")                        {                        }                        column(SerialNo_ServiceItem; ServiceItemSerialNo)                        {                        }                        column(Quantity_ServInvLine; Quantity)                        {                        }                        column(UOM_ServInvLine; "Unit of Measure")                        {                        }                        column(No_ServInvLineCaption; FieldCaption("No."))                        {                        }                        column(SerialNo_ServiceItemCaption; SerialNoCaptionLbl)                        {                        }                        column(Description_ServInvLineCaption; FieldCaption(Description))                        {                        }                        column(Quantity_ServInvLineCaption; QuantityCaptionLbl)                        {                        }                        column(UOM_ServInvLineCaption; FieldCaption("Unit of Measure"))                        {                        }                        column(UnitPrice_ServInvLine; "Unit Price")                        {                            AutoFormatExpression = GetCurrencyCode();                            AutoFormatType = 2;                        }                        column(LineDisc_ServInvLine; "Line Discount %")                        {                        }                        column(VATIdentifier_ServInvLine; "VAT Identifier")                        {                        }                        column(VATIdentifier_ServInvLineCaption; FieldCaption("VAT Identifier"))                        {                        }                        column(PostedShipmentDate; Format(PostedShipmentDate))                        {                        }                        column(InvDiscountAmount; -"Inv. Discount Amount")                        {                            AutoFormatExpression = GetCurrencyCode();                            AutoFormatType = 1;                        }                        column(TotalText; TotalText)                        {                        }                        column(Amount_ServInvLine; Amount)                        {                            AutoFormatExpression = GetCurrencyCode();                            AutoFormatType = 1;                        }                        column(AmtInclVATAmount; "Amount Including VAT" - Amount)                        {                            AutoFormatExpression = GetCurrencyCode();                            AutoFormatType = 1;                        }                        column(AmtInclVAT_ServInvLine; "Amount Including VAT")                        {                            AutoFormatExpression = GetCurrencyCode();                            AutoFormatType = 1;                        }                        column(VATAmtLineVATAmtText; TempVATAmountLine.VATAmountText())                        {                        }                        column(TotalExclVATText; TotalExclVATText)                        {                        }                        column(TotalInclVATText; TotalInclVATText)                        {                        }                        column(LineAmtInvDiscAmtAmtInclVAT; -("Line Amount" - "Inv. Discount Amount" - "Amount Including VAT"))                        {                            AutoFormatExpression = "Service Invoice Header"."Currency Code";                            AutoFormatType = 1;                        }                        column(UnitPriceCaption; UnitPriceCaptionLbl)                        {                        }                        column(ServiceInvoiceLineLineDiscountCaption; ServiceInvoiceLineLineDiscountCaptionLbl)                        {                        }                        column(PostedShipmentDateCaption; PostedShipmentDateCaptionLbl)                        {                        }                        column(SubtotalCaption; SubtotalCaptionLbl)                        {                        }                        column(LineAmountInvDiscountAmountAmountIncludingVATCaption; LineAmountInvDiscountAmountAmountIncludingVATCaptionLbl)                        {                        }                        dataitem("Service Shipment Buffer"; "Integer")                        {                            DataItemTableView = sorting(Number);                            column(ServShptBufferPostingDate; Format(TempServiceShipmentBuffer."Posting Date"))                            {                            }                            column(ServShptBufferQuantity; TempServiceShipmentBuffer.Quantity)                            {                                DecimalPlaces = 0 : 5;                            }                            column(ShipmentCaption; ShipmentCaptionLbl)                            {                            }                            trigger OnAfterGetRecord()                            begin                                if Number = 1 then                                    TempServiceShipmentBuffer.Find('-')                                else                                    TempServiceShipmentBuffer.Next();                            end;                            trigger OnPreDataItem()                            begin                                TempServiceShipmentBuffer.SetRange("Document No.", "Service Invoice Line"."Document No.");                                TempServiceShipmentBuffer.SetRange("Line No.", "Service Invoice Line"."Line No.");                                SetRange(Number, 1, TempServiceShipmentBuffer.Count);                            end;                        }                        dataitem(DimensionLoop2; "Integer")                        {                            DataItemTableView = sorting(Number);                            column(DimText1; DimText)                            {                            }                            column(LineDimensionsCaption; LineDimensionsCaptionLbl)                            {                            }                            trigger OnAfterGetRecord()                            begin                                if Number <= DimTxtArrLength then                                    DimText := DimTxtArr[Number]                                else                                    DimText := Format("Service Invoice Line".Type) + ' ' + AccNo;                            end;                            trigger OnPreDataItem()                            begin                                if not ShowInternalInfo then                                    CurrReport.Break();                                FindDimTxt("Service Invoice Line"."Dimension Set ID");                                if IsServiceContractLine then                                    SetRange(Number, 1, DimTxtArrLength + 1)                                else                                    SetRange(Number, 1, DimTxtArrLength);                            end;                        }                        trigger OnAfterGetRecord()                        begin                            PostedShipmentDate := 0D;                            AccNo := '';                            ServiceItemSerialNo := '';                            if Quantity <> 0 then                                PostedShipmentDate := FindPostedShipmentDate();                            IsServiceContractLine := (Type = Type::"G/L Account") and ("Service Item No." <> '') and ("Contract No." <> '');                            if IsServiceContractLine then begin                                AccNo := "No.";                                "No." := "Service Item No.";                                ServiceItemSerialNo := GetServiceItemSerialNo("Service Item No.");                            end else                                ServiceItemSerialNo := "Service Item Serial No.";                            TempVATAmountLine.Init();                            TempVATAmountLine."VAT Identifier" := "VAT Identifier";                            TempVATAmountLine."VAT Calculation Type" := "VAT Calculation Type";                            TempVATAmountLine."Tax Group Code" := "Tax Group Code";                            TempVATAmountLine."VAT %" := "VAT %";                            TempVATAmountLine."VAT Base" := Amount;                            TempVATAmountLine."Amount Including VAT" := "Amount Including VAT";                            TempVATAmountLine."Line Amount" := "Line Amount";                            if "Allow Invoice Disc." then                                TempVATAmountLine."Inv. Disc. Base Amount" := "Line Amount";                            TempVATAmountLine."Invoice Discount Amount" := "Inv. Discount Amount";                            TempVATAmountLine."VAT Clause Code" := "VAT Clause Code";                            TempVATAmountLine.InsertLine();                            TotalLineAmount += "Line Amount";                            TotalAmount += Amount;                            TotalAmountInclVAT += "Amount Including VAT";                            TotalInvDiscAmount += "Inv. Discount Amount";                            TypeInt := Type.AsInteger();                        end;                        trigger OnPreDataItem()                        begin                            TempVATAmountLine.DeleteAll();                            TempServiceShipmentBuffer.Reset();                            TempServiceShipmentBuffer.DeleteAll();                            FirstValueEntryNo := 0;                            if not FindLastMeaningfulLine("Service Invoice Line") then                                CurrReport.Break();                            SetFilter("Line No.", '<=%1', "Line No.");                            TotalLineAmount := 0;                            TotalAmount := 0;                            TotalAmountInclVAT := 0;                            TotalInvDiscAmount := 0;                        end;                    }                    dataitem(VATCounter; "Integer")                    {                        DataItemTableView = sorting(Number);                        column(VATAmtLineVATBase; TempVATAmountLine."VAT Base")                        {                            AutoFormatExpression = "Service Invoice Line".GetCurrencyCode();                            AutoFormatType = 1;                        }                        column(VATAmtLineVATAmount; TempVATAmountLine."VAT Amount")                        {                            AutoFormatExpression = "Service Invoice Header"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmtLineLineAmount; TempVATAmountLine."Line Amount")                        {                            AutoFormatExpression = "Service Invoice Header"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmtLineInvDiscBaseAmt; TempVATAmountLine."Inv. Disc. Base Amount")                        {                            AutoFormatExpression = "Service Invoice Header"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmtLineInvDiscAmount; TempVATAmountLine."Invoice Discount Amount")                        {                            AutoFormatExpression = "Service Invoice Header"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATAmountLineVAT; TempVATAmountLine."VAT %")                        {                            DecimalPlaces = 0 : 5;                        }                        column(VATAmtLineVATIdentifier; TempVATAmountLine."VAT Identifier")                        {                        }                        column(VATAmountLineVATCaption; VATAmountLineVATCaptionLbl)                        {                        }                        column(VATAmountLineVATBaseControl108Caption; VATAmountLineVATBaseControl108CaptionLbl)                        {                        }                        column(VATAmountLineVATAmountControl109Caption; VATAmountLineVATAmountControl109CaptionLbl)                        {                        }                        column(VATAmountSpecificationCaption; VATAmountSpecificationCaptionLbl)                        {                        }                        column(VATAmountLineVATIdentifierCaption; VATAmountLineVATIdentifierCaptionLbl)                        {                        }                        column(VATAmountLineInvDiscBaseAmountControl141Caption; VATAmountLineInvDiscBaseAmountControl141CaptionLbl)                        {                        }                        column(VATAmountLineLineAmountControl140Caption; VATAmountLineLineAmountControl140CaptionLbl)                        {                        }                        column(VATAmountLineVATBaseControl116Caption; VATAmountLineVATBaseControl116CaptionLbl)                        {                        }                        trigger OnAfterGetRecord()                        begin                            TempVATAmountLine.GetLine(Number);                        end;                        trigger OnPreDataItem()                        begin                            if TempVATAmountLine.GetTotalVATAmount() = 0 then                                CurrReport.Break();                            SetRange(Number, 1, TempVATAmountLine.Count);                        end;                    }                    dataitem(VATClauseEntryCounter; "Integer")                    {                        DataItemTableView = sorting(Number);                        column(VATClauseVATIdentifier; TempVATAmountLine."VAT Identifier")                        {                        }                        column(VATClauseCode; TempVATAmountLine."VAT Clause Code")                        {                        }                        column(VATClauseDescription; VATClauseText)                        {                        }                        column(VATClauseDescription2; VATClause."Description 2")                        {                        }                        column(VATClauseAmount; TempVATAmountLine."VAT Amount")                        {                            AutoFormatExpression = "Service Invoice Header"."Currency Code";                            AutoFormatType = 1;                        }                        column(VATClausesCaption; VATClausesCap)                        {                        }                        column(VATClauseVATIdentifierCaption; VATAmountLineVATIdentifierCaptionLbl)                        {                        }                        column(VATClauseVATAmtCaption; VATAmountLineVATAmountControl109CaptionLbl)                        {                        }                        trigger OnAfterGetRecord()                        begin                            TempVATAmountLine.GetLine(Number);                            if not VATClause.Get(TempVATAmountLine."VAT Clause Code") then                                CurrReport.Skip();                            VATClauseText := VATClause.GetDescriptionText("Service Invoice Header");                        end;                        trigger OnPreDataItem()                        begin                            Clear(VATClause);                            SetRange(Number, 1, TempVATAmountLine.Count);                        end;                    }                    dataitem(Total; "Integer")                    {                        DataItemTableView = sorting(Number) where(Number = const(1));                        column(PaymentTermsDescription; PaymentTerms.Description)                        {                        }                        column(PaymentTermsDescriptionCaption; PaymentTermsDescriptionCaptionLbl)                        {                        }                    }                    dataitem(Total2; "Integer")                    {                        DataItemTableView = sorting(Number) where(Number = const(1));                        column(CustNo_ServInvHeader; "Service Invoice Header"."Customer No.")                        {                        }                        column(CustNo_ServInvHeaderCaption; "Service Invoice Header".FieldCaption("Customer No."))                        {                        }                        column(ShipToAddr1; ShipToAddr[1])                        {                        }                        column(ShipToAddr2; ShipToAddr[2])                        {                        }                        column(ShipToAddr3; ShipToAddr[3])                        {                        }                        column(ShipToAddr4; ShipToAddr[4])                        {                        }                        column(ShipToAddr5; ShipToAddr[5])                        {                        }                        column(ShipToAddr6; ShipToAddr[6])                        {                        }                        column(ShipToAddr7; ShipToAddr[7])                        {                        }                        column(ShipToAddr8; ShipToAddr[8])                        {                        }                        column(ShiptoAddressCaption; ShiptoAddressCaptionLbl)                        {                        }                        column(ShipToPhoneNo; "Service Invoice Header"."Ship-to Phone")                        {                        }                        trigger OnPreDataItem()                        begin                            if not ShowShippingAddr then                                CurrReport.Break();                        end;                    }                    dataitem(LineFee; "Integer")                    {                        DataItemTableView = sorting(Number) order(ascending) where(Number = filter(1 ..));                        column(LineFeeCaptionLbl; TempLineFeeNoteOnReportHist.ReportText)                        {                        }                        trigger OnAfterGetRecord()                        begin                            if not DisplayAdditionalFeeNote 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;                    }                }                trigger OnAfterGetRecord()                begin                    if Number > 1 then begin                        CopyText := FormatDocument.GetCOPYText();                        OutputNo += 1;                    end;                end;                trigger OnPostDataItem()                begin                    if not IsReportInPreviewMode() then                        CODEUNIT.Run(CODEUNIT::"Service Inv.-Printed", "Service Invoice Header");                end;                trigger OnPreDataItem()                begin#if not CLEAN27                    NoOfLoops := Abs(NoOfCopies) + Cust."Invoice Copies" + 1;#else                    NoOfLoops := Abs(NoOfCopies) + 1;#endif                    if NoOfLoops <= 0 then                        NoOfLoops := 1;                    CopyText := '';                    SetRange(Number, 1, NoOfLoops);                    OutputNo := 1;                end;            }            trigger OnAfterGetRecord()            begin                CurrReport.Language := LanguageMgt.GetLanguageIdOrDefault("Language Code");                CurrReport.FormatRegion := LanguageMgt.GetFormatRegionOrDefault("Format Region");                FormatAddr.SetLanguageCode("Language Code");                FormatAddressFields("Service Invoice Header");                FormatDocumentFields("Service Invoice Header");                if not CompanyBankAccount.Get("Service Invoice Header"."Company Bank Account Code") then                    CompanyBankAccount.CopyBankFieldsFromCompanyInfo(CompanyInfo);                if not Cust.Get("Bill-to Customer No.") then                    Clear(Cust);                GetLineFeeNoteOnReportHist("No.");            end;        }    }    requestpage    {        AboutTitle = 'About Service - Invoice';        AboutText = 'Generate a service invoice that you can send to your customer.';        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(NoOfCopies; NoOfCopies)                    {                        ApplicationArea = Service;                        Caption = 'No. of Copies';                        ToolTip = 'Specifies how many copies of the document to print.';                    }                    field(ShowInternalInfo; ShowInternalInfo)                    {                        ApplicationArea = Service;                        Caption = 'Show Internal Information';                        ToolTip = 'Specifies if you want the printed report to show information that is only for internal use.';                    }                    field(DisplayAdditionalFeeNote; DisplayAdditionalFeeNote)                    {                        ApplicationArea = Service;                        Caption = 'Show Additional Fee Note';                        ToolTip = 'Specifies if you want notes about additional fees to be shown on the document.';                    }                }            }        }        actions        {        }    }    labels    {    }    trigger OnInitReport()    begin        GLSetup.Get();        CompanyInfo.Get();        ServiceSetup.Get();        FormatDocument.SetLogoPosition(ServiceSetup."Logo Position on Documents", CompanyInfo1, CompanyInfo2, CompanyInfo3);    end;    var        GLSetup: Record "General Ledger Setup";        PaymentTerms: Record "Payment Terms";        SalesPurchPerson: Record "Salesperson/Purchaser";        CompanyBankAccount: Record "Bank Account";        ServiceSetup: Record "Service Mgt. Setup";        Cust: Record Customer;        DimSetEntry: Record "Dimension Set Entry";        TempVATAmountLine: Record "VAT Amount Line" temporary;        VATClause: Record "VAT Clause";        RespCenter: Record "Responsibility Center";        TempServiceShipmentBuffer: Record "Service Shipment Buffer" temporary;        TempLineFeeNoteOnReportHist: Record "Line Fee Note on Report Hist." temporary;        LanguageMgt: Codeunit Language;        FormatAddr: Codeunit "Format Address";        FormatDocument: Codeunit "Format Document";        PostedShipmentDate: Date;        CustAddr: array[8] of Text[100];        ShipToAddr: array[8] of Text[100];        CompanyAddr: array[8] of Text[100];        OrderNoText: Text[80];        SalesPersonText: Text[50];        VATNoText: Text[80];        VATClauseText: Text;        ReferenceText: Text[80];        TotalText: Text[50];        TotalExclVATText: Text[50];        TotalInclVATText: Text[50];        NoOfCopies: Integer;        NoOfLoops: Integer;        CopyText: Text[30];        ShowShippingAddr: Boolean;        NextEntryNo: Integer;        FirstValueEntryNo: Integer;        OutputNo: Integer;        TypeInt: Integer;        DimText: Text[120];        ShowInternalInfo: Boolean;        TotalLineAmount: Decimal;        TotalAmount: Decimal;        TotalAmountInclVAT: Decimal;        TotalInvDiscAmount: Decimal;        DimTxtArrLength: Integer;        DimTxtArr: array[500] of Text[50];        IsServiceContractLine: Boolean;        AccNo: Code[20];        ServiceItemSerialNo: Code[50];        DisplayAdditionalFeeNote: Boolean;#pragma warning disable AA0074        Text004: Label 'Service - Invoice %1', Comment = '%1 = Document No.';#pragma warning disable AA0470        Text005: Label 'Page %1';#pragma warning restore AA0470#pragma warning restore AA0074        CompanyInfoPhoneNoCaptionLbl: Label 'Phone No.';        CompanyInfoFaxNoCaptionLbl: Label 'Fax No.';        CompanyInfoVATRegistrationNoCaptionLbl: Label 'VAT Reg. No.';        CompanyInfoGiroNoCaptionLbl: Label 'Giro No.';        CompanyInfoBankNameCaptionLbl: Label 'Bank';        CompanyInfoBankAccountNoCaptionLbl: Label 'Account No.';        AmountCaptionLbl: Label 'Amount';        ServiceInvoiceHeaderDueDateCaptionLbl: Label 'Due Date';        InvoiceNoCaptionLbl: Label 'Invoice No.';        ServiceInvoiceHeaderPostingDateCaptionLbl: Label 'Posting Date';        HeaderDimensionsCaptionLbl: Label 'Header Dimensions';        UnitPriceCaptionLbl: Label 'Unit Price';        ServiceInvoiceLineLineDiscountCaptionLbl: Label 'Disc. %';        PostedShipmentDateCaptionLbl: Label 'Posted Shipment Date';        SubtotalCaptionLbl: Label 'Subtotal';        LineAmountInvDiscountAmountAmountIncludingVATCaptionLbl: Label 'Payment Discount on VAT';        ShipmentCaptionLbl: Label 'Shipment';        LineDimensionsCaptionLbl: Label 'Line Dimensions';#pragma warning disable AA0074        VATClausesCap: Label 'VAT Clause';#pragma warning restore AA0074        VATAmountLineVATCaptionLbl: Label 'VAT %';        VATAmountLineVATBaseControl108CaptionLbl: Label 'VAT Base';        VATAmountLineVATAmountControl109CaptionLbl: Label 'VAT Amount';        VATAmountSpecificationCaptionLbl: Label 'VAT Amount Specification';        VATAmountLineVATIdentifierCaptionLbl: Label 'VAT Identifier';        VATAmountLineInvDiscBaseAmountControl141CaptionLbl: Label 'Inv. Disc. Base Amount';        VATAmountLineLineAmountControl140CaptionLbl: Label 'Line Amount';        VATAmountLineVATBaseControl116CaptionLbl: Label 'Total';        PaymentTermsDescriptionCaptionLbl: Label 'Payment Terms';        ShiptoAddressCaptionLbl: Label 'Ship-to Address';        InvDiscountAmountCaptionLbl: Label 'Invoice Discount Amount';        QuantityCaptionLbl: Label 'Qty';        SerialNoCaptionLbl: Label 'Serial No.';    protected var        CompanyInfo: Record "Company Information";        CompanyInfo1: Record "Company Information";        CompanyInfo2: Record "Company Information";        CompanyInfo3: Record "Company Information";    procedure FindPostedShipmentDate(): Date    var        ServiceShipmentHeader: Record "Service Shipment Header";        TempServiceShipmentBuffer2: Record "Service Shipment Buffer" temporary;    begin        NextEntryNo := 1;        if "Service Invoice Line"."Shipment No." <> '' then            if ServiceShipmentHeader.Get("Service Invoice Line"."Shipment No.") then                exit(ServiceShipmentHeader."Posting Date");        if "Service Invoice Header"."Order No." = '' then            exit("Service Invoice Header"."Posting Date");        if "Service Invoice Line".Type = "Service Invoice Line".Type::" " then            exit(0D);        GenerateBufferFromShipment("Service Invoice Line");        TempServiceShipmentBuffer.Reset();        TempServiceShipmentBuffer.SetRange("Document No.", "Service Invoice Line"."Document No.");        TempServiceShipmentBuffer.SetRange("Line No.", "Service Invoice Line"."Line No.");        if TempServiceShipmentBuffer.Find('-') then begin            TempServiceShipmentBuffer2 := TempServiceShipmentBuffer;            if TempServiceShipmentBuffer.Next() = 0 then begin                TempServiceShipmentBuffer.Get(                  TempServiceShipmentBuffer2."Document No.", TempServiceShipmentBuffer2."Line No.", TempServiceShipmentBuffer2."Entry No.");                TempServiceShipmentBuffer.Delete();                exit(TempServiceShipmentBuffer2."Posting Date");            end;            TempServiceShipmentBuffer.CalcSums(Quantity);            if TempServiceShipmentBuffer.Quantity <> "Service Invoice Line".Quantity then begin                TempServiceShipmentBuffer.DeleteAll();                exit("Service Invoice Header"."Posting Date");            end;        end else            exit("Service Invoice Header"."Posting Date");    end;    procedure GenerateBufferFromValueEntry(ServiceInvoiceLine2: Record "Service Invoice Line")    var        ValueEntry: Record "Value Entry";        ItemLedgerEntry: Record "Item Ledger Entry";        TotalQuantity: Decimal;        Quantity: Decimal;    begin        TotalQuantity := ServiceInvoiceLine2."Quantity (Base)";        ValueEntry.SetCurrentKey("Document No.");        ValueEntry.SetRange("Document No.", ServiceInvoiceLine2."Document No.");        ValueEntry.SetRange("Posting Date", "Service Invoice Header"."Posting Date");        ValueEntry.SetRange("Item Charge No.", '');        ValueEntry.SetFilter("Entry No.", '%1..', FirstValueEntryNo);        if ValueEntry.Find('-') then            repeat                if ItemLedgerEntry.Get(ValueEntry."Item Ledger Entry No.") then begin                    if ServiceInvoiceLine2."Qty. per Unit of Measure" <> 0 then                        Quantity := ValueEntry."Invoiced Quantity" / ServiceInvoiceLine2."Qty. per Unit of Measure"                    else                        Quantity := ValueEntry."Invoiced Quantity";                    AddBufferEntry(                      ServiceInvoiceLine2,                      -Quantity,                      ItemLedgerEntry."Posting Date");                    TotalQuantity := TotalQuantity + ValueEntry."Invoiced Quantity";                end;                FirstValueEntryNo := ValueEntry."Entry No." + 1;            until (ValueEntry.Next() = 0) or (TotalQuantity = 0);    end;    procedure GenerateBufferFromShipment(ServiceInvoiceLine: Record "Service Invoice Line")    var        ServiceInvoiceHeader: Record "Service Invoice Header";        ServiceInvoiceLine2: Record "Service Invoice Line";        ServiceShipmentHeader: Record "Service Shipment Header";        ServiceShipmentLine: Record "Service Shipment Line";        TotalQuantity: Decimal;        Quantity: Decimal;    begin        TotalQuantity := 0;        ServiceInvoiceHeader.SetCurrentKey("Order No.");        ServiceInvoiceHeader.SetFilter("No.", '..%1', "Service Invoice Header"."No.");        ServiceInvoiceHeader.SetRange("Order No.", "Service Invoice Header"."Order No.");        if ServiceInvoiceHeader.Find('-') then            repeat                ServiceInvoiceLine2.SetRange("Document No.", ServiceInvoiceHeader."No.");                ServiceInvoiceLine2.SetRange("Line No.", ServiceInvoiceLine."Line No.");                ServiceInvoiceLine2.SetRange(Type, ServiceInvoiceLine.Type);                ServiceInvoiceLine2.SetRange("No.", ServiceInvoiceLine."No.");                ServiceInvoiceLine2.SetRange("Unit of Measure Code", ServiceInvoiceLine."Unit of Measure Code");                if ServiceInvoiceLine2.Find('-') then                    repeat                        TotalQuantity := TotalQuantity + ServiceInvoiceLine2.Quantity;                    until ServiceInvoiceLine2.Next() = 0;            until ServiceInvoiceHeader.Next() = 0;        ServiceShipmentLine.SetCurrentKey("Order No.", "Order Line No.");        ServiceShipmentLine.SetRange("Order No.", "Service Invoice Header"."Order No.");        ServiceShipmentLine.SetRange("Order Line No.", ServiceInvoiceLine."Line No.");        ServiceShipmentLine.SetRange("Line No.", ServiceInvoiceLine."Line No.");        ServiceShipmentLine.SetRange(Type, ServiceInvoiceLine.Type);        ServiceShipmentLine.SetRange("No.", ServiceInvoiceLine."No.");        ServiceShipmentLine.SetRange("Unit of Measure Code", ServiceInvoiceLine."Unit of Measure Code");        ServiceShipmentLine.SetFilter(Quantity, '<>%1', 0);        if ServiceShipmentLine.Find('-') then            repeat                if Abs(ServiceShipmentLine.Quantity) <= Abs(TotalQuantity - ServiceInvoiceLine.Quantity) then                    TotalQuantity := TotalQuantity - ServiceShipmentLine.Quantity                else begin                    if Abs(ServiceShipmentLine.Quantity) > Abs(TotalQuantity) then                        ServiceShipmentLine.Quantity := TotalQuantity;                    Quantity :=                      ServiceShipmentLine.Quantity - (TotalQuantity - ServiceInvoiceLine.Quantity);                    TotalQuantity := TotalQuantity - ServiceShipmentLine.Quantity;                    ServiceInvoiceLine.Quantity := ServiceInvoiceLine.Quantity - Quantity;                    if ServiceShipmentHeader.Get(ServiceShipmentLine."Document No.") then                        AddBufferEntry(                          ServiceInvoiceLine,                          Quantity,                          ServiceShipmentHeader."Posting Date");                end;            until (ServiceShipmentLine.Next() = 0) or (TotalQuantity = 0);    end;    procedure AddBufferEntry(ServiceInvoiceLine: Record "Service Invoice Line"; QtyOnShipment: Decimal; PostingDate: Date)    begin        TempServiceShipmentBuffer.SetRange("Document No.", ServiceInvoiceLine."Document No.");        TempServiceShipmentBuffer.SetRange("Line No.", ServiceInvoiceLine."Line No.");        TempServiceShipmentBuffer.SetRange("Posting Date", PostingDate);        if TempServiceShipmentBuffer.Find('-') then begin            TempServiceShipmentBuffer.Quantity := TempServiceShipmentBuffer.Quantity + QtyOnShipment;            TempServiceShipmentBuffer.Modify();            exit;        end;        TempServiceShipmentBuffer."Document No." := ServiceInvoiceLine."Document No.";        TempServiceShipmentBuffer."Line No." := ServiceInvoiceLine."Line No.";        TempServiceShipmentBuffer."Entry No." := NextEntryNo;        TempServiceShipmentBuffer.Type := ServiceInvoiceLine.Type;        TempServiceShipmentBuffer."No." := ServiceInvoiceLine."No.";        TempServiceShipmentBuffer.Quantity := QtyOnShipment;        TempServiceShipmentBuffer."Posting Date" := PostingDate;        TempServiceShipmentBuffer.Insert();        NextEntryNo := NextEntryNo + 1    end;    local procedure DocumentCaption(): Text[250]    var        DocCaption: Text;    begin        OnBeforeGetDocumentCaption("Service Invoice Header", DocCaption);        if DocCaption <> '' then            exit(DocCaption);        exit(Text004);    end;    procedure FindDimTxt(DimSetID: Integer)    var        Separation: Text[5];        i: Integer;        TxtToAdd: Text[120];        StartNewLine: Boolean;    begin        DimSetEntry.SetRange("Dimension Set ID", DimSetID);        DimTxtArrLength := 0;        for i := 1 to ArrayLen(DimTxtArr) do            DimTxtArr[i] := '';        if not DimSetEntry.FindSet() then            exit;        Separation := '; ';        repeat            TxtToAdd := DimSetEntry."Dimension Code" + ' - ' + DimSetEntry."Dimension Value Code";            if DimTxtArrLength = 0 then                StartNewLine := true            else                StartNewLine := StrLen(DimTxtArr[DimTxtArrLength]) + StrLen(Separation) + StrLen(TxtToAdd) > MaxStrLen(DimTxtArr[1]);            if StartNewLine then begin                DimTxtArrLength += 1;                DimTxtArr[DimTxtArrLength] := TxtToAdd            end else                DimTxtArr[DimTxtArrLength] := DimTxtArr[DimTxtArrLength] + Separation + TxtToAdd;        until DimSetEntry.Next() = 0;    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("Service Invoice Header"."Bill-to 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 GetServiceItemSerialNo(ServiceItemNo: Code[20]): Code[50]    var        ServiceItem: Record "Service Item";    begin        if ServiceItem.Get(ServiceItemNo) then            exit(ServiceItem."Serial No.");    end;    local procedure IsReportInPreviewMode(): Boolean    var        MailManagement: Codeunit "Mail Management";    begin        exit(CurrReport.Preview or MailManagement.IsHandlingGetEmailBody());    end;    local procedure FormatAddressFields(var ServiceInvoiceHeader: Record "Service Invoice Header")    var        ServiceFormatAddress: Codeunit "Service Format Address";    begin        FormatAddr.GetCompanyAddr(ServiceInvoiceHeader."Responsibility Center", RespCenter, CompanyInfo, CompanyAddr);        ServiceFormatAddress.ServiceInvBillTo(CustAddr, ServiceInvoiceHeader);        ShowShippingAddr := ServiceFormatAddress.ServiceInvShipTo(ShipToAddr, CustAddr, ServiceInvoiceHeader);    end;    local procedure FormatDocumentFields(ServiceInvoiceHeader: Record "Service Invoice Header")    begin        FormatDocument.SetTotalLabels(ServiceInvoiceHeader."Currency Code", TotalText, TotalInclVATText, TotalExclVATText);        FormatDocument.SetSalesPerson(SalesPurchPerson, ServiceInvoiceHeader."Salesperson Code", SalesPersonText);        FormatDocument.SetPaymentTerms(PaymentTerms, ServiceInvoiceHeader."Payment Terms Code", ServiceInvoiceHeader."Language Code");        OrderNoText := FormatDocument.SetText(ServiceInvoiceHeader."Order No." <> '', ServiceInvoiceHeader.FieldCaption("Order No."));        ReferenceText := FormatDocument.SetText(ServiceInvoiceHeader."Your Reference" <> '', ServiceInvoiceHeader.FieldCaption("Your Reference"));        VATNoText := FormatDocument.SetText(ServiceInvoiceHeader."VAT Registration No." <> '', ServiceInvoiceHeader.FieldCaption("VAT Registration No."));    end;    local procedure FindLastMeaningfulLine(var ServiceInvoiceLine: Record "Service Invoice Line") MoreLines: Boolean    var        ServiceInvLine: Record "Service Invoice Line";    begin        ServiceInvLine.Copy(ServiceInvoiceLine);        ServiceInvLine.SetCurrentKey("Document No.", "Line No.");        MoreLines := ServiceInvLine.Find('+');        while MoreLines and            (ServiceInvLine.Description = '') and (ServiceInvLine."No." = '') and            (ServiceInvLine.Quantity = 0) and (ServiceInvLine.Amount = 0)        do            MoreLines := ServiceInvLine.Next(-1) <> 0;        if MoreLines then            ServiceInvoiceLine := ServiceInvLine;    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetDocumentCaption(ServiceInvoiceHeader: Record "Service Invoice Header"; var DocCaption: Text)    begin    end;}