Query 5896 Calculate Actual Material Cost

Base Application, Microsoft.Inventory.Costing

src/Layers/W1/BaseApp/Inventory/Costing/CalculateActualMaterialCost.Query.al75 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;using Microsoft.Inventory.Ledger;query 5896 "Calculate Actual Material Cost"{    DataAccessIntent = ReadOnly;    elements    {        dataitem(ItemLedgEntry; "Item Ledger Entry")        {            column(Entry_No_; "Entry No.")            {            }            column(Positive; Positive)            {            }            filter(Entry_Type; "Entry Type")            {            }            filter(Order_No_; "Order No.")            {            }            filter(Order_Type; "Order Type")            {            }            filter(Order_Line_No_; "Order Line No.")            {            }            dataitem(Value_Entry; "Value Entry")            {                DataItemLink = "Item Ledger Entry No." = ItemLedgEntry."Entry No.";                SqlJoinType = InnerJoin;                filter(Value_Entry_Type; "Entry Type")                {                }                filter(Inventoriable; Inventoriable)                {                }                column(Cost_Amount__Actual_; "Cost Amount (Actual)")                {                    Method = Sum;                }                column(Cost_Amount__Actual___ACY_; "Cost Amount (Actual) (ACY)")                {                    Method = Sum;                }                column(Cost_Amount__Non_Invtbl__; "Cost Amount (Non-Invtbl.)")                {                    Method = Sum;                }                column(Cost_Amount__Non_Invtbl___ACY_; "Cost Amount (Non-Invtbl.)(ACY)")                {                    Method = Sum;                }            }        }    }}