Catch expiring lots before they are written off
Every Monday, WebRun opens Accolent ERP, scans every lot for its expiration date, flags anything expiring within 90 days, logs each one to a Google Sheet with quantity and warehouse location, and posts your warehouse team a ranked Slack alert so slow moving stock gets sold, transferred, or rotated before it expires.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I catch expiring medical and dental inventory before it is written off?
WebRun scans Accolent ERP every Monday for every lot approaching its expiration date, flags anything expiring within 90 days, and logs it to a Google Sheet with quantity and warehouse location. It then posts your warehouse team a ranked Slack alert, so slow moving stock gets sold, transferred, or rotated before it is written off.
- Expiring lots are caught every Monday, weeks before they become a writeoff
- Warehouse teams open Slack to a list ranked by days remaining, soonest first
- Sold through lots drop off the list automatically from live Accolent ERP data
Built for medical supply distributors · dental supply distributors · warehouse inventory managers · distribution purchasing teams
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
adssolutions.comin a real browser with your saved login - no setup, no API keys. -
1
Accolent ERP - scan lot and expiration data
adssolutions.com How to Automate Accolent ERP
WebRun opens Accolent ERP to scan lot and expiration data. - Open Accolent ERP and go to the inventory module's lot tracking view
- Filter every lot by expiration date within the next 90 days
- Capture the item, lot number, quantity on hand, expiration date, and warehouse location for each
Done when Every lot expiring within 90 days is listed with its quantity and location.
-
2
Google Sheets - log lots expiring soon
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log lots expiring soon. - Open the Expiring Lot Tracker sheet
- Append a row for each newly flagged lot with today's check date
- Mark any lot already logged as still open or as cleared if it has since sold through, then sort all open rows by days remaining until expiration, soonest first
Done when The tracker sheet reflects every expiring lot sorted by urgency.
-
3
Slack - alert the warehouse team
slack.com How to Automate Slack
WebRun opens Slack to alert the warehouse team. - Post a summary to the warehouse and purchasing channel with counts of lots expiring within 30, 60, and 90 days
- List the soonest expiring items first with item, lot number, quantity, and location
- Link to the full Google Sheet tracker for the complete list
Done when The team has today's expiring lot list in Slack with a link to the full tracker.
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 WebRun discard or write off expiring inventory on its own?
No. WebRun only flags expiring lots in a tracker and a Slack alert. Deciding whether to discount, transfer, or write off any lot is left entirely to your team.
How far ahead does it flag expiring lots?
It flags anything expiring within 90 days by default, with separate urgency tiers at 30 and 60 days shown in the Slack summary. That window can be adjusted.
What if a lot sells out before it expires?
It reads live Accolent ERP quantities every Monday, so any lot that has sold through or already been cleared drops off the list automatically.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.