Minimum Version Required: 22.01
Steps
How to get to the WMS Move Tasks and WMS Move Task Trans tables
Using Universal Search, navigate to the WMS Move Tasks or WMS Move Task Trans table
If you cannot see the tables, there will be a message displayed when hovering over the table names telling you which permission you are missing to see them.
Fields And Definitions
What is the purpose of these tables and how they are used:
WMS Move Tasks table:
This table allows users to view the Replenish Move Tasks that have been created. Every Replenish Task will start in the New status. Once a Replenish Task is complete, it will move to the Completed Status
WMS Move Tasks will expire based on what System Setting 365 is set to
The WMS Move Task table is a great resource to use when assigning users to Replenish Tasks on the server, seeing what users are assigned to a task, showing the status of move tasks, or viewing what Replenish Plan the move task was created for
WMS Move Task Trans table:
This table shows the transactions that will or have occurred within the replenish task. Once a Replenish Task has been started, it will move from the New status to the In-Transit status. Then, once the product is moved to its destination bin, it will move from the In-Transit status to the Completed status
The WMS Move Task Trans table is a great resource to use when researching what replenishment transactions occurred within a replenish task, such as who completed the task, what product was moved, how much was moved, and where it was moved from/to
WMS Move Task table column definitions:
Move Task Type: Defines what type of move is occurring (Replenish, Put Away, Move, Dynamic Pick, Slotting). The Move Task Type we are focused on for Replenishment Tasks are Replenish or Dynamic Pick
Status: Lets users know the state of the task (New, Printed, Completed, and Expired)
Assigned To: Lets users know whom this task is assigned to
Print Template: This is the template that will be used and printed if required when completing a Move Task
Print Job ID: This field will be filled in if there is a record of a print job occurring for a move task. Gives users a direct link to the print job so they can preview what was actually printed
>
Replenish Plan: Lets users know what Replenish Plan this Move Task is for
Location: Defines what warehouse location this Replenish Task is for
Load Sequence: This is used more for Dynamic Picking. The Load Sequence is set on the Route but can be changed on the Load Sheet itself. The Load Sequence is created when the Load sheet is processed
WMS Move Task Trans table column definitions:
WMS Move Task Trans ID: A record that is created when a Move Task Trans is created
WMS Move Task ID: Gives users the Move Task ID so they can view the Move Task record for the Move Task Transactions
Product: Lets users know what product this transaction is for
From Bin: Defines which bin the user took the product from
To Bin: Defines the bin that the user will be bringing the product to
Num Units: Displays how many Num Units are being moved
Cases: Displays how many Cases are being moved
Status: There are three different statuses the WMS Move Task Trans can be in:
New: The task has not been started yet
In Transit: A user has started the task. The user went to the From Bin to grab the product and stated they picked up this product by taping Next on their handheld device
Completed: The user has brought the product in the task to the To Bin, thus completing the Move Task Transaction for that product
Purchase Trans ID: The Purchase Trans ID would populate here if Bin Lots are being tracked. This is based on what physical pallet tag (Purchase Trans) was actually scanned