Query 103 Item Sales and Profit
src/Layers/W1/BaseApp/Inventory/ItemSalesandProfit.Query.al95 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.Inventory;using Microsoft.Inventory.Item;using Microsoft.Purchases.Vendor;query 103 "Item Sales and Profit"{ Caption = 'Item Sales and Profit'; elements { dataitem(Item; Item) { column(No; "No.") { } column(Description; Description) { } column(Gen_Prod_Posting_Group; "Gen. Prod. Posting Group") { } column(Item_Disc_Group; "Item Disc. Group") { } column(Item_Tracking_Code; "Item Tracking Code") { } column(Profit; "Profit %") { } column(Scrap; "Scrap %") { } column(Sales_Unit_of_Measure; "Sales Unit of Measure") { } column(Standard_Cost; "Standard Cost") { } column(Unit_Cost; "Unit Cost") { } column(Unit_Price; "Unit Price") { } column(Unit_Volume; "Unit Volume") { } column(Vendor_No; "Vendor No.") { } column(Purch_Unit_of_Measure; "Purch. Unit of Measure") { } column(COGS_LCY; "COGS (LCY)") { } column(Inventory; Inventory) { } column(Net_Change; "Net Change") { } column(Net_Invoiced_Qty; "Net Invoiced Qty.") { } column(Purchases_LCY; "Purchases (LCY)") { } column(Purchases_Qty; "Purchases (Qty.)") { } column(Sales_LCY; "Sales (LCY)") { } column(Sales_Qty; "Sales (Qty.)") { } dataitem(Vendor; Vendor) { DataItemLink = "No." = Item."Vendor No."; column(VendorName; Name) { } } } }}