Introduction to Acumatica
Acumatica is a cloud-based ERP platform designed to support a wide range of business types, including retail, manufacturing, distribution, and construction, with modules for finance, inventory, and operations.
Popular with mid-market companies that need flexibility across multiple verticals
Common among businesses outgrowing entry-level accounting software
Connecting Acumatica to iPaaS.com enables real-time synchronization of orders, customers, inventory, and financials across your commerce and fulfillment stack
API Version Support
The integration uses the Acumatica Contract-Based REST API. Acumatica exposes this API under an environment-specific base address of the form https://{Instance Identifier}/entity/Default/{Version}, where {Version} is the endpoint contract version configured for your instance (for example, 22.200.001). Because each Acumatica environment is configured independently, your base address and contract version may differ from another subscriber's — the integration uses whatever you have configured. Acumatica does not push changes to iPaaS.com, so records are read on a recurring poll and on demand through a Manual Sync. See the Acumatica Connections and Settings and Acumatica API Endpoints articles for details.
Data Flows
The table below summarizes the data the integration can move between iPaaS.com and Acumatica, and in which direction. Arrows show the direction of transfer:
→ iPaaS.com writes the data to Acumatica
← iPaaS.com reads the data from Acumatica
←→ the data can move in both directions
Allow Initialization? indicates whether that data can be bulk-loaded from Acumatica when a subscription first connects. Whether a given flow is enabled, and in which direction, is configured per subscription during implementation.
iPaaS.com | Direction | Acumatica | Allow Initialization? |
Product | ← | Stock Item | |
Location | ← | Warehouse | ✔️ |
Customer | ←→ | Customer | |
Company | ← | Customer (business account) | |
Customer | ← | Contact | |
Order | ←→ | Sales Order | |
Invoice and Return | ← | AR Invoice, Credit Memo and Debit Memo | |
Order Tracking Number | ←→ | Shipment Tracking Number |
Products come in from Acumatica with their per-warehouse stock quantities. Customers carry their billing and shipping addresses. An Acumatica customer account is captured either as an iPaaS.com Customer or as an iPaaS.com Company, as the subscriber's collection filters decide, and Acumatica contacts are captured as iPaaS.com Customers, linked to their Company when their account is captured as a Company. Sales Orders are written into Acumatica with their line items, addresses, taxes, payments, and tracking numbers, and Acumatica sales orders are captured into iPaaS.com as Transactions with their lines, addresses, taxes, and payments; both directions link an order to the same Transaction. Acumatica AR invoices, credit memos and debit memos are captured into iPaaS.com as Transactions (a credit memo as a Return) with their lines, taxes and applied payments; they are not written back to Acumatica. Because Customer, Order, and Order Tracking Number can move in both directions, the inbound and outbound collections for those entities are configured per subscription to avoid circular updates. For the exact directionality, matching keys, and out-of-scope behavior of each flow, see the Acumatica Known Limitations article.
Versions and Release Notes
The integration follows its own version numbers. The current version is 1.1.5.
Version | Release Notes |
1.1.5 (current) | Captures Acumatica customer accounts as iPaaS.com Companies and Acumatica contacts as iPaaS.com Customers, linked to their Company when their account is a Company, and captures Acumatica sales orders, and AR invoices, credit memos, and debit memos, into iPaaS.com as Transactions with their lines, taxes, and payments (and, for sales orders, addresses). |
1.1.3 | Coded, searchable error messages: each error the integration records carries a stable code with its cause and resolution. |
1.1.1 | Connection validation is more reliable. |
1.1 | Synchronizes Stock Items (products) with their warehouse inventory, Warehouses (locations), and Customers into iPaaS.com; writes Sales Orders, with their lines, addresses, taxes, and payments, from iPaaS.com into Acumatica; and moves Shipment Tracking Numbers in both directions. |
1.0 | Initial release. |
Features by Release
The capabilities below reflect the current 1.1.5 integration. For the current behavior and any limitations of a given feature, see the linked reference articles and the Acumatica Known Limitations article.
Version 1.1.5 (current) — ERP catalog, customers, companies, and order-to-cash
Product synchronization: Stock Items captured from Acumatica with their per-warehouse inventory.
Warehouses (locations): warehouse records, with support for a bulk initialization.
Customer synchronization: customers written into Acumatica from iPaaS.com, and captured from Acumatica into iPaaS.com.
Companies and contacts: Acumatica customer accounts captured as iPaaS.com Companies, with their addresses, and Acumatica contacts captured as iPaaS.com Customers, linked to their Company when their account is captured as a Company; the subscriber decides which accounts are Companies with the collection filters.
Sales Orders: sales orders written into Acumatica with their line items, addresses, taxes, and payments, and Acumatica sales orders captured into iPaaS.com as Transactions, by polling or a Manual Sync (see Acumatica to iPaaS.com Sales Order Mapping Documentation).
AR invoices: Acumatica AR invoices, credit memos, and debit memos captured into iPaaS.com as Transactions with their lines, taxes, and applied payments, by polling or a Manual Sync (see Acumatica to iPaaS.com AR Invoice Mapping Documentation).
Shipment tracking numbers: order tracking numbers synced in both directions.
Coded error messages: every error the integration can record carries a stable, searchable code with its cause and a resolution you can act on.