Query 37003 Sales Line - Item Outstanding
src/Apps/W1/PowerBIReports/App/Sales/APIs/SalesLineItemOutstanding.Query.al92 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.Sales.PowerBIReports;using Microsoft.Sales.Document;query 37003 "Sales Line - Item Outstanding"{ Access = Internal; QueryType = API; AboutText = 'Provides access to outstanding sales order lines for items including quantities not yet shipped and outstanding amounts. Enables Power BI reports to analyze sales order backlog, pending shipments, and customer demand fulfillment.'; Caption = 'Power BI Outstanding SO'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'itemOutstandingSalesLine'; EntitySetName = 'itemOutstandingSalesLines'; DataAccessIntent = ReadOnly; elements { dataitem(SalesHeader; "Sales Header") { DataItemTableFilter = "Document Type" = const(Order); column(salesOrderNo; "No.") { } column(documentType; "Document Type") { } column(customerNo; "Bill-to Customer No.") { } column(orderDate; "Order Date") { } column(salespersonCode; "Salesperson Code") { } dataitem(SalesLine; "Sales Line") { DataItemLink = "Document Type" = SalesHeader."Document Type", "Document No." = SalesHeader."No."; DataItemTableFilter = Type = const(Item), "Outstanding Qty. (Base)" = filter(> 0); column(salesLineDocumentType; "Document Type") { } column(documentNo; "Document No.") { } column(lineNo; "Line No.") { } column(itemNo; "No.") { } column(locationCode; "Location Code") { } column(outstandingQtyBase; "Outstanding Qty. (Base)") { } column(outstandingAmountLCY; "Outstanding Amount (LCY)") { } column(unitCostLCY; "Unit Cost (LCY)") { } column(outstandingQuantity; "Outstanding Quantity") { } column(dimensionSetID; "Dimension Set ID") { } } } } trigger OnBeforeOpen() var PBIMgt: Codeunit "Sales Filter Helper"; DateFilterText: Text; begin DateFilterText := PBIMgt.GenerateItemSalesReportDateFilter(); if DateFilterText <> '' then CurrQuery.SetFilter(orderDate, DateFilterText); end;}