Query 37000 Value Entries - Purch.

PowerBI Reports, Microsoft.Purchases.PowerBIReports

src/Apps/W1/PowerBIReports/App/_Obsolete/Purchasing/APIs/ValueEntriesPurch.Query.al87 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.Purchases.PowerBIReports;using Microsoft.Inventory.Ledger;query 37000 "Value Entries - Purch."{    Access = Internal;    QueryType = API;    AboutText = 'Provides access to purchase value entries for item purchases including cost amounts, invoiced quantities, and dimension data. This API has been replaced by query 37023 Purch. Value Entries - PBI API.';    Caption = 'Power BI Purchase Value Entries';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5';    EntityName = 'purchaseValueEntry';    EntitySetName = 'purchaseValueEntries';    DataAccessIntent = ReadOnly;    ObsoleteState = Pending;    ObsoleteReason = 'Replaced by the new query 37023 "Purch. Value Entries - PBI API".';    ObsoleteTag = '27.0';    elements    {        dataitem(PurchValueEntry; "Item Ledger Entry")        {            DataItemTableFilter = "Entry Type" = const(Purchase);            column(itemLedgerEntryNo; "Entry No.")            {            }            dataitem(ValueEntry; "Value Entry")            {                DataItemLink = "Item Ledger Entry No." = PurchValueEntry."Entry No.";                column(entryNo; "Entry No.")                {                }                column(entryType; "Entry Type")                {                }                column(documentNo; "Document No.")                {                }                column(documentType; "Document Type")                {                }                column(vendorNo; "Source No.")                {                }                column(postingDate; "Posting Date")                {                }                column(itemNo; "Item No.")                {                }                column(locationCode; "Location Code")                {                }                column(dimensionSetID; "Dimension Set ID")                {                }                column(invoicedQuantity; "Invoiced Quantity")                {                }                column(costAmountActual; "Cost Amount (Actual)")                {                }                column(salespersonPurchaserCode; "Salespers./Purch. Code")                {                }            }        }    }    trigger OnBeforeOpen()    var        PBIMgt: Codeunit "Purchases Filter Helper";        DateFilterText: Text;    begin        DateFilterText := PBIMgt.GenerateItemPurchasesReportDateFilter();        if DateFilterText <> '' then            CurrQuery.SetFilter(postingDate, DateFilterText);    end;}#endif