Protecta
Operations Dashboard
National Operations Excellence  |  v3.4 — NetSuite + Detrack
06 Jul – 12 Jul 2026
📅 Data snapshot: 12 Jul 2026  |  Static file — not live
Site
Period
ALL SITES
⚠  Static snapshot — data as at 12 Jul 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 19 July 2026
Sales Context — Operations Output NetSuite
Item Fulfilments
MTD: —
Avg: —
Protecta Deliveries
MTD: —
External Deliveries
MTD: —
Return Auths
MTD: —
Stock Receipts
MTD: —
1Item Fulfilments By BranchNetSuite
BranchPeriodMTDAvg/dayMTD Avg/day
2Deliveries — Protecta vs ExternalNetSuite
Branch Own Own % Ext Ext % Total
3Pick Up Sales OrdersNetSuite
BranchSO TotalPick UpsPU %
6Stock Receipts — Inbound / ReceivingNetSuite
By branch
BranchPeriodMTD
By PO delivery type
TypePeriodMTD
Source: custbody_pg_purchase_order_deliv_type on linked Purchase Order.
9 Transfer Orders NetSuite
Source: NetSuite TrnfrOrd 06–12 Jul 2026 (week) | MTD 01–12 Jul 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 DateNetSuite
Source: NetSuite SalesOrd · Required Date (custbody17) · Req dates 06–12 Jul 2026 (week) | MTD 01–12 Jul 2026  |  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 06–12 Jul 2026 (week) | MTD 01–12 Jul 2026  |  Same-address/same-day heading-to correction applied.  |  Detrack counts by driver delivery date; may include jobs dispatched in the prior month — counts will differ slightly from S2 across month boundaries.  |  Protecta own-driver jobs only  |  Beverley SA = 3PL, no own drivers  |  Completed = Delivered + Collected
4Return Authorisations — OPS vs SalesNetSuite
OPS
Sales
Total
Branch OPS Sales Total
5RA Reason BreakdownNetSuite
ReasonPeriodMTD
▶  📄 Show refresh prompt
Run the Protecta Operations Dashboard refresh for week 06 Jul – 12 Jul 2026, MTD 01 Jul – 12 Jul 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.