Create a Saved Search to Display Percent of Quantity Fulfilled

To display percentage of quantity fulfilled in a Saved Search, perform the following:

1. Navigate to Lists > Search > Saved Searches > New.

2. Click Transaction.

3. Under Criteria tab and Standard subtab, set the following:

1. Type = Sales Order

2. Main Line = No

4. Under Results tab and Columns subtab, add the following:

Columns Drill Down Fields

FIELD SUMMARY TYPE FUNCTION FORMULA WHEN ORDERED BY FIELD CUSTOM LABEL SUMMARY LABEL   Item               Quantity               Quantity Fulfilled/Received               Formula (Percent)     {quantityshiprecv}/NULLIF({quantity},0)   Percent of Quantity Fulfilled

5. Enter a name for the search.

6. Click Save.