Query 37004 Item Budget Entries - Sales
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;}