Automation
NetSuite ↔ JobBoss reconciliation
Nightly at 02:00 America/New_York. Exceptions are written to recon_exceptions by the pipeline and cleared here.
17 exceptions are waiting for review.
That is above the alert threshold of 10, so the Telegram notifier fired at 02:00. The oldest unresolved exception is 13 days old.
Exception queue
Approving posts the correction to NetSuite through the same governed write path the pipeline uses, audited under your identity.
| Job | Mismatch | JobBoss | NetSuite | Value | Age | Status | Action |
|---|---|---|---|---|---|---|---|
JOB-40912 |
Quantity | 240 ea | 200 ea | $18,400 | 6 days | Held | |
JOB-41077 |
Missing in NetSuite | Closed 2026-08-04 | No order line | $11,950 | 13 days | Held | |
JOB-40688 |
Price | $84.00 | $79.50 | $4,050 | 2 days | Held | |
JOB-41120 |
Quantity | 96 ea | 94 ea | $620 | 1 day | Auto-corrected | No action |
JOB-41134 |
Quantity | 48 ea | 48 ea | — | 1 day | Resolved | No action |
Run history
Every run of jobboss-netsuite-reconcile.
| Started | Duration | Scanned | Exceptions | Auto | Status |
|---|---|---|---|---|---|
| 02:00:04 | 4.1s | 1,284 | 23 | 6 | Completed |
| 02:00:03 | 3.8s | 1,271 | 19 | 5 | Completed |
| 02:00:05 | 31.6s | 0 | — | — | Failed |
| 02:00:04 | 4.4s | 1,266 | 21 | 7 | Completed |
Run log
The failed run on 2026-08-17.
02:00:05 bridge jobboss connected (mssql, 41ms) 02:00:05 bridge netsuite connected (suiteql) 02:00:06 read jobboss.jobs window=7d rows=1,266 02:00:11 read netsuite.salesorder pushdown where custbody_jobno IN (...) 02:00:36 ERROR NetSuiteRateLimitError: governance limit exceeded (SSS_REQUEST_LIMIT_EXCEEDED) 02:00:36 retry 1/3 in 5s 02:00:41 ERROR NetSuiteRateLimitError: governance limit exceeded 02:00:46 retry 2/3 in 10s 02:00:56 ERROR NetSuiteRateLimitError: governance limit exceeded 02:00:56 run failed after 31.6s — 0 rows written, nothing partially applied 02:00:56 notifier recon-alerts: sent to Operations
Nothing on this page writes on its own.
The pipeline auto-corrects only quantity drift inside the 2% tolerance. Everything else waits here until a person with the reconciliation role approves it, and the approval is recorded against that person, not the pipeline.