Query 7302 Bin Content by Item Tracking

Base Application, Microsoft.Warehouse.Structure

src/Layers/W1/BaseApp/Warehouse/Structure/BinContentbyItemTracking.Query.al51 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.Warehouse.Structure;using Microsoft.Warehouse.Ledger;query 7302 "Bin Content by Item Tracking"{    Caption = 'Bin Content by Item Tracking';    QueryType = Normal;    DataAccessIntent = ReadOnly;    AboutText = 'Calculates the total "Qty. (Base)" per bin content and item tracking dimensions. Filters on variations that have total "Qty. (Base)" <> 0.', Locked = true;    elements    {        dataitem(Warehouse_Entry; "Warehouse Entry")        {            column(Location_Code; "Location Code")            {            }            column(Bin_Code; "Bin Code")            {            }            column(Item_No; "Item No.")            {            }            column(Variant_Code; "Variant Code")            {            }            column(Unit_of_Measure_Code; "Unit of Measure Code")            {            }            column(Lot_No; "Lot No.")            {            }            column(Serial_No; "Serial No.")            {            }            column(Package_No; "Package No.")            {            }            column(Sum_Qty_Base; "Qty. (Base)")            {                ColumnFilter = Sum_Qty_Base = filter(<> 0);                Method = Sum;            }        }    }}