Query 520 Item By Lot No. Res.

Base Application, Microsoft.Inventory.Availability

src/Layers/W1/BaseApp/Inventory/Availability/ItemByLotNoRes.Query.al43 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.Availability;using Microsoft.Inventory.Tracking;query 520 "Item By Lot No. Res."{    QueryType = Normal;    DataAccessIntent = ReadOnly;    elements    {        dataitem(Reservation_Entry; "Reservation Entry")        {            DataItemTableFilter = "Lot No." = filter(<> '');            filter(Item_No; "Item No.")            { }            filter(Quantity__Base_; "Quantity (Base)")            { }            filter(Expected_Receipt_Date; "Expected Receipt Date")            { }            filter(Shipment_Date; "Shipment Date")            { }            filter(Variant_Code; "Variant Code")            { }            filter(Location_Code; "Location Code")            { }            column(Lot_No; "Lot No.")            { }            column(Expiration_Date; "Expiration Date")            { }            column(Qty_Quantity__Base_; "Quantity (Base)")            {                Method = Sum;            }        }    }}