Query 102 Item Sales by Customer

Base Application, Microsoft.Inventory

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")                    {                    }                }            }        }    }}