Query 37005 Value Entries - Sales

PowerBI Reports, Microsoft.Sales.PowerBIReports

src/Apps/W1/PowerBIReports/App/_Obsolete/Sales/APIs/ValueEntriesSales.Query.al66 lines, Copyright (c) Microsoft Corporation. MIT

#if not CLEAN27// ------------------------------------------------------------------------------------------------// 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.Ledger;query 37005 "Value Entries - Sales"{    Access = Internal;    QueryType = API;    AboutText = 'Provides access to sales value entries including sales amounts, cost amounts, and invoiced quantities. This API has been replaced by query 37025 Sales Value Entries - PBI API.';    Caption = 'Power BI Sales Value Entries';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5';    EntityName = 'salesValueEntry';    EntitySetName = 'salesValueEntries';    DataAccessIntent = ReadOnly;    ObsoleteState = Pending;    ObsoleteReason = 'Replaced by the new query 37025 "Sales Value Entries - PBI API".';    ObsoleteTag = '27.0';    elements    {        dataitem(SalesValueEntry; "Item Ledger Entry")        {            DataItemTableFilter = "Entry Type" = const(Sale);            column(itemLedgerEntryNo; "Entry No.") { }            dataitem(Value_Entry; "Value Entry")            {                DataItemLink = "Item Ledger Entry No." = SalesValueEntry."Entry No.";                column(entryNo; "Entry No.") { }                column(entryType; "Entry Type") { }                column(documentNo; "Document No.") { }                column(documentType; "Document Type") { }                column(invoicedQuantity; "Invoiced Quantity") { }                column(salesAmountActual; "Sales Amount (Actual)") { }                column(costAmountActual; "Cost Amount (Actual)") { }                column(costAmountNonInvtbl; "Cost Amount (Non-Invtbl.)") { }                column(costPostedToGL; "Cost Posted to G/L") { }                column(customerNo; "Source No.") { }                column(postingDate; "Posting Date") { }                column(documentDate; "Document Date") { }                column(itemNo; "Item No.") { }                column(locationCode; "Location Code") { }                column(dimensionSetID; "Dimension Set ID") { }                column(salespersonPurchaserCode; "Salespers./Purch. Code") { }                column(returnReasonCode; "Return Reason Code") { }            }        }    }    trigger OnBeforeOpen()    var        PBIMgt: Codeunit "Sales Filter Helper";        DateFilterText: Text;    begin        DateFilterText := PBIMgt.GenerateItemSalesReportDateFilter();        if DateFilterText <> '' then            CurrQuery.SetFilter(postingDate, DateFilterText);    end;}#endif