Search to Get the Percentage of Fulfilled Quantity Out of Ordered Quantity

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

2. Under Criteria tab, set the following:
Type is Sales Order
Date is (specify a specific period)
Main Line is false
Tax Line is false
COGS Line is false
Shipping Line is false
*Set other criteria needed.

3. Under Results tab, set the following:  

Number
Name
Quantity
Quantity Fulfilled/Received
Formula (Percent) > Formula = nvl({quantityshiprecv},0)/nullif(nvl({quantity},0),0)
4. Enter a Search Title.
5. Hit Save & Run

Leave a comment

Your email address will not be published. Required fields are marked *