Setup
Required user role Manage Integrations
Preparation
The minimum supported Acumatica version for Tipalti ERP integration is 2023R2 (23.200.01).
Depending on the environment, you need to download the corresponding "Tipalti Customization Project" file:
Sandbox - Tipalti Customization Project
Production - Tipalti 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
Complete the following pages to configure the integration with Acumatica in Tipalti's Tipalti Hub. Click each page name to view how-to steps.
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).
Once back to the Tipalti Hub, continue with the first time configuration process.
Map your Tipalti payer entityAn entity can be a subsidiary, division, business unit, brand, etc. of your organization. Entities can have similar or different AP processes and workflows. to your Acumatica branches.
- 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.
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 |
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:
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 accountThe general ledger (GL) account that is debited for the payment amount 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 codeA code for the type of tax applied to a bill line (e.g., VAT-UK) for Tipalti's monthly fees.
- For each "Line type", from the dropdown list, select the expense account and tax code.
- Click "Next".
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".
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 |