All templates
For pharmaceutical wholesalers, drug distributors & DSCSA compliance officers

Chase down missing DSCSA transaction statements

Every morning, WebRun opens rfxcel, finds shipments missing a complete transaction history, information, or statement, drafts a follow-up request to the trading partner for your review in Outlook, and posts your compliance team a Slack list of what is still outstanding.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every day at 7:30 AM WebRun
1 rfxcel find shipments missing a transaction statement
2 Outlook draft the follow-up request
3 Slack flag unresolved gaps to compliance
Run a sample
In short

How do I catch missing DSCSA transaction statements before an audit?

WebRun checks rfxcel every morning for incoming shipments missing a complete DSCSA transaction history, transaction information, or transaction statement. It drafts a follow-up request to the responsible trading partner in Outlook for your review, then posts your compliance team a Slack list of what is still open, so gaps get resolved within days instead of surfacing at audit time.

  • Missing transaction statements get caught within one business day, not at audit time
  • Every trading partner follow-up is drafted and ready to send, never sent without review
  • Compliance gets a fresh Slack list of open gaps every morning

Built for pharmaceutical wholesalers · drug distributors · DSCSA compliance officers · trade relations teams

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens www.rfxcel.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    rfxcel - find shipments missing a transaction statement
    rfxcel.com How to Automate rfxcel
    WebRun in rfxcel: find shipments missing a transaction statement
    WebRun opens rfxcel to find shipments missing a transaction statement.
    • Open rfxcel and review the prior day's incoming shipments
    • Check each shipment for a complete Transaction History, Transaction Information, and Transaction Statement
    • List any shipment with a missing or incomplete statement, and the trading partner responsible

    Done when Every incoming shipment has been checked and any transaction statement gaps are listed with the responsible trading partner.

  3. 2
    Outlook - draft the follow-up request
    microsoft.com How to Automate Outlook
    WebRun in Outlook: draft the follow-up request
    WebRun opens Outlook to draft the follow-up request.
    • Draft a follow-up email to each trading partner naming the shipment and the missing statement
    • Attach the shipment reference so the partner can locate it quickly
    • Leave every draft unsent in your Outlook drafts folder for review

    Done when A draft follow-up request is ready for every gap, none sent without your review.

  4. 3
    Slack - flag unresolved gaps to compliance
    slack.com How to Automate Slack
    WebRun in Slack: flag unresolved gaps to compliance
    WebRun opens Slack to flag unresolved gaps to compliance.
    • Post the day's list of unresolved transaction statement gaps to the compliance channel
    • Flag any gap that has been open for more than 3 days
    • Note which drafts are waiting on your approval in Outlook

    Done when Compliance has today's list of open gaps and pending drafts in Slack.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.rfxcel.com
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Missing statement list · Slack
OutputWhat each run produces - A daily list of shipments with missing or incomplete DSCSA transaction statements, the responsible trading partner, and how long each gap has been open.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it email trading partners without me approving it first?

No. WebRun drafts every follow-up request and leaves it in Outlook for your review. Nothing goes out to a trading partner without you sending it yourself.

What counts as a missing transaction statement?

Any shipment where the Transaction History, Transaction Information, or Transaction Statement required under the DSCSA is absent or incomplete in rfxcel. WebRun checks all three for every shipment it reviews.

How far back does it check?

Each morning it reviews the prior day's incoming shipments, so a gap gets caught within one business day instead of surfacing during an audit weeks later.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.