Query 37000 Value Entries - Purch.
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