Query 5001 Locations from items Sales
Source AL, 42 lines
src/Layers/W1/BaseApp/Sales/Document/LocationsfromitemsSales.Query.allines 12 to 27 of 42, Copyright (c) Microsoft Corporation. MIT
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)