Acumatica Lite
Acumatica is a cloud-based ERP software.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step-by-step Acumatica setup guide to connect Acumatica with your destination using Fivetran connectors.
Sync overview
To capture new records, and updates, we incrementally sync the following tables and their child tables:
ACCOUNTBILLBILL_PAYMENTCURRENCYCUSTOMERFINANCIAL_PERIODINVOICEJOURNAL_TRANSACTIONPAYMENTPURCHASE_ORDERSALES_ORDERSTOCKITEMVENDOR
Schema information
This schema applies to all Acumatica connections.
Explore Acumatica schema ERD
Sync limitations
- To improve sync performance, we only sync data for a connection starting from 2020-01-01 onwards.