Query 36979 Warehouse Entries
src/Apps/W1/PowerBIReports/App/Inventory/APIs/WarehouseEntries.Query.al56 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.PowerBIReports;using Microsoft.Warehouse.Ledger;query 36979 "Warehouse Entries"{ Access = Internal; Caption = 'Power BI Warehouse Entries'; QueryType = API; AboutText = 'Provides access to warehouse entry data including item quantities by bin, zone, location, and lot/serial numbers. Enables Power BI reports to analyze bin-level inventory, warehouse stock distribution, and detailed storage location utilization.'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'warehouseEntry'; EntitySetName = 'warehouseEntries'; DataAccessIntent = ReadOnly; elements { dataitem(warehouseEntry; "Warehouse Entry") { column(itemNo; "Item No.") { } column(locationCode; "Location Code") { } column(lotNo; "Lot No.") { } column(serialNo; "Serial No.") { } column(zoneCode; "Zone Code") { } column(binCode; "Bin Code") { } column(qtyBase; "Qty. (Base)") { Method = Sum; } column(qtyPerUnitOfMeasure; "Qty. per Unit of Measure") { } column(unitOfMeasureCode; "Unit of Measure Code") { } } }}