Filter list by the Delivery Dates and delete all lines due previous working day forward (keep only the lines that require expediting - generally day before yesterday (working days only))
Delete lines for non-FMS sites (see separate list)
Delete lines for supplier Roxboro Tool Room
Filter spreadsheet by CODE keep lines with CODEs listed below and delete other lines
All CONF- codes
All UNC- codes
All HOT- codes
All EXP-PEND codes
EXP-TRANS
EXP-UPD
All LLT- codes
Blanks review lines and delete those that do not require expediting (includes uniform company PO’s)
Custom sort list in alphabetical order by vendor name with following sort levels
Color code list to assign expediting to the designated expediter
0 Comments
Add your comment