Query 36979 Warehouse Entries

PowerBI Reports, Microsoft.Inventory.PowerBIReports

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")            {            }        }    }}