Query 5833 Item to Value Entries

Base Application, Microsoft.Inventory.Analysis

src/Layers/W1/BaseApp/Inventory/Analysis/ItemToValueEntries.Query.al82 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.Analysis;using Microsoft.Inventory.Ledger;query 5833 "Item to Value Entries"{    DataAccessIntent = ReadOnly;    elements    {        dataitem(ItemLedgEntry; "Item Ledger Entry")        {            column(Entry_No_; "Entry No.")            {            }            filter(Positive; Positive)            {            }            filter(Item_No; "Item No.")            {            }            filter(Posting_Date; "Posting Date")            {            }            filter(Entry_Type; "Entry Type")            {            }            filter(Remaining_Quantity; "Remaining Quantity")            {            }            filter(Quantity; Quantity)            {            }            filter(Expiration_Date; "Expiration Date")            {            }            dataitem(Value_Entry; "Value Entry")            {                DataItemLink = "Item Ledger Entry No." = ItemLedgEntry."Entry No.";                SqlJoinType = InnerJoin;                filter(Value_Entry_Type; "Entry Type")                {                }                column(Cost_Amount__Actual_; "Cost Amount (Actual)")                {                    Method = Sum;                }                column(Cost_Amount__Expected; "Cost Amount (Expected)")                {                    Method = Sum;                }                column(Sales_Amount__Actual_; "Sales Amount (Actual)")                {                    Method = Sum;                }                column(Sales_Amount__Expected; "Sales Amount (Expected)")                {                    Method = Sum;                }                column(Invoiced_Quantity; "Invoiced Quantity")                {                    Method = Sum;                }            }        }    }}