Query 9060 Count Sales Orders
- App
- Base Application
- Namespace
- Microsoft.Sales.Document
- Versions
- 17-28
Versions171819202122232425262728
Source29
Source in 29
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;
}
}
}
}