← All work

Beverage co-packing & manufacturing

Real-time WMS ⇄ NetSuite integration

A two-way sync between Manhattan SCALE WMS and NetSuite that keeps items, orders, receipts, shipments, builds and inventory in step every five minutes, with reconciliation jobs that catch drift.

  1. SCALE WMS
  2. Airflow every 5 min
  3. NetSuite RESTlets
  4. Daily reconciliation
Real-time WMS ⇄ NetSuite integration
IllustrativeIllustrative: WMS and NetSuite stay in step through scheduled pipelines.
Client
Sojo Industries ↗
Beverage co-packing & manufacturing
Stack
Apache Airflow (MWAA), Python, SuiteScript 2.x, SuiteQL, SuiteCloud SDF, GitHub Actions

Results

  • Download and upload jobs run every 5 minutes in production
  • About 11 production pipelines, plus daily and weekly reconciliations

The problem

The warehouse runs on Manhattan SCALE, and finance and inventory run on NetSuite. Every gap between the two systems turned into billing errors, inventory drift and manual clean-up.

What I built

  • Airflow pipelines on Amazon MWAA. Items, customers, POs, sales orders and work orders with BOMs flow down to the WMS every five minutes. An upload sequence posts warehouse activity back to NetSuite.
  • Six NetSuite RESTlets on a shared library: builds, inventory transactions, receipts, shipments, inventory balance and close transaction.
  • Reconciliation jobs:
    • Daily and weekly runs for finished-goods build catch-up and finished-goods billing.
    • A NetSuite-vs-WMS inventory comparison, and a balance sync from the WMS database.
  • Production-grade delivery. Separate dev and prod environments, SDF-managed scripts, and automatic deploys from GitHub Actions.

Why it matters

Warehouse and finance work from the same numbers, and mismatches surface in a report instead of at month end.