Report 752 Work Order

Base Application, Microsoft.Sales.Document

src/Layers/W1/BaseApp/Sales/Document/WorkOrder.Report.al214 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.Sales.Document;using Microsoft.Foundation.Address;using Microsoft.Sales.Comment;using System.Utilities;/// <summary>/// Generates a work order document for internal use in processing sales orders./// </summary>report 752 "Work Order"{    Caption = 'Work Order';    WordMergeDataItem = "Sales Header";    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Sales Header"; "Sales Header")        {            DataItemTableView = sorting("Document Type", "No.") where("Document Type" = const(Order));            RequestFilterFields = "No.", "Sell-to Customer No.";            RequestFilterHeading = 'Sales Order';            dataitem(PageLoop; "Integer")            {                DataItemTableView = sorting(Number) where(Number = const(1));                column(No1_SalesHeader; "Sales Header"."No.")                {                }                column(ShipmentDate_SalesHeader; Format("Sales Header"."Shipment Date"))                {                }                column(CompanyName; COMPANYPROPERTY.DisplayName())                {                }                column(CustAddr1; CustAddr[1])                {                }                column(CustAddr2; CustAddr[2])                {                }                column(CustAddr3; CustAddr[3])                {                }                column(CustAddr4; CustAddr[4])                {                }                column(CustAddr5; CustAddr[5])                {                }                column(CustAddr6; CustAddr[6])                {                }                column(CustAddr7; CustAddr[7])                {                }                column(CustAddr8; CustAddr[8])                {                }                column(ShipmentDateCaption; ShipmentDateCaptionLbl)                {                }                column(SalesOrderNoCaption; SalesOrderNoCaptionLbl)                {                }                column(PageNoCaption; PageNoCaptionLbl)                {                }                column(WorkOrderCaption; WorkOrderCaptionLbl)                {                }                dataitem("Sales Line"; "Sales Line")                {                    DataItemLink = "Document Type" = field("Document Type"), "Document No." = field("No.");                    DataItemLinkReference = "Sales Header";                    DataItemTableView = sorting("Document Type", "Document No.", "Line No.");                    column(No_SalesLine; "No.")                    {                        IncludeCaption = true;                    }                    column(Description_SalesLine; Description)                    {                        IncludeCaption = true;                    }                    column(Quantity_SalesLine; Quantity)                    {                        IncludeCaption = true;                    }                    column(UnitofMeasure_SalesLine; "Unit of Measure")                    {                        IncludeCaption = true;                    }                    column(Type_SalesLine; Type)                    {                        IncludeCaption = true;                    }                    column(QtyworkPostSalesOrderCptn; QtyworkPostSalesOrderCptnLbl)                    {                    }                    column(QuantityUsedCaption; QuantityUsedCaptionLbl)                    {                    }                    column(UnitofMeasureCaption; UnitofMeasureCaptionLbl)                    {                    }                }                dataitem("Sales Comment Line"; "Sales Comment Line")                {                    DataItemLink = "Document Type" = field("Document Type"), "No." = field("No.");                    DataItemLinkReference = "Sales Header";                    DataItemTableView = where("Document Line No." = const(0));                    column(Date_SalesCommentLine; Format(Date))                    {                    }                    column(Code_SalesCommentLine; Code)                    {                        IncludeCaption = true;                    }                    column(Comment_SalesCommentLine; Comment)                    {                        IncludeCaption = true;                    }                    column(CommentsCaption; CommentsCaptionLbl)                    {                    }                    column(SalesCommentLineDtCptn; SalesCommentLineDtCptnLbl)                    {                    }                }                dataitem("Extra Lines"; "Integer")                {                    DataItemTableView = sorting(Number) where(Number = const(1));                    column(NoCaption; NoCaptionLbl)                    {                    }                    column(DescriptionCaption; DescriptionCaptionLbl)                    {                    }                    column(QuantityCaption; QuantityCaptionLbl)                    {                    }                    column(UnitofMeasureCaptionControl33; UnitofMeasureCaptionControl33Lbl)                    {                    }                    column(DateCaption; DateCaptionLbl)                    {                    }                    column(workPostdItemorResJnlCptn; workPostdItemorResJnlCptnLbl)                    {                    }                    column(TypeCaption; TypeCaptionLbl)                    {                    }                }            }            trigger OnAfterGetRecord()            begin                FormatAddr.SalesHeaderBillTo(CustAddr, "Sales Header");            end;        }    }    requestpage    {        layout        {        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Sales/Document/WorkOrder.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    var        FormatAddr: Codeunit "Format Address";        CustAddr: array[8] of Text[100];        ShipmentDateCaptionLbl: Label 'Shipment Date';        SalesOrderNoCaptionLbl: Label 'Sales Order No.';        PageNoCaptionLbl: Label 'Page';        WorkOrderCaptionLbl: Label 'Work Order';        QtyworkPostSalesOrderCptnLbl: Label 'Quantity used during work (Posted with the Sales Order)';        QuantityUsedCaptionLbl: Label 'Quantity Used';        UnitofMeasureCaptionLbl: Label 'Unit of Measure';        CommentsCaptionLbl: Label 'Comments';        SalesCommentLineDtCptnLbl: Label 'Date';        NoCaptionLbl: Label 'No.';        DescriptionCaptionLbl: Label 'Description';        QuantityCaptionLbl: Label 'Quantity';        UnitofMeasureCaptionControl33Lbl: Label 'Unit of Measure';        DateCaptionLbl: Label 'Date';        workPostdItemorResJnlCptnLbl: Label 'Extra Item/Resource used during work (Posted with Item or Resource Journals)';        TypeCaptionLbl: Label 'Type';}