For those wishing to create a report showing any orders that have not yet been received, or that have only been part received, the below report could be used.
Print List
Product ID (from the Orders table)
Order Reference (from the Orders table)
Order Number (from the Orders table)
Transaction Date (from the Orders table) (The transaction date is the date on which the order was originally created.)
Sort List
You can sort however you like, perhaps by Order Number, or maybe by Product ID.
Qualify List
You can qualify by Order Status (again taken from the Ordering table), IS from 10 to 15.
10 represents Printed/Faxed Orders where nothing has been received yet, and 15 represents Part Received Orders.