Manage filtering the document list
When multiple warehouse employees are available, the manager may assign each employee to process the documents they typically handle. For example, some employees may pick items for specific shipping agents or customers. Each warehouse employee can filter the document list to show only the documents they want to process.
As a warehouse manager, you can assign a standard filter to employees at the start of their day. Depending on their tasks, employees can adjust the filter throughout the day, allowing them to switch between their standard list and the general list for processing.
The filter fields and processes apply to the following modules:
- Warehouse Receipt
- Warehouse Put-Away
- Warehouse Bulk Put-Away
- Direct Put-Away
- Warehouse Pick
- Shipment Load List
For these modules, the last filter set by each WMS user is always saved.
Setup in Business Central
- Choose the search icon
, enter Locations, and then choose the related link.
The Locations list page opens. - Select the location for which you want to set the default validations.
The Location Card page opens. - On the action bar, select Configure WMS.
The WMS Configuration page opens. - On the action bar, select Modules on Scanner.
The Modules on Scanner list opens. - Select the required module.
The Module Settings card page opens. - On the action bar, select Header Fields.
The Header Fields list page opens. - Fill in the required field that you want to display in the header. Hover over a field to read a short description.
- When you leave the Text Format field blank, the system will use the standard format based on the field type.
- When you enter a format (Example: <Day,2>/<Month,2>) in the Text Format field, the system uses this format to display the value based on the field type. For more information about different formats, see Formatting Values, Dates, and Time
- Close the Header Fields list page.
- On the Module Settings page, in the Document Header Format field, enter a value using the identifiers from the header field list. (Example: %2 - %1(%3))
- On the action bar, select Default User Filters action.
The Default User Filter list opens. - Fill in the required fields for each WMS user to set the default filter in the document list. Hover over a field to read a short description.
- Close the Default User Filter list page.
- On the Module Settings page, in the Document Filter Format field, enter a value using the identifiers from the header field list. (Example: %2 - %1(%3))
- When the Document Header Format field is empty, the standard header is displayed on line 2 of the scanner.
- When the Document Filter Format field is empty, you cannot filter the document list.
- As a best practice, keep the Document Header Format field identical to the Document Filter Format field. If you need to add extra fields for filtering, add them at the end of the string.
Flows on scanner, depending on setup in default user filter list
To identify filtering in a document list, use the following lead signs:
- No lead sign: No filter is applied to the list.
- * : The list is filtered using your most recent filter.
- # : The list is filtered using your default filter.
- #* : The list is filtered using both your default filter and your most recent filter.
When you close a document list and reopen it, the list will be filtered using the last filter applied by the WMS user.
The following settings are available for three different flows for a WMS user, which are configured on the Default User Filter page.
- No line for a WMS user:
- The user can see the full list.
- When opening the document list for the first time, the document list is unfiltered.
- Entering a string in the input field on the scanner:
- Filters the document list.
- Changes the lead sign to *.
- Opens the document immediately on the scanner if only one document matches.
- Entering a * in the input field and closing the filter will return the list to its unfiltered state.
- A line with Search String field value and Default Locked checkbox is cleared for a WMS user:
- The user sees a list filtered by the search string or by their last filter.
- When opening the document list for the first time, it is filtered by the search string, with the lead sign #.
- Entering a string in the input field on the scanner:
- Filters the document list according to the entered string.
- Changes the lead sign to *.
- Opens the document immediately on the scanner if only one document matches.
- Entering a * in the input field and closing the filter returns the list to the search string filter, with the lead sign changing back to #.
- A line with Search String field value and Default Locked checkbox is selected for the WMS user:
- The user can see a filtered list and apply additional filters within it.
- When opening the document list for the first time, it is filtered by the search string, with the lead sign #.
- Entering a string in the input field on the scanner:
- Applies the entered filter in addition to the existing search string.
- Changes the lead sign to #*.
- Opens the document immediately on the scanner if only one document matches.
- Entering a * in the input field and closing the filter will revert the list to the search string filter, with the lead sign changing back to #.
When the filter selection results in no lines, use * to clear the filter and display all items.
Show only documents due today
The document list on the scanner can be limited to the documents that are due today. The Today filter is set per location, module, and WMS user on the Default User Filter page, so one WMS user can work from a list of today's documents while other WMS users, and the other modules of the same WMS user, keep the full list.
Prerequisites
- The module is set up on the Modules on Scanner list of the location. For more information, see Setting up modules on scanner per location.
- The WMS user is set up. For more information, see Setting up Users for WMS.
-
The documents of the module have a due date. The date that is used depends on the module:
Module Date used Warehouse Receipt The earliest Due Date field value on the warehouse receipt lines. Direct Put-Away The earliest Due Date field value on the warehouse receipt lines. Warehouse Pick The earliest Due Date field value on the warehouse activity lines. Warehouse Put-away The earliest Due Date field value on the warehouse activity lines. Whse. Bulk Put-Away The earliest Due Date field value on the warehouse activity lines. Movement The earliest Due Date field value on the warehouse activity lines. Whse. Bulk Movement The earliest Due Date field value on the warehouse activity lines. Shipment Load List The Shipment Date field value on the warehouse shipment. Prod. Output The Due Date field value on the production order. Prod. Consumption The Due Date field value on the production order. Adv. Prod. Consumption The Due Date field value on the production order.
Set up the Today filter
- Open the Module Settings page of the module, as described in steps 1 to 5 of Setup in Business Central.
- On the Document lists on scanner FastTab, turn on the Use Today Grouping toggle.
- In the Days to adjust Today for grouping field, enter the number of days after today for which documents are also shown.
For example, enter 0 to show only documents that are due today or earlier, or enter 1 to also show the documents that are due tomorrow. - On the action bar, select the Default User Filters action.
The Default User Filter page opens. -
Add a line for the WMS user, or select the existing line, and enter information in the following fields:
Field Description WMS User No. Select the WMS user for whom the document list is filtered. Search String Enter the text by which the document list is filtered. The field value can be left blank when the Use Today Filter checkbox is selected. Use Today Filter Select the checkbox to show only the documents that are due today, including the days to adjust. Assigned User View Select which documents are shown, based on the assigned user of the document. For more information, see Show documents by assigned user. Default Locked Select the checkbox to keep the default filter when the WMS user enters an additional filter on the scanner. -
Close the Default User Filter page.
When the WMS user opens the document list of the module on the scanner, only the documents with a date on or before today plus the Days to adjust Today for grouping field value are shown. Documents with an earlier date stay in the list, so overdue documents are not hidden. When the Search String field value is also filled in, both filters are applied. The list header shows the # lead sign when only the Use Today Filter checkbox is selected, and the lead signs and # behave as described in Flows on scanner, depending on setup in default user filter list.
- The Today filter is linked to the WMS user who is logged in on the scanner. The Business Central user, the warehouse employee, and the Assigned User ID field value of the document are not used.
- Documents without a date are not shown while the Use Today Filter checkbox is selected. The date is set when the document is created, and is updated when the due date on the lines or on the source document changes. Documents created before the upgrade to version 2603.0.0.0 have no date until their source document is modified.
- Entering * on the scanner does not remove the Today filter. The Today filter stays applied as long as the Use Today Filter checkbox is selected.
- The Use Today Filter checkbox can only be selected when the Use Today Grouping toggle is turned on for the module. The Use Today Grouping toggle cannot be turned off while a line on the Default User Filter page of the module has the Use Today Filter checkbox selected.
- The Today filter is not available for the Sales Return Order, Purchase Return Order, Transfer Receive, Transfer Shipment, and Ad Hoc Movement modules, because their documents have no date. Selecting the Use Today Filter checkbox for these modules results in an error.
- A line on the Default User Filter page requires a Search String field value, a selected Use Today Filter checkbox, or an Assigned User View field value.
For example, today is October 8 and four warehouse picks are released for location WHITE: pick 202 is due on October 7, pick 201 on October 8, pick 203 on October 9, and pick 205 on October 10. For the Warehouse Pick module, the Use Today Grouping toggle is turned on and the Days to adjust Today for grouping field value is 1. On the Default User Filter page, the line for WMS user NERANJ has the Use Today Filter checkbox selected and no search string. When NERANJ opens the pick list on the scanner, the list header shows the # lead sign and only picks 202, 201, and 203 are listed. Pick 205 is listed from October 9 onwards. A WMS user without a line on the Default User Filter page still sees all four picks.
Show documents by assigned user
The Assigned User View field on the Default User Filter page sets which documents a WMS user sees in the document list on the scanner, and in which order, based on the Assigned User ID field value of the document. The setting applies per location, module, and WMS user, so one WMS user can work only on the documents assigned to them while other WMS users keep the full list.
Prerequisites
- On the Users (WMS) page, the Warehouse Employee field value of each WMS user is the user ID that is used in the Assigned User ID field of the documents. A document that is assigned to a user ID without a matching WMS user counts as unassigned.
- The module is one of the following modules: Warehouse Receipt, Direct Put-Away, Warehouse Put-away, Whse. Bulk Put-Away, Warehouse Pick, Movement, Whse. Bulk Movement, Shipment Load List, Prod. Consumption, Adv. Prod. Consumption, or Prod. Output.
Set up the assigned user view
- Open the Module Settings page of the module, as described in steps 1 to 5 of Setup in Business Central.
- On the action bar, select the Default User Filters action.
The Default User Filter page opens. -
Add a line for the WMS user, or select the existing line, and in the Assigned User View field, select one of the following options:
Option Documents shown Order Blank The documents assigned to the WMS user and the unassigned documents. This is the same as in previous versions. The order of the module. Mine only The documents assigned to the WMS user. The order of the module. Mine and unassigned The documents assigned to the WMS user and the unassigned documents. The order of the module. Mine first then unassigned The documents assigned to the WMS user and the unassigned documents. The documents assigned to the WMS user first, then the unassigned documents. Mine and other users The documents assigned to the WMS user and to other WMS users. The order of the module. Mine first then other users The documents assigned to the WMS user and to other WMS users. The documents assigned to the WMS user first, then the documents assigned to other WMS users. All All documents. The order of the module. Mine first then other users then unassigned All documents. The documents assigned to the WMS user, then the documents assigned to other WMS users, then the unassigned documents. Mine first then unassigned then other users All documents. The documents assigned to the WMS user, then the unassigned documents, then the documents assigned to other WMS users. -
Close the Default User Filter page.
Within each block of an ordered option, the documents are sorted by document number. For the Warehouse Pick module with the Pick List Sort Mode field value set to Delivery Sequence, the picks in each block are sorted by delivery sequence.
- The Assigned User View field value is applied together with the Search String field value and the Use Today Filter checkbox. The list header shows the # lead sign when only the Assigned User View field value is set.
- When the Assigned User View field value is set to Mine only, Mine and unassigned, Mine and other users, or All, the Sort documents first on assigned user toggle of the Warehouse Pick module does not change the order of the list.
- The assigned user of a document is set when the document is created, and is updated when the source document is modified. Documents created before the upgrade to version 2603.0.0.0 count as unassigned until their source document is modified.
- Selecting an option other than blank for a module that is not listed in the prerequisites results in an error.
For example, three picks are released for location WHITE: pick 301 is assigned to warehouse employee ANNA, pick 302 is assigned to warehouse employee BOB, and pick 303 is not assigned. On the Users (WMS) page, WMS user ANNA has the Warehouse Employee field value ANNA. On the Default User Filter page of the Warehouse Pick module, the line for ANNA has the Assigned User View field value Mine first then unassigned. When ANNA opens the pick list on the scanner, picks 301 and 303 are listed in this order, and pick 302 is not shown.
Group the document list
The document list on the scanner can start with a group selection screen for the Warehouse Pick, Warehouse Receipt, and Prod. Consumption modules. Each group shows the number of remaining documents, and selecting a group opens the document list of that group.
Prerequisites
- The Aptean WMS app on the handheld device supports the group selection screen.
Turn on list grouping
- Open the Module Settings page of the module, as described in steps 1 to 5 of Setup in Business Central.
-
On the Document lists on scanner FastTab, turn on the Enable List Grouping toggle.
The documents of the module are grouped as follows:Module Grouped by Group name on the scanner Warehouse Pick The warehouse shipment of the pick. The warehouse shipment number. Warehouse Receipt The earliest Due Date field value on the warehouse receipt lines. The earliest date is shown first. The date. Prod. Consumption The first released production order line of the production order. The production order number and the line number, for example 101001 - Line 10000.
Documents without a group are listed in the Unassigned group, which is always shown last. A group is removed from the group selection screen when its last document is processed.
- The Enable List Grouping toggle is only shown for the Warehouse Pick, Warehouse Receipt, and Prod. Consumption modules. Turning it on for another module results in an error.
- The Use Today Filter checkbox, the Search String field value, and a search on the scanner are applied to the document list of a group, not to the number of documents on the group selection screen. The Assigned User View field value is applied to both.
- When a group is selected, the document list of the group is loaded, also when the Start with empty list toggle is turned on for the module.
For example, the Enable List Grouping toggle is turned on for the Warehouse Pick module of location WHITE. Three picks are created from warehouse shipment SH-1001, one pick is created from warehouse shipment SH-1002, and one pick has no warehouse shipment. When the WMS user opens the pick list on the scanner, the group selection screen shows SH-1001 with 3 remaining picks, SH-1002 with 1 remaining pick, and Unassigned with 1 remaining pick. Selecting SH-1001 opens the list of its three picks.