Query 102 Item Sales by Customer, source in 29

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