Query 37015 Inventory by Location
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'; } } } }}