Process flows
Process flow charts
Reading these
Each flow has an inline SVG diagram (renders in any browser, no external dependencies) plus the Mermaid source if you want to render it elsewhere. Two flows have richer Archify diagrams linked inline.
Order-to-Cash (O2C)
Standard order lifecycle. Lead → quote → SO → production (WO + Assembly Build) → fulfillment → invoicing → payment. Credit memos branch from invoice.
Open interactive Archify diagram →
Mermaid source
Records / D1 tables: transactions, so_lines, invoice_lines, customers, items
Procure-to-Pay (P2P)
Procurement lifecycle. PR → PO → IR (3-way match input) → VB → VP / Check. 22,911 vendor bills in D1.
Mermaid source
Records / D1 tables: transactions, vb_lines, vendors, items
Inventory & Work Orders
Production and warehouse. WO drives Assembly Build, which consumes raw items via IR and outputs finished goods.
Mermaid source
Records / D1 tables: transactions, items, ref_location
Pricing Management
Customer-specific pricing flow. 1,264 customer_pricing rows in D1. Stale prices flagged via the 'Outdated Customer Pricing' saved search.
Mermaid source
Records / D1 tables: customer_pricing, customers, items
Collections & Dunning
Dual dunning: Customer-level + Invoice-level + Invoice Group-level. 18 workflows + 8 dunning email templates.
Mermaid source
Records / D1 tables: transactions (CustInvc), customers, dunningprocedure
Financial Close
Period close. All 154 periods (FY2018-FY2026) currently OPEN per audit — undermines comparative reporting. Tier 1 GAP.
Mermaid source
Records / D1 tables: transactions, gl_accounts, AccountingPeriod
NetSuite → D1 sync
Current sync path. Single-laptop dependency — #1 SPOF in the blueprint. Remediation: Worker scheduled() handler calling SuiteAPI directly.
Mermaid source
Records / D1 tables: transactions, ref_*, sync_log
System architecture
Full architecture across NS, local sync layer, and Cloudflare. Interactive Archify version has dark/light toggle and PNG/SVG export.
Open interactive Archify diagram →
Mermaid source
Records / D1 tables: all