Query 5840 Avg. Cost Entry Points Not Adj

Base Application, Microsoft.Inventory.Costing.ActionMessage

src/Layers/W1/BaseApp/Inventory/Costing/ActionMessage/AvgCostEntryPointsNotAdj.Query.al39 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.Inventory.Costing.ActionMessage;using Microsoft.Inventory.Costing;using Microsoft.Inventory.Item;query 5840 "Avg. Cost Entry Points Not Adj"{    QueryType = Normal;    DataAccessIntent = ReadOnly;    ReadState = ReadUncommitted;    OrderBy = descending(Count);    Caption = 'Avg. Cost Entry Points Not Adjusted';    elements    {        dataitem(Avg_Cost_Adjmt_Entry_Point; "Avg. Cost Adjmt. Entry Point")        {            DataItemTableFilter = "Cost Is Adjusted" = const(false);            column(Valuation_Date; "Valuation Date")            {            }            column(Count)            {                Method = Count;            }            dataitem(Item; Item)            {                DataItemLink = "No." = Avg_Cost_Adjmt_Entry_Point."Item No.";                DataItemTableFilter = "Excluded from Cost Adjustment" = const(false);                SqlJoinType = InnerJoin;            }        }    }}