Spreadsheet: 857427d1706451613-need-help-with-kpi-reports-commerce-return-and-cancelled-orders-17012024
Sheet: COMMERCE

 | WH | DATE | DRIVER NAME | SITE CODE | CUSTOMER NAME | INVOICE NO | VALUE | STATUS | RESPONSIBLE DEPT. | REASON CATEGORY | WAREHOUSE REMARKS | CHANNEL
 | WH_01 | 2024-01-03 00:00:00 | [NAME] 1 | 170049 | CUSTOMER 1 | 804951338 | 210.24 | RETURNED | SALES | Merchandise Not Available | Re-scheduled for next Dispatch
 | WH_01 | 2024-01-03 00:00:00 | [NAME] 1 | 195390 | CUSTOMER 2 | 9800261956 | 589.62 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_01 | 2024-01-04 00:00:00 | [NAME] 1 | 169862 | CUSTOMER 3 | 9800261923 | 546 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_01 | 2024-01-04 00:00:00 | [NAME] 1 | 169981 | CUSTOMER 4 | 9800262024 | 130 | CANCELLED | SALES | LPO Expired | Expired LPO received
 | WH_01 | 2024-01-04 00:00:00 | [NAME] 1 | 170032 | CUSTOMER 5 | 804950570 | 883.44 | CANCELLED | SALES | Double Order | Duplicate order placed
 | WH_01 | 2024-01-07 00:00:00 | [NAME] 1 | 171141 | CUSTOMER 6 | 9800262524 | 3816 | RETURNED | WAREHOUSE | [NAME] | WH missed to paste [NAME], re-scheduled for next Dispatch
 | WH_01 | 2024-01-11 00:00:00 | [NAME] 1 | 169981 | CUSTOMER 7 | 9800262989 | 130 | CANCELLED | SALES | LPO Expired | Expired LPO received
 | WH_01 | 2024-01-11 00:00:00 | [NAME] 1 | 169977 | CUSTOMER 8 | 9800263404 | 570 | CANCELLED | PROCUREMENT | Rejected due to Short [NAME] | Short expiry product not accepted at outlet
 | WH_01 | 2024-01-11 00:00:00 | [NAME] 2 | 169935 | CUSTOMER 9 | 9800263396 | 2344.12 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_01 | 2024-01-11 00:00:00 | [NAME] 2 | 169985 | CUSTOMER 10 | 804961323 | 1864.62 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_01 | 2024-01-13 00:00:00 | [NAME] 2 | 169984 | CUSTOMER 11 | 804963010 | 93.12 | CANCELLED | SALES | Double Order | Duplicate order placed
 | WH_01 | 2024-01-13 00:00:00 | [NAME] 2 | 169888 | CUSTOMER 12 | 9800263669 | 45 | CANCELLED | PROCUREMENT | Rejected due to Short [NAME] | Short expiry product not accepted at outlet
 | WH_01 | 2024-01-13 00:00:00 | [NAME] 2 | 184522 | CUSTOMER 13 | 9800263822 | 566.91 | CANCELLED | SALES | LPO Expired | Expired LPO received
 | WH_01 | 2024-01-13 00:00:00 | [NAME] 2 | 191259 | CUSTOMER 14 | 804962730 | 91.92 | CANCELLED | PLANNING | Road Closure | Due to Asian Cup Football - Road was closed
 | WH_01 | 2024-01-13 00:00:00 | [NAME] 2 | 800312 | CUSTOMER 15 | 9800263733 | 4424.71 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_01 | 2024-01-13 00:00:00 | [NAME] 2 | 171499 | CUSTOMER 16 | 804962725 | 2253.36 | RETURNED | SALES | Merchandise Not Available | Re-scheduled for next Dispatch
 | WH_01 | 2024-01-13 00:00:00 | [NAME] 2 | 171499 | CUSTOMER 17 | 804963213 | 1149.34 | RETURNED | SALES | Merchandise Not Available | Re-scheduled for next Dispatch
 | WH_01 | 2024-01-13 00:00:00 | [NAME] 2 | 171499 | CUSTOMER 18 | 804963212/804963241 | 1296.64 | RETURNED | SALES | Merchandise Not Available | Re-scheduled for next Dispatch
 | WH_01 | 2024-01-14 00:00:00 | [NAME] 3 | 169936 | CUSTOMER 19 | 9800263993 | 1016.16 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-14 00:00:00 | [NAME] 3 | 169936 | CUSTOMER 20 | 9800263994 | 3947.58 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-14 00:00:00 | [NAME] 3 | 175867 | CUSTOMER 21 | 9800263965 | 3800 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-14 00:00:00 | [NAME] 3 | 169900 | CUSTOMER 22 | 9800263954 | 2241.25 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-15 00:00:00 | [NAME] 3 | 169972 | CUSTOMER 23 | 9800263869 | 156.15 | CANCELLED | PLANNING | LPO Expired | Delivery missed to dispatch as per schedule
 | WH_02 | 2024-01-15 00:00:00 | [NAME] 3 | 169928 | CUSTOMER 24 | 9800263955 | 474 | CANCELLED | SALES | Rejected by Customer | Invoice Cancelled
 | WH_02 | 2024-01-15 00:00:00 | [NAME] 3 | 170401 | CUSTOMER 25 | 9800263868 | 755 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-15 00:00:00 | [NAME] 3 | 170401 | CUSTOMER 26 | 9800263870 | 169.18 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-15 00:00:00 | [NAME] 3 | 170401 | CUSTOMER 27 | 9800263871 | 1124.27 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-15 00:00:00 | [NAME] 3 | 170401 | CUSTOMER 28 | 9800263872 | 1545.23 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-15 00:00:00 | [NAME] 3 | 800310 | CUSTOMER 29 | 9800264087 | 842.58 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-15 00:00:00 | [NAME] 3 | 170401 | CUSTOMER 30 | 9800263873 | 1252.69 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-16 00:00:00 | [NAME] 3 | 169998 | CUSTOMER 31 | 9800264423 | 4774.51 | RETURNED | SALES | Delivery Date Re-scheduled After Delivery | [NAME] date informed by Salesman, re-scheduled
 | WH_02 | 2024-01-16 00:00:00 | [NAME] 3 | 169860 | CUSTOMER 32 | 9800264387 | 14800 | RETURNED | DATA ENTRY | Wrong Customer Code | Wrong customer code entered in sales order
 | WH_02 | 2024-01-17 00:00:00 | [NAME] 3 | 180094 | CUSTOMER 33 | 9800264684 | 557 | Cancelled | SALES | Rejected by customer | Wrong Quantity placed by Salesman
 | WH_02 | 2024-01-17 00:00:00 | [NAME] 3 | 180094 | CUSTOMER 34 | 9800264697 | 557 | Cancelled | SALES | Rejected by customer | Wrong Quantity placed by Salesman
 | WH_02 | 2024-01-17 00:00:00 | [NAME] 3 | 180094 | CUSTOMER 35 | 9800244695 | 557 | Cancelled | SALES | Rejected by customer | Wrong Quantity placed by Salesman
 | WH_02 | 2024-01-17 00:00:00 | [NAME] 3 | 191280 | CUSTOMER 36 | 9800264670 | 1234.68 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-17 00:00:00 | [NAME] 4 | 191280 | CUSTOMER 37 | 9800264671 | 1482.72 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-17 00:00:00 | [NAME] 4 | 191280 | CUSTOMER 38 | 9800264672 | 1157.58 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-17 00:00:00 | DRIVER 5 | 180094 | CUSTOMER 39 | 9800264674 | 557 | Cancelled | SALES | Rejected by customer | Wrong Quantity placed by Salesman
 | WH_02 | 2024-01-17 00:00:00 | DRIVER 5 | 180094 | CUSTOMER 40 | 9800264681 | 557 | Cancelled | SALES | Rejected by customer | Wrong Quantity placed by Salesman
 | WH_02 | 2024-01-17 00:00:00 | [NAME] 6 | 180094 | CUSTOMER 41 | 9800264691 | 557 | Cancelled | SALES | Rejected by customer | Wrong Quantity placed by Salesman
 | WH_02 | 2024-01-17 00:00:00 | DRIVER 7 | 180094 | CUSTOMER 42 | 9800264662 | 557 | Cancelled | SALES | Rejected by customer | Wrong Quantity placed by Salesman
 | WH_02 | 2024-01-17 00:00:00 | [NAME] 8 | 800294 | CUSTOMER 43 | 9800264443 | 4410 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-17 00:00:00 | DRIVER 9 | 169863 | CUSTOMER 44 | 9800264679 | 23362.5 | RETURNED | [NAME] | Delivery Time Out | Driver Duty time ended, re-scheduled for next Dispatch
 | WH_02 | 2024-01-20 00:00:00 | DRIVER 10 | 169947 | CUSTOMER 45 | 9800265085 | 1314.48 | Cancelled | SALES | Double Order | Duplicate order placed
 | WH_02 | 2024-01-20 00:00:00 | DRIVER 11 | 181170 | CUSTOMER 46 | 9800265087 | 958.08 | Cancelled | SALES | Double Order | Cancelled invoice
 | WH_02 | 2024-01-20 00:00:00 | DRIVER 12 | 181170 | CUSTOMER 47 | 9800265088 | 1514.88 | Cancelled | SALES | Double Order | Cancelled invoice
 | WH_02 | 2024-01-20 00:00:00 | DRIVER 13 | 169951 | CUSTOMER 48 | 9800265091 | 941.76 | RETURNED | SALES | Double Order | As per salesman request, re-scheduled after 3 days
 | WH_02 | 2024-01-20 00:00:00 | [NAME] 14 | 169957 | CUSTOMER 49 | 9800264936 | 1839.12 | RETURNED | SALES | Merchandise Not Available | Re-scheduled for next Dispatch
 | WH_02 | 2024-01-20 00:00:00 | DRIVER 15 | 190398 | CUSTOMER 50 | 9800264953 | 6509.58 | RETURNED | SALES | Merchandise Not Available | Re-scheduled for next Dispatch