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

  1. Navigate to Lists > Search > Saved Searches > New >Transaction.
  2. Under Criteria tab, set the following:
    Type- Sales Order
    Date- (specify a specific period)
    Main Line-false
    Tax Line-false
    COGS Line-false
    Shipping Line-false
  3. Under Results tab

Number
Name
Quantity
Quantity Fulfilled/Received
Formula (Percent) > Formula = nvl({quantityshiprecv},0)/nullif(nvl({quantity},0),0)

  1. Enter a Search Title.

5.Save & Run.

Leave a comment

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