My Customer Orders widget
Graph the shipping status of customer orders: in process, complete, shipped, or past due.
Filter: You can show all orders or only orders taken by you, and filter by due date.
Calculations:
- In Process: Quantity Ordered > Quantity Shipped, Status = ‘O’, Due Date falls in range of Search Field selection, and order or customer are not on credit hold.
- Shipped: Quantity Ordered <= Quantity Shipped, Status = ‘O’, ‘C’, or ‘F’, and Due Date falls in range of Search Field selection.
- Past Due: Quantity Ordered > Quantity Shipped, Status = ‘O’, Due Date less than Today, and order or customer are not on credit hold.
- Hold: Quantity Ordered > Qty Shipped, Status = ‘O’, and Due Date less than end date of Search field selection.