Query 102 Item Sales by Customer
src/Layers/W1/BaseApp/Inventory/ItemSalesbyCustomer.Query.al62 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.Inventory.Ledger;using Microsoft.Sales.Customer;query 102 "Item Sales by Customer"{ Caption = 'Item Sales by Customer'; elements { dataitem(Value_Entry; "Value Entry") { DataItemTableFilter = "Source Type" = filter(Customer), "Item Ledger Entry No." = filter(<> 0), "Document Type" = filter("Sales Invoice" | "Sales Credit Memo"); column(Entry_No; "Entry No.") { } column(Document_No; "Document No.") { } column(Posting_Date; "Posting Date") { } column(Item_No; "Item No.") { } column(Item_Ledger_Entry_Quantity; "Item Ledger Entry Quantity") { } column(Dimension_Set_ID; "Dimension Set ID") { } dataitem(Customer; Customer) { DataItemLink = "No." = Value_Entry."Source No."; column(CustomerNo; "No.") { } column(Name; Name) { } dataitem(Item; Item) { DataItemLink = "No." = Value_Entry."Item No."; column(Description; Description) { } column(Gen_Prod_Posting_Group; "Gen. Prod. Posting Group") { } } } } }}