Page 7352 Put-away Worksheet
src/Layers/W1/BaseApp/Warehouse/Worksheet/PutawayWorksheet.Page.al602 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.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Warehouse.Activity;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 7352 "Put-away Worksheet"{ ApplicationArea = Warehouse; Caption = 'Put-away Worksheets'; DataCaptionFields = Name; InsertAllowed = false; PageType = Worksheet; 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 = 'Name'; Lookup = true; ToolTip = 'Specifies the name of the worksheet in which you can organize various kinds of put-aways, including put-aways with lines from several orders.'; 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 that is set up to use directed put-away.'; } field(CurrentSortingMethod; CurrentSortingMethod) { ApplicationArea = Warehouse; Caption = 'Sorting Method'; ToolTip = 'Specifies the method by which the warehouse internal put-away 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("From Zone Code"; Rec."From Zone Code") { ApplicationArea = Warehouse; Editable = false; Visible = false; } field("From Bin Code"; Rec."From 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. (Base)"; Rec."Qty. (Base)") { ApplicationArea = Warehouse; ToolTip = 'Specifies the quantity that should be handled in the base unit of measure.'; Visible = false; } field("Qty. Outstanding"; Rec."Qty. Outstanding") { ApplicationArea = Warehouse; } field("Qty. Outstanding (Base)"; Rec."Qty. Outstanding (Base)") { ApplicationArea = Warehouse; ToolTip = 'Specifies the quantity that still needs to be handled, expressed in the base unit of measure.'; Visible = false; } field("Qty. to Handle"; Rec."Qty. to Handle") { ApplicationArea = Warehouse; trigger OnValidate() begin QtytoHandleOnAfterValidate(); end; } field("Qty. to Handle (Base)"; Rec."Qty. to Handle (Base)") { ApplicationArea = Warehouse; ToolTip = 'Specifies the quantity you want to handle, in the base unit of measure.'; Visible = false; } field("Qty. Handled"; Rec."Qty. Handled") { ApplicationArea = Warehouse; } field("Qty. Handled (Base)"; Rec."Qty. Handled (Base)") { ApplicationArea = Warehouse; ToolTip = 'Specifies the quantity that has been handled and registered, in the base unit of measure.'; Visible = false; } field("Due Date"; Rec."Due Date") { ApplicationArea = Warehouse; } field("Unit of Measure Code"; Rec."Unit of Measure Code") { ApplicationArea = Warehouse; Editable = false; } } 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 = Warehouse; 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; Scope = Repeater; 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; Scope = Repeater; 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; Scope = Repeater; 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."); Scope = Repeater; 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"); Scope = Repeater; ShortCutKey = 'Ctrl+F7'; ToolTip = 'View completed warehouse activities related to the document.'; } action("Ledger E&ntries") { ApplicationArea = Warehouse; Caption = 'Ledger E&ntries'; Image = ItemLedger; 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."); Scope = Repeater; 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"); Scope = Repeater; 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(GetWarehouseDocuments) { 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 GetWhsePutAwayDoc: Codeunit "Get Source Doc. Inbound"; begin OnBeforeGetWarehouseDocuments(); GetWhsePutAwayDoc.GetSingleWhsePutAwayDoc( CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode); Rec.SortWhseWkshLines( CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode, CurrentSortingMethod); end; } action("Autofill Qty. to Handle") { ApplicationArea = Warehouse; Caption = 'Autofill Qty. to Handle'; Image = AutofillQtyToHandle; Scope = Repeater; ToolTip = 'Have the system enter the outstanding quantity in the Qty. to Handle field.'; trigger OnAction() var WhseWkshLine: Record "Whse. Worksheet Line"; begin WhseWkshLine.Copy(Rec); Rec.AutofillQtyToHandle(WhseWkshLine); end; } action("Delete Qty. to Handle") { ApplicationArea = Warehouse; Caption = 'Delete Qty. to Handle'; Image = DeleteQtyToHandle; Scope = Repeater; ToolTip = 'Have the system clear the value in the Qty. To Handle field. '; trigger OnAction() var WhseWkshLine: Record "Whse. Worksheet Line"; begin WhseWkshLine.Copy(Rec); Rec.DeleteQtyToHandle(WhseWkshLine); end; } action(CreatePutAway) { ApplicationArea = Warehouse; Caption = 'Create Put-away'; Ellipsis = true; Image = CreatePutAway; Scope = Repeater; ToolTip = 'Create warehouse put-away documents for the specified put-aways. '; trigger OnAction() var WhseWkshLine: Record "Whse. Worksheet Line"; begin WhseWkshLine.CopyFilters(Rec); if WhseWkshLine.FindFirst() then Rec.PutAwayCreate(WhseWkshLine) else Error(Text001); 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::"Put-away Worksheet", EditInExcelFilters, StrSubstNo(ExcelFileNameTxt, CurrentWkshName, CurrentWkshTemplateName)); end; } } } area(Promoted) { group(Category_Process) { Caption = 'Process', Comment = 'Generated from the PromotedActionCategories property index 1.'; actionref(GetWarehouseDocuments_Promoted; GetWarehouseDocuments) { } actionref(CreatePutAway_Promoted; CreatePutAway) { } 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 = 'Prepare', Comment = 'Generated from the PromotedActionCategories property index 3.'; } group(Category_Category5) { Caption = 'Line', Comment = 'Generated from the PromotedActionCategories property index 4.'; actionref("Source &Document Line_Promoted"; "Source &Document Line") { } actionref("Whse. Document Line_Promoted"; "Whse. Document Line") { } actionref("Item &Tracking Lines_Promoted"; "Item &Tracking Lines") { } } group(Category_Category6) { Caption = 'Item', Comment = 'Generated from the PromotedActionCategories property index 5.'; actionref(Card_Promoted; Card) { } actionref("Warehouse Entries_Promoted"; "Warehouse Entries") { } } 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 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; 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::"Put-away Worksheet", 0, Rec, WhseWkshSelected); if not WhseWkshSelected then Error(''); Rec.OpenWhseWksh(Rec, CurrentWkshTemplateName, CurrentWkshName, CurrentLocationCode); end; var WMSMgt: Codeunit "WMS Management"; ItemDescription: Text[100];#pragma warning disable AA0074 Text001: Label 'There is nothing to handle.';#pragma warning restore AA0074 ExcelFileNameTxt: Label 'Put-away Worksheet - WorksheetName %1 - WorksheetTemplateName %2', Comment = '%1 = Worksheet Name; %2 = Worksheet Template Name'; OpenedFromBatch: Boolean; IsSaaSExcelAddinEnabled: Boolean; WhseDocumentType: Enum "Warehouse Putaway Document Type"; protected var CurrentWkshTemplateName: Code[10]; CurrentWkshName: Code[10]; CurrentLocationCode: Code[10]; CurrentSortingMethod: Enum "Whse. Activity Sorting Method"; 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; [IntegrationEvent(true, false)] local procedure OnBeforeGetWarehouseDocuments(); begin end;}