Query 37004 Item Budget Entries - Sales

PowerBI Reports, Microsoft.Sales.PowerBIReports

src/Apps/W1/PowerBIReports/App/Sales/APIs/ItemBudgetEntriesSales.Query.al71 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.PowerBIReports;using Microsoft.Inventory.Analysis;query 37004 "Item Budget Entries - Sales"{    Access = Internal;    QueryType = API;    AboutText = 'Provides access to sales item budget entries including budgeted quantities, sales amounts, and dimension data. Enables Power BI reports to analyze sales forecasts, budget vs. actual comparisons, and sales planning by item, location, and customer.';    Caption = 'Power BI Sales Item Budget Entries';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'salesItemBudgetEntry';    EntitySetName = 'salesItemBudgetEntries';    DataAccessIntent = ReadOnly;    elements    {        dataitem(ItemBudgetEntry; "Item Budget Entry")        {            DataItemTableFilter = "Analysis Area" = const(Sales);            column(entryNo; "Entry No.")            {            }            column(budgetName; "Budget Name")            {            }            column(entryDate; Date)            {            }            column(itemNo; "Item No.")            {            }            column(locationCode; "Location Code")            {            }            column(sourceType; "Source Type")            {            }            column(sourceNo; "Source No.")            {            }            column(quantity; Quantity)            {            }            column(salesAmount; "Sales Amount")            {            }            column(dimensionSetID; "Dimension Set ID")            {            }        }    }    trigger OnBeforeOpen()    var        PBIMgt: Codeunit "Sales Filter Helper";        DateFilterText: Text;    begin        DateFilterText := PBIMgt.GenerateItemSalesReportDateFilter();        if DateFilterText <> '' then            CurrQuery.SetFilter(entryDate, DateFilterText);    end;}