Customize the Open Purchase Orders Report to show items which are not yet received

1. Navigate to Reports > Purchases > Open Purchase Orders > Customize.

2. Under Edit Columns link, click on Open Purchase Orders folder. Scroll down and click on Quantity field. This represents the quantity on the purchase order.

3. Under Edit Columns link, click on Open Purchase Orders folder. Scroll down and click on Quantity Received field. This represents the quantity received on the purchase order.

4. Under Edit Columns link, click on Add Formula Field button at the left hand side. As a result, a Formula column will be added on the report.

5. Under Edit Columns link, click on the Formula column. Choose Difference x-y from the Formula Type dropdown. X should be equal to Quantity while Y should be equal to Quantity Received. The Formula column represents the quantity which is not yet received on a particular purchase order.

6. Enter a Report Title and hit Save.