Query 9060 Count Sales Orders
src/Layers/W1/BaseApp/Sales/Document/CountSalesOrders.Query.al54 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.Document;/// <summary>/// Provides aggregated counts of sales orders based on status and shipping criteria./// </summary>query 9060 "Count Sales Orders"{ Caption = 'Count Sales Orders'; elements { dataitem(Sales_Header; "Sales Header") { DataItemTableFilter = "Document Type" = const(Order); filter(Status; Status) { } filter(Shipped; Shipped) { } filter(Completely_Shipped; "Completely Shipped") { } filter(Responsibility_Center; "Responsibility Center") { } filter(Shipped_Not_Invoiced; "Shipped Not Invoiced") { } filter(Ship; Ship) { } filter(Date_Filter; "Date Filter") { } filter(Late_Order_Shipping; "Late Order Shipping") { } filter(Shipment_Date; "Shipment Date") { } column(Count_Orders) { Method = Count; } } }}