Report 5879 Posted Phys. Invt. Recording
src/Layers/W1/BaseApp/Inventory/Counting/Reports/PostedPhysInvtRecording.Report.al195 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.Inventory.Counting.Reports;using Microsoft.Inventory.Counting.History;using System.Utilities;report 5879 "Posted Phys. Invt. Recording"{ ApplicationArea = Warehouse; Caption = 'Posted Phys. Invt. Recording'; ToolTip = 'Print Posted Phys. Invt. Recording.'; UsageCategory = ReportsAndAnalysis; WordMergeDataItem = "Posted Phys. Invt. Record Hdr"; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("Posted Phys. Invt. Record Hdr"; "Pstd. Phys. Invt. Record Hdr") { DataItemTableView = sorting("Order No.", "Recording No."); RequestFilterFields = "Order No.", "Recording No."; column(Posted_Phys__Invt__Rec__Header_Order_No_; "Order No.") { } column(Posted_Phys__Invt__Rec__Header_Recording_No_; "Recording No.") { } dataitem(PageCounter; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(USERID; UserId) { } column(COMPANYNAME; COMPANYPROPERTY.DisplayName()) { } column(FORMAT_TODAY_0_4_; Format(Today, 0, 4)) { } column(Posted_Phys__Invt__Rec__Header___Order_No__; "Posted Phys. Invt. Record Hdr"."Order No.") { } column(Posted_Phys__Invt__Rec__Header__Status; "Posted Phys. Invt. Record Hdr".Status) { } column(Posted_Phys__Invt__Rec__Header___Person_Responsible_; "Posted Phys. Invt. Record Hdr"."Person Responsible") { } column(Posted_Phys__Invt__Rec__Header___Recording_No__; "Posted Phys. Invt. Record Hdr"."Recording No.") { } column(Posted_Phys__Invt__Rec__Header__Description; "Posted Phys. Invt. Record Hdr".Description) { } column(Posted_Phys__Invt__Rec__Header___Time_Recorded_; Format("Posted Phys. Invt. Record Hdr"."Time Recorded")) { } column(Posted_Phys__Invt__Rec__Header___Date_Recorded_; Format("Posted Phys. Invt. Record Hdr"."Date Recorded")) { } column(Posted_Phys__Invt__Rec__Header___Person_Recorded_; "Posted Phys. Invt. Record Hdr"."Person Recorded") { } column(PageCounter_Number; Number) { } column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl) { } column(Posted_Phys__Inventory_RecordingCaption; Posted_Phys__Inventory_RecordingCaptionLbl) { } column(Posted_Phys__Invt__Rec__Header___Order_No__Caption; "Posted Phys. Invt. Record Hdr".FieldCaption("Order No.")) { } column(Posted_Phys__Invt__Rec__Header__StatusCaption; "Posted Phys. Invt. Record Hdr".FieldCaption(Status)) { } column(Posted_Phys__Invt__Rec__Header___Person_Responsible_Caption; "Posted Phys. Invt. Record Hdr".FieldCaption("Person Responsible")) { } column(Posted_Phys__Invt__Rec__Header___Recording_No__Caption; "Posted Phys. Invt. Record Hdr".FieldCaption("Recording No.")) { } column(Posted_Phys__Invt__Rec__Header__DescriptionCaption; "Posted Phys. Invt. Record Hdr".FieldCaption(Description)) { } column(Posted_Phys__Invt__Rec__Header___Time_Recorded_Caption; Posted_Phys__Invt__Rec__Header___Time_Recorded_CaptionLbl) { } column(Posted_Phys__Invt__Rec__Header___Date_Recorded_Caption; Posted_Phys__Invt__Rec__Header___Date_Recorded_CaptionLbl) { } column(Posted_Phys__Invt__Rec__Header___Person_Recorded_Caption; "Posted Phys. Invt. Record Hdr".FieldCaption("Person Recorded")) { } dataitem("Pstd. Phys. Invt. Record Line"; "Pstd. Phys. Invt. Record Line") { DataItemLink = "Order No." = field("Order No."), "Recording No." = field("Recording No."); DataItemLinkReference = "Posted Phys. Invt. Record Hdr"; DataItemTableView = sorting("Order No.", "Recording No.", "Line No."); column(Posted_Phys__Invt__Rec__Line__Item_No__; "Item No.") { } column(Posted_Phys__Invt__Rec__Line__Location_Code_; "Location Code") { } column(Posted_Phys__Invt__Rec__Line__Bin_Code_; "Bin Code") { } column(Posted_Phys__Invt__Rec__Line_Description; Description) { } column(Posted_Phys__Invt__Rec__Line__Unit_of_Measure_Code_; "Unit of Measure Code") { } column(Posted_Phys__Invt__Rec__Line__Variant_Code_; "Variant Code") { } column(Posted_Phys__Invt__Rec__Line_Quantity; Quantity) { } column(Posted_Phys__Invt__Rec__Line_Order_No_; "Order No.") { } column(Posted_Phys__Invt__Rec__Line_Recording_No_; "Recording No.") { } column(Posted_Phys__Invt__Rec__Line_Line_No_; "Line No.") { } column(Posted_Phys__Invt__Rec__Line__Item_No__Caption; FieldCaption("Item No.")) { } column(Posted_Phys__Invt__Rec__Line__Location_Code_Caption; FieldCaption("Location Code")) { } column(Posted_Phys__Invt__Rec__Line__Bin_Code_Caption; FieldCaption("Bin Code")) { } column(Posted_Phys__Invt__Rec__Line_DescriptionCaption; FieldCaption(Description)) { } column(Posted_Phys__Invt__Rec__Line__Unit_of_Measure_Code_Caption; FieldCaption("Unit of Measure Code")) { } column(Posted_Phys__Invt__Rec__Line__Variant_Code_Caption; FieldCaption("Variant Code")) { } column(Posted_Phys__Invt__Rec__Line_QuantityCaption; FieldCaption(Quantity)) { } } } } } requestpage { SaveValues = true; layout { } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Inventory/Counting/Reports/PostedPhysInvtRecording.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } var CurrReport_PAGENOCaptionLbl: Label 'Page'; Posted_Phys__Inventory_RecordingCaptionLbl: Label 'Posted Phys. Inventory Recording'; Posted_Phys__Invt__Rec__Header___Time_Recorded_CaptionLbl: Label 'Time Recorded'; Posted_Phys__Invt__Rec__Header___Date_Recorded_CaptionLbl: Label 'Date Recorded';}