Query 760 Trailing Sales Order Qry
src/Layers/W1/BaseApp/Sales/Analysis/TrailingSalesOrderQry.Query.al47 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.Analysis;using Microsoft.Sales.Document;/// <summary>/// Retrieves sales order amounts grouped by currency code for trailing sales order analysis./// </summary>query 760 "Trailing Sales Order Qry"{ Caption = 'Trailing Sales Order Qry'; elements { dataitem(Sales_Header; "Sales Header") { DataItemTableFilter = "Document Type" = const(Order); filter(ShipmentDate; "Shipment Date") { } filter(Status; Status) { } filter(DocumentDate; "Document Date") { } column(CurrencyCode; "Currency Code") { } dataitem(Sales_Line; "Sales Line") { DataItemLink = "Document Type" = Sales_Header."Document Type", "Document No." = Sales_Header."No."; SqlJoinType = InnerJoin; DataItemTableFilter = Amount = filter(<> 0); column(Amount; Amount) { Method = Sum; } } } }}