BUSINESS WORKFLOWS & DATA FLOWS

Complete process maps with volumes, dollar flows, status codes, and table connections

Interactive Diagrams (Archify — dark/light toggle, PNG/SVG export)

System Architecture Dataflow

Full platform: NetSuite → Chartstone → Sync → D1 → Worker → Pages. 17 nodes, 16 flows, 3 insight cards.

Order-to-Cash Workflow

4-lane swimlane: Sales → Operations → Finance → D1. 9 nodes with volumes and dollar amounts.

Order-to-Cash (Sales Cycle) — $177.4M Lifetime

Order-to-Cash Sales Cycle Flow from Sales Order through fulfillment, invoicing, and payment with D1 table mappings Customer Warehouse Finance D1 Tables Sales Order 12,862 · $177.4M 5 status codes 96.2% Item Fulfillment 12,375 shipments Pick → Pack → Ship Customer Invoice 12,542 · $169.8M 216 open ($2.3M AR) 98.3% Customer Payment 8,195 · $163.2M 99.97% deposited Credit Memo 932 · $2.7M Refund 2 · $43K transactions type='SalesOrd' so_lines 29,098 lines transactions type='ItemShip' transactions type='CustInvc' invoice_lines 28,528 lines transactions type='CustPymt' API Endpoints /api/customers/ranking /api/transactions /api/ar/aging /api/financials/summary /api/kpis

Sales Order Statuses

CodeStatusCount%
BPending Fulfillment830.6%
DPartially Fulfilled2<0.1%
FPending Billing5<0.1%
GBilled11,24987.5%
HClosed1,52311.8%

Invoice Statuses

CodeStatusCount%Value
AOpen2161.7%$2.3M
BPaid In Full12,32698.3%$167.5M

Payment Statuses

CodeStatusCount%
BNot Deposited20.03%
CDeposited8,19399.97%

Procure-to-Pay (Purchasing Cycle) — $145.0M Lifetime

Procure-to-Pay Purchasing Cycle Flow from Purchase Order through receipt, billing, and payment with D1 table mappings Purchasing Warehouse AP / Finance D1 Tables Purchase Order 11,566 · $131.0M 6 status codes Receive Item Receipt 3,491 · $51.7M No entity on header Bill Vendor Bill 22,916 · $145.0M 1.98 per PO avg · 80 open 99.6% Vendor Payment 9,603 · $144.0M + 5,493 Checks ($29.1M) VendCred: 116 · $254K transactions type='PurchOrd' transactions type='ItemRcpt' transactions type='VendBill' vb_lines 21,317 (100% of item bills) transactions type='VendPymt'

PO Statuses

CodeStatusCount%
BPending Receipt780.7%
DPartially Received180.2%
EPending Bill (Partial)1<0.1%
FPending Billing150.1%
GFully Billed10,27388.8%
HClosed1,18110.2%

Key Metrics

1.98
Bills per PO (avg)
99.6%
Bills Paid Rate
100%
VB Item Line Coverage

Top 5 Vendors 2026

Echo Lake
$2.16M
Harvest
$788K
Gen Mills
$488K
Bongards
$425K
Damascus
$398K

System Architecture — Data Flow

Source (NetSuite) ETL Pipeline Storage (Cloudflare) Delivery Layer NetSuite ERP Account 4656898 102K transactions SuiteAPI #2948 RESTlet gateway SuiteQL + REST MCP Server Claude ↔ NetSuite 4 tools N/llm Module Cohere Command R 0 governance units Deployed Scripts #2947 #2948 #2949 SuiteAttach + 60+ tools Chartstone Pro localhost:PORT 500K row ceiling sync.sh launchd */15m delta SuiteQL wrangler d1 INSERT OR REPLACE SQL batch upserts Worker Cron */15 sync check 19:00 daily report D1 Database 185,487 rows 18 tables · 29.6 MB KV Cache CACHE binding READY (unused) R2 Storage gfs-files bucket READY (unused) CF Worker 20 REST endpoints Auth · CORS · CSP Domain ai-globalfoodsolutions.co SSL pending System Guide pages.dev Infra Dashboard live health checks Exec Dashboard KPIs + charts Power Tools 60+ NS tools 14 More Pages hub · pricing · etc Workers AI Phase 4

Manufacturing · Inventory · Financial

Manufacturing

Work Order 547 · 2020-2025 Build 98 · $107K Unbuild 13 · $4.2K

Inventory Operations

InvAdjst 848 · $5.95M InvWksht 457 · $43.5M InvTrnfr 44 transfers D1: items 1,265 items 114 inactive

Financial

Check 5,493 · $29.1M Deposit 220 · $9.25M Journal 47 entries D1: gl_accounts 152 accounts 102 P&L

2026 Monthly Volume

Invoices vs Sales Orders

Jan
139 inv / $2.62M
Feb
141 inv / $2.45M
Mar
155 inv / $2.55M
Apr
150 inv / $2.36M
May*
127 inv / $1.30M
YTD: $11,272,176 · Annualized: ~$29.4M · *May partial

Vendor Bills vs POs

Jan
271 VB / $1.96M
Feb
327 VB / $1.91M
Mar
314 VB / $2.04M
Apr
297 VB / $2.08M
May*
121 VB / $752K
YTD: $8,745,956 · 1,330 bills from 453 POs