Table 7326 Whse. Worksheet Line

Base Application, Microsoft.Warehouse.Worksheet

src/Layers/W1/BaseApp/Warehouse/Worksheet/WhseWorksheetLine.Table.al1,766 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.Warehouse.Worksheet;using Microsoft.Foundation.Shipping;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Inventory.Tracking;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Planning;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Warehouse.Activity;using Microsoft.Warehouse.Availability;using Microsoft.Warehouse.Document;using Microsoft.Warehouse.History;using Microsoft.Warehouse.InternalDocument;using Microsoft.Warehouse.Journal;using Microsoft.Warehouse.Ledger;using Microsoft.Warehouse.Request;using Microsoft.Warehouse.Setup;using Microsoft.Warehouse.Structure;using Microsoft.Warehouse.Tracking;using System.Reflection;using System.Telemetry;table 7326 "Whse. Worksheet Line"{    Caption = 'Whse. Worksheet Line';    DataClassification = CustomerContent;    fields    {        field(1; "Worksheet Template Name"; Code[10])        {            Caption = 'Worksheet Template Name';            NotBlank = true;            TableRelation = "Whse. Worksheet Template";        }        field(2; Name; Code[10])        {            Caption = 'Name';            NotBlank = true;        }        field(3; "Line No."; Integer)        {            Caption = 'Line No.';            Editable = false;        }        field(4; "Source Type"; Integer)        {            Caption = 'Source Type';            Editable = false;        }        field(5; "Source Subtype"; Option)        {            Caption = 'Source Subtype';            Editable = false;            OptionCaption = '0,1,2,3,4,5,6,7,8,9,10';            OptionMembers = "0","1","2","3","4","5","6","7","8","9","10";        }        field(6; "Source No."; Code[20])        {            Caption = 'Source No.';            ToolTip = 'Specifies the number of the source document that the entry originates from.';            Editable = false;        }        field(7; "Source Line No."; Integer)        {            BlankZero = true;            Caption = 'Source Line No.';            ToolTip = 'Specifies the line number of the source document that the entry originates from.';            Editable = false;        }        field(8; "Source Subline No."; Integer)        {            BlankZero = true;            Caption = 'Source Subline No.';            Editable = false;        }        field(9; "Source Document"; Enum "Warehouse Activity Source Document")        {            BlankZero = true;            Caption = 'Source Document';            ToolTip = 'Specifies the type of document that the line relates to.';            Editable = false;        }        field(10; "Location Code"; Code[10])        {            Caption = 'Location Code';            Editable = false;            TableRelation = Location;        }        field(11; "Shelf No."; Code[10])        {            Caption = 'Shelf No.';            ToolTip = 'Specifies the shelf number of the item for information use.';        }        field(12; "From Zone Code"; Code[10])        {            Caption = 'From Zone Code';            ToolTip = 'Specifies the zone from which the items should be taken.';            TableRelation = Zone.Code where("Location Code" = field("Location Code"));            trigger OnValidate()            begin                if "From Zone Code" <> xRec."From Zone Code" then                    "From Bin Code" := '';            end;        }        field(13; "From Bin Code"; Code[20])        {            Caption = 'From Bin Code';            ToolTip = 'Specifies the code of the bin from which the items should be taken.';            trigger OnLookup()            begin                LookupFromBinCode();            end;            trigger OnValidate()            var                WMSMgt: Codeunit "WMS Management";            begin                if "From Bin Code" <> '' then                    WMSMgt.FindBinContent("Location Code", "From Bin Code", "Item No.", "Variant Code", "From Zone Code");                if CurrFieldNo = FieldNo("From Bin Code") then                    CheckBin("Location Code", "From Bin Code", false);                if "From Bin Code" <> '' then begin                    GetBin("Location Code", "From Bin Code");                    "From Zone Code" := Bin."Zone Code";                end;            end;        }        field(14; "To Bin Code"; Code[20])        {            Caption = 'To Bin Code';            ToolTip = 'Specifies the code of the bin into which the items should be placed.';            TableRelation = if ("To Zone Code" = filter('')) Bin.Code where("Location Code" = field("Location Code"),                                                                            Code = field("To Bin Code"))            else            if ("To Zone Code" = filter(<> '')) Bin.Code where("Location Code" = field("Location Code"),                                                               "Zone Code" = field("To Zone Code"),                                                               Code = field("To Bin Code"));            trigger OnValidate()            begin                if CurrFieldNo = FieldNo("To Bin Code") then                    CheckBin("Location Code", "To Bin Code", true);                if "To Bin Code" <> '' then begin                    GetBin("Location Code", "To Bin Code");                    "To Zone Code" := Bin."Zone Code";                end;            end;        }        field(15; "To Zone Code"; Code[10])        {            Caption = 'To Zone Code';            ToolTip = 'Specifies the code of the zone in which the items should be placed.';            TableRelation = Zone.Code where("Location Code" = field("Location Code"));            trigger OnValidate()            begin                if "To Zone Code" <> xRec."To Zone Code" then                    "To Bin Code" := '';            end;        }        field(16; "Item No."; Code[20])        {            Caption = 'Item No.';            ToolTip = 'Specifies the number of the item that the line concerns.';            TableRelation = Item where(Type = const(Inventory));            trigger OnValidate()            begin                if "Item No." <> '' then begin                    GetItemUnitOfMeasure();                    Description := Item.Description;                    Validate("Unit of Measure Code", ItemUnitOfMeasure.Code);                end else begin                    Description := '';                    "Variant Code" := '';                    Validate("Unit of Measure Code", '');                end;            end;        }        field(17; Quantity; Decimal)        {            AutoFormatType = 0;            Caption = 'Quantity';            ToolTip = 'Specifies how many units of the item you want to move.';            DecimalPlaces = 0 : 5;            MinValue = 0;            trigger OnValidate()            begin                if Quantity < "Qty. Handled" then                    FieldError(Quantity, StrSubstNo(Text010, "Qty. Handled"));                if not IsProdOrder(Rec."Source Type") then                    Validate("Qty. Outstanding", (Quantity - "Qty. Handled"))                else                    UpdateQtyHandledForProdOrderOutput();                "Qty. (Base)" := CalcBaseQty(Quantity, FieldCaption(Quantity), FieldCaption("Qty. (Base)"));            end;        }        field(18; "Qty. (Base)"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. (Base)';            DecimalPlaces = 0 : 5;            Editable = false;        }        field(19; "Qty. Outstanding"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. Outstanding';            ToolTip = 'Specifies the quantity that still needs to be handled.';            DecimalPlaces = 0 : 5;            Editable = false;            trigger OnValidate()            begin                "Qty. Outstanding (Base)" := CalcBaseQty("Qty. Outstanding", FieldCaption("Qty. Outstanding"), FieldCaption("Qty. Outstanding (Base)"));                Validate("Qty. to Handle", "Qty. Outstanding");            end;        }        field(20; "Qty. Outstanding (Base)"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. Outstanding (Base)';            DecimalPlaces = 0 : 5;            Editable = false;        }        field(21; "Qty. to Handle"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. to Handle';            ToolTip = 'Specifies how many units of the item you want to move.';            DecimalPlaces = 0 : 5;            MinValue = 0;            trigger OnValidate()            var                WhseWkshTemplate: Record "Whse. Worksheet Template";                Confirmed: Boolean;                AvailableQty: Decimal;            begin                if "Qty. to Handle" > "Qty. Outstanding" then                    Error(                      Text000,                      "Qty. Outstanding");                "Qty. to Handle (Base)" := CalcBaseQty("Qty. to Handle", FieldCaption("Qty. to Handle"), FieldCaption("Qty. to Handle (Base)"));                if "Qty. to Handle (Base)" > 0 then begin                    WhseWkshTemplate.Get("Worksheet Template Name");                    if WhseWkshTemplate.Type = WhseWkshTemplate.Type::Pick then begin                        Confirmed := true;                        if (CurrFieldNo = FieldNo("Qty. to Handle")) and                           ("Shipping Advice" = "Shipping Advice"::Complete) and                           ("Qty. to Handle" <> "Qty. Outstanding")                        then                            Confirmed := Confirm(                                Text001 +                                Text002,                                false,                                FieldCaption("Shipping Advice"),                                "Shipping Advice",                                FieldCaption("Qty. to Handle"),                                "Qty. Outstanding");                        if not Confirmed then                            Error(Text003);                        UpdatePickQtyToHandleBase();                    end else                        if WhseWkshTemplate.Type = WhseWkshTemplate.Type::Movement then                            if CurrFieldNo <> FieldNo("Qty. to Handle") then begin                                AvailableQty := CheckAvailQtytoMove();                                OnValidateQtyToHandleOnAfterCalcQtyAvailToMove(Rec, xRec, AvailableQty);                                if AvailableQty < 0 then                                    "Qty. to Handle (Base)" := 0                                else                                    if "Qty. to Handle (Base)" > AvailableQty then                                        "Qty. to Handle (Base)" := AvailableQty;                            end;                    CheckBin("Location Code", "From Bin Code", false);                    CheckBin("Location Code", "To Bin Code", true);                end;                TestField("Qty. per Unit of Measure");                if "Qty. to Handle (Base)" = "Qty. Outstanding (Base)" then                    "Qty. to Handle" := "Qty. Outstanding"                else                    "Qty. to Handle" := Round("Qty. to Handle (Base)" / "Qty. per Unit of Measure", UOMMgt.QtyRndPrecision()); // what about this???            end;        }        field(22; "Qty. to Handle (Base)"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. to Handle (Base)';            DecimalPlaces = 0 : 5;            trigger OnValidate()            begin                TestField("Qty. per Unit of Measure", 1);                Validate("Qty. to Handle", "Qty. to Handle (Base)");            end;        }        field(23; "Qty. Handled"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. Handled';            ToolTip = 'Specifies the quantity that has been handled and registered.';            DecimalPlaces = 0 : 5;            Editable = false;            trigger OnValidate()            begin                "Qty. Handled (Base)" := CalcBaseQty("Qty. Handled", FieldCaption("Qty. Handled"), FieldCaption("Qty. Handled (Base)"));                if not IsProdOrder(Rec."Source Type") then                    Validate("Qty. Outstanding", Quantity - "Qty. Handled")                else                    UpdateQtyHandledForProdOrderOutput();            end;        }        field(24; "Qty. Handled (Base)"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. Handled (Base)';            DecimalPlaces = 0 : 5;            Editable = false;            trigger OnValidate()            begin                "Qty. Handled" := CalcQty("Qty. Handled (Base)");                if not IsProdOrder(Rec."Source Type") then                    Validate("Qty. Outstanding", Quantity - "Qty. Handled")                else                    UpdateQtyHandledForProdOrderOutput();            end;        }        field(27; "From Unit of Measure Code"; Code[10])        {            Caption = 'From Unit of Measure Code';            NotBlank = true;            TableRelation = "Item Unit of Measure".Code where("Item No." = field("Item No."));            trigger OnValidate()            var                FromItemUnitOfMeasure: Record "Item Unit of Measure";            begin                if "Item No." <> '' then begin                    GetItemUnitOfMeasure();                    if not FromItemUnitOfMeasure.Get(Item."No.", "From Unit of Measure Code") then                        FromItemUnitOfMeasure.Get(Item."No.", Item."Base Unit of Measure");                    "Qty. per From Unit of Measure" := FromItemUnitOfMeasure."Qty. per Unit of Measure";                end else                    "Qty. per From Unit of Measure" := 1;            end;        }        field(28; "Qty. per From Unit of Measure"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. per From Unit of Measure';            DecimalPlaces = 0 : 5;            Editable = false;            InitValue = 1;        }        field(29; "Unit of Measure Code"; Code[10])        {            Caption = 'Unit of Measure Code';            ToolTip = 'Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.';            NotBlank = true;            TableRelation = "Item Unit of Measure".Code where("Item No." = field("Item No."));            trigger OnValidate()            begin                if "Item No." <> '' then begin                    GetItemUnitOfMeasure();                    "Qty. per Unit of Measure" := ItemUnitOfMeasure."Qty. per Unit of Measure";                    "Qty. Rounding Precision" := UOMMgt.GetQtyRoundingPrecision(Item, ItemUnitOfMeasure.Code);                    "Qty. Rounding Precision (Base)" := UOMMgt.GetQtyRoundingPrecision(Item, Item."Base Unit of Measure");                end else                    "Qty. per Unit of Measure" := 1;                "From Unit of Measure Code" := "Unit of Measure Code";                "Qty. per From Unit of Measure" := "Qty. per Unit of Measure";                ValidateQty();            end;        }        field(30; "Qty. per Unit of Measure"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. per Unit of Measure';            DecimalPlaces = 0 : 5;            Editable = false;            InitValue = 1;        }        field(31; "Variant Code"; Code[10])        {            Caption = 'Variant Code';            ToolTip = 'Specifies the variant of the item on the line.';            TableRelation = "Item Variant".Code where("Item No." = field("Item No."));            trigger OnValidate()            var                ItemVariant: Record "Item Variant";            begin                if "Variant Code" <> '' then begin                    ItemVariant.Get("Item No.", "Variant Code");                    Description := ItemVariant.Description;                    "Description 2" := ItemVariant."Description 2";                end else                    GetItem("Item No.", Description);            end;        }        field(32; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies the description of the item on the line.';        }        field(33; "Description 2"; Text[50])        {            Caption = 'Description 2';            ToolTip = 'Specifies information in addition to the description.';        }        field(35; "Sorting Sequence No."; Integer)        {            Caption = 'Sorting Sequence No.';            Editable = false;        }        field(36; "Due Date"; Date)        {            Caption = 'Due Date';            ToolTip = 'Specifies the due date of the line.';        }        field(39; "Destination Type"; Enum "Warehouse Destination Type")        {            Caption = 'Destination Type';            ToolTip = 'Specifies the type of destination associated with the warehouse worksheet line.';            Editable = false;        }        field(40; "Destination No."; Code[20])        {            Caption = 'Destination No.';            ToolTip = 'Specifies the number of the customer, vendor, or location for which the items should be processed.';            Editable = false;            TableRelation = if ("Destination Type" = const(Customer)) Customer."No."            else            if ("Destination Type" = const(Vendor)) Vendor."No."            else            if ("Destination Type" = const(Location)) Location.Code;        }        field(41; "Shipping Agent Code"; Code[10])        {            AccessByPermission = TableData "Shipping Agent Services" = R;            Caption = 'Shipping Agent Code';            TableRelation = "Shipping Agent";        }        field(42; "Shipping Agent Service Code"; Code[10])        {            Caption = 'Shipping Agent Service Code';            TableRelation = "Shipping Agent Services".Code where("Shipping Agent Code" = field("Shipping Agent Code"));        }        field(43; "Shipment Method Code"; Code[10])        {            Caption = 'Shipment Method Code';            TableRelation = "Shipment Method";        }        field(44; "Shipping Advice"; Enum "Sales Header Shipping Advice")        {            Caption = 'Shipping Advice';            ToolTip = 'Specifies the shipping advice on the warehouse shipment line associated with this worksheet line.';            Editable = false;        }        field(45; "Shipment Date"; Date)        {            Caption = 'Shipment Date';        }        field(46; "Whse. Document Type"; Enum "Warehouse Worksheet Document Type")        {            Caption = 'Whse. Document Type';            ToolTip = 'Specifies the type of warehouse document this line is associated with.';            Editable = false;        }        field(47; "Whse. Document No."; Code[20])        {            Caption = 'Whse. Document No.';            ToolTip = 'Specifies the number of the warehouse document.';            Editable = false;            TableRelation = if ("Whse. Document Type" = const(Receipt)) "Posted Whse. Receipt Header"."No." where("No." = field("Whse. Document No."))            else            if ("Whse. Document Type" = const(Shipment)) "Warehouse Shipment Header"."No." where("No." = field("Whse. Document No."))            else            if ("Whse. Document Type" = const("Internal Put-away")) "Whse. Internal Put-away Header"."No." where("No." = field("Whse. Document No."))            else            if ("Whse. Document Type" = const("Internal Pick")) "Whse. Internal Pick Header"."No." where("No." = field("Whse. Document No."))            else            if ("Whse. Document Type" = const(Job)) Job."No." where("No." = field("Whse. Document No."));        }        field(48; "Whse. Document Line No."; Integer)        {            BlankZero = true;            Caption = 'Whse. Document Line No.';            ToolTip = 'Specifies the number of the line in the warehouse document that is the basis for the worksheet line.';            Editable = false;            TableRelation = if ("Whse. Document Type" = const(Receipt)) "Posted Whse. Receipt Line"."Line No." where("No." = field("Whse. Document No."),                                                                                                                     "Line No." = field("Whse. Document Line No."))            else            if ("Whse. Document Type" = const(Shipment)) "Warehouse Shipment Line"."Line No." where("No." = field("Whse. Document No."),                                                                                                    "Line No." = field("Whse. Document Line No."))            else            if ("Whse. Document Type" = const("Internal Put-away")) "Whse. Internal Put-away Line"."Line No." where("No." = field("Whse. Document No."),                                                                                                                    "Line No." = field("Whse. Document Line No."))            else            if ("Whse. Document Type" = const("Internal Pick")) "Whse. Internal Pick Line"."Line No." where("No." = field("Whse. Document No."),                                                                                                            "Line No." = field("Whse. Document Line No."))            else            if ("Whse. Document Type" = const(Job)) "Job Planning Line"."Job Contract Entry No." where("Job No." = field("Whse. Document No."),                                                                                                       "Job Contract Entry No." = field("Whse. Document Line No."));        }        field(50; "Qty. Rounding Precision"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. Rounding Precision';            InitValue = 0;            DecimalPlaces = 0 : 5;            MinValue = 0;            MaxValue = 1;            Editable = false;        }        field(51; "Qty. Rounding Precision (Base)"; Decimal)        {            AutoFormatType = 0;            Caption = 'Qty. Rounding Precision (Base)';            InitValue = 0;            DecimalPlaces = 0 : 5;            MinValue = 0;            MaxValue = 1;            Editable = false;        }    }    keys    {        key(Key1; "Worksheet Template Name", Name, "Location Code", "Line No.")        {            Clustered = true;        }        key(Key2; "Worksheet Template Name", Name, "Location Code", "Sorting Sequence No.")        {        }        key(Key3; "Item No.", "Location Code", "Worksheet Template Name", "Variant Code", "Unit of Measure Code")        {            IncludedFields = "Qty. to Handle (Base)";        }        key(Key4; "Whse. Document Type", "Whse. Document No.", "Whse. Document Line No.")        {        }        key(Key5; "Worksheet Template Name", Name, "Location Code", "Item No.")        {            MaintainSQLIndex = false;        }        key(Key6; "Worksheet Template Name", Name, "Location Code", "Due Date")        {            MaintainSQLIndex = false;        }        key(Key7; "Worksheet Template Name", Name, "Location Code", "Destination Type", "Destination No.")        {            MaintainSQLIndex = false;        }        key(Key8; "Worksheet Template Name", Name, "Location Code", "Source Document", "Source No.")        {            MaintainSQLIndex = false;        }        key(Key9; "Worksheet Template Name", Name, "Location Code", "To Bin Code")        {            MaintainSQLIndex = false;        }        key(Key10; "Worksheet Template Name", Name, "Location Code", "Shelf No.")        {            MaintainSQLIndex = false;        }        key(Key11; "Source Type", "Source Subtype", "Source No.", "Source Line No.", "Source Subline No.")        {        }        key(Key12; "Item No.", "From Bin Code", "Location Code", "Variant Code", "From Unit of Measure Code")        {            IncludedFields = "Qty. to Handle", "Qty. to Handle (Base)";        }    }    fieldgroups    {        fieldgroup(Brick; "Item No.", Description, Quantity, "Source No.", "Due Date")        { }    }    trigger OnDelete()    var        WhseWkshTemplate: Record "Whse. Worksheet Template";        ItemTrackingMgt: Codeunit "Item Tracking Management";    begin        WhseWkshTemplate.Get("Worksheet Template Name");        if WhseWkshTemplate.Type = WhseWkshTemplate.Type::Movement then begin            UpdateMovActivLines();            ItemTrackingMgt.DeleteWhseItemTrkgLines(              Database::"Whse. Worksheet Line", 0, Name, "Worksheet Template Name", 0, "Line No.", "Location Code", true);        end;    end;    var        WhseWorksheetLine: Record "Whse. Worksheet Line";        Location: Record Location;        Item: Record Item;        Bin: Record Bin;        BinType: Record "Bin Type";        ItemUnitOfMeasure: Record "Item Unit of Measure";        CreatePick: Codeunit "Create Pick";        WhseAvailMgt: Codeunit "Warehouse Availability Mgt.";        UOMMgt: Codeunit "Unit of Measure Management";        LastLineNo: Integer;        OpenFromBatch: Boolean;        CurrentFieldNo: Integer;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'You cannot handle more than the outstanding %1 units.';        Text001: Label '%1 is set to %2. %3 should be %4.\\';#pragma warning restore AA0470        Text002: Label 'Accept the entered value?';        Text003: Label 'The update was interrupted to respect the warning.';#pragma warning disable AA0470        Text004: Label 'You cannot handle more than the available %1 units.';#pragma warning restore AA0470        Text005: Label 'DEFAULT';#pragma warning disable AA0470        Text006: Label 'Default %1 Worksheet';#pragma warning restore AA0470#pragma warning restore AA0074#pragma warning disable AA0074#pragma warning disable AA0470        Text008: Label '%1 Worksheet';        Text009: Label 'The location %1 of %2 %3 is not enabled for user %4.';        Text010: Label 'must not be less than %1 units';#pragma warning restore AA0470        Text011: Label 'Quantity available to pick is not enough to fill in all the lines.';#pragma warning restore AA0074    protected var        HideValidationDialog: Boolean;    procedure CalcBaseQty(Qty: Decimal): Decimal    begin        TestField("Qty. per Unit of Measure");        exit(UOMMgt.RoundQty(Qty * "Qty. per Unit of Measure", "Qty. Rounding Precision (Base)"));    end;    local procedure CalcBaseQty(Qty: Decimal; FromFieldName: Text; ToFieldName: Text): Decimal    begin        TestField("Qty. per Unit of Measure");        exit(UOMMgt.CalcBaseQty(            "Item No.", "Variant Code", "Unit of Measure Code", Qty, "Qty. per Unit of Measure", "Qty. Rounding Precision (Base)", FieldCaption("Qty. Rounding Precision"), FromFieldName, ToFieldName));    end;    procedure CalcQty(QtyBase: Decimal): Decimal    begin        TestField("Qty. per Unit of Measure");        exit(Round(QtyBase / "Qty. per Unit of Measure", UOMMgt.QtyRndPrecision()));    end;    procedure AutofillQtyToHandle(var WhseWkshLine: Record "Whse. Worksheet Line")    var        NotEnough: Boolean;    begin        NotEnough := false;        WhseWkshLine.SetHideValidationDialog(true);        WhseWkshLine.LockTable();        if WhseWkshLine.Find('-') then            repeat                if WhseWkshLine."Qty. to Handle" <> WhseWkshLine."Qty. Outstanding" then begin                    WhseWkshLine.Validate(WhseWkshLine."Qty. to Handle", WhseWkshLine."Qty. Outstanding");                    if WhseWkshLine."Qty. to Handle" <> xRec."Qty. to Handle" then begin                        OnAutofillQtyToHandleOnbeforeModify(WhseWkshLine);                        WhseWkshLine.Modify();                        if not NotEnough then                            if WhseWkshLine."Qty. to Handle" < WhseWkshLine."Qty. Outstanding" then                                NotEnough := true;                    end;                end;            until WhseWkshLine.Next() = 0;        WhseWkshLine.SetHideValidationDialog(false);        if NotEnough then            Message(Text011);        OnAfterAutofillQtyToHandle(WhseWkshLine);    end;    procedure DeleteQtyToHandle(var WhseWkshLine: Record "Whse. Worksheet Line")    begin        WhseWkshLine.LockTable();        if WhseWkshLine.Find('-') then            repeat                WhseWkshLine.Validate(WhseWkshLine."Qty. to Handle", 0);                WhseWkshLine.OnDeleteQtyToHandleOnBeforeModify(WhseWkshLine);                WhseWkshLine.Modify();            until WhseWkshLine.Next() = 0;    end;    procedure AssignedQtyOnReservedLines(): Decimal    var        WhseWkshLine: Record "Whse. Worksheet Line";        TempWhseActivLine: Record "Warehouse Activity Line" temporary;        LineReservedQtyBase: Decimal;        TotalReservedAndAssignedBase: Decimal;        ReservedAndAssignedBase: Decimal;    begin        WhseWkshLine.SetCurrentKey(          "Item No.", "Location Code", "Worksheet Template Name", "Variant Code");        WhseWkshLine.SetRange("Item No.", "Item No.");        WhseWkshLine.SetRange("Location Code", "Location Code");        WhseWkshLine.SetRange("Worksheet Template Name", "Worksheet Template Name");        WhseWkshLine.SetRange("Variant Code", "Variant Code");        OnAssignedQtyOnReservedLinesOnAfterWhseWkshLineSetFilters(Rec, WhseWkshLine);        if WhseWkshLine.Find('-') then            repeat                if RecordId <> WhseWkshLine.RecordId then begin                    LineReservedQtyBase :=                      Abs(                        WhseAvailMgt.CalcLineReservedQtyOnInvt(                          WhseWkshLine."Source Type", WhseWkshLine."Source Subtype",                          WhseWkshLine."Source No.", WhseWkshLine."Source Line No.",                          WhseWkshLine."Source Subline No.",                          true, TempWhseActivLine));                    if LineReservedQtyBase > 0 then begin                        if LineReservedQtyBase <= WhseWkshLine."Qty. to Handle (Base)" then                            ReservedAndAssignedBase := LineReservedQtyBase                        else                            ReservedAndAssignedBase := WhseWkshLine."Qty. to Handle (Base)";                        TotalReservedAndAssignedBase := TotalReservedAndAssignedBase + ReservedAndAssignedBase;                    end;                end;            until WhseWkshLine.Next() = 0;        exit(TotalReservedAndAssignedBase);    end;    procedure CalcAvailableQtyBase() AvailableQty: Decimal    var        DummyWhseItemTrackingLine: Record "Whse. Item Tracking Line";        AvailQtyBase: Decimal;        QtyAssgndOnWkshBase: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCalcAvailableQtyBase(Rec, AvailableQty, IsHandled);        if IsHandled then            exit(AvailableQty);        GetItem("Item No.");        GetLocation("Location Code");        if Location."Directed Put-away and Pick" then begin            QtyAssgndOnWkshBase := WhseAvailMgt.CalcQtyAssgndOnWksh(Rec, not Location."Allow Breakbulk", true);            // Adjust the available quantity to pick with the QtyAssgndOnWkshBase and AssignedQtyOnReservedLines from the other active worksheet lines.            AvailableQty := CreatePick.CalcTotalAvailQtyToPickForDirectedPutAwayPick("Location Code", "Item No.", "Variant Code", DummyWhseItemTrackingLine, "Source Type", "Source Subtype", "Source No.", "Source Line No.", "Source Subline No.", "Qty. to Handle (Base)", QtyAssgndOnWkshBase, AssignedQtyOnReservedLines());        end else begin            QtyAssgndOnWkshBase := WhseAvailMgt.CalcQtyAssgndOnWksh(Rec, true, true);            AvailQtyBase := WhseAvailMgt.CalcQtyAvailToTakeOnWhseWorksheetLine(Rec);            AvailableQty := AvailQtyBase - QtyAssgndOnWkshBase + AssignedQtyOnReservedLines();        end;        OnAfterCalcAvailableQtyBase(Rec, AvailableQty);    end;    procedure CalcReservedNotFromILEQty(QtyBaseAvailToPick: Decimal; var QtyToPick: Decimal; var QtyToPickBase: Decimal)    begin        CreatePick.CheckReservation(            QtyBaseAvailToPick, "Source Type", "Source Subtype", "Source No.", "Source Line No.", "Source Subline No.", false,            "Qty. per Unit of Measure", QtyToPick, QtyToPickBase);    end;    procedure CheckAvailQtytoMove() AvailableQtyToMoveBase: Decimal    begin        AvailableQtyToMoveBase := CalcAvailQtyToMove() + xRec."Qty. to Handle (Base)";        OnAfterCheckAvailQtytoMove(Rec, xRec, AvailableQtyToMoveBase);    end;    local procedure CalcAvailQtyToMove() QtyAvailToMoveBase: Decimal    var        BinContent: Record "Bin Content";        WhseWkshLine: Record "Whse. Worksheet Line";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCalcAvailQtyToMove(Rec, QtyAvailToMoveBase, IsHandled);        if IsHandled then            exit(QtyAvailToMoveBase);        if ("Location Code" <> '') and ("From Bin Code" <> '') and           ("Item No." <> '') and ("From Unit of Measure Code" <> '')        then begin            GetLocation("Location Code");            if BinContent.Get(                 "Location Code", "From Bin Code", "Item No.", "Variant Code", "From Unit of Measure Code")            then begin                QtyAvailToMoveBase := BinContent.CalcQtyAvailToTake(0);                WhseWkshLine.SetCurrentKey(                  "Item No.", "From Bin Code", "Location Code", "Variant Code", "From Unit of Measure Code");                WhseWkshLine.SetRange("Item No.", "Item No.");                WhseWkshLine.SetRange("From Bin Code", "From Bin Code");                WhseWkshLine.SetRange("Location Code", "Location Code");                WhseWkshLine.SetRange("Variant Code", "Variant Code");                WhseWkshLine.SetRange("From Unit of Measure Code", "From Unit of Measure Code");                OnCalcAvailQtyToMoveOnAfterSetFilters(WhseWkshLine, Rec);                WhseWkshLine.CalcSums("Qty. to Handle (Base)");                QtyAvailToMoveBase := QtyAvailToMoveBase - WhseWkshLine."Qty. to Handle (Base)";            end;        end;    end;    local procedure UpdateQtyHandledForProdOrderOutput()    begin        OnUpdateQtyHandledForProdOrderOutput(Rec);    end;    local procedure IsProdOrder(SourceType: Integer): Boolean    begin        exit(SourceType = 5406); // Database::"Prod. Order Line"    end;    procedure SortWhseWkshLines(WhseWkshTemplate: Code[10]; WhseWkshName: Code[10]; LocationCode: Code[10]; SortingMethod: Enum "Whse. Activity Sorting Method")    var        WhseWkshLine: Record "Whse. Worksheet Line";        SequenceNo: Integer;    begin        WhseWkshLine.SetRange("Worksheet Template Name", WhseWkshTemplate);        WhseWkshLine.SetRange(Name, WhseWkshName);        WhseWkshLine.SetRange("Location Code", LocationCode);        case SortingMethod of            SortingMethod::Item:                WhseWkshLine.SetCurrentKey(                  "Worksheet Template Name", Name, "Location Code", "Item No.");            SortingMethod::Document:                WhseWkshLine.SetCurrentKey(                  "Worksheet Template Name", Name, "Location Code", "Source Document", "Source No.");            SortingMethod::"Shelf or Bin":                begin                    GetLocation(LocationCode);                    if Location."Bin Mandatory" then                        WhseWkshLine.SetCurrentKey(                          "Worksheet Template Name", Name, "Location Code", "To Bin Code", "Shelf No.")                    else                        WhseWkshLine.SetCurrentKey(                          "Worksheet Template Name", Name, "Location Code", "Shelf No.");                end;            SortingMethod::"Due Date":                WhseWkshLine.SetCurrentKey(                  "Worksheet Template Name", Name, "Location Code", "Due Date");            SortingMethod::"Ship-To":                WhseWkshLine.SetCurrentKey(                  "Worksheet Template Name", Name, "Location Code", "Destination Type", "Destination No.");            else                OnSortWhseWkshLinesOnCaseElse(WhseWkshLine, SortingMethod);        end;        if WhseWkshLine.Find('-') then begin            SequenceNo := 10000;            repeat                WhseWkshLine."Sorting Sequence No." := SequenceNo;                WhseWkshLine.Modify();                SequenceNo := SequenceNo + 10000;            until WhseWkshLine.Next() = 0;        end;    end;    local procedure GetLocation(LocationCode: Code[10])    begin        if Location.Code <> LocationCode then            if LocationCode = '' then                Location.GetLocationSetup(LocationCode, Location)            else                Location.Get(LocationCode);    end;    procedure GetItem(ItemNo: Code[20]; var ItemDescription: Text[100])    begin        if ItemNo = '' then            ItemDescription := ''        else            if ItemNo <> Item."No." then begin                ItemDescription := '';                if Item.Get(ItemNo) then                    ItemDescription := Item.Description;            end else                ItemDescription := Item.Description;        OnAfterGetItem(Rec, Item, ItemDescription);    end;    local procedure GetItem(ItemNo: Code[20])    var        ItemDescription: Text[100];    begin        GetItem(ItemNo, ItemDescription);    end;    local procedure GetItemUnitOfMeasure()    begin        GetItem("Item No.", Description);        if (Item."No." <> ItemUnitOfMeasure."Item No.") or           ("Unit of Measure Code" <> ItemUnitOfMeasure.Code)        then            if not ItemUnitOfMeasure.Get(Item."No.", "Unit of Measure Code") then                ItemUnitOfMeasure.Get(Item."No.", Item."Base Unit of Measure");    end;    local procedure GetBin(LocationCode: Code[10]; BinCode: Code[20])    begin        if (LocationCode = '') or (BinCode = '') then            Clear(Bin)        else            if (Bin."Location Code" <> LocationCode) or               (Bin.Code <> BinCode)            then                Bin.Get(LocationCode, BinCode);    end;    procedure CheckBin(LocationCode: Code[10]; BinCode: Code[20]; Inbound: Boolean)    var        WhseWkshTemplate: Record "Whse. Worksheet Template";        BinContent: Record "Bin Content";        WMSMgt: Codeunit "WMS Management";        Cubage: Decimal;        Weight: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckBin(Rec, LocationCode, BinCode, Inbound, IsHandled);        if IsHandled then            exit;        GetLocation(LocationCode);        GetBin(LocationCode, BinCode);        if Location."Directed Put-away and Pick" then begin            Bin.CalcFields("Adjustment Bin");            Bin.TestField("Adjustment Bin", false);        end;        if (BinCode <> '') and ("Item No." <> '') then begin            if Location."Directed Put-away and Pick" then                if Bin."Bin Type Code" <> '' then begin                    WhseWkshTemplate.Get("Worksheet Template Name");                    if WhseWkshTemplate.Type = WhseWkshTemplate.Type::Movement then begin                        GetBinType(Bin."Bin Type Code");                        BinType.TestField(Receive, false);                    end;                end;            if Inbound then begin                if Location."Bin Capacity Policy" <> Location."Bin Capacity Policy"::"Never Check Capacity" then begin                    WMSMgt.CalcCubageAndWeight(                      "Item No.", "Unit of Measure Code", "Qty. to Handle", Cubage, Weight);                    CheckIncreaseBin(BinCode, Cubage, Weight);                end else                    if Location."Check Whse. Class" then                        CheckWhseClass(BinCode);            end else                if Location."Directed Put-away and Pick" then begin                    BinContent.Get("Location Code", BinCode, "Item No.", "Variant Code", "From Unit of Measure Code");                    if BinContent."Block Movement" in [BinContent."Block Movement"::Outbound, BinContent."Block Movement"::All] then                        BinContent.FieldError("Block Movement");                end;        end;    end;    local procedure CheckIncreaseBin(BinCode: Code[20]; Cubage: Decimal; Weight: Decimal)    var        BinContent: Record "Bin Content";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckIncreaseBin(Rec, Bin, BinCode, Cubage, Weight, IsHandled);        if IsHandled then            exit;        if BinContent.Get(             "Location Code", BinCode, "Item No.", "Variant Code", "Unit of Measure Code")        then            BinContent.CheckIncreaseBinContent(              "Qty. to Handle (Base)", 0, 0, 0, Cubage, Weight, false, false)        else            Bin.CheckIncreaseBin(BinCode, "Item No.", "Qty. to Handle", 0, 0, Cubage, Weight, false, false);    end;    local procedure CheckWhseClass(BinCode: Code[20])    var        BinContent: Record "Bin Content";    begin        if BinContent.Get(             "Location Code", BinCode, "Item No.", "Variant Code", "Unit of Measure Code")        then            BinContent.CheckWhseClass(false)        else            Bin.CheckWhseClass("Item No.", false);    end;    local procedure GetBinType(BinTypeCode: Code[10])    begin        if BinTypeCode = '' then begin            Clear(BinType);            BinType.Init();        end else            if BinType.Code <> BinTypeCode then                BinType.Get(BinTypeCode);    end;    procedure PutAwayCreate(var WhsePutAwayWkshLine: Record "Whse. Worksheet Line")    var        CreatePutAwayFromWhseSource: Report "Whse.-Source - Create Document";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforePutAwayCreate(WhsePutAwayWkshLine, IsHandled, HideValidationDialog);        if IsHandled then            exit;        CreatePutAwayFromWhseSource.SetWhseWkshLine(WhsePutAwayWkshLine);        CreatePutAwayFromWhseSource.RunModal();        CreatePutAwayFromWhseSource.GetResultMessage(1);        Clear(CreatePutAwayFromWhseSource);    end;    procedure MovementCreate(var WhseWkshLine: Record "Whse. Worksheet Line")    var        WhseSourceCreateDocument: Report "Whse.-Source - Create Document";        CreateInventoryPickMovement: Codeunit "Create Inventory Pick/Movement";        FeatureTelemetry: Codeunit "Feature Telemetry";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeMovementCreate(WhseWkshLine, IsHandled);        if IsHandled then            exit;        if WhseWkshLine."Location Code" <> '' then begin            GetLocation(WhseWkshLine."Location Code");            if not Location."Directed Put-away and Pick" then begin                FeatureTelemetry.LogUsage('0000JNP', 'Warehouse Movement', 'create movement document for basic warehouse');                CreateInventoryPickMovement.SetHideDialogForTracking(true);                CreateInventoryPickMovement.CreateInvtMvntWithoutSource(WhseWkshLine);                exit;            end;        end;        WhseSourceCreateDocument.SetWhseWkshLine(WhseWkshLine);        WhseSourceCreateDocument.RunModal();        WhseSourceCreateDocument.GetResultMessage(3);        Clear(WhseSourceCreateDocument);    end;    local procedure ValidateQty()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeValidateQty(Rec, IsHandled);        if IsHandled then            exit;        Validate(Quantity);    end;    procedure TemplateSelection(PageID: Integer; PageTemplate: Option "Put-away",Pick,Movement; var WhseWkshLine: Record "Whse. Worksheet Line"; var WhseWkshSelected: Boolean)    var        WhseWkshTemplate: Record "Whse. Worksheet Template";    begin        WhseWkshSelected := true;        WhseWkshTemplate.Reset();        WhseWkshTemplate.SetRange("Page ID", PageID);        WhseWkshTemplate.SetRange(Type, PageTemplate);        case WhseWkshTemplate.Count of            0:                begin                    WhseWkshTemplate.Init();                    WhseWkshTemplate.Validate(Type, PageTemplate);                    WhseWkshTemplate.Validate("Page ID");                    WhseWkshTemplate.Name :=                      Format(WhseWkshTemplate.Type, MaxStrLen(WhseWkshTemplate.Name));                    WhseWkshTemplate.Description := StrSubstNo(Text008, WhseWkshTemplate.Type);                    WhseWkshTemplate.Insert();                    Commit();                end;            1:                WhseWkshTemplate.FindFirst();            else                WhseWkshSelected := Page.RunModal(0, WhseWkshTemplate) = Action::LookupOK;        end;        if WhseWkshSelected then begin            WhseWkshLine.FilterGroup := 2;            WhseWkshLine.SetRange("Worksheet Template Name", WhseWkshTemplate.Name);            WhseWkshLine.FilterGroup := 0;            if OpenFromBatch then begin                WhseWkshLine."Worksheet Template Name" := '';                Page.Run(WhseWkshTemplate."Page ID", WhseWkshLine);            end;        end;    end;    procedure TemplateSelectionFromBatch(var WhseWkshName: Record "Whse. Worksheet Name")    var        WhseWkshLine: Record "Whse. Worksheet Line";        WhseWkshTemplate: Record "Whse. Worksheet Template";    begin        OpenFromBatch := true;        WhseWkshTemplate.Get(WhseWkshName."Worksheet Template Name");        WhseWkshTemplate.TestField("Page ID");        WhseWkshName.TestField(Name);        WhseWkshLine.FilterGroup := 2;        WhseWkshLine.SetRange("Worksheet Template Name", WhseWkshTemplate.Name);        WhseWkshLine.FilterGroup := 0;        WhseWkshLine."Worksheet Template Name" := '';        WhseWkshLine.Name := WhseWkshName.Name;        WhseWkshLine."Location Code" := WhseWkshName."Location Code";        Page.Run(WhseWkshTemplate."Page ID", WhseWkshLine);    end;    procedure OpenWhseWksh(var WhseWkshLine: Record "Whse. Worksheet Line"; var CurrentWkshTemplateName: Code[10]; var CurrentWkshName: Code[10]; var CurrentLocationCode: Code[10])    begin        CurrentWkshTemplateName := WhseWkshLine.GetRangeMax("Worksheet Template Name");        CheckTemplateName(CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode);        WhseWkshLine.FilterGroup := 2;        WhseWkshLine.SetRange(Name, CurrentWkshName);        if CurrentLocationCode <> '' then            WhseWkshLine.SetRange("Location Code", CurrentLocationCode);        WhseWkshLine.FilterGroup := 0;    end;    procedure OpenWhseWkshBatch(var WhseWkshName: Record "Whse. Worksheet Name")    var        WhseWkshTemplate: Record "Whse. Worksheet Template";        WhseWkshLine: Record "Whse. Worksheet Line";        WmsMgt: Codeunit "WMS Management";        JnlSelected: Boolean;    begin        if WhseWkshName.GetFilter("Worksheet Template Name") <> '' then            exit;        WhseWkshName.FilterGroup(2);        if WhseWkshName.GetFilter("Worksheet Template Name") <> '' then begin            WhseWkshName.FilterGroup(0);            exit;        end;        WhseWkshName.FilterGroup(0);        if not WhseWkshName.Find('-') then            for WhseWkshTemplate.Type := WhseWkshTemplate.Type::"Put-away" to WhseWkshTemplate.Type::Movement do begin                WhseWkshTemplate.SetRange(Type, WhseWkshTemplate.Type);                if not WhseWkshTemplate.FindFirst() then                    TemplateSelection(0, WhseWkshTemplate.Type.AsInteger(), WhseWkshLine, JnlSelected);                if WhseWkshTemplate.FindFirst() then begin                    if WhseWkshName."Location Code" = '' then                        WhseWkshName."Location Code" := WmsMgt.GetDefaultLocation();                    CheckTemplateName(WhseWkshTemplate.Name, WhseWkshName.Name, WhseWkshName."Location Code");                end;            end;        WhseWkshName.Find('-');        JnlSelected := true;        WhseWkshName.CalcFields("Template Type");        WhseWkshTemplate.SetRange(Type, WhseWkshName."Template Type");        if WhseWkshName.GetFilter("Worksheet Template Name") <> '' then            WhseWkshTemplate.SetRange(Name, WhseWkshName.GetFilter("Worksheet Template Name"));        case WhseWkshTemplate.Count of            1:                WhseWkshTemplate.FindFirst();            else                JnlSelected := Page.RunModal(0, WhseWkshTemplate) = Action::LookupOK;        end;        if not JnlSelected then            Error('');        WhseWkshName.FilterGroup(0);        WhseWkshName.SetRange("Worksheet Template Name", WhseWkshTemplate.Name);        WhseWkshName.FilterGroup(2);    end;    local procedure CheckTemplateName(CurrentWkshTemplateName: Code[10]; var CurrentWkshName: Code[10]; var CurrentLocationCode: Code[10])    var        WhseWkshTemplate: Record "Whse. Worksheet Template";        WhseWkshName: Record "Whse. Worksheet Name";        WhseEmployee: Record "Warehouse Employee";        WmsMgt: Codeunit "WMS Management";        FoundLocation: Boolean;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckTemplateName(CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode, IsHandled);        if IsHandled then            exit;        WhseWkshTemplate.Get(CurrentWkshTemplateName);        WhseWkshName.SetRange("Worksheet Template Name", CurrentWkshTemplateName);        if not WhseWkshName.Get(CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode) or           ((UserId <> '') and not WhseEmployee.Get(UserId, CurrentLocationCode))        then begin            if UserId <> '' then begin                CurrentLocationCode := WmsMgt.GetDefaultLocation();                WhseWkshName.SetRange("Location Code", CurrentLocationCode);            end;            if not WhseWkshName.FindFirst() then begin                if UserId <> '' then begin                    WhseEmployee.SetCurrentKey(Default);                    WhseEmployee.SetRange(Default, false);                    WhseEmployee.SetRange("User ID", UserId);                    if WhseEmployee.Find('-') then                        repeat                            WhseWkshName.SetRange("Location Code", WhseEmployee."Location Code");                            FoundLocation := WhseWkshName.FindFirst();                        until (WhseEmployee.Next() = 0) or FoundLocation;                end;                if not FoundLocation then begin                    WhseWkshName.Init();                    WhseWkshName."Worksheet Template Name" := CurrentWkshTemplateName;                    WhseWkshName.SetupNewName();                    WhseWkshName.Name := Text005;                    WhseWkshName.Description :=                      StrSubstNo(Text006, WhseWkshTemplate.Type);                    WhseWkshName.Insert(true);                end;                CurrentLocationCode := WhseWkshName."Location Code";                Commit();            end;            CurrentWkshName := WhseWkshName.Name;            CurrentLocationCode := WhseWkshName."Location Code";        end;    end;    procedure CheckWhseWkshName(CurrentWkshName: Code[10]; CurrentLocationCode: Code[10]; var WhseWkshLine: Record "Whse. Worksheet Line")    var        WhseWkshName: Record "Whse. Worksheet Name";        WhseEmployee: Record "Warehouse Employee";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckWhseWkshName(CurrentWkshName, CurrentLocationCode, IsHandled);        if IsHandled then            exit;        WhseWkshName.Get(          WhseWkshLine.GetRangeMax("Worksheet Template Name"), CurrentWkshName, CurrentLocationCode);        if (UserId <> '') and not WhseEmployee.Get(UserId, CurrentLocationCode) then            Error(Text009, CurrentLocationCode, WhseWkshName.TableCaption(), CurrentWkshName, UserId);    end;    procedure SetWhseWkshName(CurrentWkshName: Code[10]; CurrentLocationCode: Code[10]; var WhseWkshLine: Record "Whse. Worksheet Line")    begin        WhseWkshLine.FilterGroup := 2;        WhseWkshLine.SetRange(Name, CurrentWkshName);        WhseWkshLine.SetRange("Location Code", CurrentLocationCode);        WhseWkshLine.FilterGroup := 0;        if WhseWkshLine.Find('-') then;    end;    procedure LookupWhseWkshName(var WhseWkshLine: Record "Whse. Worksheet Line"; var CurrentWkshName: Code[10]; var CurrentLocationCode: Code[10])    var        WhseWkshName: Record "Whse. Worksheet Name";    begin        Commit();        WhseWkshName."Worksheet Template Name" := WhseWkshLine.GetRangeMax("Worksheet Template Name");        WhseWkshName.Name := WhseWkshLine.GetRangeMax(Name);        WhseWkshName.FilterGroup(2);        WhseWkshName.SetRange("Worksheet Template Name", WhseWkshName."Worksheet Template Name");        WhseWkshName.FilterGroup(0);        OnLookupWhseWkshNameOnBeforeRunModal(WhseWkshName);        if Page.RunModal(0, WhseWkshName) = Action::LookupOK then begin            CurrentWkshName := WhseWkshName.Name;            CurrentLocationCode := WhseWkshName."Location Code";            SetWhseWkshName(CurrentWkshName, WhseWkshName."Location Code", WhseWkshLine);        end;    end;    local procedure UpdatePickQtyToHandleBase()    var        TypeHelper: Codeunit "Type Helper";        AvailableQty: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeUpdatePickQtyToHandleBase(Rec, CurrFieldNo, IsHandled);        if IsHandled then            exit;        GetLocation("Location Code");        if Location."Bin Mandatory" then begin            if CurrFieldNo <> FieldNo("Qty. to Handle") then                if not Location."Always Create Pick Line" then begin                    AvailableQty := CalcAvailableQtyBase();                    if "Qty. to Handle (Base)" > AvailableQty then                        if ("Shipping Advice" = "Shipping Advice"::Complete) then                            "Qty. to Handle (Base)" := 0                        else                            "Qty. to Handle (Base)" := TypeHelper.Maximum(0, AvailableQty);                end        end else begin            AvailableQty := CalcAvailableQtyBase();            if "Qty. to Handle (Base)" > AvailableQty then begin                if ("Shipping Advice" = "Shipping Advice"::Complete) or                   (AvailableQty < 0)                then                    "Qty. to Handle (Base)" := 0                else                    "Qty. to Handle (Base)" := AvailableQty;                if (not HideValidationDialog) and (CurrFieldNo = FieldNo("Qty. to Handle")) then                    Error(                      Text004,                      AvailableQty);            end;        end;    end;    local procedure UpdateMovActivLines()    var        WhseActivLine: Record "Warehouse Activity Line";        WhseActivLine2: Record "Warehouse Activity Line";    begin        WhseActivLine.SetCurrentKey(          "Whse. Document No.", "Whse. Document Type", "Activity Type", "Whse. Document Line No.");        WhseActivLine.SetRange("Whse. Document No.", Name);        WhseActivLine.SetRange("Whse. Document Type", WhseActivLine."Whse. Document Type"::"Movement Worksheet");        WhseActivLine.SetRange("Activity Type", WhseActivLine."Activity Type"::Movement);        WhseActivLine.SetRange("Whse. Document Line No.", "Line No.");        WhseActivLine.SetRange("Source Type", Database::"Whse. Worksheet Line");        WhseActivLine.SetRange("Source No.", "Worksheet Template Name");        WhseActivLine.SetRange("Location Code", "Location Code");        if WhseActivLine.Find('-') then            repeat                WhseActivLine2.Copy(WhseActivLine);                WhseActivLine2."Source Type" := 0;                WhseActivLine2."Source No." := '';                WhseActivLine2."Source Line No." := 0;                WhseActivLine2.Modify();            until WhseActivLine.Next() = 0;    end;    procedure SetHideValidationDialog(NewHideValidationDialog: Boolean)    begin        HideValidationDialog := NewHideValidationDialog;    end;    procedure OpenItemTrackingLines()    var        WhseItemTrackingLines: Page "Whse. Item Tracking Lines";    begin        OnBeforeOpenItemTrackingLines(Rec);        TestField("Item No.");        TestField("Qty. (Base)");        WhseItemTrackingLinesSetSource(WhseItemTrackingLines);        WhseItemTrackingLines.RunModal();    end;    local procedure WhseItemTrackingLinesSetSource(var WhseItemTrackingLines: Page "Whse. Item Tracking Lines")    var        IsHandled: Boolean;    begin        case "Whse. Document Type" of            "Whse. Document Type"::Receipt:                WhseItemTrackingLines.SetSource(Rec, Database::"Posted Whse. Receipt Line");            "Whse. Document Type"::Shipment:                WhseItemTrackingLines.SetSource(Rec, Database::"Warehouse Shipment Line");            "Whse. Document Type"::"Internal Put-away":                WhseItemTrackingLines.SetSource(Rec, Database::"Whse. Internal Put-away Line");            "Whse. Document Type"::"Internal Pick":                WhseItemTrackingLines.SetSource(Rec, Database::"Whse. Internal Pick Line");            else begin                IsHandled := false;                OnWhseItemTrackingLinesSetSource(Rec, WhseItemTrackingLines, IsHandled);                if not IsHandled then                    WhseItemTrackingLines.SetSource(Rec, Database::"Whse. Worksheet Line");            end;        end;    end;    procedure AvailableQtyToPick(): Decimal    begin        if "Qty. per Unit of Measure" <> 0 then            exit(Round(CalcAvailableQtyBase() / "Qty. per Unit of Measure", UOMMgt.QtyRndPrecision()));        exit(0);    end;    internal procedure AvailableQtyToPickForCurrentLine(): Decimal    var        TypeHelper: Codeunit "Type Helper";    begin        exit(TypeHelper.Minimum(Rec."Qty. (Base)", AvailableQtyToPick()));    end;    procedure InitNewLineWithItem(DocumentType: Enum "Warehouse Worksheet Document Type"; DocumentNo: Code[20];                                                    DocumentLineNo: Integer;                                                    LocationCode: Code[10];                                                    ItemNo: Code[20];                                                    VariantCode: Code[10];                                                    Qty: Decimal;                                                    QtyToHandle: Decimal;                                                    QtyPerUoM: Decimal)    begin        Init();        "Whse. Document Type" := DocumentType;        "Whse. Document No." := DocumentNo;        "Whse. Document Line No." := DocumentLineNo;        "Location Code" := LocationCode;        "Item No." := ItemNo;        "Variant Code" := VariantCode;        "Qty. (Base)" := Qty;        "Qty. to Handle (Base)" := QtyToHandle;        "Qty. per Unit of Measure" := QtyPerUoM;        OnAfterInitLineWithItem();    end;    procedure SetUpNewLine(WhseWkshTemplate: Code[10]; WhseWkshName: Code[10]; LocationCode: Code[10]; SortingMethod: Enum "Whse. Activity Sorting Method"; LineNo: Integer)    begin        WhseWorksheetLine.Reset();        WhseWorksheetLine.SetRange("Worksheet Template Name", WhseWkshTemplate);        WhseWorksheetLine.SetRange(Name, WhseWkshName);        WhseWorksheetLine.SetRange("Location Code", LocationCode);        if WhseWorksheetLine.Count = 0 then            LastLineNo := 0        else            LastLineNo := LineNo;        "Worksheet Template Name" := WhseWkshTemplate;        Name := WhseWkshName;        "Location Code" := LocationCode;        "Line No." := GetNextLineNo(SortingMethod);        "Whse. Document Type" := "Whse. Document Type"::"Whse. Mov.-Worksheet";        "Whse. Document No." := WhseWkshName;        "Whse. Document Line No." := "Line No.";    end;    local procedure GetNextLineNo(SortMethod: Enum "Whse. Activity Sorting Method"): Integer    var        WhseWorksheetLine2: Record "Whse. Worksheet Line";        HigherLineNo: Integer;        LowerLineNo: Integer;    begin        WhseWorksheetLine2.Copy(WhseWorksheetLine);        if SortMethod <> SortMethod::None then            exit(GetLastLineNo() + 10000);        WhseWorksheetLine2 := Rec;        WhseWorksheetLine2."Line No." := LastLineNo;        if WhseWorksheetLine2.Find('<') then            LowerLineNo := WhseWorksheetLine2."Line No."        else            if WhseWorksheetLine2.Find('>') then                exit(LastLineNo div 2)            else                exit(LastLineNo + 10000);        WhseWorksheetLine2 := Rec;        WhseWorksheetLine2."Line No." := LastLineNo;        if WhseWorksheetLine2.Find('>') then            HigherLineNo := LastLineNo        else            exit(LastLineNo + 10000);        exit(LowerLineNo + (HigherLineNo - LowerLineNo) div 2);    end;    local procedure GetLastLineNo(): Integer    var        WhseWorksheetLine2: Record "Whse. Worksheet Line";    begin        WhseWorksheetLine2.CopyFilters(WhseWorksheetLine);        if WhseWorksheetLine2.FindLast() then            exit(WhseWorksheetLine2."Line No.");        exit(0);    end;    procedure GetSortSeqNo(SortMethod: Enum "Whse. Activity Sorting Method"): Integer    var        WhseWorksheetLine2: Record "Whse. Worksheet Line";        HigherSeqNo: Integer;        LowerSeqNo: Integer;        LastSeqNo: Integer;    begin        WhseWorksheetLine2 := Rec;        WhseWorksheetLine2.SetRecFilter();        WhseWorksheetLine2.SetRange("Line No.");        case SortMethod of            SortMethod::None:                WhseWorksheetLine2.SetCurrentKey(                  "Worksheet Template Name", Name, "Location Code", "Line No.");            SortMethod::Item:                WhseWorksheetLine2.SetCurrentKey(                  "Worksheet Template Name", Name, "Location Code", "Item No.");            SortMethod::Document:                WhseWorksheetLine2.SetCurrentKey(                  "Worksheet Template Name", Name, "Location Code", "Source Document", "Source No.");            SortMethod::"Shelf or Bin":                begin                    GetLocation("Location Code");                    if Location."Bin Mandatory" then                        WhseWorksheetLine2.SetCurrentKey(                          "Worksheet Template Name", Name, "Location Code", "To Bin Code")                    else                        WhseWorksheetLine2.SetCurrentKey(                          "Worksheet Template Name", Name, "Location Code", "Shelf No.");                end;            SortMethod::"Due Date":                WhseWorksheetLine2.SetCurrentKey(                  "Worksheet Template Name", Name, "Location Code", "Due Date");            SortMethod::"Ship-To":                WhseWorksheetLine2.SetCurrentKey(                  "Worksheet Template Name", Name, "Location Code", "Destination Type", "Destination No.")            else                OnGetSortSeqNoOnCaseElse(WhseWorksheetLine2, SortMethod);        end;        LastSeqNo := GetLastSeqNo(WhseWorksheetLine2);        if WhseWorksheetLine2.Find('<') then            LowerSeqNo := WhseWorksheetLine2."Sorting Sequence No."        else            if WhseWorksheetLine2.Find('>') then                exit(WhseWorksheetLine2."Sorting Sequence No." div 2)            else                LowerSeqNo := 10000;        WhseWorksheetLine2 := Rec;        if WhseWorksheetLine2.Find('>') then            HigherSeqNo := WhseWorksheetLine2."Sorting Sequence No."        else            if WhseWorksheetLine2.Find('<') then                exit(LastSeqNo + 10000)            else                HigherSeqNo := LastSeqNo;        exit(LowerSeqNo + (HigherSeqNo - LowerSeqNo) div 2);    end;    local procedure GetLastSeqNo(WhseWorksheetLine2: Record "Whse. Worksheet Line"): Integer    begin        WhseWorksheetLine2.SetRecFilter();        WhseWorksheetLine2.SetRange("Line No.");        WhseWorksheetLine2.SetCurrentKey("Worksheet Template Name", Name, "Location Code", "Sorting Sequence No.");        if WhseWorksheetLine2.FindLast() then            exit(WhseWorksheetLine2."Sorting Sequence No.");        exit(0);    end;    procedure SetItemTrackingLines(WhseEntry: Record "Warehouse Entry"; QtyToEmpty: Decimal)    var        WhseItemTrackingLines: Page "Whse. Item Tracking Lines";    begin        TestField("Item No.");        TestField("Qty. (Base)");        Clear(WhseItemTrackingLines);        WhseItemTrackingLinesSetSource(WhseItemTrackingLines);        WhseItemTrackingLines.InsertItemTrackingLine(Rec, WhseEntry, QtyToEmpty);    end;    procedure SetCurrentFieldNo(FieldNo: Integer)    begin        if CurrentFieldNo <> CurrFieldNo then            CurrentFieldNo := FieldNo;    end;    procedure SetSourceFilter(SourceType: Integer; SourceSubType: Option; SourceNo: Code[20]; SourceLineNo: Integer; SetKey: Boolean)    begin        if SetKey then            SetCurrentKey("Source Type", "Source Subtype", "Source No.", "Source Line No.");        SetRange("Source Type", SourceType);        if SourceSubType >= 0 then            SetRange("Source Subtype", SourceSubType);        SetRange("Source No.", SourceNo);        if SourceLineNo >= 0 then            SetRange("Source Line No.", SourceLineNo);        OnAfterSetSourceFilter(Rec, SourceType, SourceSubtype, SourceNo, SourceLineNo, SetKey);    end;    local procedure LookupFromBinCode()    var        WhseItemTrackingSetup: Record "Item Tracking Setup";        WMSMgt: Codeunit "WMS Management";        BinCode: Code[20];    begin        LookupItemTracking(WhseItemTrackingSetup);        BinCode :=          WMSMgt.BinContentLookUp("Location Code", "Item No.", "Variant Code", "From Zone Code", WhseItemTrackingSetup, "From Bin Code");        if BinCode <> '' then            Validate("From Bin Code", BinCode);    end;    procedure LookupItemTracking(var WhseItemTrackingSetup: Record "Item Tracking Setup")    var        WhseItemTrkgLine: Record "Whse. Item Tracking Line";        ItemTrackingMgt: Codeunit "Item Tracking Management";    begin        if ItemTrackingMgt.WhseItemTrackingLineExists(            "Worksheet Template Name", Name, "Location Code", "Line No.", WhseItemTrkgLine)        then            // Don't step in if more than one Tracking Definition exists:            if WhseItemTrkgLine.Count = 1 then begin                WhseItemTrkgLine.FindFirst();                if WhseItemTrkgLine."Quantity (Base)" = "Qty. (Base)" then                    WhseItemTrackingSetup.CopyTrackingFromWhseItemTrackingLine(WhseItemTrkgLine);            end;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterAutofillQtyToHandle(var WhseWorksheetLine: Record "Whse. Worksheet Line")    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAfterInitLineWithItem()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCheckAvailQtytoMove(var WhseWorksheetLine: Record "Whse. Worksheet Line"; xWhseWorksheetLine: Record "Whse. Worksheet Line"; var QtyAvailToMoveBase: Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetItem(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var Item: Record Item; var ItemDescription: Text[100])    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAssignedQtyOnReservedLinesOnAfterWhseWkshLineSetFilters(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var FilteredWhseWorksheetLine: Record "Whse. Worksheet Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAutofillQtyToHandleOnBeforeModify(var WhseWorksheetLine: Record "Whse. Worksheet Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcAvailQtyToMove(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var QtyAvailToMoveBase: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckBin(WhseWorksheetLine: Record "Whse. Worksheet Line"; LocationCode: Code[10]; BinCode: Code[20]; Inbound: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckIncreaseBin(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var Bin: Record Bin; BinCode: Code[20]; Cubage: Decimal; Weight: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckTemplateName(var WkshTemplateName: Code[10]; var WkshName: Code[10]; var LocationCode: Code[10]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckWhseWkshName(var WkshTemplateName: Code[10]; var LocationCode: Code[10]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeMovementCreate(var WhseWkshLine: Record "Whse. Worksheet Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeOpenItemTrackingLines(var WhseWkshLine: Record "Whse. Worksheet Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePutAwayCreate(var PutAwayWhseWorksheetLine: Record "Whse. Worksheet Line"; var IsHandled: Boolean; HideValidationDialog: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdatePickQtyToHandleBase(var WhseWorksheetLine: Record "Whse. Worksheet Line"; CurrFieldNo: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateQty(var PutAwayWhseWorksheetLine: Record "Whse. Worksheet Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcAvailQtyToMoveOnAfterSetFilters(var NewWhseWorksheetLine: Record "Whse. Worksheet Line"; var WhseWorksheetLine: Record "Whse. Worksheet Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcAvailableQtyBase(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var AvailableQty: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCalcAvailableQtyBase(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var AvailableQty: Decimal)    begin    end;    [IntegrationEvent(false, false)]    procedure OnDeleteQtyToHandleOnBeforeModify(var WhseWorksheetLine: Record "Whse. Worksheet Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnLookupWhseWkshNameOnBeforeRunModal(var WhseWkshName: Record "Whse. Worksheet Name")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetSortSeqNoOnCaseElse(var WhseWorksheetLine: Record "Whse. Worksheet Line"; SortMethod: Enum "Whse. Activity Sorting Method")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnSortWhseWkshLinesOnCaseElse(var WhseWorksheetLine: Record "Whse. Worksheet Line"; SortingMethod: Enum "Whse. Activity Sorting Method")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnValidateQtyToHandleOnAfterCalcQtyAvailToMove(var WhseWorksheetLine: Record "Whse. Worksheet Line"; xWhseWorksheetLine: Record "Whse. Worksheet Line"; var QtyAvailToMoveBase: Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetSourceFilter(var WhseWorksheetLine: Record "Whse. Worksheet Line"; SourceType: Integer; SourceSubtype: Option; SourceNo: Code[20]; SourceLineNo: Integer; SetKey: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnWhseItemTrackingLinesSetSource(var WhseWorksheetLine: Record "Whse. Worksheet Line"; var WhseItemTrackingLines: Page "Whse. Item Tracking Lines"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnUpdateQtyHandledForProdOrderOutput(var WhseWorksheetLine: Record "Whse. Worksheet Line")    begin    end;}