Query 115 Sales Shipped Not Invoiced LCY

App
Base Application
Namespace
Microsoft.Sales.Customer
Versions
26-28
Obsolete
Pending 28.0, seen from 28. Not used, as Customer.GetShippedFromOrderLCYAmountLCY() procedure is no longer used in GetTotalAmountLCYCommon procedure.

Obsolete, 1

Versions171819202122232425262728

Source29

Source in 29

src/Layers/W1/BaseApp/Sales/Customer/SalesShippedNotInvoicedLCY.Query.al39 lines, Copyright (c) Microsoft Corporation. MIT

#if not CLEAN28
namespace Microsoft.Sales.Customer;

using Microsoft.Sales.Document;
using Microsoft.Sales.History;

/// <summary>
/// Retrieves sales amounts that have been shipped but not yet invoiced in local currency.
/// </summary>
query 115 "Sales Shipped Not Invoiced LCY"
{
    Caption = 'Sales Shipped Not Invoiced (LCY)';
    QueryType = Normal;
    DataAccessIntent = ReadOnly;
    ObsoleteReason = 'Not used, as Customer.GetShippedFromOrderLCYAmountLCY() procedure is no longer used in GetTotalAmountLCYCommon procedure.';
    ObsoleteState = Pending;
    ObsoleteTag = '28.0';

    elements
    {
        dataitem(SalesShipmentLine; "Sales Shipment Line")
        {
            column(BillToCustomerNo; "Bill-to Customer No.") { }
            column(OrderNo; "Order No.") { }
            column(OrderLineNo; "Order Line No.") { }
            filter(BillToCustomerNoFilter; "Bill-to Customer No.") { }
            filter(OrderNoFilter; "Order No.") { }
            filter(OrderLineNoFilter; "Order Line No.") { }
            dataitem(SalesLine; "Sales Line")
            {
                DataItemTableFilter = "Document Type" = const(Order);
                DataItemLink = "Document No." = SalesShipmentLine."Order No.",
                               "Line No." = SalesShipmentLine."Order Line No.";
                column(ShippedNotInvoicedLCY; "Shipped Not Invoiced (LCY)") { }
            }
        }
    }
}
#endif