
Acumatica Integration
Acumatica's mid-market positioning
Acumatica concentrates in the mid-market segment Horizon serves directly — manufacturers in the $50M-$500M revenue range that have outgrown QuickBooks Enterprise, smaller industry ERPs, or basic manufacturing systems but aren't ready for SAP S/4HANA or Oracle Fusion. The product is cloud-deployable with optional on-premise hosting, customizable through Acumatica's developer framework, and licensed by resource rather than user (allowing broader access).
Integration through Acumatica's contract-based API
Acumatica's REST API uses a contract-based design — every API endpoint is defined by an API contract that specifies which fields are exposed and how they're accessed. For Horizon integration, this means:
- Standard Acumatica entities (Stock Items, Inventory Quantities, Sales Orders, Purchase Orders) are accessible through default endpoints
- Customer-specific customizations (custom fields, extended entities) require API contract extension by the customer's Acumatica administrator or VAR
- OData endpoints provide alternative access for analytics-style queries
Acumatica-specific data objects Horizon reads
- Stock items with planning attributes (lead time, base safety stock, ABC code)
- Item warehouse details for per-warehouse overrides
- Inventory quantities by warehouse, location, lot/serial
- Sales order history with customer, branch, and shipping data
- Purchase orders and vendor information
- Bills of material (for customers using Acumatica's Manufacturing edition)
- Production orders and operations
- Vendor master with lead time and pricing
Acumatica Manufacturing edition specifics
Acumatica's Manufacturing edition adds the production-specific entities Horizon needs for full planning scope:
- Production BOMs with revision control
- Operations and work centers
- Production orders with material requirements
- Routing data with run rates and setup times
For customers running Acumatica's Distribution edition without Manufacturing, the integration scope reduces — Horizon can handle demand planning, inventory optimization, and replenishment but not production planning or finite capacity scheduling.
Custom fields and ISV extensions
Acumatica's customer base tends to use significant customization — custom fields on items, custom forms for industry-specific processes, ISV add-ons for specific verticals. The integration captures customer-specific custom fields explicitly during configuration. ISV extensions vary; integration with each is handled case-by-case.
Alternative integration path
For environments where API access is constrained by Acumatica's resource-based licensing limits, Horizon supports scheduled SFTP delivery of flat-file extracts produced by Acumatica's import/export framework or custom Generic Inquiries.
Authentication and connection
Acumatica authentication uses OAuth 2.0 with service account. The customer's Acumatica administrator creates the integration user with appropriate role assignments. For cloud deployments, the connection is direct internet; for on-premise deployments, VPN or secure tunnel as the customer prefers.
Write-back patterns
- Planned purchase orders through standard PO creation endpoints
- Planned production orders for Manufacturing edition customers
- Item planning parameter updates on Stock Item and Item Warehouse Details records
- Demand forecast records for Acumatica's MRP processes
Common Acumatica-specific considerations
- Multi-branch configurations — Many Acumatica manufacturers run multiple branches (subsidiaries, divisions). The integration captures the branch structure explicitly for proper planning segregation.
- License resource limits — Acumatica's resource-based licensing has API call limits per tier. The integration is designed to work within typical limits with bulk data extraction rather than chatty real-time queries.
- Distribution vs Manufacturing edition — The integration scope depends on which edition is licensed. For Distribution-only customers, the planning scope is limited to demand, inventory, and replenishment; Manufacturing customers get the full planning scope.
- Acumatica Cloud vs hosted on-premise — Same API, different connection patterns. Cloud is direct internet with IP allowlisting; on-premise typically requires VPN.


