Query 101 Sales Dashboard

Base Application, Microsoft.Sales.RoleCenters

src/Layers/W1/BaseApp/Sales/RoleCenters/SalesDashboard.Query.al96 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.Sales.RoleCenters;using Microsoft.CRM.Team;using Microsoft.Foundation.Address;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Sales.Customer;/// <summary>/// Provides sales transaction data by combining item ledger entries with customer and salesperson information for dashboard reporting./// </summary>query 101 "Sales Dashboard"{    Caption = 'Sales Dashboard';    elements    {        dataitem(Item_Ledger_Entry; "Item Ledger Entry")        {            DataItemTableFilter = "Entry Type" = filter(Sale);            column(Entry_No; "Entry No.")            {            }            column(Document_No; "Document No.")            {            }            column(Posting_Date; "Posting Date")            {            }            column(Entry_Type; "Entry Type")            {            }            column(Quantity; Quantity)            {            }            column(Sales_Amount_Actual; "Sales Amount (Actual)")            {            }            column(Sales_Amount_Expected; "Sales Amount (Expected)")            {            }            column(Cost_Amount_Actual; "Cost Amount (Actual)")            {            }            column(Cost_Amount_Expected; "Cost Amount (Expected)")            {            }            column(Dimension_Set_ID; "Dimension Set ID")            {            }            dataitem(Country_Region; "Country/Region")            {                DataItemLink = Code = Item_Ledger_Entry."Country/Region Code";                column(CountryRegionName; Name)                {                }                dataitem(Customer; Customer)                {                    DataItemLink = "No." = Item_Ledger_Entry."Source No.";                    column(CustomerName; Name)                    {                    }                    column(Customer_Posting_Group; "Customer Posting Group")                    {                    }                    column(Customer_Disc_Group; "Customer Disc. Group")                    {                    }                    column(City; City)                    {                    }                    dataitem(Item; Item)                    {                        DataItemLink = "No." = Item_Ledger_Entry."Item No.";                        column(Description; Description)                        {                        }                        dataitem(Salesperson_Purchaser; "Salesperson/Purchaser")                        {                            DataItemLink = Code = Customer."Salesperson Code";                            column(SalesPersonName; Name)                            {                            }                        }                    }                }            }        }    }}