Query 760 Trailing Sales Order Qry

Base Application, Microsoft.Sales.Analysis

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;                }            }        }    }}