Saved Search that Displays Back Ordered Quantity and Amount or Dollar Value

To create a saved search that displays backordered quantity and back ordered amount of sales orders, perform the following:

  1. Navigate to Reports > Saved Searches > All Saved Searches > New.
  2. Click Transactions.
  3. Under Criteria tab and Standard subtab, set the following:
  4. Type = Sales Order
  5. Tax Line = False
  6. Shipping Line = False
  7. Status = is any of Sales Order:Partially Fulfilled, Sales Order:Pending Fulfillment
  8. Under Results tab and Columns sub tab, set the following:
  9. Formula (Numeric) = {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0)
  10. Formula (Currency)= ({quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0))*{rate}
  11. Enter a name for the custom search.
  12. Click Save.
Did this help? If not, try contacting us Submit a request

Comments