Report 99000768 Prod. Order - Detailed Calc.
src/Layers/W1/BaseApp/Manufacturing/Reports/ProdOrderDetailedCalc.Report.al199 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.Manufacturing.Reports;using Microsoft.Manufacturing.Document;using System.Utilities;report 99000768 "Prod. Order - Detailed Calc."{ ApplicationArea = Manufacturing; Caption = 'Prod. Order - Detailed Calc.'; ToolTip = 'View a list of the production orders. This list contains the expected costs and the quantity per production order or per operation of a production order.'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("Production Order"; "Production Order") { DataItemTableView = sorting(Status, "No."); RequestFilterFields = Status, "No.", "Source Type", "Source No."; column(TodayFormatted; Format(Today, 0, 4)) { } column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(ProdOrderTableCaptionFilter; TableCaption + ':' + ProdOrderFilter) { } column(ProdOrderFilter; ProdOrderFilter) { } column(No_ProdOrder; "No.") { } column(Desc_ProdOrder; Description) { } column(SourceNo_ProdOrder; "Source No.") { IncludeCaption = true; } column(Qty_ProdOrder; Quantity) { IncludeCaption = true; } column(ProdOrderDetailedCalcCaption; ProdOrderDetailedCalcCaptionLbl) { } column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl) { } dataitem("Prod. Order Line"; "Prod. Order Line") { DataItemLink = Status = field(Status), "Prod. Order No." = field("No."); DataItemTableView = sorting(Status, "Prod. Order No.", "Line No.") where("Planning Level Code" = const(0)); column(LineNo_ProdOrderLine; "Line No.") { } dataitem("Prod. Order Routing Line"; "Prod. Order Routing Line") { DataItemLink = Status = field(Status), "Prod. Order No." = field("Prod. Order No."), "Routing Reference No." = field("Line No."); DataItemTableView = sorting(Status, "Prod. Order No.", "Routing Reference No.", "Routing No.", "Operation No."); column(OPNo_ProdOrderRtngLine; "Operation No.") { IncludeCaption = false; } column(OPNo_ProdOrderRtngLineCaption; FieldCaption("Operation No.")) { } column(Type_ProdOrderRtngLine; Type) { IncludeCaption = true; } column(No_ProdOrderRtngLine; "No.") { IncludeCaption = true; } column(Desc_ProdOrderRtngLine; Description) { IncludeCaption = true; } column(InputQty_ProdOrderRtngLine; "Input Quantity") { IncludeCaption = true; } column(ExpecOPCostAmt_ProdOrderRtngLine; "Expected Operation Cost Amt.") { IncludeCaption = true; } column(TotalProductionCostCaption; TotalProductionCostCaptionLbl) { } } dataitem("Prod. Order Component"; "Prod. Order Component") { DataItemLink = Status = field(Status), "Prod. Order No." = field("Prod. Order No."), "Prod. Order Line No." = field("Line No."); DataItemTableView = sorting(Status, "Prod. Order No.", "Prod. Order Line No.", "Line No."); column(ItemNo_ProdOrderComp; "Item No.") { IncludeCaption = false; } column(ItemNo_ProdOrderCompCaption; FieldCaption("Item No.")) { } column(Desc_ProdOrderComp; Description) { IncludeCaption = true; } column(RtngLinkCode_ProdOrderComp; "Routing Link Code") { IncludeCaption = true; } column(ExpectedQty_ProdOrderComp; "Expected Quantity") { IncludeCaption = true; } column(CostAmt_ProdOrderComp; "Cost Amount") { IncludeCaption = true; } column(UnitCost_ProdOrderComp; "Unit Cost") { IncludeCaption = true; } column(TotalMaterialCostCaption; TotalMaterialCostCaptionLbl) { } } dataitem("Integer"; "Integer") { DataItemTableView = sorting(Number); MaxIteration = 1; column(ProdOrderCompOPCostAmt; "Prod. Order Component"."Cost Amount" + "Prod. Order Routing Line"."Expected Operation Cost Amt.") { AutoFormatType = 1; } column(TotalProdCostCaption; TotalProdCostCaptionLbl) { } column(TotalMterlCostCaption; TotalMterlCostCaptionLbl) { } column(TotalCostCaption; TotalCostCaptionLbl) { } } } trigger OnPreDataItem() begin ProdOrderFilter := GetFilters(); end; } } requestpage { AboutTitle = 'About Prod. Order - Detailed Calc.'; AboutText = 'Get a comprehensive analysis of the costs associated with production orders broken down to costs by material, capacity, overhead, and other cost components.'; layout { } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Manufacturing/Reports/ProdOrderDetailedCalc.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } var ProdOrderFilter: Text; ProdOrderDetailedCalcCaptionLbl: Label 'Prod. Order - Detailed Calc.'; CurrReportPageNoCaptionLbl: Label 'Page'; TotalProductionCostCaptionLbl: Label 'Total Production Cost'; TotalMaterialCostCaptionLbl: Label 'Total Material Cost'; TotalProdCostCaptionLbl: Label 'Total Production Cost'; TotalMterlCostCaptionLbl: Label 'Total Material Cost'; TotalCostCaptionLbl: Label 'Total Cost';}