Page 7345 Pick Worksheet

Base Application, Microsoft.Warehouse.Worksheet

src/Layers/W1/BaseApp/Warehouse/Worksheet/PickWorksheet.Page.al660 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.UOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Warehouse.Activity;using Microsoft.Warehouse.CrossDock;using Microsoft.Warehouse.Journal;using Microsoft.Warehouse.Ledger;using Microsoft.Warehouse.Request;using Microsoft.Warehouse.Structure;using System.Environment;using System.Environment.Configuration;using System.Integration;using System.Integration.Excel;page 7345 "Pick Worksheet"{    ApplicationArea = Warehouse;    Caption = 'Pick Worksheets';    DataCaptionFields = Name;    InsertAllowed = false;    PageType = Worksheet;    AboutTitle = 'About Pick Worksheets';    AboutText = 'Create and manage pick worksheets to efficiently prepare, sort, and generate pick documents in bulk for released warehouse shipments, optimizing item handling and warehouse operations.';    RefreshOnActivate = true;    SaveValues = true;    SourceTable = "Whse. Worksheet Line";    SourceTableView = sorting("Worksheet Template Name", Name, "Location Code", "Sorting Sequence No.");    UsageCategory = Tasks;    layout    {        area(content)        {            field(CurrentWkshName; CurrentWkshName)            {                ApplicationArea = Warehouse;                Caption = 'Batch Name';                Lookup = true;                ToolTip = 'Specifies the name of the journal batch, a personalized journal layout, that the journal is based on.';                trigger OnLookup(var Text: Text): Boolean                begin                    CurrPage.SaveRecord();                    Rec.LookupWhseWkshName(Rec, CurrentWkshName, CurrentLocationCode);                    CurrPage.Update(false);                end;                trigger OnValidate()                begin                    Rec.CheckWhseWkshName(CurrentWkshName, CurrentLocationCode, Rec);                    CurrentWkshNameOnAfterValidate();                end;            }            field(CurrentLocationCode; CurrentLocationCode)            {                ApplicationArea = Warehouse;                Caption = 'Location Code';                Editable = false;                ToolTip = 'Specifies the location where the warehouse activity takes place. ';            }            field(CurrentSortingMethod; CurrentSortingMethod)            {                ApplicationArea = Warehouse;                Caption = 'Sorting Method';                ToolTip = 'Specifies the method by which the movement lines are sorted.';                trigger OnValidate()                begin                    CurrentSortingMethodOnAfterValidate();                end;            }            repeater(Control1)            {                ShowCaption = false;                field("Whse. Document Type"; Rec."Whse. Document Type")                {                    ApplicationArea = Warehouse;                    Visible = false;                }                field("WhseDocumentType"; WhseDocumentType)                {                    ApplicationArea = Warehouse;                    Caption = 'Whse. Document Type';                    ToolTip = 'Specifies the type of warehouse document this line is associated with.';                    trigger OnValidate()                    begin                        Rec.Validate("Whse. Document Type", WhseDocumentType);                    end;                }                field("Whse. Document No."; Rec."Whse. Document No.")                {                    ApplicationArea = Warehouse;                }                field("Whse. Document Line No."; Rec."Whse. Document Line No.")                {                    ApplicationArea = Warehouse;                    Visible = false;                }                field("Item No."; Rec."Item No.")                {                    ApplicationArea = Warehouse;                    Editable = false;                    trigger OnValidate()                    begin                        Rec.GetItem(Rec."Item No.", ItemDescription);                    end;                }                field("Variant Code"; Rec."Variant Code")                {                    ApplicationArea = Planning;                    Editable = false;                    Visible = false;                }                field(Description; Rec.Description)                {                    ApplicationArea = Warehouse;                    Editable = false;                }                field("Description 2"; Rec."Description 2")                {                    ApplicationArea = Warehouse;                    Visible = false;                }                field("To Zone Code"; Rec."To Zone Code")                {                    ApplicationArea = Warehouse;                    Editable = false;                    Visible = false;                }                field("To Bin Code"; Rec."To Bin Code")                {                    ApplicationArea = Warehouse;                    Editable = false;                    Visible = false;                }                field("Shelf No."; Rec."Shelf No.")                {                    ApplicationArea = Warehouse;                    Visible = false;                }                field(Quantity; Rec.Quantity)                {                    ApplicationArea = Warehouse;                    Editable = false;                }                field("Qty. to Handle"; Rec."Qty. to Handle")                {                    ApplicationArea = Warehouse;                    trigger OnValidate()                    begin                        QtytoHandleOnAfterValidate();                    end;                }                field("Qty. Outstanding"; Rec."Qty. Outstanding")                {                    ApplicationArea = Warehouse;                }                field(AvailableQtyToPickExcludingQCBins; Rec.AvailableQtyToPickForCurrentLine())                {                    ApplicationArea = Warehouse;                    AutoFormatType = 0;                    Caption = 'Available Qty. to Pick';                    DecimalPlaces = 0 : 5;                    Editable = false;                    ToolTip = 'Specifies the quantity on the pick worksheet line that is available to pick. This quantity includes released warehouse shipment lines.';                }                field("Due Date"; Rec."Due Date")                {                    ApplicationArea = Warehouse;                }                field("Unit of Measure Code"; Rec."Unit of Measure Code")                {                    ApplicationArea = Warehouse;                    Editable = false;                }                field("Shipping Advice"; Rec."Shipping Advice")                {                    ApplicationArea = Warehouse;                }                field("Destination Type"; Rec."Destination Type")                {                    ApplicationArea = Warehouse;                }                field("Destination No."; Rec."Destination No.")                {                    ApplicationArea = Warehouse;                }                field("Source Document"; Rec."Source Document")                {                    ApplicationArea = Warehouse;                    Visible = false;                }                field("Source No."; Rec."Source No.")                {                    ApplicationArea = Warehouse;                    Visible = false;                }                field("Source Line No."; Rec."Source Line No.")                {                    ApplicationArea = Warehouse;                    Visible = false;                }                field(QtyCrossDockedUOM; QtyCrossDockedUOM)                {                    ApplicationArea = Warehouse;                    AutoFormatType = 0;                    Caption = 'Qty. on Cross-Dock Bin';                    DecimalPlaces = 0 : 5;                    Editable = false;                    ToolTip = 'Specifies the quantity of items to be cross-docked.';                    trigger OnDrillDown()                    begin                        CrossDockMgt.ShowBinContentsCrossDocked(Rec."Item No.", Rec."Variant Code", Rec."Unit of Measure Code", Rec."Location Code", true);                    end;                }                field(QtyCrossDockedUOMBase; QtyCrossDockedUOMBase)                {                    ApplicationArea = Warehouse;                    AutoFormatType = 0;                    Caption = 'Qty. on Cross-Dock (Base)';                    DecimalPlaces = 0 : 5;                    Editable = false;                    ToolTip = 'Specifies the quantity of items to be cross-docked.';                    Visible = false;                    trigger OnDrillDown()                    begin                        CrossDockMgt.ShowBinContentsCrossDocked(Rec."Item No.", Rec."Variant Code", Rec."Unit of Measure Code", Rec."Location Code", true);                    end;                }                field(QtyCrossDockedAllUOMBase; QtyCrossDockedAllUOMBase)                {                    ApplicationArea = Warehouse;                    AutoFormatType = 0;                    Caption = 'Qty. on Cross-Dock Bin (Base all UOM)';                    DecimalPlaces = 0 : 5;                    Editable = false;                    ToolTip = 'Specifies the quantity of items to be cross-docked. ';                    Visible = false;                    trigger OnDrillDown()                    begin                        CrossDockMgt.ShowBinContentsCrossDocked(Rec."Item No.", Rec."Variant Code", Rec."Unit of Measure Code", Rec."Location Code", false);                    end;                }            }            group(Control22)            {                ShowCaption = false;                fixed(Control1900669001)                {                    ShowCaption = false;                    group("Item Description")                    {                        Caption = 'Item Description';                        field(ItemDescription; ItemDescription)                        {                            ApplicationArea = Warehouse;                            Editable = false;                            ShowCaption = false;                        }                    }                }            }        }        area(factboxes)        {            part(Control8; "Lot Numbers by Bin FactBox")            {                ApplicationArea = ItemTracking;                SubPageLink = "Item No." = field("Item No."),                              "Variant Code" = field("Variant Code"),                              "Location Code" = field("Location Code");                Visible = false;            }            systempart(Control1900383207; Links)            {                ApplicationArea = RecordLinks;                Visible = false;            }            systempart(Control1905767507; Notes)            {                ApplicationArea = Notes;                Visible = false;            }        }    }    actions    {        area(navigation)        {            group("&Line")            {                Caption = '&Line';                Image = Line;                action("Source &Document Line")                {                    ApplicationArea = Warehouse;                    Caption = 'Source &Document Line';                    Image = SourceDocLine;                    ToolTip = 'View the line on a released source document that the warehouse activity is for. ';                    trigger OnAction()                    begin                        WMSMgt.ShowSourceDocLine(                          Rec."Source Type", Rec."Source Subtype", Rec."Source No.", Rec."Source Line No.", Rec."Source Subline No.");                    end;                }                action("Whse. Document Line")                {                    ApplicationArea = Warehouse;                    Caption = 'Whse. Document Line';                    Image = Line;                    ToolTip = 'View the line on another warehouse document that the warehouse activity is for.';                    trigger OnAction()                    begin                        WMSMgt.ShowWhseActivityDocLine(                            Rec."Whse. Document Type", Rec."Whse. Document No.", Rec."Whse. Document Line No.");                    end;                }                action("Item &Tracking Lines")                {                    ApplicationArea = ItemTracking;                    Caption = 'Item &Tracking Lines';                    Image = ItemTrackingLines;                    ShortCutKey = 'Ctrl+Alt+I';                    ToolTip = 'View or edit serial, lot and package numbers that are assigned to the item on the document or journal line.';                    trigger OnAction()                    begin                        Rec.OpenItemTrackingLines();                    end;                }            }            group("&Item")            {                Caption = '&Item';                Image = Item;                action(Card)                {                    ApplicationArea = Warehouse;                    Caption = 'Card';                    Image = EditLines;                    RunObject = Page "Item Card";                    RunPageLink = "No." = field("Item No.");                    ShortCutKey = 'Shift+F7';                    ToolTip = 'View or change detailed information about the record on the document or journal line.';                }                action("Warehouse Entries")                {                    ApplicationArea = Warehouse;                    Caption = 'Warehouse Entries';                    Image = BinLedger;                    RunObject = Page "Warehouse Entries";                    RunPageLink = "Item No." = field("Item No."),                                  "Variant Code" = field("Variant Code"),                                  "Location Code" = field("Location Code");                    RunPageView = sorting("Item No.", "Location Code", "Variant Code", "Bin Type Code", "Unit of Measure Code", "Lot No.", "Serial No.");                    ShortCutKey = 'Ctrl+F7';                    ToolTip = 'View completed warehouse activities related to the document.';                }                action("Ledger E&ntries")                {                    ApplicationArea = Warehouse;                    Caption = 'Ledger E&ntries';                    Image = CustomerLedger;                    RunObject = Page "Item Ledger Entries";                    RunPageLink = "Item No." = field("Item No."),                                  "Variant Code" = field("Variant Code"),                                  "Location Code" = field("Location Code");                    RunPageView = sorting("Item No.");                    ToolTip = 'View the history of transactions that have been posted for the selected record.';                }                action("Bin Contents")                {                    ApplicationArea = Warehouse;                    Caption = 'Bin Contents';                    Image = BinContent;                    RunObject = Page "Bin Contents List";                    RunPageLink = "Location Code" = field("Location Code"),                                  "Item No." = field("Item No."),                                  "Variant Code" = field("Variant Code");                    RunPageView = sorting("Location Code", "Item No.", "Variant Code");                    ToolTip = 'View items in the bin if the selected line contains a bin code.';                }            }        }        area(processing)        {            group("F&unctions")            {                Caption = 'F&unctions';                Image = "Action";                action("Get Warehouse Documents")                {                    ApplicationArea = Warehouse;                    Caption = 'Get Warehouse Documents';                    Ellipsis = true;                    Image = GetSourceDoc;                    ShortCutKey = 'Shift+F11';                    ToolTip = 'Select a warehouse document to pick for, such as a warehouse shipment.';                    trigger OnAction()                    var                        RetrieveWhsePickDoc: Codeunit "Get Source Doc. Outbound";                    begin                        RetrieveWhsePickDoc.GetSingleWhsePickDoc(                          CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode);                        Rec.SortWhseWkshLines(                          CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode, CurrentSortingMethod);                        OnAfterActionGetWarehouseDocuments(CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode, CurrentSortingMethod);                    end;                }                action("Autofill Qty. to Handle")                {                    ApplicationArea = Warehouse;                    Caption = 'Autofill Qty. to Handle';                    Image = AutofillQtyToHandle;                    ToolTip = 'Have the system enter the outstanding quantity in the Qty. to Handle field.';                    trigger OnAction()                    var                        PickWkshLine: Record "Whse. Worksheet Line";                    begin                        PickWkshLine.Copy(Rec);                        Rec.AutofillQtyToHandle(PickWkshLine);                    end;                }                action("Delete Qty. to Handle")                {                    ApplicationArea = Warehouse;                    Caption = 'Delete Qty. to Handle';                    Image = DeleteQtyToHandle;                    ToolTip = 'Have the system clear the value in the Qty. To Handle field. ';                    trigger OnAction()                    var                        PickWkshLine: Record "Whse. Worksheet Line";                    begin                        PickWkshLine.Copy(Rec);                        Rec.DeleteQtyToHandle(PickWkshLine);                    end;                }                action(CreatePick)                {                    ApplicationArea = Warehouse;                    Caption = 'Create Pick';                    Ellipsis = true;                    Image = CreateInventoryPickup;                    ToolTip = 'Create warehouse pick documents for the specified picks. ';                    trigger OnAction()                    begin                        CODEUNIT.Run(CODEUNIT::"Whse. Create Pick", Rec);                    end;                }            }            group("Page")            {                Caption = 'Page';                action(EditInExcel)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Edit in Excel';                    Image = Excel;                    ToolTip = 'Send the data in the worksheet to an Excel file for analysis or editing.';                    Visible = IsSaaSExcelAddinEnabled;                    AccessByPermission = System "Allow Action Export To Excel" = X;                    trigger OnAction()                    var                        EditinExcel: Codeunit "Edit in Excel";                        EditinExcelFilters: Codeunit "Edit in Excel Filters";                        ODataUtility: Codeunit "ODataUtility";                    begin                        EditinExcelFilters.AddFieldV2(ODataUtility.ExternalizeName(Rec.FieldName(Rec.Name)), Enum::"Edit in Excel Filter Type"::Equal, CurrentWkshName, Enum::"Edit in Excel Edm Type"::"Edm.String");                        EditinExcelFilters.AddFieldV2(ODataUtility.ExternalizeName(Rec.FieldName(Rec."Worksheet Template Name")), Enum::"Edit in Excel Filter Type"::Equal, CurrentWkshTemplateName, Enum::"Edit in Excel Edm Type"::"Edm.String");                        EditinExcelFilters.AddFieldV2(ODataUtility.ExternalizeName(Rec.FieldName(Rec."Location Code")), Enum::"Edit in Excel Filter Type"::Equal, CurrentLocationCode, Enum::"Edit in Excel Edm Type"::"Edm.String");                        EditinExcel.EditPageInExcel(Text.CopyStr(CurrPage.Caption, 1, 240), Page::"Pick Worksheet", EditInExcelFilters, StrSubstNo(ExcelFileNameTxt, CurrentWkshName, CurrentWkshTemplateName));                    end;                }            }        }        area(Promoted)        {            group(Category_Process)            {                Caption = 'Process', Comment = 'Generated from the PromotedActionCategories property index 1.';                actionref(CreatePick_Promoted; CreatePick)                {                }                actionref("Get Warehouse Documents_Promoted"; "Get Warehouse Documents")                {                }                group("Category_Qty. to Handle")                {                    Caption = 'Qty. to Handle';                    ShowAs = SplitButton;                    actionref("Autofill Qty. to Handle_Promoted"; "Autofill Qty. to Handle")                    {                    }                    actionref("Delete Qty. to Handle_Promoted"; "Delete Qty. to Handle")                    {                    }                }            }            group(Category_Category4)            {                Caption = 'Line', Comment = 'Generated from the PromotedActionCategories property index 3.';                actionref("Item &Tracking Lines_Promoted"; "Item &Tracking Lines")                {                }                actionref("Source &Document Line_Promoted"; "Source &Document Line")                {                }                actionref("Whse. Document Line_Promoted"; "Whse. Document Line")                {                }                actionref("Warehouse Entries_Promoted"; "Warehouse Entries")                {                }            }            group(Category_Category5)            {                Caption = 'Item', Comment = 'Generated from the PromotedActionCategories property index 4.';            }            group(Category_Report)            {                Caption = 'Report', Comment = 'Generated from the PromotedActionCategories property index 2.';            }        }    }    trigger OnAfterGetCurrRecord()    begin        Rec.GetItem(Rec."Item No.", ItemDescription);        WhseDocumentType := Rec."Whse. Document Type";    end;    trigger OnAfterGetRecord()    begin        CrossDockMgt.CalcCrossDockedItems(            Rec."Item No.", Rec."Variant Code", Rec."Unit of Measure Code", Rec."Location Code",            QtyCrossDockedUOMBase, QtyCrossDockedAllUOMBase);        QtyCrossDockedUOM := 0;        if Rec."Qty. per Unit of Measure" <> 0 then            QtyCrossDockedUOM := Round(QtyCrossDockedUOMBase / Rec."Qty. per Unit of Measure", UOMMgt.QtyRndPrecision());        WhseDocumentType := Rec."Whse. Document Type";    end;    trigger OnDeleteRecord(): Boolean    begin        ItemDescription := '';    end;    trigger OnOpenPage()    var        ClientTypeManagement: Codeunit "Client Type Management";        ServerSetting: Codeunit "Server Setting";        WhseWkshSelected: Boolean;    begin        IsSaaSExcelAddinEnabled := ServerSetting.GetIsSaasExcelAddinEnabled();        // if called from API (such as edit-in-excel), do not filter         if ClientTypeManagement.GetCurrentClientType() = CLIENTTYPE::ODataV4 then            exit;        if OpenedFromDrillDown then begin // Drill down handles the filtering on the record            CurrentWkshName := DrillDownCurrentWkshName;            CurrentWkshTemplateName := DrillDownCurrentWkshTemplateName;            CurrentLocationCode := DrillDownCurrentLocationCode;            exit;        end;        OpenedFromBatch := (Rec.Name <> '') and (Rec."Worksheet Template Name" = '');        if OpenedFromBatch then begin            CurrentWkshName := Rec.Name;            CurrentLocationCode := Rec."Location Code";            Rec.OpenWhseWksh(Rec, CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode);            exit;        end;        Rec.TemplateSelection(PAGE::"Pick Worksheet", 1, Rec, WhseWkshSelected);        if not WhseWkshSelected then            Error('');        Rec.OpenWhseWksh(Rec, CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode);    end;    var        WMSMgt: Codeunit "WMS Management";        CrossDockMgt: Codeunit "Whse. Cross-Dock Management";        UOMMgt: Codeunit "Unit of Measure Management";        ExcelFileNameTxt: Label 'Pick Worksheet - WorksheetName %1 - WorksheetTemplateName %2', Comment = '%1 = Worksheet Name; %2 = Worksheet Template Name';        QtyCrossDockedUOM: Decimal;        QtyCrossDockedAllUOMBase: Decimal;        QtyCrossDockedUOMBase: Decimal;        OpenedFromBatch: Boolean;        OpenedFromDrillDown: Boolean;        DrillDownCurrentWkshTemplateName: Code[10];        DrillDownCurrentWkshName: Code[10];        DrillDownCurrentLocationCode: Code[10];        IsSaaSExcelAddinEnabled: Boolean;        WhseDocumentType: Enum "Warehouse Pick Document Type";    protected var        CurrentWkshTemplateName: Code[10];        CurrentWkshName: Code[10];        CurrentLocationCode: Code[10];        CurrentSortingMethod: Enum "Whse. Activity Sorting Method";        ItemDescription: Text[100];    protected procedure QtytoHandleOnAfterValidate()    begin        CurrPage.Update();    end;    protected procedure CurrentWkshNameOnAfterValidate()    begin        CurrPage.SaveRecord();        Rec.SetWhseWkshName(CurrentWkshName, CurrentLocationCode, Rec);        CurrPage.Update(false);    end;    protected procedure CurrentSortingMethodOnAfterValidate()    begin        Rec.SortWhseWkshLines(CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode, CurrentSortingMethod);        CurrPage.Update(false);        Rec.SetCurrentKey("Worksheet Template Name", Name, "Location Code", "Sorting Sequence No.");    end;    internal procedure DrillDownFromCalculationSummary(var WhseWorksheetLine: Record "Whse. Worksheet Line")    begin        WhseWorksheetLine.CheckWhseWkshName(WhseWorksheetLine.Name, WhseWorksheetLine."Location Code", WhseWorksheetLine);        DrillDownCurrentWkshTemplateName := WhseWorksheetLine."Worksheet Template Name";        DrillDownCurrentWkshName := WhseWorksheetLine.Name;        DrillDownCurrentLocationCode := WhseWorksheetLine."Location Code";        OpenedFromDrillDown := true;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterActionGetWarehouseDocuments(WhseWkshTemplate: Code[10]; WhseWkshName: Code[10]; LocationCode: Code[10]; SortingMethod: Enum "Whse. Activity Sorting Method")    begin    end;}