Automated Verity 340B Replenishment Variance
Every Monday, WebRun opens Verity Solutions, compares the week's accumulated 340B purchase optimization data against actual replenishment orders and receipts, logs the variance by NDC and location in Airtable, and drafts a replenishment adjustment in Outlook for your purchasing manager to review before any order goes out.
How do I catch 340B inventory replenishment variance before it causes a stockout?
WebRun checks your 340B replenishment variance every Monday. It compares accumulated purchase optimization data in Verity Solutions against actual replenishment orders and receipts, logs the gap by NDC and location in Airtable, and drafts an order adjustment in Outlook for your purchasing manager, so over-replenishment and stockout risk both get caught weekly instead of at month end.
- Replenishment variance is caught weekly instead of at month end
- Both over-replenishment and stockout risk get flagged, not just one direction
- Every order adjustment is reviewed by a purchasing manager before anything is placed
Built for 340B program managers · pharmacy purchasing managers · covered entity inventory teams · hospital outpatient pharmacy
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
app.verity-solutions.comin a real browser with your saved login - no setup, no API keys. -
1
Verity Solutions - compare purchases to replenishment
verity-solutions.com
WebRun opens Verity Solutions to compare purchases to replenishment. - Open Verity Solutions and pull the week's accumulated 340B purchase optimization data
- Compare it against actual replenishment orders and receipts by NDC and location
- Flag any NDC running ahead of or behind its expected replenishment
Done when Every NDC and location has been compared against its expected replenishment for the week.
-
2
Airtable - log the variance
airtable.com
WebRun opens Airtable to log the variance. - Log each variance with the NDC, location, and whether it is over or under replenished
- Carry forward any variance still open from prior weeks
- Mark a variance resolved once the following week's receipt closes the gap
Done when The variance log reflects every open and resolved item for the week.
-
3
Outlook - draft the adjustment
microsoft.com
WebRun opens Outlook to draft the adjustment. - Draft a replenishment adjustment for the largest variances, over-ordered or at risk of a stockout
- Include the NDC, location, and suggested adjustment quantity
- Leave the draft for your purchasing manager. Never place a replenishment order automatically
Done when Your purchasing manager has a drafted adjustment ready to review for every significant variance.
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 place a replenishment order on its own?
No. It only drafts the suggested adjustment in Outlook. Your purchasing manager reviews and places any actual order.
What counts as a variance worth flagging?
Any NDC where accumulated 340B purchases and actual replenishment orders diverge past the threshold you set, whether it is running ahead, which risks a compliance issue, or behind, which risks a stockout.
Does it only look at this week's activity?
It checks the current week and carries forward anything still open from prior weeks, so a slow-building variance does not get lost between reports.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.