Page 304 Item Entry Statistics

Base Application, Microsoft.Inventory.Item

src/Layers/W1/BaseApp/Inventory/Item/ItemEntryStatistics.Page.al737 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.Item;using Microsoft.Inventory.Ledger;using Microsoft.Purchases.Document;using Microsoft.Sales.Document;page 304 "Item Entry Statistics"{    Caption = 'Item Entry Statistics';    Editable = false;    LinksAllowed = false;    PageType = Card;    SourceTable = Item;    layout    {        area(content)        {            group("Most Recently Posted")            {                Caption = 'Most Recently Posted';                fixed(Control1903895301)                {                    ShowCaption = false;                    group(Date)                    {                        Caption = 'Date';#pragma warning disable AA0100                        field("ItemLedgEntry[5].""Posting Date"""; ItemLedgEntry[5]."Posting Date")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Receipt';                            ToolTip = 'Specifies item ledger entries that are related to purchase receipts.';                        }#pragma warning disable AA0100                        field("ValueEntry[1].""Posting Date"""; ValueEntry[1]."Posting Date")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Purchases';                            ToolTip = 'Specifies item ledger entries that are related to purchases.';                        }#pragma warning disable AA0100                        field("ItemLedgEntry[3].""Posting Date"""; ItemLedgEntry[3]."Posting Date")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Positive Adjustment';                            ToolTip = 'Specifies item ledger entries that are related to positive adjustment through an inventory journal.';                        }#pragma warning disable AA0100                        field("ItemLedgEntry[6].""Posting Date"""; ItemLedgEntry[6]."Posting Date")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Shipment';                            ToolTip = 'Specifies item ledger entries that are related to sales shipments.';                        }#pragma warning disable AA0100                        field("ValueEntry[2].""Posting Date"""; ValueEntry[2]."Posting Date")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Sales';                            ToolTip = 'Specifies item ledger entries that are related to sales.';                        }#pragma warning disable AA0100                        field("ItemLedgEntry[4].""Posting Date"""; ItemLedgEntry[4]."Posting Date")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Negative Adjustment';                            ToolTip = 'Specifies item ledger entries that are related to negative adjustment through an inventory journal.';                        }                    }                    group("Document No.")                    {                        Caption = 'Document No.';#pragma warning disable AA0100                        field("ItemLedgEntry[5].""Document No."""; ItemLedgEntry[5]."Document No.")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Document No.';                            ToolTip = 'Specifies the number of the document that the statistic is based on.';                        }#pragma warning disable AA0100                        field("ValueEntry[1].""Document No."""; ValueEntry[1]."Document No.")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Document No.';                            ToolTip = 'Specifies the number of the document that the statistic is based on.';                        }#pragma warning disable AA0100                        field("ItemLedgEntry[3].""Document No."""; ItemLedgEntry[3]."Document No.")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Document No.';                            ToolTip = 'Specifies the number of the document that the statistic is based on.';                        }#pragma warning disable AA0100                        field("ItemLedgEntry[6].""Document No."""; ItemLedgEntry[6]."Document No.")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Document No.';                            ToolTip = 'Specifies the number of the document that the statistic is based on.';                        }#pragma warning disable AA0100                        field("ValueEntry[2].""Document No."""; ValueEntry[2]."Document No.")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Document No.';                            ToolTip = 'Specifies the number of the document that the statistic is based on.';                        }#pragma warning disable AA0100                        field("ItemLedgEntry[4].""Document No."""; ItemLedgEntry[4]."Document No.")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Document No.';                            ToolTip = 'Specifies the number of the document that the statistic is based on.';                        }                    }                    group(Quantity)                    {                        Caption = 'Quantity';#pragma warning disable AA0100                        field("ValueEntry[5].""Valued Quantity"""; ValueEntry[5]."Valued Quantity")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Quantity';                            DecimalPlaces = 0 : 5;                            ToolTip = 'Specifies the total quantity of items in the entry.';                        }#pragma warning disable AA0100                        field("ValueEntry[1].""Invoiced Quantity"""; ValueEntry[1]."Invoiced Quantity")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Quantity';                            DecimalPlaces = 0 : 5;                            ToolTip = 'Specifies the total quantity of items in the entry.';                        }                        field("ItemLedgEntry[3].Quantity"; ItemLedgEntry[3].Quantity)                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Quantity';                            DecimalPlaces = 0 : 5;                            ToolTip = 'Specifies the total quantity of items in the entry.';                        }#pragma warning disable AA0100                        field("-ValueEntry[6].""Valued Quantity"""; -ValueEntry[6]."Valued Quantity")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 0;                            Caption = 'Quantity';                            DecimalPlaces = 0 : 5;                            ToolTip = 'Specifies the total quantity of items in the entry.';                        }#pragma warning disable AA0100                        field("-ValueEntry[2].""Invoiced Quantity"""; -ValueEntry[2]."Invoiced Quantity")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 0;                            Caption = 'Quantity';                            DecimalPlaces = 0 : 5;                            ToolTip = 'Specifies the total quantity of items in the entry.';                        }                        field("-ItemLedgEntry[4].Quantity"; -ItemLedgEntry[4].Quantity)                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 0;                            Caption = 'Quantity';                            DecimalPlaces = 0 : 5;                            ToolTip = 'Specifies the total quantity of items in the entry.';                        }                    }                    group("Unit Amount")                    {                        Caption = 'Unit Amount';                        field("UnitAmount[5]"; UnitAmount[5])                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 2;                            AutoFormatExpression = '';                            Caption = 'Unit Amount';                            ToolTip = 'Specifies the value per unit on the item ledger entry.';                        }                        field("UnitAmount[1]"; UnitAmount[1])                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 2;                            AutoFormatExpression = '';                            Caption = 'Unit Amount';                            ToolTip = 'Specifies the value per unit on the item ledger entry.';                        }                        field("UnitAmount[3]"; UnitAmount[3])                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 2;                            AutoFormatExpression = '';                            Caption = 'Unit Amount';                            ToolTip = 'Specifies the value per unit on the item ledger entry.';                        }                        field("UnitAmount[6]"; UnitAmount[6])                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 2;                            AutoFormatExpression = '';                            Caption = 'Unit Amount';                            ToolTip = 'Specifies the value per unit on the item ledger entry.';                        }                        field("UnitAmount[2]"; UnitAmount[2])                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 2;                            AutoFormatExpression = '';                            Caption = 'Unit Amount';                            ToolTip = 'Specifies the value per unit on the item ledger entry.';                        }                        field("UnitAmount[4]"; UnitAmount[4])                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 2;                            AutoFormatExpression = '';                            Caption = 'Unit Amount';                            ToolTip = 'Specifies the value per unit on the item ledger entry.';                        }                    }                    group("Discount Amount")                    {                        Caption = 'Discount Amount';#pragma warning disable AA0100                        field("ValueEntry[5].""Discount Amount"""; ValueEntry[5]."Discount Amount")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }#pragma warning disable AA0100                        field("ValueEntry[1].""Discount Amount"""; ValueEntry[1]."Discount Amount")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }#pragma warning disable AA0100                        field("ValueEntry[3].""Discount Amount"""; ValueEntry[3]."Discount Amount")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }#pragma warning disable AA0100                        field("-ValueEntry[6].""Discount Amount"""; -ValueEntry[6]."Discount Amount")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }#pragma warning disable AA0100                        field("-ValueEntry[2].""Discount Amount"""; -ValueEntry[2]."Discount Amount")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }#pragma warning disable AA0100                        field("-ValueEntry[4].""Discount Amount"""; -ValueEntry[4]."Discount Amount")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }                    }                    group(Amount)                    {                        Caption = 'Amount';#pragma warning disable AA0100                        field("ValueEntry[5].""Cost Amount (Actual)"""; ValueEntry[5]."Cost Amount (Actual)")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }#pragma warning disable AA0100                        field("ValueEntry[1].""Cost Amount (Actual)"""; ValueEntry[1]."Cost Amount (Actual)")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }#pragma warning disable AA0100                        field("ValueEntry[3].""Cost Amount (Actual)"""; ValueEntry[3]."Cost Amount (Actual)")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }#pragma warning disable AA0100                        field("ValueEntry[6].""Sales Amount (Actual)"""; ValueEntry[6]."Sales Amount (Actual)")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }#pragma warning disable AA0100                        field("ValueEntry[2].""Sales Amount (Actual)"""; ValueEntry[2]."Sales Amount (Actual)")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }#pragma warning disable AA0100                        field("-ValueEntry[4].""Cost Amount (Actual)"""; -ValueEntry[4]."Cost Amount (Actual)")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 1;                            AutoFormatExpression = '';                            Caption = 'Amount';                            ToolTip = 'Specifies the net amount of all the lines in the item entry.';                        }                    }                }            }            group("To Be Posted")            {                Caption = 'To Be Posted';                fixed(Control1904230801)                {                    ShowCaption = false;                    group(Control1900206001)                    {                        Caption = 'Date';#pragma warning disable AA0100                        field("PurchOrderLine[1].""Expected Receipt Date"""; PurchOrderLine[1]."Expected Receipt Date")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Next Receipt';                            ToolTip = 'Specifies information for the next expected receipt of the item.';                        }#pragma warning disable AA0100                        field("PurchOrderLine[2].""Expected Receipt Date"""; PurchOrderLine[2]."Expected Receipt Date")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Last Receipt';                            ToolTip = 'Specifies information about the last receipt that was posted for the item.';                        }#pragma warning disable AA0100                        field("SalesLine[1].""Shipment Date"""; SalesLine[1]."Shipment Date")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Next Shipment';                            ToolTip = 'Specifies information about the next shipment that is expected for the item.';                        }#pragma warning disable AA0100                        field("SalesLine[2].""Shipment Date"""; SalesLine[2]."Shipment Date")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Last Shipment';                            ToolTip = 'Specifies information about the last shipment that was posted for the item.';                        }                    }                    group("Order No.")                    {                        Caption = 'Order No.';#pragma warning disable AA0100                        field("PurchOrderLine[1].""Document No."""; PurchOrderLine[1]."Document No.")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Order No.';                            ToolTip = 'Specifies the number of the order that the item was handled on.';                        }#pragma warning disable AA0100                        field("PurchOrderLine[2].""Document No."""; PurchOrderLine[2]."Document No.")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Order No.';                            ToolTip = 'Specifies the number of the order that the item was handled on.';                        }#pragma warning disable AA0100                        field("SalesLine[1].""Document No."""; SalesLine[1]."Document No.")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Order No.';                            ToolTip = 'Specifies the number of the order that the item was handled on.';                        }#pragma warning disable AA0100                        field("SalesLine[2].""Document No."""; SalesLine[2]."Document No.")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Order No.';                            ToolTip = 'Specifies the number of the order that the item was handled on.';                        }                    }                    group(Control1903098801)                    {                        Caption = 'Quantity';                        field("PurchOrderLine[1].Quantity"; PurchOrderLine[1].Quantity)                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Quantity';                            ToolTip = 'Specifies the total quantity of items in the entry.';                        }                        field("PurchOrderLine[2].Quantity"; PurchOrderLine[2].Quantity)                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Quantity';                            ToolTip = 'Specifies the total quantity of items in the entry.';                        }                        field("SalesLine[1].Quantity"; SalesLine[1].Quantity)                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Quantity';                            ToolTip = 'Specifies the total quantity of items in the entry.';                        }                        field("SalesLine[2].Quantity"; SalesLine[2].Quantity)                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Quantity';                            ToolTip = 'Specifies the total quantity of items in the entry.';                        }                    }                    group(Control1900545201)                    {                        Caption = 'Unit Amount';#pragma warning disable AA0100                        field("PurchOrderLine[1].""Direct Unit Cost"""; PurchOrderLine[1]."Direct Unit Cost")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 2;                            Caption = 'Unit Amount';                            ToolTip = 'Specifies the value per unit on the item ledger entry.';                        }#pragma warning disable AA0100                        field("PurchOrderLine[2].""Direct Unit Cost"""; PurchOrderLine[2]."Direct Unit Cost")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 2;                            Caption = 'Unit Amount';                            ToolTip = 'Specifies the value per unit on the item ledger entry.';                        }#pragma warning disable AA0100                        field("SalesLine[1].""Unit Price"""; SalesLine[1]."Unit Price")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 2;                            Caption = 'Unit Amount';                            ToolTip = 'Specifies the value per unit on the item ledger entry.';                        }#pragma warning disable AA0100                        field("SalesLine[2].""Unit Price"""; SalesLine[2]."Unit Price")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            AutoFormatType = 2;                            Caption = 'Unit Amount';                            ToolTip = 'Specifies the value per unit on the item ledger entry.';                        }                    }                    group("Qty. on Order")                    {                        Caption = 'Qty. on Order';#pragma warning disable AA0100                        field("PurchOrderLine[1].""Outstanding Quantity"""; PurchOrderLine[1]."Outstanding Quantity")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Qty. on Order';                            ToolTip = 'Specifies the quantity on the order that the item was handled on.';                        }#pragma warning disable AA0100                        field("PurchOrderLine[2].""Outstanding Quantity"""; PurchOrderLine[2]."Outstanding Quantity")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Qty. on Order';                            ToolTip = 'Specifies the quantity on the order that the item was handled on.';                        }#pragma warning disable AA0100                        field("SalesLine[1].""Outstanding Quantity"""; SalesLine[1]."Outstanding Quantity")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Qty. on Order';                            ToolTip = 'Specifies the quantity on the order that the item was handled on.';                        }#pragma warning disable AA0100                        field("SalesLine[2].""Outstanding Quantity"""; SalesLine[2]."Outstanding Quantity")#pragma warning restore AA0100                        {                            ApplicationArea = Basic, Suite;                            Caption = 'Qty. on Order';                            ToolTip = 'Specifies the quantity on the order that the item was handled on.';                        }                    }                }            }        }    }    actions    {    }    trigger OnAfterGetRecord()    begin        ClearAll();        ItemLedgEntry2.SetCurrentKey(          "Item No.", "Entry Type", "Variant Code", "Drop Shipment", "Location Code", "Posting Date", "Entry No.");        ValueEntry2.SetCurrentKey(          "Item No.", "Posting Date", "Item Ledger Entry Type", "Entry Type", "Variance Type",          "Item Charge No.", "Location Code", "Variant Code", "Entry No.");        ItemLedgEntry2.SetRange("Item No.", Rec."No.");        ValueEntry2.SetRange("Item No.", Rec."No.");        for j := 1 to 4 do begin            ItemLedgEntry2.SetRange("Entry Type", j - 1); // Purchase,Positive Adjustment,Sale,Negative Adjustment            Rec.CopyFilter("Variant Filter", ItemLedgEntry2."Variant Code");            Rec.CopyFilter("Drop Shipment Filter", ItemLedgEntry2."Drop Shipment");            Rec.CopyFilter("Location Filter", ItemLedgEntry2."Location Code");            ValueEntry2.SetRange("Item Ledger Entry Type", j - 1);            ValueEntry2.SetRange("Entry Type", ValueEntry2."Entry Type"::"Direct Cost");            Rec.CopyFilter("Variant Filter", ValueEntry2."Variant Code");            Rec.CopyFilter("Drop Shipment Filter", ValueEntry2."Drop Shipment");            Rec.CopyFilter("Location Filter", ValueEntry2."Location Code");            if j in [1, 2] then begin // Purchase,Sale                ValueEntry2.SetFilter("Invoiced Quantity", '<>0');                FindLastValueEntry(j);                ValueEntry2.SetRange("Invoiced Quantity");                FindLastItemEntry(j + 4); // Receipt,Shipment                ValueEntry2.SetRange("Item Ledger Entry No.", ItemLedgEntry2."Entry No.");                FindLastValueEntry(j + 4);                ValueEntry2.SetRange("Item Ledger Entry No.");            end else begin                FindLastItemEntry(j);                ValueEntry2.SetRange("Item Ledger Entry No.", ItemLedgEntry2."Entry No.");                FindLastValueEntry(j);                ValueEntry2.SetRange("Item Ledger Entry No.");            end;        end;        PurchLine2.Reset();        PurchLine2.SetCurrentKey(          "Document Type", Type, "No.", "Variant Code",          "Drop Shipment", "Location Code", "Expected Receipt Date");        PurchLine2.SetRange("Document Type", PurchLine2."Document Type"::Order);        PurchLine2.SetRange(Type, PurchLine2.Type::Item);        PurchLine2.SetRange("No.", Rec."No.");        PurchLine2.SetFilter("Outstanding Quantity", '<>0');        Rec.CopyFilter("Variant Filter", PurchLine2."Variant Code");        Rec.CopyFilter("Drop Shipment Filter", PurchLine2."Drop Shipment");        Rec.CopyFilter("Location Filter", PurchLine2."Location Code");        if PurchLine2.Find('-') then begin            PurchOrderLine[1] := PurchLine2;            repeat                if (PurchLine2."Expected Receipt Date" < PurchOrderLine[1]."Expected Receipt Date") or                   ((PurchLine2."Expected Receipt Date" = PurchOrderLine[1]."Expected Receipt Date") and                    (PurchLine2."Document No." < PurchOrderLine[1]."Document No."))                then                    PurchOrderLine[1] := PurchLine2;                PurchLine2.SetRange("Variant Code", PurchLine2."Variant Code");                PurchLine2.SetRange("Drop Shipment", PurchLine2."Drop Shipment");                PurchLine2.SetRange("Location Code", PurchLine2."Location Code");                PurchLine2.Find('+');                if (PurchLine2."Expected Receipt Date" > PurchOrderLine[2]."Expected Receipt Date") or                   ((PurchLine2."Expected Receipt Date" = PurchOrderLine[2]."Expected Receipt Date") and                    (PurchLine2."Document No." > PurchOrderLine[2]."Document No."))                then                    PurchOrderLine[2] := PurchLine2;                Rec.CopyFilter("Variant Filter", PurchLine2."Variant Code");                Rec.CopyFilter("Location Filter", PurchLine2."Location Code");                Rec.CopyFilter("Drop Shipment Filter", PurchLine2."Drop Shipment");            until PurchLine2.Next() = 0;        end;        SalesLine2.Reset();        SalesLine2.SetCurrentKey(          "Document Type", Type, "No.", "Variant Code",          "Drop Shipment", "Location Code", "Shipment Date");        SalesLine2.SetRange("Document Type", SalesLine2."Document Type"::Order);        SalesLine2.SetRange(Type, SalesLine2.Type::Item);        SalesLine2.SetRange("No.", Rec."No.");        Rec.CopyFilter("Variant Filter", SalesLine2."Variant Code");        SalesLine2.SetFilter("Outstanding Quantity", '<>0');        Rec.CopyFilter("Drop Shipment Filter", SalesLine2."Drop Shipment");        Rec.CopyFilter("Location Filter", SalesLine2."Location Code");        if SalesLine2.Find('-') then begin            SalesLine[1] := SalesLine2;            repeat                if (SalesLine2."Shipment Date" < SalesLine[1]."Shipment Date") or                   ((SalesLine2."Shipment Date" = SalesLine[1]."Shipment Date") and                    (SalesLine2."Document No." < SalesLine[1]."Document No."))                then                    SalesLine[1] := SalesLine2;                SalesLine2.SetRange("Variant Code", SalesLine2."Variant Code");                SalesLine2.SetRange("Drop Shipment", SalesLine2."Drop Shipment");                SalesLine2.SetRange("Location Code", SalesLine2."Location Code");                SalesLine2.Find('+');                if (SalesLine2."Shipment Date" > SalesLine[2]."Shipment Date") or                   ((SalesLine2."Shipment Date" = SalesLine[2]."Shipment Date") and                    (SalesLine2."Document No." > SalesLine[2]."Document No."))                then                    SalesLine[2] := SalesLine2;                Rec.CopyFilter("Variant Filter", SalesLine2."Variant Code");                Rec.CopyFilter("Location Filter", SalesLine2."Location Code");                Rec.CopyFilter("Drop Shipment Filter", SalesLine2."Drop Shipment");            until SalesLine2.Next() = 0;        end;    end;    var        ItemLedgEntry2: Record "Item Ledger Entry";        ValueEntry2: Record "Value Entry";        PurchLine2: Record "Purchase Line";        SalesLine2: Record "Sales Line";        ItemLedgEntry: array[6] of Record "Item Ledger Entry";        ValueEntry: array[6] of Record "Value Entry";        PurchOrderLine: array[2] of Record "Purchase Line";        SalesLine: array[2] of Record "Sales Line";        j: Integer;        UnitAmount: array[6] of Decimal;    local procedure FindLastItemEntry(k: Integer)    begin        if ItemLedgEntry2.Find('-') then            repeat                ItemLedgEntry2.SetRange("Variant Code", ItemLedgEntry2."Variant Code");                ItemLedgEntry2.SetRange("Drop Shipment", ItemLedgEntry2."Drop Shipment");                ItemLedgEntry2.SetRange("Location Code", ItemLedgEntry2."Location Code");                ItemLedgEntry2.Find('+');                if (ItemLedgEntry2."Posting Date" > ItemLedgEntry[k]."Posting Date") or                   ((ItemLedgEntry2."Posting Date" = ItemLedgEntry[k]."Posting Date") and                    (ItemLedgEntry2."Entry No." > ItemLedgEntry[k]."Entry No."))                then                    ItemLedgEntry[k] := ItemLedgEntry2;                Rec.CopyFilter("Variant Filter", ItemLedgEntry2."Variant Code");                Rec.CopyFilter("Drop Shipment Filter", ItemLedgEntry2."Drop Shipment");                Rec.CopyFilter("Location Filter", ItemLedgEntry2."Location Code");            until ItemLedgEntry2.Next() = 0;    end;    local procedure FindLastValueEntry(k: Integer)    begin        if ValueEntry2.Find('-') then            repeat                ValueEntry2.SetRange("Variant Code", ValueEntry2."Variant Code");                ValueEntry2.SetRange("Drop Shipment", ValueEntry2."Drop Shipment");                ValueEntry2.SetRange("Location Code", ValueEntry2."Location Code");                ValueEntry2.Find('+');                if (ValueEntry2."Posting Date" > ValueEntry[k]."Posting Date") or                   ((ValueEntry2."Posting Date" = ValueEntry[k]."Posting Date") and                    (ValueEntry2."Entry No." > ValueEntry[k]."Entry No."))                then begin                    ValueEntry[k] := ValueEntry2;                    if ValueEntry2."Valued Quantity" <> 0 then begin                        if ValueEntry2."Item Ledger Entry Type" = ValueEntry2."Item Ledger Entry Type"::Sale then                            UnitAmount[k] :=                              -(ValueEntry2."Sales Amount (Actual)" - ValueEntry2."Discount Amount") / ValueEntry2."Valued Quantity"                        else                            UnitAmount[k] :=                              (ValueEntry2."Cost Amount (Actual)" + ValueEntry2."Discount Amount") / ValueEntry2."Valued Quantity"                    end else                        UnitAmount[k] := 0;                end;                Rec.CopyFilter("Variant Filter", ValueEntry2."Variant Code");                Rec.CopyFilter("Drop Shipment Filter", ValueEntry2."Drop Shipment");                Rec.CopyFilter("Location Filter", ValueEntry2."Location Code");            until ValueEntry2.Next() = 0;    end;}