| Customer | Open lines | Open value | Late lines | Late value |
|---|---|---|---|---|
| Anchor Point Machinery | 3 | $30,790.00 | 0 | $0.00 |
| Bayou Drilling Supply | 4 | $30,490.00 | 1 | $13,700.00 |
| Caliche Flats Ag Store | 1 | $11,370.00 | 0 | $0.00 |
| Prairie Wheel Equipment | 4 | $39,493.00 | 1 | $7,488.00 |
| Sweetwater Draw Farm Supply | 2 | $60,640.00 | 0 | $0.00 |
| Tri-County Implement | 3 | $11,850.00 | 0 | $0.00 |
| Order | Line | Customer | Item | Open qty | Open value | Ship date | Days late |
|---|---|---|---|---|---|---|---|
| SO004805 | 1 | Bayou Drilling Supply | MR-1031 | 2 | $13,700.00 | 2026-11-12 | 4 |
| SO004801 | 2 | Prairie Wheel Equipment | MR-1010 | 24 | $7,488.00 | 2026-11-13 | 3 |
| Excel row | Order | Line | Reason |
|---|---|---|---|
| 11 | SO004815 | 1 | status 'Completed' is not an open status |
| 15 | SO004818 | 1 | duplicate order and line (first one kept) |
| 16 | QT001207 | 1 | order type 'QT' is not counted |
| 18 | SO004820 | 1 | ship date is blank or not a date |
| 20 | RC000311 | 1 | order type 'RC' is not counted |
| 23 | SO004824 | 1 | status 'Cancelled' is not an open status |
Export file: MR-Open-Sales-Lines-2026-11-16.xlsx | As-of date: 2026-11-16 | Rows in export: 23