Protecta
Operations Dashboard
National Operations Excellence  |  v3.3 — Live NetSuite Data
27 Apr – 03 May 2026
📅 Data snapshot: 03 May 2026  |  Static file — not live
Site
Period
ALL SITES
⚠  Custom date range selected. This is a static snapshot — data cannot be re-queried from NetSuite here. The dashboard is displaying MTD figures as the closest proxy (01 Apr–03 May 2026). For precise custom-period figures, use the live NetSuite Suitelet (Option 3) or request a manual refresh.
⚠  Static snapshot — data as at 03 May 2026.   This file does not update automatically. To refresh, send the prompt below to Claude and replace this file on SharePoint.  |  Next scheduled refresh: Sunday 10 May 2026
Item Fulfilments
MTD: —
Protecta Deliveries
MTD: —
External Deliveries
MTD: —
Return Auths
MTD: —
Stock Receipts
MTD: —
1Item Fulfilments By BranchLive
BranchPeriodMTD
2Deliveries — Protecta vs ExternalLive
Branch Own Own % Ext Ext % Total
3Pick Up Sales OrdersLive
BranchSO TotalPick UpsPU %
6Stock Receipts — Inbound / ReceivingLive
By branch
BranchPeriodMTD
By PO delivery type
TypePeriodMTD
Source: custbody_pg_purchase_order_deliv_type on linked PO.
Null = ad hoc / credit card POs.
9 Transfer Orders Live
Source: NetSuite TrnfrOrd 20–26 Apr 2026  |  To location = receiving branch  |  Lines = distinct SKUs  |  Freight cost = custbody41  |  Carrier/connote from Memo field  |  Received TOs only  |  Click ▼ detail to expand per-TO breakdown
7Regional DIFOT — Required Date vs Delivery DateLive
Source: NetSuite SalesOrd · Required Date (custbody17) · Req dates 01 Apr–03 May 2026 (MTD)  |  Freight Method IN (4=Regional Express, 4139=Regional Standard)  |  DIFOT = custbody_transport_status = 8 · Late = status 6  |  Pending = open / in transit (excl. from % calc)  |  Target ≥95%
8Protecta Fleet — Driver Delivery SummaryDetrack
Source: Detrack 27 Apr–03 May 2026 (week) | MTD 01 Apr – 03 May 2026  |  Heading To % includes same-address/same-day correction (2 jobs corrected)  |  Protecta own-driver jobs only (shipmethod 5359/5360)  |  Beverley SA = 3PL, no own drivers  |  Completed = Delivered + Collected
4Return Authorisations — OPS vs SalesLive
OPS
Sales
Total
Branch OPS Sales Total OPS % of SOs Sales % of SOs
5RA Reason BreakdownLive
ReasonPeriodMTD
📄 Refresh prompt — paste into Claude:
Run the Protecta Operations Dashboard refresh for week 04 May – 10 May 2026, MTD 01 May – 10 May 2026. Query all sections S1–S9 from NetSuite, pull daily fulfilment data for the chart, apply the Detrack same-address/same-day heading-to correction, rebuild the HTML dashboard with updated data and snapshot date, and provide the new HTML file for SharePoint.