On this page
Use an asterisk (*) for wildcard searches:
Asterisk at the beginning of a search term: Using *ndon will find Swindon and London
Asterisk at the end of a search term: Using wind* will find Window
Asterisk at the beginning and end of a search term: Using *windo* will find Window and Swindon
Use a semicolon (;) for multiple search terms: Using Customer Country = Brazil;Colombia will find quotes having a Customer Country of Brazil or Colombia.
For long multiple search term strings, in the Criteria field, add a space after each semicolon (but do not put a semicolon at the end of the search string). This will enable the field (which is scrollable) to wrap.
Filtering on Operation Code or Division Code is much easier than searching by Product Code
Search for multiple items within one filter. For example if you wish to filter on status, you can look for RFQs and DPQs by entering RFQ*;DPQ*
To search for quotes that have a DPA number, filter by DPA Number >= 0
If you will be using the same filter frequently, save it as part of your default view within the Customize your Quote List page. When you login, this filter will always be there.
You can view as many quotes as you want, by just changing the number of quotes you wish to view per page. Again this can be saved via the Customize your Quote List page.
You can sort by any of the headers in your view, by just simply clicking on the header title. Again you can set a sorting preference in the Customize your Quote List page.
Within the filters, it is easy to get confused about the difference between END CUSTOMER and CUSTOMER
END CUSTOMER – if the Disti's end customer is reseller/subcontractor, the END CUSTOMER is the reseller/Subcontractors End Customer.
CUSTOMER – this is the Disti's end customer.
| Filter Entry | Returns Each Quote that... |
Customer Name = Cisco |
...has a Customer Name of Cisco |
Customer Name = Cisco; Dell |
...has a Customer Name of Cisco or Dell |
Customer Name = Cis* |
...has a Customer Name beginning with "Cis" (Cisco, Cisalpino, etc.) |
Customer Name = *cisco |
...has a Customer Name ending with "isco" (Cisco, Francisco, etc.) |
Customer Name <> Cisco |
...does not have a Customer Name of Cisco |
|
|
Approved Quantity = 20 |
...has an Approved Quantity of exactly 20 |
Approved Quantity > 20 |
...has an Approved Quantity of more than 20 |
Approved Quantity >= 20 |
...has an Approved Quantity of 20 or more |
Approved Quantity < 20 |
...has an Approved Quantity of less than 20 |
Approved Quantity <= 20 |
...has an Approved Quantity of 20 or less |
|
|
Creation Date = 01 Apr 2009 |
...was created on April 1, 2009 |
Creation Date < 01 Apr 2009 |
...was created before April 1, 2009 |
Creation Date > 01 Apr 2009 |
...was created after April 1, 2009 |
Creation Date <> 01 Apr 2009 |
...was not created on April 1, 2009 |
Creation Date >= 01 Apr 2009 |
...was created on or after April 1, 2009 |
Creation Date <= 01 Apr 2009 |
...was created on or before April 1, 2009 |
|
|
GEO = APAC |
...pertains to Asia Pacific (APAC) region |
GEO = APAC ; EMEA |
...pertains to APAC or Europe, Middle East and Africa (EMEA) Regions |
GEO <> IJKK |
...does not pertain to Japan region (IJKK) |
GEO = A* |
...pertains to APAC or ASMO (Americas) region |
|
|
End Customer Name = BLANK |
...does not have an entry in the End Customer Name field |
End Customer Name = <BLANK> |
...does not have an entry in the End Customer Name field |
End Customer Name = NULL |
...does not have an entry in the End Customer Name field |
End Customer Name = <NULL> |
...does not have an entry in the End Customer Name field |
End Customer Name <> BLANK |
...has an entry in the End Customer Name field |
End Customer Name <> <BLANK> |
...has an entry in the End Customer Name field |
End Customer Name <> NULL |
...has an entry in the End Customer Name field |
End Customer Name <> <NULL> |
...has an entry in the End Customer Name field |
Updated: 15-May-2013 12:58