← All work

Beverage co-packing & manufacturing

Customer EDI program: AS2, VAN and SFTP

Automated X12 EDI with national beverage brands, including a self-hosted AS2 server. Orders, receipts, shipments and inventory flow straight between partners and NetSuite.

  1. Brand partner
  2. AS2 / VAN / SFTP
  3. X12 940 · 943
  4. NetSuite orders
  5. 944 · 945 · 846
Customer EDI program: AS2, VAN and SFTP
IllustrativeIllustrative: X12 documents flowing between partners and NetSuite.
Client
Sojo Industries ↗
Beverage co-packing & manufacturing
Stack
OpenAS2, Docker, AWS (EC2, Lambda, S3, EventBridge), Python, X12, SuiteQL, RESTlets

Results

  • Live with 3 brand partners across AS2, VAN and SFTP
  • Full 940 / 943 / 944 / 945 / 846 / 997 transaction set

The problem

As a 3PL and co-packer, Sojo has to trade orders, receipts, ship confirmations and inventory with each brand in the format and transport that brand requires. Doing that by hand means re-keying orders and sending confirmations late.

What I built

  • Self-hosted AS2 for Niagara Bottling.
    • OpenAS2 in Docker on EC2, with dev and prod running side by side.
    • SHA-256 signing, AES-256 encryption, signed MDN receipts, and a full message archive.
    • Inbound 940/943 become NetSuite sales orders and purchase orders. 944, 945 (with LPNs), a daily 846 and 997 acknowledgements are generated automatically.
    • Hosting AS2 in-house avoided paying a VAN or EDI vendor for this partner.
  • Premier Nutrition over a VAN. Three scheduled Lambda services (inventory 846, inbound 940/943, outbound 945/944), with a daily retry lane for inbound files that keep failing.
  • BodyArmor via Stord SFTP. Inbound orders every hour, outbound confirmations every four hours, and DynamoDB de-duplication.
  • Shared monitoring. Every success and failure reports to a central integration-monitoring dashboard.