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.