All templates

Automated FieldServio Parts Backorder Alerts

Every morning, WebRun opens FieldServio, finds open work orders that are waiting on a part, checks each part's purchase order status in QuickBooks, and logs a worklist to Google Sheets flagging which jobs are blocked and for how long, so your scheduler can reschedule or chase the vendor before the job stalls.

Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 FieldServio find work orders waiting on parts
2 QuickBooks check each part's purchase order status
3 Google Sheets log the backorder worklist
In short

How do I know which generator service jobs are at risk from a backordered part before the technician shows up?

WebRun checks FieldServio every morning for work orders stuck waiting on parts, confirms each part's purchase order status in QuickBooks, and logs a worklist to Google Sheets flagging any job whose expected part date falls after its scheduled service date. Your scheduler sees at-risk jobs a day or two early instead of finding out when the technician shows up without the part.

  • At-risk jobs get flagged a day or two before the scheduled visit, not at the truck
  • Schedulers work from one shared worklist instead of checking two systems by hand
  • Vendor delays are caught early enough to rebook without a wasted trip

Built for standby generator dealers · service coordinators · parts and inventory managers · generator service technicians

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 app.fieldservio.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    FieldServio - find work orders waiting on parts
    fieldservio.com
    WebRun in FieldServio: find work orders waiting on parts
    WebRun opens FieldServio to find work orders waiting on parts.
    • Open FieldServio and filter work orders to status Waiting on Parts
    • Capture the job, customer, technician assigned, and the part or parts needed
    • Note the scheduled or requested service date for each job

    Done when Every work order waiting on a part is listed with its scheduled date.

  3. 2
    QuickBooks - check each part's purchase order status
    • Look up the purchase order tied to each needed part
    • Check whether the vendor bill shows the part as shipped, backordered, or still pending
    • Capture the vendor's expected ship or delivery date where available

    Done when Each waiting part has a purchase order status and an expected date, if the vendor provided one.

  4. 3
    Google Sheets - log the backorder worklist
    google.com
    WebRun in Google Sheets: log the backorder worklist
    WebRun opens Google Sheets to log the backorder worklist.
    • Append each blocked job to the backorder worklist with part, PO status, expected date, and scheduled service date
    • Flag any job whose expected part date falls after its scheduled service date in red

    Done when The backorder worklist reflects every blocked job and whether it is at risk of missing its scheduled date.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.fieldservio.com
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Backorder tracker · Google Sheets
OutputWhat each run produces - A Google Sheet worklist of every work order waiting on parts, with purchase order status and a flag for jobs at risk of missing their scheduled date.
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

Does it contact the customer about the delay?

No. WebRun only builds the internal backorder worklist in Google Sheets. Your scheduler decides whether and how to reach out to the customer once they see a job is at risk.

Where does the part status come from?

It reads the purchase order and vendor bill tied to each part directly in QuickBooks, so the status reflects what your vendor has actually confirmed, not a guess.

How do I know which jobs are actually at risk, not just waiting?

The sheet flags any job whose expected part date falls after its scheduled service date, so your scheduler can focus on the ones that need a reschedule call first.

Put this on autopilot.

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