Query 5001 Locations from items Sales

Base Application, Microsoft.Sales.Document

src/Layers/W1/BaseApp/Sales/Document/LocationsfromitemsSales.Query.al42 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;using Microsoft.Inventory.Location;/// <summary>/// Retrieves distinct location information from sales order lines for warehouse operations./// </summary>query 5001 "Locations from items Sales"{    Caption = 'Locations from items Sales';    elements    {        dataitem(Sales_Line; "Sales Line")        {            DataItemTableFilter = "Document Type" = const(Order), Type = const(Item), "Location Code" = filter(<> ''), "No." = filter(<> ''), Quantity = filter(<> 0);            column(Document_No; "Document No.")            {            }            column(Location_Code; "Location Code")            {            }            dataitem(Location; Location)            {                DataItemLink = Code = Sales_Line."Location Code";                DataItemTableFilter = "Use As In-Transit" = const(false);                column(Require_Shipment; "Require Shipment")                {                }                column(Require_Pick; "Require Pick")                {                }            }        }    }}