Report 5988 Contr. Serv. Orders - Test

Base Application, Microsoft.Service.Reports

src/Layers/W1/BaseApp/Service/Reports/ContrServOrdersTest.Report.al269 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.Reports;using Microsoft.Sales.Customer;using Microsoft.Service.Contract;using Microsoft.Service.Document;using Microsoft.Service.Setup;report 5988 "Contr. Serv. Orders - Test"{    DefaultLayout = RDLC;    RDLCLayout = './Service/Reports/ContrServOrdersTest.rdlc';    Caption = 'Contr. Serv. Orders - Test';    ToolTip = 'View the numbers of contracts, the numbers and the names of customers, as well as some other information relating to the service orders that are created for the period that you have specified. You can test which service contracts include service items that are due for service within the specified period.';    dataset    {        dataitem("Service Contract Header"; "Service Contract Header")        {            DataItemTableView = where("Contract Type" = const(Contract), "Change Status" = const(Locked), Status = const(Signed));            PrintOnlyIfDetail = true;            RequestFilterFields = "Contract No.";            column(FORMAT_TODAY_0_4_; Format(Today, 0, 4))            {            }            column(USERID; UserId)            {            }            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(StartDate; Format(StartDate))            {            }            column(EndDate; Format(EndDate))            {            }            column(Service_Contract_Header__TABLECAPTION__________ServContractFilters; TableCaption + ': ' + ServContractFilters)            {            }            column(ShowServContractFilters; ServContractFilters)            {            }            column(ShowFullBody; ShowFullBody)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(Contract_Service_Orders___TestCaption; Contract_Service_Orders___TestCaptionLbl)            {            }            column(StartDateCaption; StartDateCaptionLbl)            {            }            column(EndDateCaption; EndDateCaptionLbl)            {            }            column(Service_Contract_Line__Next_Planned_Service_Date_Caption; Service_Contract_Line__Next_Planned_Service_Date_CaptionLbl)            {            }            column(Service_Contract_Line__Last_Service_Date_Caption; Service_Contract_Line__Last_Service_Date_CaptionLbl)            {            }            column(Service_Contract_Line__Last_Planned_Service_Date_Caption; Service_Contract_Line__Last_Planned_Service_Date_CaptionLbl)            {            }            column(Service_Contract_Line_DescriptionCaption; "Service Contract Line".FieldCaption(Description))            {            }            column(Service_Contract_Line__Serial_No__Caption; "Service Contract Line".FieldCaption("Serial No."))            {            }            column(Service_Contract_Line__Contract_No__Caption; "Service Contract Line".FieldCaption("Contract No."))            {            }            column(Customer_No_Caption; Customer_No_CaptionLbl)            {            }            column(Customer_NameCaption; Customer_NameCaptionLbl)            {            }            dataitem("Service Contract Line"; "Service Contract Line")            {                DataItemLink = "Contract Type" = field("Contract Type"), "Contract No." = field("Contract No.");                DataItemTableView = sorting("Contract Type", "Contract No.", "Line No.") order(ascending) where("Service Period" = filter(<> ''));                column(Service_Contract_Line__Serial_No__; "Serial No.")                {                }                column(Service_Contract_Line__Last_Planned_Service_Date_; Format("Last Planned Service Date"))                {                }                column(Service_Contract_Line__Next_Planned_Service_Date_; Format("Next Planned Service Date"))                {                }                column(Service_Contract_Line__Last_Service_Date_; Format("Last Service Date"))                {                }                column(Service_Contract_Line_Description; Description)                {                }                column(Service_Contract_Line__Contract_No__; "Contract No.")                {                }                column(Cust__No__; Cust."No.")                {                }                column(Cust_Name; Cust.Name)                {                }                trigger OnAfterGetRecord()                begin                    if "Contract Expiration Date" <> 0D then begin                        if "Contract Expiration Date" <= "Next Planned Service Date" then                            CurrReport.Skip();                    end else                        if ("Service Contract Header"."Expiration Date" <> 0D) and                           ("Service Contract Header"."Expiration Date" <= "Next Planned Service Date")                        then                            CurrReport.Skip();                    Cust.Get("Service Contract Header"."Bill-to Customer No.");                    if Cust.Blocked = Cust.Blocked::All then                        CurrReport.Skip();                    ServHeader.SetCurrentKey("Contract No.", Status, "Posting Date");                    ServHeader.SetRange("Contract No.", "Contract No.");                    ServHeader.SetRange(Status, ServHeader.Status::Pending);                    if ServHeader.FindFirst() then begin                        ServItemLine.SetCurrentKey("Document Type", "Document No.", "Service Item No.");                        ServItemLine.SetRange("Document Type", ServHeader."Document Type");                        ServItemLine.SetRange("Document No.", ServHeader."No.");                        ServItemLine.SetRange("Contract No.", "Contract No.");                        ServItemLine.SetRange("Contract Line No.", "Line No.");                        OnBeforeFindServiceItemLine(                          ServItemLine, "Service Contract Header", "Service Contract Line", ServHeader);                        if ServItemLine.FindFirst() then                            CurrReport.Skip();                    end;                    if LastContractNo <> "Contract No." then begin                        LastContractNo := "Contract No.";                        ShowFullBody := true;                    end else                        ShowFullBody := false;                end;                trigger OnPreDataItem()                begin                    if EndDate = 0D then                        Error(Text000);                    if EndDate < StartDate then                        Error(Text001);                    if StartDate <> 0D then                        if EndDate - StartDate + 1 > ServMgtSetup."Contract Serv. Ord.  Max. Days" then                            Error(                              Text002,                              ServMgtSetup.TableCaption());                    if GetFilter("Contract No.") = '' then                        SetFilter("Contract No.", '<>%1', '');                    SetRange("Next Planned Service Date", StartDate, EndDate);                end;            }        }    }    requestpage    {        AboutTitle = 'About Contr. Serv. Orders - Test';        AboutText = 'Find service contracts that include service items that are due for service within a period you specify.';        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(StartDate; StartDate)                    {                        ApplicationArea = Service;                        Caption = 'Starting Date';                        ToolTip = 'Specifies the starting date for the period that you want to create contract service orders for. The report includes contracts with service items that have next planned service dates on or later than this date.';                    }                    field(EndingDate; EndDate)                    {                        ApplicationArea = Service;                        Caption = 'Ending Date';                        ToolTip = 'Specifies the ending date for the period that you want to create contract service orders for. ';                        trigger OnValidate()                        begin                            if EndDate < StartDate then                                Error(Text001);                        end;                    }                }            }        }        actions        {        }    }    labels    {    }    trigger OnInitReport()    begin        ServMgtSetup.Get();        if StartDate = 0D then            if ServMgtSetup."Last Contract Service Date" <> 0D then                StartDate := ServMgtSetup."Last Contract Service Date" + 1;    end;    trigger OnPreReport()    begin        ServContractFilters := "Service Contract Header".GetFilters();    end;    var        ServMgtSetup: Record "Service Mgt. Setup";        ServHeader: Record "Service Header";        Cust: Record Customer;        ServItemLine: Record "Service Item Line";        LastContractNo: Code[20];        StartDate: Date;        EndDate: Date;        ServContractFilters: Text;        ShowFullBody: Boolean;#pragma warning disable AA0074        Text000: Label 'You must fill in the ending date field.';        Text001: Label 'Starting Date is greater than Ending Date.';#pragma warning disable AA0470        Text002: Label 'The date range you have entered is a longer period than is allowed in the %1 table.';#pragma warning restore AA0470#pragma warning restore AA0074        CurrReport_PAGENOCaptionLbl: Label 'Page';        Contract_Service_Orders___TestCaptionLbl: Label 'Contract Service Orders - Test';        StartDateCaptionLbl: Label 'Starting Date';        EndDateCaptionLbl: Label 'Ending Date';        Service_Contract_Line__Next_Planned_Service_Date_CaptionLbl: Label 'Next Planned Service Date';        Service_Contract_Line__Last_Service_Date_CaptionLbl: Label 'Last Service Date';        Service_Contract_Line__Last_Planned_Service_Date_CaptionLbl: Label 'Last Planned Service Date';        Customer_No_CaptionLbl: Label 'Customer No.';        Customer_NameCaptionLbl: Label 'Customer Name';    procedure InitVariables(LocalStartDate: Date; LocalEndDate: Date)    begin        StartDate := LocalStartDate;        EndDate := LocalEndDate;    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFindServiceItemLine(var ServiceItemLine: Record "Service Item Line"; ServiceContractHeader: Record "Service Contract Header"; ServiceContractLine: Record "Service Contract Line"; ServiceHeader: Record "Service Header")    begin    end;}