Query 37005 Value Entries - Sales
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