Skip to end of metadata
Go to start of metadata

DoveTrack™ Utilities 

A full compliment of maintenance programs is included in DoveTrack™ WMS V4. Supervisory personnel can delete orders, purge completed orders, tables and journals.

Customer requirements dictate which utility programs are enabled on their menus.


Export Stockroom Activity
Daily Stats By Operator
Daily Stats By Operator No B2B
Daily Cycle Count Activity
Device Distribution Report


ORDER w/Quewes
ORDER w/ Zones
Force Complete Orders
Manual Allocate Order
Release Hold Order


Location History Report
Update Qty Carousel Bin


Inventory Export


Part Inventory
Item Inventory
Part Location History
Empty Locations - P/N=0
Empty Locations = QOH=0
Location Contents
Order Status
Part History
Part History for a Location

WMS V4 Setup

Browse - System Config
Browse - Zone Config
Browse - Printer Config

TXP V4 Setup

Browse - Host Loc Xref
Import Host Loc Xref


Browse - Order and Order Detail

The first is a browse of all orders. Orders may be Active, on Hold or Completed. The status column denotes this. You can see the order details of a particular order by highlighting the order header. As you highlight each order header, the order details are shown below. To browse or scroll in the order detail you need to click into the lower portion of the screen. From the order details you can look at allocations and/or expected records. You may also check inventory locations for the orders' med ids by clicking on the "Show Inv" button.

To leave the order details you may hit escape or click on the exit details button. This takes you back to the order header. Either hit exit order button or escape.

Browse - Order with Order Details Allocation Logs

This Browse is identical to the above Order Browse plus the Allocation/Expected Logs can be viewed!utilities 1.jpg!

Browse - Active Orders

This browse only includes Active Orders.  The same browsing functionality exists for this browse as for All Orders described above. 

Purge Completed Orders

This function is used to purge all completed orders.  The current date is used as the default.  This will purge all completed orders prior to this default date.  If another date is required, the operator must enter in the purge date.

The following rules are used when purging all completed orders:
The Order Status is set to "C".
If the "Retain Completed Orders for Upload" flag is set to FALSE the "Purge All Completed Orders" button will be enabled and the system will remove Orders and Order details if there is no allocations expected for the orders.
If the "Retain Completed Orders for Upload" flag is set to TRUE the "Purge Uploaded Orders" button is enabled and the system will remove only Orders and Order details that have the upload_flag (found in the order_details) set to True and there is no allocations expected for the orders.

Force Completed Orders

If there is an order in the system that you no longer want to process, you can force complete it. This process will deallocate and close the order.

Force complete the order header (sets the status to C and updates the completion date) only if there are uncompleted details. This works in normal operation but if the order status is manually changed from C, it will have to be manually changed back.


Browse Location

This browse sorts the locations by location and then displays the Part Number.  This browse has zoom buttons to display Location details and allocated/expected quantities associated with the location detail.

This browse also allows an operator to view the location detail log for the location.  This log is a history of transactions occurring for the location.


Locations by Description

This browse displays the locations description sequence. To locate a part, the operator may start typing the part description.  The software "zooms" to the first instance of the data being typed.  The down or up arrow keys may also be used to scroll through the parts.  Control Home will take you to the top of the browse.  Control End will take you to the bottom.   To browse all the location details for a specific part, you must click on the LocnDT button.  This will put the focus into the location details.



Browse Part Master

The part master allows the operator to browse through every Part in the system. The operator can, among other things, view the Cell Size, Max Cell Qty, QOH, and a description of the part.  From this utility, the carousel location of a part can be viewed and a new part can be entered into the system.
When the operator is finished entering the new part information, pressing Esc creates the new part.  The operator can cancel adding a new part by pressing the Exit Add Part button.

Delete Part Number

This Utility allows the operator to browse through every Part in the system. The operator can, among other things, view the Cell Size, Max Cell Qty, QOH, and a description of the part.  From this utility, the carousel location of a part can be viewed and a part can be deleted from the system.


The queries (reports)  generated in DoveTrack will display in a second window.    The task bar title will display Magic Print Preview.
Helpful tip.  If  you select a report that is going to take a long time to generate (e.g. part inventory report), in the Print Preview window you will see the page numbers incrementing.  You will also see a grayed out arrow on the toolbar.  If you want to escape out of the report generation you must go back to the Main magic window and press F2 Escape.  This will stop the report generation.  When you return to the Print Preview, the page numbering has stopped and the arrow is no longer grayed out.  You may then click on the arrow to exit print preview or the standard Windows X to close the window.

Empty Locations Report

This report displays empty locations across all zones, sorted by cell size.  It details the number of dedicated and non-dedicated locations.

A sample of the report is below:

Location History Report

The location history report allows the user to see the history of a location.  It displays picks, stocks and other inventory adjustments.  The operator enters a location and a date range (the default date range is one year).  If the operator wants to see all the allocation and expected records, they must click on the box.  Once this information is entered, click on OK.  The report is generated in another window on the screen.  From this screen the operator may view it or print it to a report printer.

A sample of the report is below:


Location Contents

The locations contents report allows the operator to select a range of locations.  It also allows for print preview or to show the quantities. The report displays the location, part number, description, and quantity on hand (if operator clicks the box to show quantities.

A sample of the report is below:

Inventory Export

The inventory export creates a comma-delimited file containing the part number, quantity on hand, part description, cell size and location.  The report can be sorted by part number or location.  After selecting the sort sequence, click on export. A progress bar is displayed and then a message that a file has been created and saved to a specific location.
A sample of the export is below:


Part Inventory

The part inventory report lists all parts in the part master.  You may sort it by location or part number.  You may also uncheck the print preview to send the report directly to a printer.  Once the sorting and printing options are entered, click on OK to begin generation of the report.  After pressing OK you will see the printer selection.  If you have checked the print preview, the report will not go to a printer.

Sorted by location looks like this:

Sorted by part number looks like this:

Part History Report - Desc

The part history report is similar to the location history report. It will display all location transactions for a part number.  However, this allows the user to find a part-by-part description.  A screen with all part numbers sorted by description is displayed.  The operator searches for the correct part number by typing in the description.  While typing the software "zooms" to the first instance of the letters and/or numbers being typed in.  Once the right part is found operator hits enter.  The start date and end date are defaulted to one year previous. However, the data is limited to the data not purged from the system.

There is an option to show allocation and expected records.  Click on OK and the report generates in the Print Preview window.
A sample of the report is below:

Picks By Zone

This report provides information on the number of picks per zone.  It allows operator to enter a date range.  The report is created in a second Magic Window and from there can be printed or just viewed.

A sample of this report is below:

Empty Locations by Cell Size

This report provides information on the number and percentage of empty locations.  This report can be run for 1 zone or all zones. Operator selects this report. Operator clicks on the down arrow to select one zone from the drop down list.  If all zones are required, operator clicks in the box next to All Zones. Click on Create Report.  Report is generated in a second Magic Window.

A sample of the report is below:


Browse System Config

The system configuration file contains many settings for the system; such as, allocation methods, deletion of work files, and flat file import. 

System Key

This is an internal setting required by the system. This will never need changing.

Allow Short Allocations

A yes setting for this feature allows orders to be allocated and processed even if there is not enough inventory to completely fill the order.  The system does not support any backordering so it is the responsibility of the host system to re-send the shorted items.

Allocation Algorithm

The system allows a choice between three methods of order allocation; locations with the least qty., expiration date and "oldest" receipt date (FIFO).

Initiate Allocation

This setting selects whether allocation is performed at the time the order is downloaded or at the time the workstation operator selects it.

Purge Features

The auto purge time allows the end user to set a time during the day to run an auto purge of the log files. The log files that will get purged are allocation, expected, order details and location details.  (This feature is not yet implemented).

Order Detail Retention Period

This setting allows the system administrator to retain data for a certain period of time.  When various purge functions are used, only those records older than this retention period are purged.

Flowrack Sort to Beginning

If non-carousel locations are included in the system (different carousel number, with carousel type set to Flowrack in carousel configuration table), this allows the picking and stocking to be grouped together for the Flowrack locations.  If you want the Flowrack picks to be presented at the beginning of the batch, click on this to display a check mark.

Disable Cyc Cnt on Short

This setting tells the system whether or not to create a cycle count order when a short pick is encountered.

Browse Zone Config

The zone configuration identifies the number and type of zones in the system. "C" is used for carousel zones and "B" is used for bulk zones. If the carousels have lift platforms, the max lower shelf setting is recorded in this table.  This setting tells the software where the lower level of shelves end.  An entry of 0 for this setting signifies no lift platform.

The options for pick lists and labels are customized for each site.  If your site doesn't have customized labels or picks lists, setting these options will not work for you system.
Each zone has the following options:
Print Part Label - this turns the pick label printing on and off

Print Order Label - this turns the order or tote label printing on or off

Print Shorts Only Report - future feature

Print Tote Contents Report - tote contents at end of the batch

Print Zone Pick List - this reports all picks from a zone
Two Step Task Complete - this turns the two-step task complete on and off.  This means operator must task complete after the pick from the carousel and again when item is placed in the order tote.

Disable Pick Commonality - turning this off means operator will have to pick common parts from the same location multiple times.  When this is not disabled, the operator will pick the combined total from the carousel for disbursement into separate order totes.

Enable Skip Pick - This allows operator to skip picks (Shift F7) at the workstations.

Disable Pass Done Notification - This enables the pass done notification

Allow Op to Change Qty - this enables an operator to change location quantity at the zone during picking or stocking.

Browse Carousel Config

The carousel configuration table is setup during installation time by installation personnel. It is used to identify the type of carousel hardware the system is using.  Once it is completed, it will not require modification, unless additional hardware is added to the system.
The zone refers to the workstation.  The carousel is the physical carousel number.  The device type refers to the type of carousel.  The Carousel COM Port refers to the serial port number on the computer to which the carousel is connected.


Browse Pass and Pick Zone

In this configuration, every zone in the system is one pick and pass zone.  Future usage may dictate that the carousels are split into multiple zones.  In this case, this table will be modified to show which carousels (typically 1-4 in zone 1 and 5-8 in zone 2).



Send Go

The Send Go command requests that a carousel rotate to a specified bin. It may be used to test the interface to the carousel hardware. In the Send Go window, enter the carousel number and bin you want the carousel to spin to. Click the OK button. When finished, press Esc


SortBar Qty Msg

Enter the desired sortbar position number.  Enter a quantity. Click the Send button. Press the Test button to test the task complete feature.


Lighttree Qty Msg

The Lightree Qty Msg command requests a light tree to indicate a specified carousel shelf and bin. Enter the desired carousel number, shelf, cell and quantity. Click the Light button. Press the TC button to test the task complete feature.


Wait For Task Complete

This Test simply waits for any Task Complete button to be pressed before continuing.  When you select this you will see a message to start execution.  Click on ok or press enter.  Waiting for task complete window displays with the timer active.  Pressing a task complete or pressing Shift F4 completes the test.






  • None