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.