GFS NETSUITE MASTER SYSTEM GUIDE

Global Food Solutions, Inc. · Account 4656898 · ai-globalfoodsolutions.co
CHECKING...

System Architecture

NetSuite 4656898
SuiteQL · REST · N/llm
SuiteAPI #2948
RESTlet
Chartstone
localhost API
Sync (15m)
launchd + Worker
D1 Database
185K rows · 18 tables
CF Worker
20 endpoints
Pages (16)
dashboards + tools
MCP
Claude ↔ NS
SuiteQL #2947
queries
Toolkit #2949
batch
SuiteAttach
files
KV
cache
R2
storage
Workers AI
Phase 4

Cloudflare Pages — All 16 Projects

System Guide

This page — master admin home, database wiki, API docs, workflows, infrastructure
LIVE

NetSuite Tools (60+)

Filterable tool catalog — Suitelets, Chrome extensions, APIs, GitHub repos
LIVE

GFS Hub

Central hub portal
LIVE

GFS Pricing

Pricing tools and CME data
LIVE

NYC DOE Hub

NYC Department of Education account hub
LIVE

Broker Roster

Broker contact roster and management
LIVE

Facility Licensing

131 Heartland facility licensing tracker
LIVE

Assembly Costing

BOM and assembly cost analysis
LIVE

Portal Plan

Platform portal planning
LIVE

Design v9

Latest design system iteration
LIVE

Evidence Dashboard

Evidence and documentation dashboard
LIVE

Echo Lake Review

Echo Lake Foods vendor review
LIVE

Echo Lake DMARC

DMARC email authentication analysis
LIVE

GFS Docs

Documentation portal
LIVE

Broker Roster (v1)

Original broker roster
LIVE

Michael Levine Profile

Professional profile page
LIVE

Cloudflare Worker API

API Base URLs

Custom Domainapi.ai-globalfoodsolutions.co (SSL pending)
Domainai-globalfoodsolutions.co

20 API Endpoints → Full Docs

/ PUB · /api/health PUB · /api/kpis AUTH · /api/briefing AUTH · /api/customers AUTH · /api/customers/:id AUTH · /api/customers/:id/history AUTH · /api/customers/ranking AUTH · /api/items AUTH · /api/items/:id AUTH · /api/items/performance AUTH · /api/items/:id/customers AUTH · /api/transactions AUTH · /api/vendors AUTH · /api/vendors/spend AUTH · /api/ar/aging AUTH · /api/financials/summary AUTH · /api/financials/monthly AUTH · /api/revenue/trend AUTH · /api/gl/accounts AUTH · /api/search AUTH

NetSuite Admin Pages — Account 4656898

Core Admin

Home DashboardOpen →
Setup → CompanyOpen →
Users/RolesOpen →
Enabled FeaturesOpen →
Accounting PeriodsOpen →
SubsidiariesOpen →

Scripting & Customization

Script DeploymentsOpen →
SuiteQL Tool #2947Open →
WorkflowsOpen →
Custom RecordsOpen →
Custom FieldsOpen →
File CabinetOpen →
SuiteAppsOpen →

Records & Transactions

CustomersOpen →
VendorsOpen →
ContactsOpen →
InvoicesOpen →
Sales OrdersOpen →
Purchase OrdersOpen →
Vendor BillsOpen →

Reports & Searches

Saved SearchesOpen →
Financial ReportsOpen →
AR AgingOpen →
Income StatementOpen →
Balance SheetOpen →
Global SearchOpen →

Integrations & API

Integration RecordsOpen →
OAuth TokensOpen →
RESTletsOpen →
SuiteletsOpen →
Scheduled ScriptsOpen →
Records CatalogOpen →

Performance & Monitoring

APM (Performance)Open →
Execution LogsOpen →
System StatusOpen →
Login Audit TrailOpen →
Mass UpdatesOpen →
CSV ImportOpen →

Cloudflare Admin

Dashboard

CF DashboardOpen →
Workers & PagesOpen →
D1 DatabasesOpen →
R2 StorageOpen →
KV NamespacesOpen →

Domain

Zone: ai-globalfoodsolutions.coOpen →
DNS RecordsOpen →
SSL/TLSOpen →
Email RoutingOpen →

Workers

gfs-platform WorkerOpen →
Worker LogsOpen →
Worker SettingsOpen →
Cron TriggersOpen →

System Guide Pages

Database Wiki

18 tables · ~120 columns · every field, type, index, FK

API Reference

20 endpoints · params · responses · error codes

Business Workflows

Order-to-Cash · Procure-to-Pay · status lifecycles

Infrastructure

All services · DNS · crons · issues · credentials

Infra Dashboard

Live health checks · service status · DB counts

Executive Dashboard

KPIs · revenue charts · AR · SOs (needs API key)

Power Tools (60+)

Filterable tool catalog · all links live

Full 12-Tab Guide

Build plan · roadmap · suitelets · AI · automations · pitfalls · tools · skills · research

2026 Business Snapshot

Monthly Revenue (CustInvc)

Jan
$2,617,390
Feb
$2,447,971
Mar
$2,550,474
Apr
$2,355,274
May*
$1,301,067
YTD: $11,272,176 · Pace: ~$29.4M annualized

Top Customers (81.9% of YTD)

Driscoll
$4,107,918
Operative
$1,745,114
Mivila
$617,441
SYSCO LI
$569,354
T. Nichols
$555,527
Concentration: Driscoll = 36.4% of revenue

Core Workflows → Full Details

Order-to-Cash

SalesOrd 12,862 · $177.4M
ItemShip 12,375 (96.2%)
CustInvc 12,542 · 98.3% paid
CustPymt 8,195 · 99.97% deposited

Procure-to-Pay

PurchOrd 11,566 · $131.0M
ItemRcpt 3,491 · $51.7M
VendBill 22,916 · 99.6% paid
VendPymt 9,603 · $144.0M

Data Integrity

Completeness

Null dates: 0 · Null types: 0
Orphaned lines: 0
Entity backfill: 78,616 (100%)
GL accounts: 152/152
20 txn types · 2018-2027

Security

Bearer auth · CORS (4 origins)
CSP · X-Frame · XSS · Referrer
SQL parameterized · input validated
SPF configured
!
DKIM/DMARC: verify in CF dashboard

Known Issues → Details

sync.sh quarantine: FIXED
!
Custom domain SSL: provisioning
!
vb_lines: 50.7% coverage
!
Worker sync cron: stub only
!
KV/R2: bound but unused

Complete System Inventory

gfs-platform/

src/index.tsWorker
schema.sql18 tables
sql/45 loader files
docs/9 research (280K words)
guide/11 guide files
*.html3 dashboards
*.sh2 scripts (sync + report)

Template Review 2026/

Data-Exports/134 files (40MB)
Email-Templates/53 templates
PDF-HTML-Templates/54 XML
PDF-Layouts/19 layouts
HTML-Layouts/10 layouts
Reference/24 files
Schema-Browser/24 schemas
00_*.html6 system guides

NetSuite Deployed

Chartstone Prolocalhost API
SuiteQL #2947Suitelet
SuiteAPI #2948RESTlet
Toolkit #2949Suitelet
SuiteAttachRESTlet
MCP ServerClaude ↔ NS
60+ toolspages.dev

Cloudflare Deployed

Workergfs-platform
D1gfs-netsuite
KVCACHE
R2gfs-files
Pages16 projects
Domainai-globalfoodsolutions.co
Crons2 (sync + report)