Query 37001 Purch. Lines - Item Received
src/Apps/W1/PowerBIReports/App/Purchasing/APIs/PurchLinesItemReceived.Query.al73 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.Purchases.PowerBIReports;using Microsoft.Purchases.Document;query 37001 "Purch. Lines - Item Received"{ Access = Internal; QueryType = API; AboutText = 'Provides access to purchase order lines for items received but not yet invoiced including quantities and amounts pending invoicing. Enables Power BI reports to analyze goods-received-not-invoiced accruals and pending vendor invoices.'; Caption = 'Power BI Received Not Invd. PO'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'itemReceivedNotInvoicedPurchaseLine'; EntitySetName = 'itemReceivedNotInvoicedPurchaseLines'; DataAccessIntent = ReadOnly; elements { dataitem(purchaseHeader; "Purchase Header") { DataItemTableFilter = "Document Type" = const(Order); column(purchaseOrderNo; "No.") { } column(documentType; "Document Type") { } column(vendorNo; "Pay-to Vendor No.") { } column(orderDate; "Order Date") { } column(purchaserCode; "Purchaser Code") { } dataitem(purchaseLine; "Purchase Line") { DataItemLink = "Document Type" = purchaseHeader."Document Type", "Document No." = purchaseHeader."No."; DataItemTableFilter = Type = const(Item), "Qty. Rcd. Not Invoiced (Base)" = filter(> 0); column(purchaseLineDocumentType; "Document Type") { } column(documentNo; "Document No.") { } column(lineNo; "Line No.") { } column(itemNo; "No.") { } column(locationCode; "Location Code") { } column(qtyRcdNotInvoicedBase; "Qty. Rcd. Not Invoiced (Base)") { } column(amtRcdNotInvoicedLCY; "A. Rcd. Not Inv. Ex. VAT (LCY)") { } column(dimensionSetID; "Dimension Set ID") { } } } }}