OTIF Compliance Issues: On Time
On Time compliance issues for “Prepaid” are for times where you manage the freight. In these instances, you own the On Time accountability.
Prepaid Early Delivery
Cases on an order are designated “Prepaid Early Delivery” if the cases were delivered to the distribution center (DC) before the Must Arrive By Date (MABD) window. Early deliveries can be bad because they cause congestion in Walmart’s DCs and can actually result in the order arriving late to the store.
Prepaid Late Delivery
Cases on an order are designated “Prepaid Late Delivery” if the cases were delivered to the DC after the MABD window. Late deliveries can be bad because they can cause replenishment and stocking issues. You want to make sure that your product is always stocked and having on time deliveries will help with that.
Prepaid Unscheduled Appointment
Cases on an order are designated “Prepaid Unscheduled Appointment” when the cases arrive on a truck at the DC without a delivery appointment. Because the shipment did not have a delivery appointment, the Pro date will be considered the Arrival Compliance Date. This Pro date represents when shipping documentation is processed and may be days after the actual goods arrive. Scheduling DC appointments is something typically done by you or your carrier/3PL. Scheduled appointments are important so that the DCs know what to expect and can plan accordingly.
For more information on MABD windows, check our OTIF – How To Meet Delivery Appointments blog post.
OTIF Compliance Issues: Collect Ready
Collect Ready orders are instances where Walmart or a third party is in charge of picking up the order. Some compliance issues for Collect Ready orders go into the supplier’s accountability bucket, while others are owned by Walmart. Here are the ones that are the supplier’s accountability.
Supplier Ship Point
The “Supplier Ship Point” bucket occurs when an order fails to be Collect Ready because the assigned carrier could not secure the load in a timely manner due to an issue caused by the supplier. This is based on a carrier EDI transmission reason code of “Held by Shipper”.
This means that the carrier was not able to secure the product upon the pickup attempt due to a supplier-caused issue. For example, the facility may have been closed, there may have been too many trucks in line to pick up shipments, or the product simply wasn’t ready. In order to avoid accountability, you are required to submit a ticket to Walmart Transportation if a carrier does not show up for a pickup appointment. Either way, this compliance issue will count against your OTIF score.
Late Transport Notification
You will see a “Late Transport Notification” if the Request for Routing was not completed in a timely manner. Requests for Routing should be submitted by 4:00 PM CST the day after receiving the order.
This means that the supplier failed to submit a request for routing by 4:00 PM CST the day after the PO was submitted by Walmart. This includes weekend days, so be sure that you’re able to route all POs the day of, and the day after, any of your order review days of the week. Order Review Days are the days of the week that you’ve told Walmart you can receive POs on.
For manual orders, the expectation is to key the request 30 days prior to the MABD. If the order is received less than 30 days prior to MABD, the expectation is to key the routing request by 4:00 PM CST the day after receiving the order.
Specifically for D94 (Produce) items, System and Manual PO routing requests should be submitted at least two day prior to the ship-on day. If the order is received less than two days prior to the ship-on day, the expectation is to key the routing request on the day the order was received.
OTIF Compliance Issues: In Full
In-Full metrics measure the number of cases ordered against the number of cases delivered. In Full compliance issues are in the supplier's accountability bucket.
An order is considered “Not in Full” if the number of cases received was less than the number of cases ordered per PO line. System-generated orders are measured against the original order quantity. Manual orders are measured against the adjusted order quantity.
This means cases were not delivered to the destination as ordered. If a supplier cancels an entire PO or individual PO lines, the cancellation information is available to review in OTIF. Canceling a PO or PO line can be helpful as opposed to just not fulfilling an order with Walmart so that you can differentiate canceled POs on Not In Full issues from POs where you did not expect to be short.
Collect Early Delivery - Walmart Accountability
Cases on an order are designated “Collect Early Delivery” if the cases were delivered by Walmart or their third party carrier to the DC prior to the MABD window. This is based on the Arrival Compliance Date.
This means that Walmart picked up the product and delivered the cases to the DC before the MABD window. Perhaps the weather was good for driving, or Walmart’s truck was able to circumvent traffic. Either way, the accountability is Walmart’s and not the supplier’s.
Collect Late Delivery - Walmart Accountability
Cases on an order are designated “Collect Late Delivery” if the cases were delivered by Walmart or their third party carrier to the DC after the MABD. This is based on the Arrival Compliance Date.
This means that Walmart picked up the product and delivered the cases to the DC after the MABD window. This scenario would not go into the “supplier bucket” for accountability, as it is outside of the supplier’s control.
Collect Unscheduled Appointment - Walmart Accountability
Cases on an order are considered “Collect Unscheduled Appointment” when cases arrive on a Walmart truck or their arranged third party carrier at the DC without an appointment. Because the shipment did not have a delivery appointment, the Pro date will be considered the Arrival Compliance Date.
System-generated orders versus manual orders
System-generated orders are measured against the original MABD (MABD assigned when the PO was originally created) and the original order quantity. Canceled system orders do count against OTIF scores.
Manual orders are measured against the adjusted MABD (MABD assigned at the time of receipt at the DC) and adjusted order quantity. Canceled manual orders do not count against OTIF scores.
Manual PO < 45 Days - Walmart Accountability
For the metric “Manual PO < 45 Days”, a manual PO was created with an MABD less than 45 days from the order date, and the PO was late or unfilled. POs of this nature typically don’t give you the amount of time it takes to fulfill the order and get it shipped. Orders unfilled or late due to a manual PO of this type are considered to be in Walmart’s accountability bucket, and, again, do not count against your OTIF score.
Delayed System POs - Walmart Accountability
“Delayed System POs” occur when a system-generated order is delayed and the PO is late. The criteria to determine a delay is based on the EDI transmission to the suppliers.
Cancelled System POs - Walmart Accountability
“Cancelled System POs” occur when a system-generated PO is cancelled with a PO status “C” and has no receivings. Some cancelled POs will count against your OTIF score, depending on the reason code given. For example, “Supplier doesn’t have Product” would count, but “Weather/Natural Disaster” might not. Work with your buyer or RM on making sure you cancel your PO for the right reasons.