Report 752 Work Order
- App
- Base Application
- Namespace
- Microsoft.Sales.Document
- Versions
- 17-28
Versions171819202122232425262728
Source29
Source in 29
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';
}