Query 5896 Calculate Actual Material Cost
- App
- Base Application
- Namespace
- Microsoft.Inventory.Costing
- Versions
- 20-28
Versions171819202122232425262728
Source29
Source in 29
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;
}
}
}
}
}