Set up Acumatica with Tipalti
You can set up the Acumatica app to integrate in Tipalti, enabling you to sync Tipalti data with Acumatica. This helps you keep both systems up to date with your latest financial data, facilitating accurate account reconciliation.
Required user role Manage Integrations
Preparation
The minimum supported Acumatica version for Tipalti ERP integration is 2023R2 (23.200.01).
Step 1. Download Tipalti Project
Depending on the environment, you need to download the corresponding "Tipalti Customization Project" file:
- Sandbox - Tipalti Customization Project
- Production - Tipalti Customization Project
Step 2. Import the customization project
In Acumatica,
- Log in to Acumatica.
- In the search bar, enter "Customization Projects".
- On the "Customization Projects" page, click "IMPORT".
- In the "Open Package" dialog, click "Choose a File". A window opens displaying your files.
- Select the relevant file and click "UPLOAD".
- On the "Customization Projects" page, select the relevant row and click "PUBLISH".
- In the "Compilation" dialog, click "Publish".
Integration configuration
Step 1. Configure Acumatica integration
Complete the following pages to configure the integration with Acumatica in Tipalti's Tipalti Hub.
A. Authenticate
The following instructions are for first-time authentication.
- Go to Administration > API integration > Apps.
- At the top right of the screen, click "Add app" and select "Acumatica".
- On the "Configure Acumatica integration" page, do the following: enter your credentials to log in to your account.
- In the "Instance name" field, enter the name of your instance. For example, if the URL is https://tipalti.acumatica.com/, then the instance is Tipalti.
- In the "Tenant" field, enter your tenant.
- Click "Next" to open the Acumatica app and begin the authentication step.
- On the Acumatica login page, enter your credentials to log in to your account.
Make sure you do not miss a space character, as it hardly can be seen (e.g., after a dash).
B. Payer entity mapping
Map your Tipalti payer entity to your Acumatica branches.
C. Sync preferences
- In the "Record type" column, to the left of each entity types you want to sync, toggle the button "On".
- In the "Sync options", select "Sync all payees in to Acumatica to Tipalti" checkbox to sync your payees during the initial sync.
- Click "Next".
- When choosing syncing payees from Acumatica to Tipalti, only NEW payees are synced (i.e., updated payees are not synced).
- Do not activate fees in Sandbox, only in production.
- Tipalti only supports payment terms that have a fixed number of days, such as net 30, net 45, net 60, etc. If your payer is using other types, convert the not supported types into fixed days, or remove them if not necessary.
D. Custom field mapping
Map existing custom fields between Tipalti and Acumatica.
- Click the "+Add field" button according to the record type to which you want to map the custom field .
- In the "Acumatica field" column, select the tracking category name in Acumatica from the dropdown.
- In the "Tipalti field" column, select the corresponding custom field name in Tipalti from the dropdown.
- Repeat the previous three steps for each custom field you want to map.
- To delete a row, hover over the mapping line, click
on the right side of the row, and confirm the deletion.
- When you are finished mapping fields, click "Next" to be directed to the "Accounts" screen.
Supported custom fields
Custom fields |
value |
screen iD |
code |
|---|---|---|---|
| Project (bill line) | Description (project ID) | PM3010PL | project ID |
| Subaccount (bill line) | Subaccount + Description | GL203000 | Subaccount |
| Project Task (bill line) | Description (project ID) | PM3020PL | Task ID + Project Id |
| Vendor Class (payee) | Class ID + Description | AP2010PL | Class ID |
| Post Period (bill) | Financial period ID (month-year) | GL201000 | Financial period ID |
| Ap account (payee) | account + description | GL202500 | account |
| Cash discount account (payee) | account + description | GL202500 | account |
| Cash discount subaccount (payee) | Subaccount + Description | GL203000 | Subaccount |
| AP subaccount (payee) | Subaccount + Description | GL203000 | Subaccount |
E. Accounts
Map the virtual account in Tipalti to the bank accounts in Acumatica ( called "Cash account" in Acumatica).
Each Tipalti account must be mapped to the bank account from Acumatica of the corresponding currency. Only relevant accounts are displayed.
- Adjacent to each Tipalti account name, begin typing the Acumatica account to which Tipalti payments will be synchronized, then select it from the populated list.
- Click "Next".
- Make sure the cash account shares the same currency with the VA account. The relevant screen in Acumatica are "Cash accounts" and "Cash of accounts" in the search bar.
- Make sure the "AP/PR Suggest Next Number" is not selected:
F. Fees
Map fee bill and corresponding fee payment between Tipalti and Acumatica.
Prior to this step, you need to create a vendor in Acumatica that will represent 'Tipalti' as a vendor. This vendor is used both for daily and for monthly fees.
- In the "Daily and monthly fees" field, from the dropdown list, select the relevant Tipalti payee.
- In the "Tipalti daily fees" field, from the dropdown list, select the expense account that you want to associate for Tipalti's transaction fees.
- In the "Tipalti monthly fees" field, from the dropdown list, select the expense account and tax code for Tipalti's monthly fees.
- For each "Line type", from the dropdown list, select the expense account and tax code.
- Click "Next".
G. Payment preferences
Map the payment methods in Tipalti with the payment methods in Acumatica.
- For each of the payment methods, from the dropdown list, select the select the corresponding payment method in Tipalti
- Click "Next".
- On the "Sync summary" dialog, review the sync fields and click "Confirm".
Step 2. Perform initial synchronization
The summary screen shows the objects that will be synchronized with Acumatica.
- Click "Confirm" to start off the first sync with Acumatica. You will be directed to the main apps screen.
- Upon first sync completion, the status of the integration changes according to the result.
Acumatica permissions
The minimum permission required in Acumatica to set up the integration are:
Permission |
Actions |
|---|---|
| AP clerk | Sync bills, debit adjustments, payments, vendors |
| CS Admin | View all entities during the Wizard process |
| GL viewer | View and retrieve post period |
| PR Clerk | View and sync GL account during wizard |