General Details
Customer Number(s): 01DEPVIC
Orders Received: ☒ EDI ☐ Email ☐ Portal Import ☐ Fax
Ship From Location: Gun Club Road
Planned Ship Date: ☐ From Order Date* ☐ From Customer Ship Date*
☐ From Cancel Date* ☒ Day(s) of Week: Mon, Tues, Wed
☐ EDI Mapped Directly
*If “From” logic: ☐ Add # days ☐ Subtract # days
Same Day Shipping: ☐ Yes Cutoff Time: N/A. ☒ No
Ship Via: Customer Routing Guide
Freight Code: Collect
Order Processing Schedule: Orders Received On: Tues, Wed, Thurs
Orders Released On: Tues, Wed, Thurs
Orders Shipped On: Shipping Scheduled 6 day from release day.
Customer Contacts: Kerry.Carmell@OfficeDepot.com
Damaged & Defective Terms: N/A
Backorder/Partial Line Handling: Line in full: Commit entire line or not at all; release when committed.
Order Confirmation Requirements: Auto via EDI
Changes/Cancellations to PO: N/A
Holiday Schedule/Requirements: They will send notifications.
Sales Order Processing
Approval Method: ☒ Auto ☐ Manual
Release Method: ☐ Auto ☒ Manual
Release Email Required: ☒ Yes ☐ No
Orders Must be Released together for pick jobs: ☒ Yes ☐ No
Validation Failure: Please list any common validation failure reasons and how to resolve.
N/A
Customer Portal Process: If customer has portal, please detail when and how it is used in the order process.
N/A
Customer Specific Process: Please outline any unique processes performed for this customer by Advantus. (Examples: Optional fields valued with specific data,
N/A
Return Authorizations
Returns Allowed: ☐ Yes ☐ No
If so, please explain any existing customer specific details to the Return Authorization process.
N/A
Order Process
The orders will arrive in the morning in between 8:30 and 11am, but usually closer to 8:30.
- Check the EDI Range email to see if the orders have arrived
2. Go to the Unfilled Lines (Qty To Ship=0) search and search for 01DEPVIC orders for today’s date.
3. Export the results as an Excel file and save to S:\Customer Service\Team Folder\Will F\Victory Light Accounts\01DEPVIC\01DEPVIC Unfilled Lines
4. Send this file to Kerry Carmell at Office Depot Kerry.Carmell@OfficeDepot.com. If there are no unfilled lines, send him an email saying that all lines are full.
5. Go to Sales Order Manager and search for 01DEPVIC orders that are on hold and are scheduled to be released on that day. In order to get the orders for that day, copy and paste the below location IDs into the Ship to Address field. You will also need to change the location to Gun Club Road on the SO Manager when searching for the orders with the location ID’s.
- (Now Tuesday as of 7/11/22) Locations:
- 3059, 1079, 1127, 1105, 1090, 6877, 6874, 6869, 1170
- Location ID: 16584, 16562, 16572, 16561, 16566, 16608, 16607, 16605, 16576
- (Now Wednesday as of 7/11/22) Locations:
- 1214, 3013, 3077, 5101, 5125, 3049, 6881
- Location ID: 16575, 16581, 16595, 16599, 16601, 16583, 16610
- (Now Thursday as of 7/11/22) Locations:
- 1078, 5910, 1080, 6871, 6876, 1135, 1165, 3048, 3063
- Location ID: 16559, 16603, 16560, 16606, 16609, 16573, 16574, 16582, 16586
6. Mark every line that has quantity committed to it and change the status to Released and the PSD to 6 days from today, Apply Mass Updates, and Submit Changes. Make a mental note of how many orders you are releasing.
7. Change the Release Status filter to Released, enter the Planned Ship Date, and hit Apply Filters. You should see the same number of lines as the number that you released. If you do not, wait a few minutes and try again. There is sometimes a delay, especially when there is a large number of orders.
8. Export this to Excel.
9. Copy the entire Excel sheet, paste it into an email, and send it to GCRShipping@advantus.com saying that you have released these orders to ship on X-X-20XX. CC Virginia, Jason, and Amanda.