Monitor when supplier lead times change
Every night, WebRun compares the actual receipt date of each PO to the original promised lead time in NetSuite, calculates rolling average lead times per supplier, updates your tracker, and alerts you to any supplier whose lead time has crept up significantly.
- No credit card
- Under $0.01 per run
- Cancel anytime
How can I automatically monitor when supplier lead times are getting longer?
Every night, WebRun compares the actual receipt date of each purchase order to the original promised lead time in NetSuite, calculates rolling average lead times per supplier, updates your Google Sheets tracker, and alerts you in Slack to any supplier whose lead time has crept up - so you can adjust reorder points before a stockout hits.
- Lead time drift caught before it causes a stockout
- Rolling average lead times updated nightly per supplier
- Reorder points adjustable based on real delivery data, not guesses
Built for supply chain managers · inventory planners · procurement teams · operations directors
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
system.netsuite.comin a real browser with your saved login - no setup, no API keys. -
1
NetSuite - compare promised vs actual delivery dates
netsuite.com How to Automate NetSuite
WebRun opens NetSuite to compare promised vs actual delivery dates. - Open Purchase Orders and filter for orders received today or updated to Received status
- For each PO capture the supplier, the original promised delivery date, and the actual receipt date
- Calculate the lead-time variance: actual days from PO date to receipt vs. the vendor lead time on the item record
Done when Today's received POs all have an actual vs. promised lead-time comparison.
-
2
Google Sheets - update rolling lead-time tracker
google.com How to Automate Google Sheets
WebRun opens Google Sheets to update rolling lead-time tracker. - Open the Lead-Time Tracker and add today's PO data for each supplier
- Recalculate the 30-day rolling average lead time per supplier
- Flag any supplier whose rolling average has increased by more than 20% compared to their vendor item record
Done when Rolling lead times are updated and suppliers with significant drift are flagged.
-
3
Slack - alert you to significant lead-time drift
slack.com How to Automate Slack
WebRun opens Slack to alert you to significant lead-time drift. - Post an alert listing suppliers with lead-time drift above the threshold: current rolling average vs. expected
- Recommend reviewing the reorder point for affected SKUs to avoid a stockout
Done when You have been alerted to suppliers whose delivery performance has changed and which SKUs are at risk.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it update reorder points in NetSuite automatically?
No - it flags the drift and recommends a review, but changing reorder points in NetSuite is always a human decision.
What if a supplier had one unusually late delivery - will it overreact?
It uses a 30-day rolling average, so a single late shipment shifts the trend gradually rather than triggering an immediate alert.
Can I set different drift thresholds for different suppliers?
Yes - add a threshold column per supplier in the Google Sheets tracker and WebRun will use each supplier's individual limit.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.