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.
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