Query 37015 Inventory by Location

Base Application

src/Layers/W1/BaseApp/Inventory/Availability/InventoryByLocation.Query.al100 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.// ------------------------------------------------------------------------------------------------#pragma warning disable AA0247query 37015 "Inventory by Location"{    QueryType = Normal;    DataAccessIntent = ReadOnly;    UsageCategory = ReportsAndAnalysis;    Caption = 'Inventory by Location Analysis';    AboutTitle = 'About Inventory by Location Analysis';    AboutText = 'The Inventory by Location Analysis is a query that joins data from item ledger entries with location master data.';    elements    {        dataitem(ItemLedgerEntry; "Item Ledger Entry")        {            DataItemTableFilter = Open = const(true);            column(ItemNo; "Item No.")            {                Caption = 'Item No.';            }            column(VariantCode; "Variant Code")            {                Caption = 'Variant Code';            }            column(LotNo; "Lot No.")            {                Caption = 'Lot No.';            }            column(SerialNo; "Serial No.")            {                Caption = 'Serial No.';            }            column(PackageNo; "Package No.")            {                Caption = 'Package No.';            }            column(ExpirationDate; "Expiration Date")            {                Caption = 'Expiration Date';            }            column(UnitOfMeasureCode; "Unit of Measure Code")            {                Caption = 'Unit of Measure Code';            }            column(QtyPerUnitOfMeasure; "Qty. per Unit of Measure")            {                Caption = 'Qty. per Unit of Measure';            }            column(Quantity; Quantity)            {                Caption = 'Quantity';                Method = Sum;            }            column(RemainingQuantity; "Remaining Quantity")            {                Caption = 'Remaining Quantity';                Method = Sum;            }            column(ReservedQuantity; "Reserved Quantity")            {                Caption = 'Reserved Quantity';                Method = Sum;            }            column(CountryRegionCode; "Country/Region Code")            {                Caption = 'Country/Region Code';            }            dataitem(Location; Location)            {                DataItemLink = Code = ItemLedgerEntry."Location Code";                column(LocationCode; Code)                {                    Caption = 'Location Code';                }                column(LocationName; Name)                {                    Caption = 'Location Name';                }                column(LocationCity; City)                {                    Caption = 'Location City';                }                column(LocationCounty; County)                {                    Caption = 'Location County';                }                column(LocationCountryRegionCode; "Country/Region Code")                {                    Caption = 'Location Country/Region Code';                }            }        }    }}