← Home SAT-001Your item End-to-End Lifecycle · Aerospace Demo
Step 0 / 16
Aerospace Demo · Salesforce → NetSuite → Arena → MES → Vendor EDI → QMS → Bank

Sales captures the order. Engineering builds the satellite. Finance closes the books.

A 16-step walkthrough of the complete lifecycle for one $47.8M flagship deal at Aerospace Demo (sample item SAT-001). Every record below is read from the live AWS Lambda · Postgres backend at render time — click any drill-in pill to open the source record.
1 · SF Sale 2 · NS Ingest 3 · Engineering 4 · MRP + EDI 5 · MES Build 6 · QMS 7 · Cash + Close
1
☁ Salesforce
Phase 1 · Sales motion
Apex Account captured · Opportunity created
live

BD captures the lead. Account created in Salesforce with DUNS, CAGE, Restricted clearance, Priority rating. Opportunity opened referencing the GSA RFI · stage: Proposal in.

Live SF data · aerospace-demo.customers · aerospace-demo.opportunities
2
☁ Salesforce 🟦 NetSuite
Phase 1 · Sales motion
Opp Closed-Won · Celigo triggers SF → NS sync

Stage transition Negotiation → Closed-Won fires the Celigo IO connector. Real-time sync writes 3 records into NetSuite within 47 seconds: Customer entity (idempotent on SF Account ID), Sales Order with 7 CLINs, Project record.

Sync run log · aerospace-demo.sync_runs · 24 SF↔NS sync points
3
🟦 NetSuite
Phase 2 · NetSuite ingest
SO created · 7 CLINs · Standard priority · Restricted handling
live

NS Sales Order SO-2026-0501 auto-created from the SF Opp. Each line item is a CLIN with milestone-based revenue recognition (ASC 606 performance obligation). Contract record links Priority rating + Restricted category for flow-down to vendors.

CLINs (live) · aerospace-demo.clins
4
🟦 NetSuite
Phase 2 · NetSuite ingest
Project + Revenue Arrangement (ASC 606) opened
live

NS Project PROJ-ANDROMEDA-SAT-001 created (the EVMS unit of work). NS Advanced Revenue Management opens a revenue arrangement; performance obligations + standalone selling prices set per CLIN, deferred revenue scheduled to release on milestone acceptance.

Project record (live) · aerospace-demo.projects
5
🟦 NetSuite
Phase 2 · NetSuite ingest
Backlog booked · journal entry posted

Order acceptance posts a journal entry recording the new contract value as funded backlog and deferred revenue. This shows up in the FP&A backlog burn-down on the CEO dashboard immediately.

Journal Entry · JE-2025-1148 · automatic on SO acceptance
AcctDescriptionDebitCredit
1100Contracts receivable · DEMO-CON-001$47,800,000
2300Deferred revenue · ASC 606 obligation$47,800,000
$47,800,000$47,800,000
6
🛠 Arena PLM/QMS 🟦 NetSuite
Phase 3 · Engineering
BOM released · ECOs cleared · Item Master synced
live

Engineering releases the design via Arena PLM. The 93-line SAT-001 BOM (CFRP structure, ADCS reaction wheels, COMM X-band amp, EPS bus, payload mirrors) syncs to NS Item Master via the Native Arena NS Connector. ECOs from prior NCRs (CAPA-2026-008 ferrite bead, CAPA-2026-005 star-tracker mount) are folded in before release.

CAPAs in flight · aerospace-demo.capas
Top-level BOM (live · 93 lines available)
7
🟦 NetSuite
Phase 4 · MRP + Procurement
MRP run · 38 long-lead items identified · POs released
live

NS MRP run executes against the released BOM. 38 long-lead items roll up into 14 Purchase Orders. Each PO carries Standard priority priority, Restricted handling flow-down, and CMMC L2 vendor requirement.

POs released (live) · aerospace-demo.pos
8
🟦 NetSuite 📨 Vendor EDI
Phase 4 · MRP + Procurement
EDI 850 → Blue Canyon · 855 ack · 856 ASN

Cleo AS2 transmits EDI 850 Purchase Order to Blue Canyon Technologies for 4× ADCS-RW-MEDIUM-A reaction wheels ($729,600). The vendor portal acknowledges with EDI 855 within 24 hrs and commits delivery date. 26 weeks later they ship — EDI 856 ASN arrives 72 hrs ahead of physical delivery.

ISA*00* *00* *ZZ*AEROSPACE *ZZ*BLUECANYON *260119*1142*U*00401*000001148*0*P*>~
GS*PO*AEROSPACE*BLUECANYON*20260119*1142*1148*X*004010~
ST*850*PO-2026-1148~
BEG*00*SA*PO-2026-1148**20260119~
REF*DP*Standard~ // Standard priority priority
REF*Restricted*CAT-XV~ // Restricted Category XV flow-down
PO1*1*4*EA*182400.00**BP*ADCS-RW-MEDIUM-A~
CTT*1~ SE*8*1148~ GE*1*1148~ IEA*1*000001148~
9
📨 Vendor EDI 🟦 NetSuite
Phase 4 · MRP + Procurement
Receipt · 3-way match · EDI 810 invoice · AP posting

Physical receipt at Centennial CO dock 2026-04-22. Item Receipt created. Vendor sends EDI 810 Invoice for $729,600. NS auto-runs 3-way match (PO ↔ Receipt ↔ Invoice): PASS · $0 variance. AP bill posts; payment scheduled Net 30.

3-way match journal · JE-2026-0422-AP
AcctDescriptionDebitCredit
1500Inventory · ADCS-RW-MEDIUM-A · 4 units$729,600.00
2000Accounts payable · BCT (Net 30, due 2026-05-22)$729,600.00
$729,600.00$729,600.00
10
🟦 NetSuite 🏭 MES
Phase 5 · Manufacturing build
WO released to MES · 8-stage build flow begins
live

NS Work Order WO-2027-001 released. Routes to MES. The 8-stage build flow tracks the satellite from receiving through Compliance Reviewer acceptance — each stage gates the next via QMS sign-off.

8-stage build flow (live) · aerospace-demo.mes_stages
11
🏭 MES
Phase 5 · Manufacturing build
Stages 1–3 complete · Receiving → Sub-assy → Subsystem integration

The first three stages run from 2025-09-08 through 2026-04-22. Receiving inspects 147 line-items, Sub-assembly builds boards + harnesses to IPC-A-610 Class 3, Subsystem integration mates power/data/RF subsystems.

  • Stage 1 · Receiving — 147 line-items received · 23 Restricted handling lines segregated · 9 first-articles verified
  • Stage 2 · Sub-assembly — 4 EPS PCBs built · OBC main+backup with X-ray verified BGA · power+LVDS harness 100% pull-tested
  • Stage 3 · Subsystem integration — EPS subsystem FAT pass · CDH boot+telemetry verified · ADCS pointing accuracy 0.01° (req 0.05°) · COMM RF return loss after retune
12
🏭 MES
Phase 5 · Manufacturing build
Stage 4 currently active · Bus integration
live

Mate subsystems to the structure. CFRP panels, bracket integration, harness routing through the bus. This is the stage you're viewing right now in the MES shop floor.

Stage 4 details (live) · aerospace-demo.mes_stages/4
13
🏭 MES
Phase 5 · Manufacturing build
Stages 5–8 queued · Functional · Environmental · Final assy · Acceptance

The remaining four stages take the satellite from integrated bus through customer/Compliance Reviewer acceptance:

  • Stage 5 · Functional test — full system functional sequence · all subsystems exercised against ICD
  • Stage 6 · Environmental test — TVAC chamber, vibration table, EMI/EMC compliance per MIL-STD-461
  • Stage 7 · Final assembly — solar arrays integrated, deployment mechanisms armed, propellant loaded
  • Stage 8 · Acceptance / Compliance Reviewer buy-off — DD250 signed by Compliance Reviewer QAR · CDRL package delivered · title transfers to Apex
14
🛠 Arena QMS
Phase 6 · Quality (parallel to all stages)
NCRs / CAPAs / Audits in flight · all closed clean
live

Quality runs alongside every stage. NCRs raised at the point of detection are dispositioned within 24 hrs (Use-as-is, Rework, or Scrap). Systemic issues open 8D CAPAs. AS9100 + ISO 9001 audit findings tracked to closure within 30 days.

NCRs (live · last 5) · aerospace-demo.ncrs
Active CAPAs (live) · aerospace-demo.capas
15
🟦 NetSuite
Phase 7 · Revenue + Cash
Milestone billing · revenue recognized · invoice issued
live

On stage acceptance, the linked CLIN milestone is billed. NS Advanced Revenue Management releases deferred revenue to recognized revenue (ASC 606), and an invoice is auto-issued to Apex (Net 30, payment via NACHA).

Milestone JE · CLIN-006 acceptance · revenue recognition
AcctDescriptionDebitCredit
2300Deferred revenue · CLIN-006 portion$8,200,000
4000Revenue · contract · CLIN-006 milestone$8,200,000
5100COGS · directs + applied OH on CLIN-006$5,395,600
1500Inventory · WIP relief on milestone$5,395,600
1200A/R · Apex · invoice INV-2026-0612$8,200,000
1100Contract receivable draw-down$8,200,000
$21,795,600$21,795,600
16
🏦 Bank/SIEM 🟦 NetSuite
Phase 7 · Revenue + Cash
NACHA payment received · cash applied · period close · Compliance Reviewer acceptance

Apex Treasury sends NACHA payment 28 days later (well within Net 30, DSO=24d). Bank file ingested via SFTP, auto-applied to invoice INV-2026-0612, A/R cleared. Period close runs the 16-step checklist (Cost-Auditor-compliant, indirect rate true-up, ARM unbilled receivable, balance sheet validation A=L+E). Compliance Reviewer QAR signs DD250 on final acceptance.

Cash receipt JE · NACHA file 2026-07-12
AcctDescriptionDebitCredit
1000Cash · operating · JPM$8,200,000
1200A/R · Apex · INV-2026-0612 cleared$8,200,000
✓ Lifecycle complete. One $47.8M satellite has flowed end-to-end through Salesforce → NetSuite → Arena → Vendor EDI → MES (8 stages) → QMS → Revenue Recognition → Cash · zero data re-entry · every record traceable in Postgres · audit-ready for Cost Auditor, Compliance Reviewer, AS9100, CMMC L2, Restricted.
📭
No workflow examples yet
Connect your data source to populate this page with your records.
Run the import wizard ▸