Version 5.9
In this Topic: Show
"Quick Filters" are used to limit the types and the amount of orders that are displayed at the Orders or Multi-Order Processor screens. Each Quick Filter has its own set of criteria by which orders are selected for viewing. The program is distributed with nineteen pre-defined Quick Filters.
Make a selection from the Quick Filter drop-down list at the top of the Orders and Multi Order Processor screens to change the Quick Filter that is currently applied.
See system parameters MultiOrderDefaultView and DefaultOrderView to set the default view for the Multi-Order Processor and Orders screens, respectively.
All Orders - displays every order within the system
Today’s Pending Orders - shows only orders that were imported or manually entered on the current day, which have not yet been approved
All Pending (not approved yet) - provides a list of all unapproved orders within the system, regardless of when they were entered
Complete, Pending orders - displays all unapproved orders that are ready to be shipped to the customer; meaning that all items on the order are available (contains no backorders) and that purchase orders for any drop-ship items on the order have been created
Orders on Hold - displays a list of orders that have an Order State of "On Hold" as seen in the lower right-hand corner of the Orders screen
Incomplete (open BO's or drop-ships) - displays a list of orders that are not ready to be shipped due to open backorders or un-placed drop-ship orders
Incomplete, paid by CC or COD - displays a list of orders that are not ready to be shipped, but have been paid by credit card or COD
Backorders to be Filled - shows a list of orders in which the Quantity Needed column contains a value greater than zero; except in any line items for products that are normally drop-shipped.
Drop-ships to be Ordered - displays orders containing drop-ship products that have not yet been ordered from the supplier
Drop-ships missing Date Shipped - produces a list of orders containing drop-ship items that do not yet have a ship date set
Stock items to be Filled - lists any orders that contain at least one non-drop-shipped item for which the DateShipped field is Null, the Quantity Shipped is >1, and the Quantity Needed = 0
All orders missing Date Shipped - shows all orders within the system that do not yet have a ship date set
Approved orders with no Date Shipped - displays all approved orders within the system that do not yet have a ship date set
Orders from Last Import - produces a list of orders that were created during the last import session
All Orders with No Tracking #'s - limits the view to a group of orders which do not have at least one tracking number associated with them, regardless of their status
Approved Orders with No Tracking #'s - limits the set of records that are displayed to those which have been approved but do not have at least one tracking number associated with them
Non-Externally Fulfilled Orders with no Tracking #'s - all orders which are fulfilled outside of the Order Manager that have no tracking information
Non-Externally Fulfilled Approved Orders with No Tracking #'s - Approved orders which are fulfilled outside of the Order Manager that have no tracking information
Orders with Externally Fulfilled Items - all orders that contain line items that are fulfilled outside of the Order Manager
Creating custom Quick Filters on your own requires some basic knowledge of SQL (Structured Query Language).
NOTE: Version 4.3xx and greater allows for 5 custom filters, Version 4.2xx and lower allows only 1
For example:
If you want a filter to look for all orders that are approved in the state of PA then enter:
Approved=True AND Cancelled=False AND (State='PA' or ShipState='PA')
Created: 12/15/10
Modified: 9/12/13
Go to Top