Table 7346 Internal Movement Header
src/Layers/W1/BaseApp/Warehouse/InternalDocument/InternalMovementHeader.Table.al385 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.InternalDocument;using Microsoft.Foundation.NoSeries;using Microsoft.Inventory.Location;using Microsoft.Inventory.Setup;using Microsoft.Inventory.Tracking;using Microsoft.Warehouse.Comment;using Microsoft.Warehouse.Journal;using Microsoft.Warehouse.Setup;using Microsoft.Warehouse.Structure;table 7346 "Internal Movement Header"{ Caption = 'Internal Movement Header'; LookupPageID = "Internal Movement List"; DataClassification = CustomerContent; fields { field(1; "No."; Code[20]) { Caption = 'No.'; ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.'; trigger OnValidate() begin InvtSetup.Get(); if "No." <> xRec."No." then begin NoSeries.TestManual(InvtSetup."Internal Movement Nos."); "No. Series" := ''; end; end; } field(2; "Location Code"; Code[10]) { Caption = 'Location Code'; ToolTip = 'Specifies the code of the location where the internal movement is being performed.'; TableRelation = Location where("Use As In-Transit" = const(false)); trigger OnValidate() begin if not WmsManagement.LocationIsAllowed("Location Code") then Error(Text003, "Location Code"); CheckLocationSettings("Location Code"); if "Location Code" <> xRec."Location Code" then begin if LineExist() then Error(LinesExistErr, FieldCaption("Location Code")); "To Bin Code" := ''; end; FilterGroup := 2; SetRange("Location Code", "Location Code"); FilterGroup := 0; end; } field(3; "Assigned User ID"; Code[50]) { Caption = 'Assigned User ID'; ToolTip = 'Specifies the ID of the user who is responsible for the document.'; DataClassification = EndUserIdentifiableInformation; TableRelation = "Warehouse Employee" where("Location Code" = field("Location Code")); trigger OnValidate() begin if "Assigned User ID" <> '' then begin "Assignment Date" := Today; "Assignment Time" := Time; end else begin "Assignment Date" := 0D; "Assignment Time" := 0T; end; end; } field(4; "Assignment Date"; Date) { Caption = 'Assignment Date'; ToolTip = 'Specifies the date when the user was assigned the activity.'; Editable = false; } field(5; "Assignment Time"; Time) { Caption = 'Assignment Time'; ToolTip = 'Specifies the time when the user was assigned the activity.'; Editable = false; } field(6; "No. Series"; Code[20]) { Caption = 'No. Series'; TableRelation = "No. Series"; } field(7; Comment; Boolean) { CalcFormula = exist("Warehouse Comment Line" where("Table Name" = const("Internal Movement"), Type = const(" "), "No." = field("No."))); Caption = 'Comment'; Editable = false; FieldClass = FlowField; } field(8; "To Bin Code"; Code[20]) { Caption = 'To Bin Code'; ToolTip = 'Specifies the bin where you want items on this internal movement to be placed when they are picked.'; TableRelation = Bin.Code where("Location Code" = field("Location Code")); trigger OnLookup() var Bin: Record Bin; begin Bin.FilterGroup(2); Bin.SetRange("Location Code", "Location Code"); Bin.FilterGroup(0); if PAGE.RunModal(0, Bin) = ACTION::LookupOK then Validate("To Bin Code", Bin.Code); end; trigger OnValidate() var BinType: Record "Bin Type"; InternalMovementLine: Record "Internal Movement Line"; begin if xRec."To Bin Code" <> "To Bin Code" then begin if "To Bin Code" <> '' then begin GetLocation("Location Code"); Location.TestField("Bin Mandatory"); InternalMovementLine.CheckBin("Location Code", "To Bin Code", true); Bin.Get("Location Code", "To Bin Code"); if Bin."Bin Type Code" <> '' then if BinType.Get(Bin."Bin Type Code") then BinType.TestField(Receive, false); end; InternalMovementLine.SetRange("No.", "No."); if not InternalMovementLine.IsEmpty() then Message(Text004, FieldCaption("To Bin Code"), TableCaption); end; end; } field(10; "Due Date"; Date) { Caption = 'Due Date'; ToolTip = 'Specifies the date when the warehouse activity must be completed.'; } field(12; "Sorting Method"; Enum "Warehouse Internal Sorting Method") { Caption = 'Sorting Method'; ToolTip = 'Specifies the method by which the internal movements are sorted.'; trigger OnValidate() begin if "Sorting Method" <> xRec."Sorting Method" then SortWhseDoc(); end; } } keys { key(Key1; "No.") { Clustered = true; } } fieldgroups { } trigger OnDelete() begin DeleteRelatedLines(); end; trigger OnInsert() begin InvtSetup.Get(); if "No." = '' then begin InvtSetup.TestField("Internal Movement Nos."); "No. Series" := InvtSetup."Internal Movement Nos."; if NoSeries.AreRelated("No. Series", xRec."No. Series") then "No. Series" := xRec."No. Series"; "No." := NoSeries.GetNextNo("No. Series"); end; end; trigger OnRename() begin Error(Text002, TableCaption); end; var Location: Record Location; Bin: Record Bin; InvtSetup: Record "Inventory Setup"; NoSeries: Codeunit "No. Series"; WmsManagement: Codeunit "WMS Management"; ItemTrackingMgt: Codeunit "Item Tracking Management";#pragma warning disable AA0074#pragma warning disable AA0470 Text002: Label 'You cannot rename a %1.'; Text003: Label 'You cannot use Location Code %1.'; Text004: Label 'You have changed the %1 on the %2, but it has not been changed on the existing internal movement lines.\You must update the existing internal movement lines manually.';#pragma warning restore AA0470#pragma warning restore AA0074 NoAllowedLocationsErr: Label 'Internal movement is not possible at any locations where you are a warehouse employee.'; LinesExistErr: Label 'You cannot change %1 because one or more lines exist.', Comment = '%1=Location Code'; local procedure SortWhseDoc() var InternalMovementLine: Record "Internal Movement Line"; SequenceNo: Integer; begin InternalMovementLine.Reset(); InternalMovementLine.SetRange("No.", "No."); case "Sorting Method" of "Sorting Method"::Item: InternalMovementLine.SetCurrentKey("No.", "Item No."); "Sorting Method"::"Shelf or Bin": begin GetLocation("Location Code"); if Location."Bin Mandatory" then InternalMovementLine.SetCurrentKey("No.", "From Bin Code") else InternalMovementLine.SetCurrentKey("No.", "Shelf No."); end; "Sorting Method"::"Due Date": InternalMovementLine.SetCurrentKey("No.", "Due Date"); else OnSortWhseDocOnCaseSortingMethodElse(Rec); end; if InternalMovementLine.Find('-') then begin SequenceNo := 10000; repeat InternalMovementLine."Sorting Sequence No." := SequenceNo; InternalMovementLine.Modify(); SequenceNo := SequenceNo + 10000; until InternalMovementLine.Next() = 0; end; end; procedure AssistEdit(): Boolean begin InvtSetup.Get(); InvtSetup.TestField("Internal Movement Nos."); if NoSeries.LookupRelatedNoSeries(InvtSetup."Internal Movement Nos.", xRec."No. Series", "No. Series") then begin "No." := NoSeries.GetNextNo("No. Series"); exit(true); end; end; local procedure GetLocation(LocationCode: Code[10]) begin if LocationCode = '' then Clear(Location) else if Location.Code <> LocationCode then Location.Get(LocationCode); end; local procedure LineExist(): Boolean var InternalMovementLine: Record "Internal Movement Line"; begin InternalMovementLine.SetRange("No.", "No."); exit(not InternalMovementLine.IsEmpty); end; procedure OpenInternalMovementHeader(var InternalMovementHeader: Record "Internal Movement Header") var WhseEmployee: Record "Warehouse Employee"; CurrentLocationCode: Code[10]; IsHandled: Boolean; begin IsHandled := false; OnBeforeOpenInternalMovementHeader(InternalMovementHeader, IsHandled); if IsHandled then exit; WhseEmployee.SetRange("Location Code", InternalMovementHeader."Location Code"); if not WhseEmployee.IsEmpty() then CurrentLocationCode := InternalMovementHeader."Location Code" else CurrentLocationCode := GetDefaultOrFirstAllowedLocation(); InternalMovementHeader.FilterGroup := 2; InternalMovementHeader.SetRange("Location Code", CurrentLocationCode); InternalMovementHeader.FilterGroup := 0; end; procedure LookupInternalMovementHeader(var InternalMovementHeader: Record "Internal Movement Header") var IsHandled: Boolean; begin IsHandled := false; OnBeforeLookupInternalMovementHeader(InternalMovementHeader, IsHandled); if IsHandled then exit; Commit(); InternalMovementHeader.FilterGroup := 2; InternalMovementHeader.SetRange("Location Code"); if PAGE.RunModal(0, InternalMovementHeader) = ACTION::LookupOK then; InternalMovementHeader.SetRange("Location Code", InternalMovementHeader."Location Code"); InternalMovementHeader.FilterGroup := 0; end; local procedure DeleteRelatedLines() var InternalMovementLine: Record "Internal Movement Line"; WhseCommentLine: Record "Warehouse Comment Line"; begin InternalMovementLine.SetRange("No.", "No."); InternalMovementLine.DeleteAll(); WhseCommentLine.SetRange("Table Name", WhseCommentLine."Table Name"::"Internal Movement"); WhseCommentLine.SetRange(Type, WhseCommentLine.Type::" "); WhseCommentLine.SetRange("No.", "No."); WhseCommentLine.DeleteAll(); ItemTrackingMgt.DeleteWhseItemTrkgLines( Database::"Internal Movement Line", 0, "No.", '', 0, 0, '', false); end; procedure CheckLocationSettings(LocationCode: Code[10]) begin GetLocation(LocationCode); Location.TestField("Directed Put-away and Pick", false); Location.TestField("Bin Mandatory", true); end; local procedure GetDefaultOrFirstAllowedLocation() LocationCode: Code[10] var WhseEmployeesatLocations: Query "Whse. Employees at Locations"; begin WhseEmployeesatLocations.SetRange(User_ID, UserId); WhseEmployeesatLocations.SetRange(Bin_Mandatory, true); WhseEmployeesatLocations.SetRange(Directed_Put_away_and_Pick, false); WhseEmployeesatLocations.SetRange(Default, true); if GetFirstLocationCodeFromLocationsofWhseEmployee(LocationCode, WhseEmployeesatLocations) then exit(LocationCode); WhseEmployeesatLocations.SetRange(Default); if GetFirstLocationCodeFromLocationsofWhseEmployee(LocationCode, WhseEmployeesatLocations) then exit(LocationCode); Error(NoAllowedLocationsErr); end; local procedure GetFirstLocationCodeFromLocationsofWhseEmployee(var LocationCode: Code[10]; var WhseEmployeesatLocations: Query "Whse. Employees at Locations"): Boolean begin WhseEmployeesatLocations.TopNumberOfRows(1); if WhseEmployeesatLocations.Open() then if WhseEmployeesatLocations.Read() then begin LocationCode := WhseEmployeesatLocations.Code; WhseEmployeesatLocations.Close(); exit(true); end; exit(false); end; [IntegrationEvent(true, false)] local procedure OnBeforeLookupInternalMovementHeader(var InternalMovementHeader: Record "Internal Movement Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOpenInternalMovementHeader(var InternalMovementHeader: Record "Internal Movement Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnSortWhseDocOnCaseSortingMethodElse(var InternalMovementHeader: Record "Internal Movement Header") begin end;}