Report 752 Work Order
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';}