How to set criteria for an item saved search to show items where the back order quantity is lower than what is on order

Scenario: Create a saved search to display items having the backorder quantity is lower than what is on order

Step: 1 Create an Item saved search

List> searches> saved searches> New> Item

Provide necessary criteria and results.

In the criteria add the formula numeric field

Add formula: NVL({quantityonorder},0)-NVL({quantitybackordered},0)

And greater than needs to be defined.

Save and Run.

Leave a comment

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