Report 5987 Expired Contract Lines - Test

Base Application, Microsoft.Service.Reports

src/Layers/W1/BaseApp/Service/Reports/ExpiredContractLinesTest.Report.al196 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.Foundation.AuditCodes;using Microsoft.Service.Contract;using Microsoft.Service.Setup;report 5987 "Expired Contract Lines - Test"{    DefaultLayout = RDLC;    RDLCLayout = './Service/Reports/ExpiredContractLinesTest.rdlc';    Caption = 'Expired Contract Lines - Test';    ToolTip = 'View the service contract, the service items to be removed, the contract expiration dates, and the line amounts.';    dataset    {        dataitem("Service Contract Line"; "Service Contract Line")        {            DataItemTableView = sorting("Contract Type", "Contract No.", "Line No.") where("Contract Type" = const(Contract), "Contract Status" = const(Signed));            RequestFilterFields = "Contract No.", "Service Item No.";            column(FORMAT_TODAY_0_4_; Format(Today, 0, 4))            {            }            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(DelToDate; Format(DelToDate))            {            }            column(ReasonCode2_Code_________ReasonCode2_Description; ReasonCode2.Code + ' ' + ReasonCode2.Description)            {            }            column(Service_Contract_Line__TABLECAPTION__________ServItemFilters; TableCaption + ': ' + ServItemFilters)            {            }            column(ServItemFilters; ServItemFilters)            {            }            column(DescriptionLine; DescriptionLine)            {            }            column(Service_Contract_Line__Contract_No__; "Contract No.")            {            }            column(Service_Contract_Line_Description; Description)            {            }            column(Service_Contract_Line__Contract_Expiration_Date_; Format("Contract Expiration Date"))            {            }            column(Service_Contract_Line__Service_Item_No__; "Service Item No.")            {            }            column(Service_Contract_Line__Line_Amount_; "Line Amount")            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(Expired_Contract_Lines___TestCaption; Expired_Contract_Lines___TestCaptionLbl)            {            }            column(Delete_Contract_Lines_toCaption; Delete_Contract_Lines_toCaptionLbl)            {            }            column(Reason_CodeCaption; Reason_CodeCaptionLbl)            {            }            column(Service_Contract_Line__Contract_No__Caption; FieldCaption("Contract No."))            {            }            column(Service_Contract_Line__Service_Item_No__Caption; FieldCaption("Service Item No."))            {            }            column(Service_Contract_Line_DescriptionCaption; FieldCaption(Description))            {            }            column(Service_Contract_Line__Contract_Expiration_Date_Caption; Service_Contract_Line__Contract_Expiration_Date_CaptionLbl)            {            }            column(Service_Contract_Line__Line_Amount_Caption; FieldCaption("Line Amount"))            {            }            trigger OnAfterGetRecord()            begin                DescriptionLine := Text002;            end;            trigger OnPreDataItem()            begin                if DelToDate = 0D then                    Error(Text000);                ServMgtSetup.Get();                if ServMgtSetup."Use Contract Cancel Reason" then                    if ReasonCode2.Code = '' then                        Error(Text001);                if GetFilter("Contract No.") = '' then                    SetFilter("Contract No.", '<>%1', '');                SetFilter("Contract Expiration Date", '<>%1&<=%2', 0D, DelToDate);            end;        }    }    requestpage    {        AboutTitle = 'About Expired Contract Lines - Test';        AboutText = 'Find contract lines that are expired up to a date that you specify. Then remove them from the service contracts.';        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(DelToDate; DelToDate)                    {                        ApplicationArea = Service;                        Caption = 'Remove Lines to';                        ToolTip = 'Specifies the date up to which you want to check for expired contract lines. The report includes contract lines with contract expiration dates on or before this date.';                    }                    field(ReasonCode; ReasonCode2.Code)                    {                        ApplicationArea = Service;                        Caption = 'Reason Code';                        ToolTip = 'Specifies the reason code for the removal of lines from the contract. To see the existing reason codes, choose the field.';                        TableRelation = "Reason Code".Code;                        trigger OnValidate()                        begin                            ReasonCode2.Get(ReasonCode2.Code);                        end;                    }                    field("Reason Code"; ReasonCode2.Description)                    {                        ApplicationArea = Service;                        Caption = 'Reason Code Description';                        Editable = false;                        ToolTip = 'Specifies a description for the reason code.';                    }                }            }        }        actions        {        }    }    labels    {    }    trigger OnInitReport()    begin        if DelToDate = 0D then            DelToDate := WorkDate();        ServMgtSetup.Get();    end;    trigger OnPreReport()    begin        ServItemFilters := "Service Contract Line".GetFilters();    end;    var        ServMgtSetup: Record "Service Mgt. Setup";        ReasonCode2: Record "Reason Code";        DescriptionLine: Text[60];        DelToDate: Date;        ServItemFilters: Text;#pragma warning disable AA0074        Text000: Label 'You must fill in the Remove to field.';        Text001: Label 'You must fill in the Reason Code field.';        Text002: Label 'Would be removed';#pragma warning restore AA0074        CurrReport_PAGENOCaptionLbl: Label 'Page';        Expired_Contract_Lines___TestCaptionLbl: Label 'Expired Contract Lines - Test';        Delete_Contract_Lines_toCaptionLbl: Label 'Delete Contract Lines to';        Reason_CodeCaptionLbl: Label 'Reason Code';        Service_Contract_Line__Contract_Expiration_Date_CaptionLbl: Label 'Contract Expiration Date';    procedure InitVariables(LocalDelToDate: Date; NewReasonCode: Code[10])    begin        DelToDate := LocalDelToDate;        Clear(ReasonCode2);        if NewReasonCode <> '' then            ReasonCode2.Get(NewReasonCode);    end;}