Report 9091 Combine Service Shipments

Base Application, Microsoft.Service.Document

src/Layers/W1/BaseApp/Service/Document/CombineServiceShipments.Report.al583 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.Document;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Calculation;using Microsoft.Foundation.PaymentTerms;using Microsoft.Sales.Customer;using Microsoft.Sales.Setup;using Microsoft.Service.History;using Microsoft.Service.Posting;using System.Globalization;report 9091 "Combine Service Shipments"{    ApplicationArea = Service;    Caption = 'Combine Service Shipments';    ProcessingOnly = true;    UsageCategory = Tasks;    dataset    {        dataitem(ServiceOrderHeader; "Service Header")        {            DataItemTableView = sorting("Document Type", "Combine Shipments", "Customer No.", "Bill-to Customer No.", "Currency Code", "EU 3-Party Trade", "Dimension Set ID", "Journal Templ. Name") where("Document Type" = const(Order), "Combine Shipments" = const(true));            RequestFilterFields = "Customer No.", "Bill-to Customer No.";            RequestFilterHeading = 'Service Order';            dataitem("Service Shipment Header"; "Service Shipment Header")            {                DataItemLink = "Order No." = field("No.");                DataItemTableView = sorting("Order No.");                RequestFilterFields = "Posting Date";                RequestFilterHeading = 'Posted Service Shipment';                dataitem("Service Shipment Line"; "Service Shipment Line")                {                    DataItemLink = "Document No." = field("No.");                    DataItemTableView = sorting("Document No.", "Line No.");                    trigger OnAfterGetRecord()                    var                        CustIsBlocked: Boolean;                        IsHandled: Boolean;                    begin                        IsHandled := false;                        OnBeforeServiceShipmentLineOnAfterGetRecord("Service Shipment Line", IsHandled);                        if IsHandled then                            CurrReport.Skip();                        if Type = Type::" " then                            if (not CopyTextLines) or ("Attached to Line No." <> 0) then                                CurrReport.Skip();                        if ("Qty. Shipped Not Invoiced" <> 0) or (Type = Type::" ") then begin                            if ("Bill-to Customer No." <> Customer."No.") and                               ("Customer No." <> '')                            then                                if "Bill-to Customer No." <> '' then                                    Customer.Get("Bill-to Customer No.")                                else                                    if "Customer No." <> '' then                                        Customer.Get("Customer No.");                            CustIsBlocked := Customer.Blocked in [Customer.Blocked::All, Customer.Blocked::Invoice];                            OnBeforeCustIsBlockedOnAfterGetRecord(ServiceOrderHeader, ServiceHeader, "Service Shipment Line", Customer, CustIsBlocked);                            if not CustIsBlocked then begin                                if ShouldFinalizeServiceInvHeader(ServiceOrderHeader, ServiceHeader, "Service Shipment Line") then begin                                    if ServiceHeader."No." <> '' then                                        FinalizeServiceInvHeader();                                    InsertServiceInvHeader();                                    ServiceLine.SetRange("Document Type", ServiceHeader."Document Type");                                    ServiceLine.SetRange("Document No.", ServiceHeader."No.");                                    ServiceLine."Document Type" := ServiceHeader."Document Type";                                    ServiceLine."Document No." := ServiceHeader."No.";                                end;                                IsHandled := false;                                OnServiceShipmentLineBeforeInsertInvLineFromShptLine("Service Shipment Line", IsHandled);                                if not IsHandled then begin                                    ServiceShipmentLine := "Service Shipment Line";                                    HasAmount := HasAmount or ("Qty. Shipped Not Invoiced" <> 0);                                    OnServiceShipmentLineOnAfterGetRecordOnBeforeInsertInvLineFromShptLine(ServiceLine, ServiceShipmentLine);                                    ServiceShipmentLine.InsertInvLineFromShptLine(ServiceLine);                                end;                            end else                                NoOfServiceInvErrors := NoOfServiceInvErrors + 1;                        end;                    end;                }                trigger OnAfterGetRecord()                var                    DueDate: Date;                    PmtDiscDate: Date;                    PmtDiscPct: Decimal;                begin                    if GuiAllowed() then                        Window.Update(3, "No.");                    if IsCompletelyInvoiced() then                        CurrReport.Skip();                    if OnlyStdPmtTerms then begin                        Customer.Get("Bill-to Customer No.");                        PaymentTerms.Get(Customer."Payment Terms Code");                        if PaymentTerms.Code = "Payment Terms Code" then begin                            DueDate := CalcDate(PaymentTerms."Due Date Calculation", "Document Date");                            PmtDiscDate := CalcDate(PaymentTerms."Discount Date Calculation", "Document Date");                            PmtDiscPct := PaymentTerms."Discount %";                            if (DueDate <> "Due Date") or                               (PmtDiscDate <> "Pmt. Discount Date") or                               (PmtDiscPct <> "Payment Discount %")                            then begin                                NoOfskippedShiment := NoOfskippedShiment + 1;                                CurrReport.Skip();                            end;                        end else begin                            NoOfskippedShiment := NoOfskippedShiment + 1;                            CurrReport.Skip();                        end;                    end;                end;            }            trigger OnAfterGetRecord()            var                IsHandled: Boolean;            begin                IsHandled := false;                OnAfterGetRecordServiceOrderHeader(ServiceOrderHeader, IsHandled);                if IsHandled then                    CurrReport.Skip();                CurrReport.Language := LanguageMgt.GetLanguageIdOrDefault("Language Code");                CurrReport.FormatRegion := LanguageMgt.GetFormatRegionOrDefault("Format Region");                if GuiAllowed() then begin                    Window.Update(1, "Bill-to Customer No.");                    Window.Update(2, "No.");                end            end;            trigger OnPostDataItem()            begin                CurrReport.Language := ReportLanguage;                if ReportFormatRegion <> '' then                    CurrReport.FormatRegion := ReportFormatRegion;                if GuiAllowed() then                    Window.Close();                ShowResult();            end;            trigger OnPreDataItem()            begin                if PostingDateReq = 0D then                    Error(Text000);                if DocDateReq = 0D then                    Error(Text001);                if VATDateReq = 0D then                    Error(VATDateEmptyErr);                if GuiAllowed() then                    Window.Open(                      Text002 +                      Text003 +                      Text004 +                      Text005);                OnServiceOrderHeaderOnPreDataItem(ServiceOrderHeader);                ReportLanguage := CurrReport.Language();                ReportFormatRegion := CopyStr(CurrReport.FormatRegion(), 1, StrLen(ReportFormatRegion));            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(Content)            {                group(Options)                {                    Caption = 'Options';                    field(PostingDate; PostingDateReq)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Posting Date';                        ToolTip = 'Specifies the posting date for the invoice(s) that the batch job creates. This field must be filled in.';                        trigger OnValidate()                        begin                            UpdateVATDate();                        end;                    }                    field(DocDateReq; DocDateReq)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Document Date';                        ToolTip = 'Specifies the document date for the invoice(s) that the batch job creates. This field must be filled in.';                        trigger OnValidate()                        begin                            UpdateVATDate();                        end;                    }                    field(VATDate; VATDateReq)                    {                        ApplicationArea = VAT;                        Caption = 'VAT Date';                        Editable = VATDateEnabled;                        Visible = VATDateEnabled;                        ToolTip = 'Specifies the VAT Date for the invoice(s) that the batch job creates. This field must be filled in.';                    }                    field(CalcInvDisc; CalcInvDisc)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Calc. Inv. Discount';                        ToolTip = 'Specifies if you want the invoice discount amount to be automatically calculated on the shipment.';                        trigger OnValidate()                        begin                            SalesSetup.Get();                            SalesSetup.TestField("Calc. Inv. Discount", false);                        end;                    }                    field(PostInv; PostInv)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Post Invoices';                        ToolTip = 'Specifies if you want to have the invoices posted immediately.';                    }                    field(OnlyStdPmtTerms; OnlyStdPmtTerms)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Only Std. Payment Terms';                        ToolTip = 'Specifies if you want to include shipments with standard payments terms. If you select this option, you must manually invoice all other shipments.';                    }                    field(CopyTextLines; CopyTextLines)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Copy Text Lines';                        ToolTip = 'Specifies if you want manually written text on the shipment lines to be copied to the invoice.';                    }                }            }        }        trigger OnOpenPage()        var            VATReportingDateMgt: Codeunit "VAT Reporting Date Mgt";            IsHandled: Boolean;        begin            IsHandled := false;            OnBeforeOnOpenPage(IsHandled);            if IsHandled then                exit;            if PostingDateReq = 0D then                PostingDateReq := WorkDate();            if DocDateReq = 0D then                DocDateReq := WorkDate();            if VATDateReq = 0D then                VATDateReq := GeneralLedgerSetup.GetVATDate(PostingDateReq, DocDateReq);            SalesSetup.Get();            CalcInvDisc := SalesSetup."Calc. Inv. Discount";            VATDateEnabled := VATReportingDateMgt.IsVATDateEnabled();        end;    }    labels    {    }    trigger OnPostReport()    begin        OnBeforePostReport();    end;    trigger OnPreReport()    begin        OnBeforePreReport();    end;    var        Customer: Record Customer;        GeneralLedgerSetup: Record "General Ledger Setup";        PaymentTerms: Record "Payment Terms";        SalesSetup: Record "Sales & Receivables Setup";        ServiceCalcDiscount: Codeunit "Service-Calc. Discount";        ServicePost: Codeunit "Service-Post";        HideDialog: Boolean;        Window: Dialog;        NoOfServiceInv: Integer;        NoOfskippedShiment: Integer;        NotAllInvoicesCreatedMsg: Label 'Not all the invoices were created. A total of %1 invoices were not created.', Comment = '%1-Number of invoices';        Text000: Label 'Enter the posting date.';        Text001: Label 'Enter the document date.';        Text002: Label 'Combining shipments...\\';        Text003: Label 'Customer No.    #1##########\';        Text004: Label 'Order No.       #2##########\';        Text005: Label 'Shipment No.    #3##########';        Text007: Label 'Not all the invoices were posted. A total of %1 invoices were not posted.';        Text008: Label 'There is nothing to combine.';        Text010: Label 'The shipments are now combined and the number of invoices created is %1.';        Text011: Label 'The shipments are now combined, and the number of invoices created is %1.\%2 Shipments with nonstandard payment terms have not been combined.', Comment = '%1-Number of invoices,%2-Number Of shipments';        VATDateEmptyErr: Label 'Enter the VAT date.';    protected var        ServiceHeader: Record "Service Header";        ServiceLine: Record "Service Line";        ServiceShipmentLine: Record "Service Shipment Line";        LanguageMgt: Codeunit Language;        CalcInvDisc: Boolean;        CopyTextLines: Boolean;        HasAmount: Boolean;        OnlyStdPmtTerms: Boolean;        PostInv: Boolean;        VATDateEnabled: Boolean;        DocDateReq: Date;        PostingDateReq: Date;        VATDateReq: Date;        NoOfServiceInvErrors: Integer;        ReportLanguage: Integer;        ReportFormatRegion: Text[80];    local procedure FinalizeServiceInvHeader()    var        HasError: Boolean;        ShouldPostInv: Boolean;    begin        HasError := false;        OnBeforeFinalizeServiceInvHeader(ServiceHeader, HasAmount, HasError);        if HasError then            NoOfServiceInvErrors += 1;        if (not HasAmount) or HasError then begin            OnFinalizeServiceInvHeaderOnBeforeDelete(ServiceHeader);            ServiceHeader.Delete(true);            OnFinalizeServiceInvHeaderOnAfterDelete(ServiceHeader);            exit;        end;        OnFinalizeServiceInvHeader(ServiceHeader);        if CalcInvDisc then            ServiceCalcDiscount.Run(ServiceLine);        ServiceHeader.Find();        Commit();        Clear(ServiceCalcDiscount);        Clear(ServicePost);        NoOfServiceInv := NoOfServiceInv + 1;        ShouldPostInv := PostInv;        OnFinalizeServiceInvHeaderOnAfterCalcShouldPostInv(ServiceHeader, NoOfServiceInv, ShouldPostInv);        if ShouldPostInv then begin            Clear(ServicePost);            if not ServicePost.Run(ServiceHeader) then                NoOfServiceInvErrors := NoOfServiceInvErrors + 1;        end;    end;    local procedure InsertServiceInvHeader()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeInsertServiceInvHeader(ServiceHeader, ServiceOrderHeader, "Service Shipment Header", "Service Shipment Line", NoOfServiceInv, HasAmount, IsHandled);        if not IsHandled then begin            GeneralLedgerSetup.Get();            Clear(ServiceHeader);            ServiceHeader.Init();            ServiceHeader."Document Type" := ServiceHeader."Document Type"::Invoice;            ServiceHeader."No." := '';            OnBeforeServiceInvHeaderInsert(ServiceHeader, ServiceOrderHeader);            ServiceHeader.Insert(true);            ValidateCustomerNo(ServiceHeader, ServiceOrderHeader);            ServiceHeader.Validate("Posting Date", PostingDateReq);            ServiceHeader.Validate("Document Date", DocDateReq);            ServiceHeader.Validate("VAT Reporting Date", VATDateReq);            ServiceHeader.Validate("Currency Code", ServiceOrderHeader."Currency Code");            ServiceHeader.Validate("EU 3-Party Trade", ServiceOrderHeader."EU 3-Party Trade");            if GeneralLedgerSetup."Journal Templ. Name Mandatory" then                ServiceHeader.Validate("Journal Templ. Name", ServiceOrderHeader."Journal Templ. Name");            ServiceHeader."Salesperson Code" := ServiceOrderHeader."Salesperson Code";            ServiceHeader."Shortcut Dimension 1 Code" := ServiceOrderHeader."Shortcut Dimension 1 Code";            ServiceHeader."Shortcut Dimension 2 Code" := ServiceOrderHeader."Shortcut Dimension 2 Code";            ServiceHeader."Dimension Set ID" := ServiceOrderHeader."Dimension Set ID";            OnBeforeServiceInvHeaderModify(ServiceHeader, ServiceOrderHeader);            ServiceHeader.Modify();            Commit();            HasAmount := false;        end;        OnAfterInsertServiceInvHeader(ServiceHeader, "Service Shipment Header");    end;    procedure InitializeRequest(NewPostingDate: Date; NewDocDate: Date; NewCalcInvDisc: Boolean; NewPostInv: Boolean; NewOnlyStdPmtTerms: Boolean; NewCopyTextLines: Boolean)    begin        PostingDateReq := NewPostingDate;        DocDateReq := NewDocDate;        VATDateReq := GeneralLedgerSetup.GetVATDate(PostingDateReq, DocDateReq);        CalcInvDisc := NewCalcInvDisc;        PostInv := NewPostInv;        OnlyStdPmtTerms := NewOnlyStdPmtTerms;        CopyTextLines := NewCopyTextLines;    end;    procedure InitializeRequest(NewPostingDate: Date; NewDocDate: Date; NewVATDate: Date; NewCalcInvDisc: Boolean; NewPostInv: Boolean; NewOnlyStdPmtTerms: Boolean; NewCopyTextLines: Boolean)    begin        InitializeRequest(NewPostingDate, NewDocDate, NewCalcInvDisc, NewPostInv, NewOnlyStdPmtTerms, NewCopyTextLines);        VATDateReq := NewVATDate;    end;    local procedure ValidateCustomerNo(var ToServiceHeader: Record "Service Header"; FromServiceOrderHeader: Record "Service Header")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeValidateCustomerNo(ToServiceHeader, FromServiceOrderHeader, "Service Shipment Header", "Service Shipment Line", IsHandled);        if IsHandled then            exit;        ToServiceHeader.Validate("Customer No.", FromServiceOrderHeader."Customer No.");        ToServiceHeader.Validate("Bill-to Customer No.", FromServiceOrderHeader."Bill-to Customer No.");    end;    procedure SetHideDialog(NewHideDialog: Boolean)    begin        HideDialog := NewHideDialog;    end;    local procedure ShowResult()    begin        OnBeforeShowResult(ServiceHeader, NoOfServiceInvErrors, PostInv);        if ServiceHeader."No." <> '' then begin // Not the first time            FinalizeServiceInvHeader();            OnServiceShipmentHeaderOnAfterFinalizeServiceInvHeader(ServiceHeader, NoOfServiceInvErrors, PostInv, HideDialog);            if (NoOfServiceInvErrors = 0) and not HideDialog then begin                if NoOfskippedShiment > 0 then                    Message(Text011, NoOfServiceInv, NoOfskippedShiment)                else                    Message(Text010, NoOfServiceInv);            end else                if not HideDialog then                    if PostInv then                        Message(Text007, NoOfServiceInvErrors)                    else                        Message(NotAllInvoicesCreatedMsg, NoOfServiceInvErrors)        end else            if not HideDialog then                Message(Text008);    end;    local procedure ShouldFinalizeServiceInvHeader(ServiceOrderHeader: Record "Service Header"; ServiceHeader: Record "Service Header"; ServiceShipmentLine: Record "Service Shipment Line") Finalize: Boolean    begin        Finalize :=          (ServiceOrderHeader."Customer No." <> ServiceHeader."Customer No.") or          (ServiceOrderHeader."Bill-to Customer No." <> ServiceHeader."Bill-to Customer No.") or          (ServiceOrderHeader."Currency Code" <> ServiceHeader."Currency Code") or          (ServiceOrderHeader."EU 3-Party Trade" <> ServiceHeader."EU 3-Party Trade") or          (ServiceOrderHeader."Dimension Set ID" <> ServiceHeader."Dimension Set ID") or          (ServiceOrderHeader."Journal Templ. Name" <> ServiceHeader."Journal Templ. Name");        OnAfterShouldFinalizeServiceInvHeader(ServiceOrderHeader, ServiceHeader, Finalize, ServiceShipmentLine, "Service Shipment Header");        exit(Finalize);    end;    local procedure UpdateVATDate()    begin        VATDateReq := GeneralLedgerSetup.GetVATDate(PostingDateReq, DocDateReq);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetRecordServiceOrderHeader(var ServiceOrderHeader: Record "Service Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInsertServiceInvHeader(var ServiceHeader: Record "Service Header"; var ServiceShipmentHeader: Record "Service Shipment Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFinalizeServiceInvHeader(var ServiceHeader: Record "Service Header"; var HasAmount: Boolean; var HasError: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertServiceInvHeader(var ServiceInvoiceHeader: Record "Service Header"; ServiceOrderHeader: Record "Service Header"; ServiceShipmentHeader: Record "Service Shipment Header"; ServiceShipmentLine: Record "Service Shipment Line"; var NoOfServiceInv: Integer; var HasAmount: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforePreReport()    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforePostReport()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeServiceInvHeaderInsert(var ServiceHeader: Record "Service Header"; ServiceOrderHeader: Record "Service Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeShowResult(var ServiceInvoiceHeader: Record "Service Header"; var NoOfServiceInvErrors: Integer; PostInvoice: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeServiceInvHeaderModify(var ServiceHeader: Record "Service Header"; ServiceOrderHeader: Record "Service Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeServiceShipmentLineOnAfterGetRecord(var ServiceShipmentLine: Record "Service Shipment Line"; var IsHandled: Boolean);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateCustomerNo(var ToServiceHeader: Record "Service Header"; var FromServiceOrderHeader: Record "Service Header"; ServiceShipmentHeader: Record "Service Shipment Header"; ServiceShipmentLine: Record "Service Shipment Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFinalizeServiceInvHeader(var ServiceHeader: Record "Service Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFinalizeServiceInvHeaderOnAfterDelete(var ServiceHeader: Record "Service Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFinalizeServiceInvHeaderOnAfterCalcShouldPostInv(var ServiceHeader: Record "Service Header"; var NoOfServiceInv: Integer; var ShouldPostInv: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFinalizeServiceInvHeaderOnBeforeDelete(var ServiceHeader: Record "Service Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnServiceOrderHeaderOnPreDataItem(var ServiceOrderHeader: Record "Service Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterShouldFinalizeServiceInvHeader(var ServiceOrderHeader: Record "Service Header"; ServiceHeader: Record "Service Header"; var Finalize: Boolean; ServiceShipmentLine: Record "Service Shipment Line"; ServiceShipmentHeader: Record "Service Shipment Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnServiceShipmentLineOnAfterGetRecordOnBeforeInsertInvLineFromShptLine(var ServiceLine: Record "Service Line"; var ServiceShipmentLine: Record "Service Shipment Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnServiceShipmentLineBeforeInsertInvLineFromShptLine(ServiceShipmentLine: Record "Service Shipment Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnServiceShipmentHeaderOnAfterFinalizeServiceInvHeader(var ServiceHeader: Record "Service Header"; var NoOfServiceInvErrors: Integer; PostInvoice: Boolean; var HideDialog: Boolean)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeOnOpenPage(var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCustIsBlockedOnAfterGetRecord(OrderServiceHeader: Record "Service Header"; ServiceHeader: Record "Service Header"; ServiceShipmentLine: Record "Service Shipment Line"; Customer: Record Customer; var CustIsBlocked: Boolean)    begin    end;}