Catch GPO price changes before they hit an invoice
Every Monday, WebRun opens Outlook to check the purchasing inbox for new GPO contract price files, opens Accolent ERP to compare each item against the price currently loaded, and builds a draft price update batch in Google Sheets flagging every changed item with its old price, new price, and effective date for your pricing team to review before import.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I catch GPO contract price changes before they reach an invoice?
WebRun checks Outlook every Monday for new GPO contract price files, then compares each line against the price loaded in Accolent ERP. It builds a draft update batch in Google Sheets flagging every changed item with its old price, new price, and effective date, so pricing catches each GPO change before a customer is billed wrong.
- Every GPO price change is caught the same week the file arrives, not weeks late
- Pricing team reviews a single draft batch instead of hunting through email attachments
- No price reaches Accolent ERP without a human checking it against the contract
Built for medical supply distributors · dental supply distributors · distributor pricing analysts · GPO contract administrators
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
outlook.office.com/mailin a real browser with your saved login - no setup, no API keys. -
1
Outlook - read the latest GPO price file
microsoft.com How to Automate Outlook
WebRun opens Outlook to read the latest GPO price file. - Open Outlook and check the purchasing inbox for GPO contract price files received this week
- Open the newest file for each active GPO contract
- Note the contract number and effective date printed on the file
Done when The newest GPO price file for each active contract is open and logged.
-
2
Accolent ERP - compare against current pricing
adssolutions.com How to Automate Accolent ERP
WebRun opens Accolent ERP to compare against current pricing. - Open Accolent ERP and look up the current contract price for every item on the new file
- Compare each line and flag every item where the new price differs from what is loaded
- Note items on the file that are not yet set up as a purchased item
Done when Every price difference between the new file and Accolent ERP is identified.
-
3
Google Sheets - draft the price update for review
google.com How to Automate Google Sheets
WebRun opens Google Sheets to draft the price update for review. - Open the GPO Price Update sheet
- List each changed item with its old price, new price, effective date, and contract number
- Leave the sheet as a draft update batch for the pricing team to review. Do not update pricing in Accolent ERP directly
Done when A draft price update batch is ready in the sheet for the pricing team to review before import.
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 update prices in Accolent ERP automatically?
No. WebRun only drafts a price update batch in Google Sheets. Importing any new price into Accolent ERP is left for your pricing team to review and apply.
How does it know which GPO contract a price file belongs to?
It reads the contract number and effective date printed on the file itself, then matches those against the contract already set up in Accolent ERP.
What if a GPO file lists an item you do not carry?
It flags the item as not yet set up in Accolent ERP rather than guessing at a match, so your pricing team can decide whether to add it.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.