Report 5902 Service Quote

Base Application, Microsoft.Service.Document

src/Layers/W1/BaseApp/Service/Document/ServiceQuote.Report.al759 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.CRM.Contact;using Microsoft.CRM.Interaction;using Microsoft.CRM.Segment;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Address;using Microsoft.Foundation.Company;using Microsoft.Inventory.Location;using Microsoft.Sales.Customer;using Microsoft.Service.Archive;using Microsoft.Service.Comment;using Microsoft.Service.Setup;using Microsoft.Utilities;using System.Email;using System.Globalization;using System.Utilities;report 5902 "Service Quote"{    DefaultLayout = RDLC;    RDLCLayout = './Service/Document/ServiceQuote.rdlc';    Caption = 'Service Quote';    WordMergeDataItem = "Service Header";    dataset    {        dataitem("Service Header"; "Service Header")        {            DataItemTableView = sorting("Document Type", "No.") where("Document Type" = const(Quote));            RequestFilterFields = "No.", "Customer No.";            column(DocumentType_ServHeader; "Document Type")            {            }            column(No_ServHeader; "No.")            {            }            column(HomePageCaption; HomePageCaptionLbl)            {            }            column(EmailCaption; EmailCaptionLbl)            {            }            dataitem(CopyLoop; "Integer")            {                DataItemTableView = sorting(Number);                dataitem(PageLoop; "Integer")                {                    DataItemTableView = sorting(Number) where(Number = const(1));                    column(CompanyInfo1Picture; CompanyInfo1.Picture)                    {                    }                    column(CompanyInfo2Picture; CompanyInfo2.Picture)                    {                    }                    column(CompanyInfo3Picture; CompanyInfo3.Picture)                    {                    }                    column(HomePage; CompanyInfo."Home Page")                    {                    }                    column(Email; CompanyInfo."E-Mail")                    {                    }                    column(OrderTime_ServHeader; "Service Header"."Order Time")                    {                    }                    column(OrderDate_ServHeader; Format("Service Header"."Order Date"))                    {                    }                    column(Status_ServHeader; "Service Header".Status)                    {                    }                    column(No1_ServHeader; "Service Header"."No.")                    {                    }                    column(CustAddr6; CustAddr[6])                    {                    }                    column(CustAddr5; CustAddr[5])                    {                    }                    column(CustAddr4; CustAddr[4])                    {                    }                    column(CustAddr3; CustAddr[3])                    {                    }                    column(CustAddr2; CustAddr[2])                    {                    }                    column(CustAddr1; CustAddr[1])                    {                    }                    column(CompanyAddr7; CompanyAddr[7])                    {                    }                    column(CompanyAddr8; CompanyAddr[8])                    {                    }                    column(CompanyAddr6; CompanyAddr[6])                    {                    }                    column(CompanyAddr5; CompanyAddr[5])                    {                    }                    column(BilltoName_ServHeader; "Service Header"."Bill-to Name")                    {                    }                    column(CompanyAddr4; CompanyAddr[4])                    {                    }                    column(CompanyAddr3; CompanyAddr[3])                    {                    }                    column(CompanyAddr2; CompanyAddr[2])                    {                    }                    column(CompanyAddr1; CompanyAddr[1])                    {                    }                    column(OrderConfirmationCopyText; StrSubstNo(Text001, CopyText))                    {                    }                    column(CompanyInfoPhoneNo; CompanyInfo."Phone No.")                    {                    }                    column(EMail_ServHeader; "Service Header"."E-Mail")                    {                    }                    column(PhoneNo_ServHeader; "Service Header"."Phone No.")                    {                    }                    column(OutputNo; OutputNo)                    {                    }                    column(PageCaption; StrSubstNo(Text002, ''))                    {                    }                    column(SerHdrOrderDateCaption; SerHdrOrderDateCaptionLbl)                    {                    }                    column(InvoicetoCaption; InvoicetoCaptionLbl)                    {                    }                    column(CompanyInfoPhoneNoCaption; CompanyInfoPhoneNoCaptionLbl)                    {                    }                    column(ServiceHeaderEMailCaption; ServiceHeaderEMailCaptionLbl)                    {                    }                    column(OrderTime_ServHeaderCaption; "Service Header".FieldCaption("Order Time"))                    {                    }                    column(Status_ServHeaderCaption; "Service Header".FieldCaption(Status))                    {                    }                    column(No1_ServHeaderCaption; "Service Header".FieldCaption("No."))                    {                    }                    dataitem(DimensionLoop1; "Integer")                    {                        DataItemTableView = sorting(Number) where(Number = filter(1 ..));                        column(DimText; DimText)                        {                        }                        column(DimensionLoopNumber; Number)                        {                        }                        column(HeaderDimensionsCaption; HeaderDimensionsCaptionLbl)                        {                        }                        trigger OnAfterGetRecord()                        begin                            if Number = 1 then begin                                if not DimSetEntry1.FindSet() then                                    CurrReport.Break();                            end else                                if not Continue then                                    CurrReport.Break();                            Clear(DimText);                            Continue := false;                            repeat                                OldDimText := DimText;                                if DimText = '' then                                    DimText := StrSubstNo('%1 %2', DimSetEntry1."Dimension Code", DimSetEntry1."Dimension Value Code")                                else                                    DimText :=                                      StrSubstNo(                                        '%1, %2 %3', DimText,                                        DimSetEntry1."Dimension Code", DimSetEntry1."Dimension Value Code");                                if StrLen(DimText) > MaxStrLen(OldDimText) then begin                                    DimText := OldDimText;                                    Continue := true;                                    exit;                                end;                            until DimSetEntry1.Next() = 0;                        end;                        trigger OnPreDataItem()                        begin                            if not ShowInternalInfo then                                CurrReport.Break();                        end;                    }                    dataitem("Service Order Comment"; "Service Comment Line")                    {                        DataItemLink = "Table Subtype" = field("Document Type"), "No." = field("No.");                        DataItemLinkReference = "Service Header";                        DataItemTableView = sorting("Table Name", "Table Subtype", "No.", Type, "Table Line No.", "Line No.") where("Table Name" = const("Service Header"), Type = const(General));                        column(LineNo_ServOrderComment; "Line No.")                        {                        }                        column(TblSubtype_ServOrderComm; "Table Subtype")                        {                        }                        column(Type_ServOrderComment; Type)                        {                        }                    }                    dataitem("Service Item Line"; "Service Item Line")                    {                        DataItemLink = "Document Type" = field("Document Type"), "Document No." = field("No.");                        DataItemLinkReference = "Service Header";                        DataItemTableView = sorting("Document Type", "Document No.", "Line No.");                        column(ShowInternalInfo; ShowInternalInfo)                        {                        }                        column(SerialNo_ServLineType; "Serial No.")                        {                        }                        column(Description_ServLineType; Description)                        {                        }                        column(ServItemNo_ServLineType; "Service Item No.")                        {                        }                        column(SerItmGrCode_ServLineType; "Service Item Group Code")                        {                        }                        column(Warranty_ServLineType; Warranty)                        {                        }                        column(ItemNo_ServLineType; "Item No.")                        {                        }                        column(LoanerNo_ServLineType; "Loaner No.")                        {                        }                        column(ServShelfNo_ServLineType; "Service Shelf No.")                        {                        }                        column(Warranty1_ServLineType; Format(Warranty))                        {                        }                        column(DocNo_ServLineType; "Document No.")                        {                        }                        column(LineNo_ServLineType; "Line No.")                        {                        }                        column(ServiceItemLinesCaption; ServiceItemLinesCaptionLbl)                        {                        }                        column(SerialNo_ServLineTypeCaption; FieldCaption("Serial No."))                        {                        }                        column(Description_ServLineTypeCaption; FieldCaption(Description))                        {                        }                        column(ServItemNo_ServLineTypeCaption; FieldCaption("Service Item No."))                        {                        }                        column(SerItmGrCode_ServLineTypeCaption; FieldCaption("Service Item Group Code"))                        {                        }                        column(Warranty_ServLineTypeCaption; FieldCaption(Warranty))                        {                        }                        column(ItemNo_ServLineTypeCaption; FieldCaption("Item No."))                        {                        }                        column(LoanerNo_ServLineTypeCaption; FieldCaption("Loaner No."))                        {                        }                        column(ServShelfNo_ServLineTypeCaption; FieldCaption("Service Shelf No."))                        {                        }                        dataitem("Fault Comment"; "Service Comment Line")                        {                            DataItemLink = "Table Subtype" = field("Document Type"), "No." = field("Document No."), "Table Line No." = field("Line No.");                            DataItemTableView = sorting("Table Name", "Table Subtype", "No.", Type, "Table Line No.", "Line No.") where("Table Name" = const("Service Header"), Type = const(Fault));                            column(Comment_FaultComment; Comment)                            {                            }                            column(Number_FaultComment; Number1)                            {                            }                            column(TableSubtype_FaultComment; "Table Subtype")                            {                            }                            column(Type_FaultComment; Type)                            {                            }                            column(LineNo_FaultComment; "Line No.")                            {                            }                            column(FaultCommentsCaption; FaultCommentsCaptionLbl)                            {                            }                            trigger OnAfterGetRecord()                            begin                                Number2 := 0;                                Number1 := Number1 + 1;                            end;                        }                        dataitem("Resolution Comment"; "Service Comment Line")                        {                            DataItemLink = "Table Subtype" = field("Document Type"), "No." = field("Document No."), "Table Line No." = field("Line No.");                            DataItemTableView = sorting("Table Name", "Table Subtype", "No.", Type, "Table Line No.", "Line No.") where("Table Name" = const("Service Header"), Type = const(Resolution));                            column(Comment_ResolutionComment; Comment)                            {                            }                            column(Number_ResolutionComment; Number2)                            {                            }                            column(TblSubtype_ResolComment; "Table Subtype")                            {                            }                            column(Type_ResolutionComment; Type)                            {                            }                            column(LineNo_ResolutionComment; "Line No.")                            {                            }                            column(ResolutionCommentsCaption; ResolutionCommentsCaptionLbl)                            {                            }                            trigger OnAfterGetRecord()                            begin                                Number1 := 0;                                Number2 := Number2 + 1;                            end;                        }                        trigger OnAfterGetRecord()                        begin                            Number1 := 0;                            Number2 := 0;                        end;                    }                    dataitem("Service Line"; "Service Line")                    {                        DataItemLink = "Document Type" = field("Document Type"), "Document No." = field("No.");                        DataItemLinkReference = "Service Header";                        DataItemTableView = sorting("Document Type", "Document No.", "Line No.");                        column(SerItemSlNo_ServLine; "Service Item Serial No.")                        {                        }                        column(Type_ServLine; Type)                        {                        }                        column(No_ServLine; "No.")                        {                        }                        column(Description_ServLine; Description)                        {                        }                        column(UnitPrice_ServLine; "Unit Price")                        {                        }                        column(LineDiscount_ServLine; "Line Discount %")                        {                        }                        column(Amt; Amt)                        {                        }                        column(VariantCode_ServLine; "Variant Code")                        {                        }                        column(GrossAmt; GrossAmt)                        {                        }                        column(Quantity_ServLine; Quantity)                        {                        }                        column(TotAmt; TotAmt)                        {                        }                        column(TotGrossAmt; TotGrossAmt)                        {                        }                        column(DocumentNo_ServLine; "Document No.")                        {                        }                        column(LineNo_ServLine; "Line No.")                        {                        }                        column(ServiceLineCaption; ServiceLineCaptionLbl)                        {                        }                        column(AmtCaption; AmtCaptionLbl)                        {                        }                        column(GrossAmountCaption; GrossAmountCaptionLbl)                        {                        }                        column(SerItemSlNo_ServLineCaption; FieldCaption("Service Item Serial No."))                        {                        }                        column(TotalCaption; TotalCaptionLbl)                        {                        }                        column(Type_ServLineCaption; FieldCaption(Type))                        {                        }                        column(No_ServLineCaption; FieldCaption("No."))                        {                        }                        column(Description_ServLineCaption; FieldCaption(Description))                        {                        }                        column(UnitPrice_ServLineCaption; FieldCaption("Unit Price"))                        {                        }                        column(LineDiscount_ServLineCaption; FieldCaption("Line Discount %"))                        {                        }                        column(VariantCode_ServLineCaption; FieldCaption("Variant Code"))                        {                        }                        column(Quantity_ServLineCaption; FieldCaption(Quantity))                        {                        }                        dataitem(DimesionLoop2; "Integer")                        {                            DataItemTableView = sorting(Number) where(Number = filter(1 ..));                            column(DimText1; DimText)                            {                            }                            column(LineDimensionsCaption; LineDimensionsCaptionLbl)                            {                            }                            trigger OnAfterGetRecord()                            begin                                if Number = 1 then begin                                    if not DimSetEntry2.FindSet() then                                        CurrReport.Break();                                end else                                    if not Continue then                                        CurrReport.Break();                                Clear(DimText);                                Continue := false;                                repeat                                    OldDimText := DimText;                                    if DimText = '' then                                        DimText := StrSubstNo('%1 %2', DimSetEntry2."Dimension Code", DimSetEntry2."Dimension Value Code")                                    else                                        DimText :=                                          StrSubstNo(                                            '%1, %2 %3', DimText,                                            DimSetEntry2."Dimension Code", DimSetEntry2."Dimension Value Code");                                    if StrLen(DimText) > MaxStrLen(OldDimText) then begin                                        DimText := OldDimText;                                        Continue := true;                                        exit;                                    end;                                until DimSetEntry2.Next() = 0;                            end;                            trigger OnPreDataItem()                            begin                                if not ShowInternalInfo then                                    CurrReport.Break();                                DimSetEntry2.SetRange("Dimension Set ID", "Service Line"."Dimension Set ID");                            end;                        }                        trigger OnAfterGetRecord()                        begin                            Amt := "Line Amount";                            GrossAmt := "Amount Including VAT";                            TotAmt := TotAmt + Amt;                            TotGrossAmt := TotGrossAmt + GrossAmt;                        end;                    }                    dataitem(Shipto; "Integer")                    {                        DataItemTableView = sorting(Number) where(Number = const(1));                        column(ShipToAddr6; ShipToAddr[6])                        {                        }                        column(ShipToAddr5; ShipToAddr[5])                        {                        }                        column(ShipToAddr4; ShipToAddr[4])                        {                        }                        column(ShipToAddr3; ShipToAddr[3])                        {                        }                        column(ShipToAddr2; ShipToAddr[2])                        {                        }                        column(ShipToAddr1; ShipToAddr[1])                        {                        }                        column(ShipToAddressCaption; ShipToAddressCaptionLbl)                        {                        }                        column(ShipToPhoneNo; "Service Header"."Ship-to Phone")                        {                        }                        trigger OnPreDataItem()                        begin                            if not ShowShippingAddr then                                CurrReport.Break();                        end;                    }                }                trigger OnAfterGetRecord()                begin                    TotAmt := 0;                    TotGrossAmt := 0;                    if Number > 1 then                        CopyText := FormatDocument.GetCOPYText();                    OutputNo += 1;                end;                trigger OnPostDataItem()                begin                    if not IsReportInPreviewMode() then                        CODEUNIT.Run(CODEUNIT::"Service-Printed", "Service Header");                end;                trigger OnPreDataItem()                begin                    NoOfLoops := Abs(NoOfCopies) + 1;                    if NoOfLoops <= 0 then                        NoOfLoops := 1;                    CopyText := '';                    SetRange(Number, 1, NoOfLoops);                    OutputNo := 1;                end;            }            trigger OnAfterGetRecord()            var                ServiceDocumentArchiveMgmt: Codeunit "Service Document Archive Mgmt.";            begin                CurrReport.Language(LanguageMgt.GetLanguageIdOrDefault("Language Code"));                CurrReport.FormatRegion := LanguageMgt.GetFormatRegionOrDefault("Format Region");                FormatAddr.SetLanguageCode("Language Code");                FormatAddressFields("Service Header");                DimSetEntry1.SetRange("Dimension Set ID", "Dimension Set ID");                if not IsReportInPreviewMode() and                   ((CurrReport.UseRequestPage()) and ArchiveDocument or                   not (CurrReport.UseRequestPage()) and (ServiceSetup."Archive Quotes" <> ServiceSetup."Archive Quotes"::Never))                then                    case ServiceSetup."Archive Quotes" of                        ServiceSetup."Archive Quotes"::Always:                            ServiceDocumentArchiveMgmt.ArchServiceDocumentNoConfirm("Service Header");                        ServiceSetup."Archive Quotes"::Question:                            begin                                CurrReport.Language(LanguageMgt.GetLanguageIdOrDefault(LanguageMgt.GetUserLanguageCode()));                                ServiceDocumentArchiveMgmt.ArchiveServiceDocument("Service Header");                                CurrReport.Language(LanguageMgt.GetLanguageIdOrDefault("Language Code"));                            end;                    end;            end;        }    }    requestpage    {        AboutTitle = 'About Service Quote';        AboutText = 'Generate a service quote 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(LogInteraction; LogInteraction)                    {                        ApplicationArea = Service;                        Caption = 'Log Interaction';                        Enabled = LogInteractionEnable;                        ToolTip = 'Specifies if you want to record the service quotes that you want to print as interactions and add them to the Interaction Log Entry table.';                    }                    field(ArchiveDocument; ArchiveDocument)                    {                        ApplicationArea = Service;                        Caption = 'Archive Document';                        ToolTip = 'Specifies if the document is archived after you preview or print it.';                        trigger OnValidate()                        begin                            if not ArchiveDocument then                                LogInteraction := false;                        end;                    }                }            }        }        actions        {        }        trigger OnInit()        begin            LogInteraction := SegManagement.FindInteractionTemplateCode(Enum::"Interaction Log Entry Document Type"::"Service Quote") <> '';            LogInteractionEnable := LogInteraction;            ArchiveDocument := ServiceSetup."Archive Quotes" <> ServiceSetup."Archive Quotes"::Never;        end;    }    labels    {    }    trigger OnInitReport()    begin        CompanyInfo.Get();        ServiceSetup.Get();        FormatDocument.SetLogoPosition(ServiceSetup."Logo Position on Documents", CompanyInfo1, CompanyInfo2, CompanyInfo3);    end;    trigger OnPostReport()    begin        if LogInteraction and not IsReportInPreviewMode() then            if "Service Header".FindSet() then                repeat                    "Service Header".CalcFields("No. of Archived Versions");                    if "Service Header"."Contact No." <> '' then                        SegManagement.LogDocument(25, "Service Header"."No.", "Service Header"."Doc. No. Occurrence",                         "Service Header"."No. of Archived Versions", Database::Contact, "Service Header"."Contact No.",                          "Service Header"."Salesperson Code", '', '', '')                    else                        SegManagement.LogDocument(25, "Service Header"."No.", "Service Header"."Doc. No. Occurrence",                        "Service Header"."No. of Archived Versions", Database::Customer, "Service Header"."Customer No.",                          "Service Header"."Salesperson Code", '', '', '');                until "Service Header".Next() = 0;    end;    var        CompanyInfo3: Record "Company Information";        ServiceSetup: Record "Service Mgt. Setup";        RespCenter: Record "Responsibility Center";        DimSetEntry1: Record "Dimension Set Entry";        DimSetEntry2: Record "Dimension Set Entry";        LanguageMgt: Codeunit Language;        FormatAddr: Codeunit "Format Address";        FormatDocument: Codeunit "Format Document";        SegManagement: Codeunit SegManagement;        NoOfCopies: Integer;        NoOfLoops: Integer;        Number1: Integer;        Number2: Integer;        ArchiveDocument: Boolean;        ShowInternalInfo: Boolean;        ShowShippingAddr: Boolean;        Continue: Boolean;        CopyText: Text[30];        CompanyAddr: array[8] of Text[100];        CustAddr: array[8] of Text[100];        ShipToAddr: array[8] of Text[100];        DimText: Text[120];        OldDimText: Text[120];        Amt: Decimal;        TotAmt: Decimal;        LogInteraction: Boolean;        GrossAmt: Decimal;        TotGrossAmt: Decimal;        OutputNo: Integer;        LogInteractionEnable: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470        Text001: Label 'Service Quote%1';        Text002: Label 'Page %1';#pragma warning restore AA0470#pragma warning restore AA0074        SerHdrOrderDateCaptionLbl: Label 'Order Date';        InvoicetoCaptionLbl: Label 'Invoice to';        CompanyInfoPhoneNoCaptionLbl: Label 'Phone No.';        ServiceHeaderEMailCaptionLbl: Label 'Email';        HeaderDimensionsCaptionLbl: Label 'Header Dimensions';        ServiceItemLinesCaptionLbl: Label 'Service Item Lines';        FaultCommentsCaptionLbl: Label 'Fault Comments';        ResolutionCommentsCaptionLbl: Label 'Resolution Comments';        ServiceLineCaptionLbl: Label 'Service Line';        AmtCaptionLbl: Label 'Amount';        GrossAmountCaptionLbl: Label 'Gross Amount';        TotalCaptionLbl: Label 'Total';        LineDimensionsCaptionLbl: Label 'Line Dimensions';        ShipToAddressCaptionLbl: Label 'Ship-to Address';        HomePageCaptionLbl: Label 'Home Page';        EmailCaptionLbl: Label 'Email';    protected var        CompanyInfo: Record "Company Information";        CompanyInfo1: Record "Company Information";        CompanyInfo2: Record "Company Information";    local procedure IsReportInPreviewMode(): Boolean    var        MailManagement: Codeunit "Mail Management";    begin        exit(CurrReport.Preview or MailManagement.IsHandlingGetEmailBody());    end;    local procedure FormatAddressFields(var ServiceHeader: Record "Service Header")    var        ServiceFormatAddress: Codeunit "Service Format Address";    begin        FormatAddr.GetCompanyAddr(ServiceHeader."Responsibility Center", RespCenter, CompanyInfo, CompanyAddr);        ServiceFormatAddress.ServiceOrderSellto(CustAddr, ServiceHeader);        ShowShippingAddr := ServiceHeader."Ship-to Code" <> '';        if ShowShippingAddr then            ServiceFormatAddress.ServiceOrderShipto(ShipToAddr, ServiceHeader);    end;}