My Purchase Orders widget

Graph the receiving status of purchase orders: in process, received, or past due.

Filter: You can show all orders or only your orders, and filter by due date.

Calculations:

• In Process indicates that Quantity Ordered > Quantity Received, Status = ‘O’, Due Date is greater than or equal to today, and Due Date falls in the range of the filter field selection.
• Received indicates that Quantity Ordered <= Quantity Received, Status = ‘O’, ‘F’, or ‘C’, and Due Date falls in the range of the filter field selection.
• Past Due indicates that Quantity Ordered > Quantity Received, Status = ‘O’, and Due Date is less than today.