Sage 100 ERP Integration
Bi-directional REST integration connecting Sage 100 (MAS 90/200) with JASCI warehouse management system using SmartTask workflows for real-time synchronization across inbound, outbound, inventory, and returns.
Integration Overview
Sage 100 (formerly MAS 90/200) is one of the most widely deployed midmarket ERPs in North America with a large installed base in wholesale distribution, light manufacturing, and B2B order fulfillment. JASCI Cloud WMS provides advanced warehouse execution including receiving, putaway, picking, packing, shipping, cycle counting, cartonization, slotting, and robotics workflows.
This integration uses REST JSON via Sage Data & Services where available, with ODBC and flat file fallback options for legacy environments. JASCI SmartTask Custom API Tasks manage all outbound calls with built-in retry, queuing, and exception handling.
Key Integration Benefits
- • Inbound: POs download automatically, receipts post back with quantities
- • Outbound: Sales orders flow to JASCI, shipment confirmations return with tracking
- • Inventory: Real-time delta feeds for every warehouse movement
- • Returns: Customer and vendor return processing with disposition tracking
8 Bi-Directional Data Flows
Complete coverage across all midmarket distribution operations
Item Master Sync
Synchronize item master data including SKUs, dimensions, weight, categories, and product attributes.
Purchase Order Download
Send open purchase orders with vendor info, expected dates, and line details for warehouse receiving.
PO Receipts
Post receipt confirmations back to Sage 100 with quantities received per line.
Inventory Transactions
Real-time inventory delta feed for receipts, picks, packs, ships, adjustments, and transfers.
Sales Orders
Send sales orders for allocation, wave execution, picking, packing, and shipping.
Shipment Confirmations
Post shipment details with tracking numbers, carrier info, packages, and shipped quantities.
Cycle Count Variances
Send cycle count results as inventory adjustments with variance deltas.
Returns / RMAs
Support customer and vendor returns with RMA processing and disposition tracking.
Real-Time Inventory Transactions API
The primary mechanism Sage uses to maintain accurate warehouse quantities
{
"TransactionID": "TX-551882",
"TransactionType": "Pick",
"ItemCode": "A100-RED",
"QtyDelta": -2,
"Location": "A1-03-02",
"Reference": "PICK-77119-01",
"Timestamp": "2025-12-11T15:10:25Z"
}Integration Capabilities
Enterprise-grade features powered by SmartTask workflows
Midmarket Focus
Designed for wholesale distribution, light manufacturing, and B2B order fulfillment operations.
SmartTask Workflows
JASCI SmartTask Custom API Tasks handle all outbound calls with built-in retry and queuing.
Real-Time Inventory Deltas
Inventory Transactions API provides live delta feeds for every warehouse movement.
Flexible Connectivity
REST via Sage Data & Services preferred, with ODBC and flat file fallback options.
Package-Level Detail
Shipment confirmations include package weights, dimensions, and tracking numbers.
Exception Dashboard
Automatic retry on failures with exception queue for manual resubmission and alerts.
Field Mapping Examples
Clear, documented mappings between Sage 100 and JASCI
Purchase Orders
PONumberpoNumberVendorvendorNameExpectedDateexpectedReceiptDateLines[].ItemCodeproductSales Orders
OrderNumberorderNumberCustomerCodecustomerCodeCarriercarrierMethodshipViaItem Master
ItemCodeproductDescriptionproductDescriptionUOMuomCategoryproductCategoryTechnical Specifications
Flexible connectivity with modern REST and legacy support
{
"OrderNumber": "SO-77119",
"ShipmentNumber": "SHP-44519",
"TrackingNumber": "78546339129",
"Carrier": "FedEx",
"Service": "Ground",
"Packages": [
{
"PackageID": "PKG1",
"Weight": 8.4,
"Dimensions": {"L": 16, "W": 10, "H": 8}
}
],
"Lines": [
{"ItemCode": "A100-RED", "QtyShipped": 24}
]
}SmartTask Error Handling
Built-in retry logic with exception queue for reliable operation
Automatic Retry
- Network failure detection and retry
- Configurable retry intervals
- Response parsing and validation
- Credential vault for secure storage
Exception Dashboard
- Validation exceptions flagged
- Reprocess/Resend capability
- SLA-based notifications
- Response branching logic
Integration Impact
Eliminate manual data entry with real-time inventory visibility
Ready to Connect Sage 100 & JASCI?
See how our SmartTask-powered integration eliminates manual data entry and keeps your midmarket ERP and warehouse perfectly synchronized in real-time.
Related Solutions
Explore capabilities that work seamlessly with this solution