Articles in this section

Synchronization with Acumatica

Select a category below to see information about synchronization between Acumatica and Tipalti.

Payment terms

Payment terms only exist in Acumatica and are synced to Tipalti.

Payees
  • Updated payees are synced from Tipalti and Acumatica.
  • Created payees are synced from Acumatica to Tipalti.
Custom fields

The following is a list of predefined records in Acumatica that do not exist in Tipalti, but can be mapped as a custom field in Tipalti:

Record Type

Value

Screen id

mapping

custom field type

entity support type

code
Project (bil/ po line) Description (project ID) PM3010PL
  • Active
  • Inactive
 List Single entity project ID
Subaccount (bil/ po line) Subaccount + Description GL203000
  • Active
  • Inactive
 List Entitiless Subaccount
Project Task (bil/ po line) Description (project ID) PM3020PL
  • Active
  • Inactive
 List Single entity Task ID + Project Id
Vendor Class (payee) Class ID + Description AP2010PL   List Entitiless Class ID
Post Period (bill) Financial period ID (month-year) GL201000       Financial period ID
Ap account (payee) Account + Description GL202500
  • Active
  • Inactive
 List Entitiless Account
Cash discount account (payee) Account + Description GL202500
  • Active
  • Inactive
 List Entitiless Account
Cash discount subaccount (payee) Subaccount + Description GL203000
  • Active
  • Inactive
 List Entitiless Subaccount
AP subaccount (payee) Subaccount + Description GL203000
  • Active
  • Inactive
 List Entitiless Subaccount
Tax zone (payee/ bill/ po) Tax zone ID + Description TX2060PL   List Entitiless Tax zone ID
Bills / Vendor credit
  • In Acumatica, bills and vendor credits are the same object.
    • Bill corresponds to a bill in Tipalti.
    • Debit adjustment corresponds to a vendor credit in Tipalti. It can be:
      • Applied against a bill (or multiple bills)
      • Be used as a vendor refund (i.e., when the vendor is paying the payer)
  • Bills in the following statuses are synced automatically from Tipalti to Acumatica as "Open" bills:
    • Pending payment
    • Scheduled for payment
    • Submitted for payment
    • Paid
    • Partially paid
    • Paid manually
    • Scheduled for payment with outstanding amount
    • Partially paid with outstanding amount
  • The status of the invoice in Acumatica is updated to "Paid" once their payment is synced to Acumatica.
  • Bill attachments (the bill image) are synced to Tipalti as a standalone record type.
  • Bills can be configured to sync before or after approval in Acumatica wizard > sync preferences table.
    • 0 bills are synced to Acumatica as "Paid".
    • Edit post approval is supported (according to the bill's settings).
    • Retract approval is supported. Behavior is determined according to the timing of the following sync (after retraction):
  • Bills in the following statuses are synced from Tipalti to Acumatica as "Balanced" bills, before approval:
    • Pending approval
    • Pending AP action
    • Pending payee invoice
    • Pending payee approval
Payments
  • Payment are synced from Tipalti to Acumatica.
  • Payments made from Tipalti are synced as "Closed" status in Acumatica.
  • Payment statuses in Acumatica are automatically updated when a payment is rejected, deferred, or canceled by the payee’s bank.
  • When a payment’s status is changed to rejected, deferred, or canceled in Tipalti, the integration will automatically void it in the ERP. The bill notes will indicate that the payment was reversed.
Gl accounts
  • GL and bank accounts sync from Acumatica to Tipalti.
  • In Acumatica, there are four types of accounts:
    • Liability
    • Assets
    • Expense
    • Income account class
Tax codes
  • Tax codes are synced from Tipalti to Acumatica.
  • Tax codes on bill (code and amount) are synced as part of the bill from Tipalti to Acumatica.
  • POs are synced to Tipalti using a single tax code applied to the entire amount on the PO from Acumatica.
Purchase orders
  • POs are synced from Acumatica directly into Tipalti.
  • 2-way PO matching - invoices are matched against synced POs in Tipalti, and sync matched invoices to Acumatica, allowing for seamless reconciliation between Tipalti and payers’ Acumatica accounts.
  • The PO status is synced from Acumatica to Tipalti.
GRNs
  • Only released GRN are synced to Tipalti.
  • The GRN status is synced from Acumatica to Tipalti.

GRn status in Acumatica

grn status in TIPALTI
On hold N/A
Balanced Active
Released Active
Fees
  • Fees are translated into a bill and a payment in Acumatica.
  • Fees are synced from Tipalti to Acumatica every 24 hours.

Standard integration

Several fields are mapped automatically in the standard integration and are not available for custom mapping. Select a category below to see the mapped fields.

GL accounts

All GL accounts in Acumatica that were added, updated, or archived since the last sync are collected and synced to Tipalti.

Mapped fields

Mapping table for Expense and AP accounts

Acumatica

Tipalti
AccountCD ExternalId number 
AccountClass N/A
AccountGroup N/A
AccountID N/A
Active Active
CashAccount N/A
ChartOfAccountsOrder N/A
ConsolidationAccount N/A
CreatedDateTime N/A
CurrencyID Currency
Description Name/ Description
LastModifiedDateTime N/A
PostOption N/A
RequireUnits N/A
RevaluationRateType N/A
Secured N/A
TaxCategory N/A

Type (ENUM)

  • AP account or liability
  • Asset
  • Expense
  • Income 
 Type (ENUM)
UseDefaultSubaccount N/A
https://tipalti.acumatica.com/(W(2))/Main?CompanyID=Company&ScreenId=GL202500 ExternalUrl
Whatever ID we generate  TipaltiId
  ExternalPayerEntitiesIds
  TipaltiPayerEntitiesIds
N/A Category

Mapping table for cash accounts

Acumatica

Tipalti
CashAccount/ accountCD ExternalId
CashAccount/ accountCD Number
Active Active
Currency Currency
Description Name/ Description
Bank Type (ENUM)
https://tipalti.acumatica.com/(W(5))/Main?CompanyID=Company&ScreenId=CA202000&CashAccountCD=56445+++++ ExternalUrl
What Tipalti returns  TipaltiId
Branch ExternalPayerEntitiesIds
What Tipalti returns  TipaltiPayerEntitiesIds
N/A  Category
Payees

All payees that were updated since the last sync are collected and synced to Acumatica. Created payees are synced from Acumatica to Tipalti.

Mapped fields

Acumatica

Tipalti
AccountRef N/A
GlAccountsAPAccount Custom Field
GlAccountsAPSubaccount Custom Field
GlAccountsCashDiscountAccount Custom Field
GlAccountsCashDiscountSubaccount Custom Field
CreatedDateTime Custom Field
CurrencyID PaymentCurrency
CurrencyRateType N/A
EnableCurrencyOverride N/A
EnableRateOverride N/A
F1099Box N/A
F1099Vendor N/A
FATCA N/A
FOBPoint N/A
ForeignEntity N/A
LandedCostVendor N/A
LastModifiedDateTime N/A
LeadTimedays N/A
LocationName N/A
MaxReceipt N/A
MinReceipt N/A
ParentAccount N/A
PaymentBy N/A
PaymentLeadTimedays N/A
PaymentMethod PaymentMethodId
PaySeparately N/A
PrintOrders N/A
ReceiptAction N/A
ReceivingBranch N/A
RemittanceAddressOverride N/A
RemittanceContactOverride N/A
SendOrdersbyEmail N/A
ShippingContactOverride N/A
ShippingAddressOverride N/A
ShippingTerms N/A
ShipVia N/A

Tipalti to Acumatica status mapping:

  • Active –— Active 
  • Suspended –— Hold payments 
  • Blocked –— On hold
  • Closed –— Inactive 
  • Unmapped –— On hold 

Acumatica  to Tipalti status mapping:

  • Active –— Active 
  • On hold –— Blocked 
  • Hold payments –— Suspended 
  • On-time –— Active 
  • Inactive –— Closed 
TaxCalculationMode N/A
TaxRegistrationID N/A
TaxZone N/A
Terms PaymentTermId
ThresholdReceipt N/A
VendorClass Custom Field
VendorID ExternalId
Whatever ID we generate  TipaltiId
URL of payee within Tipalti TipaltiUrl
https://tipalti.acumatica.com/(W(2))/Main?CompanyID=Company&ScreenId=AP303000&AcctCD=32242+++++ ExternalUrl
  ExternalPayerEntitiesIds
  TipaltiPayerEntitiesIds
VendorIsLaborUnion N/A
VendorIsTaxAgency N/A
Account name (vendor name on the table)  If exists, Alias, otherwise, Legal name 
Warehouse N/A
LegalName If exists, CompanyName, otherwise, <FirstName> <LastName>
Name  FirstName
Last name  LastName
NA MiddleName
Email  Email
Address line 1  Street1
Address line 2 Street2
City  City
State  StateCode
Postal code  Zip
Country  N/A
 

Phone

 
'NoMapping' PayeeEntityType
NA for Acumatica > Tipalti IsPayable
FALSE IsAccountClosed
Phone Country  PhoneCountryCode
TaxInfoModel 
N/A TaxFormEntityName
N/A TaxFormEntityType
N/A TaxFormType
N/A TaxFormStatus
N/A TaxFormTreatyCountry
N/A Invite to supplier portal 
GlAccountsAPAccount Ap default account 
VendorID - most left column  IDAP
VendorID - most left column ExternalId

PURCHASE SETTINGS

Tax zone  Custom Field
CustomFieldsValues  
Bills

All bills that were added, updated, or deleted since the last sync are collected and synced from Tipalti to Acumatica.

Mapped fields

Acumatica

Tipalti

HEADER

Amount Amount
ApprovedForPayment N/A
Balance AmountDue
BranchID N/A
CashAccount  
CurrencyID Currency
Date BillDate
Take from tipalti  CreationDate
Description Description
DueDate DueDate
Hold False 
LocationID Custom field 
PostPeriod Custom Fields
ReferenceNbr ExternalId
Orig. ref. Nbr.   
Take from tipalti (bill ref code) TipaltiId
Take from Tipalti  RefCode
Go to Tipalti screen TipaltiUrl
https://tipalti.acumatica.com/(W(2))/Main?CompanyID=Company&ScreenId=AP301000&DocType=INV&RefNbr=000003 ExternalUrl
N/A TipaltiAttachmentId
N/A ExternalAttachmentId
  ExternalPayerEntitiesIds
BranchID TipaltiPayerEntitiesIds
Status Status
TaxTotal  
Terms  
Type Bill or debit adjustment 
Vendor ExternalVendorId
Take from Tipalti  VendorId
VendorRef BillNumber
Take from Tipalti  PayerId
Vendor (ID) - most left column  IDAP
LastModifiedDateTime N/A

Financial 

Ap account  ExternalApAccountId
Vendor tax zone  Custom Fields

Bill line

Account ExternalGlAccountId
N/A TipaltiGlAccountId
Amount Amount
Branch N/A
CalculateDiscountsOnImport N/A
CostCode N/A
Description N/A
LineNbr LineId
ExtendedCost N/A
InventoryID N/A
NonBillable N/A
POLine N/A
POOrderNbr N/A
POOrderType N/A
POReceiptLine N/A
POReceiptNbr N/A
Project Custom Fields
ProjectTask Custom Fields
Qty Quantity
Subaccount Custom Fields
TaxCategory N/A
TransactionDescription Description
UnitCost UnitPrice
UOM N/A
N/A LineType
Inventory id  PoMatchingExternalItemId
Subitem  Custom Fields

TAX DETAILS

TaxableAmount Amount
TaxAmount TaxAmount
TaxID ExternalTaxCodeId
N/A TipaltiTaxCodeId
TaxRate N/A
CustomFieldsValues  
PurchaseOrders  
Purchase order

All Purchase orders that were updated since the last sync are collected and synced from Tipalti to Acumatica.

Mapped fields

TIPALTI

Acumatica

Header

Date Date 
Number OrderNbr
Currency CurrencyID
Status (mapping provided above)  Status 
ExternalId OrderNbr
TipaltiId  
ExternalPayerEntitiesIds The id of the entity (in Acumatica)
TipaltiPayerEntitiesIds N/A
TipaltiVendorId  
Notes  N/A
IDAP N/A
ExternalVendorId VendorID
TipaltiUrl N/A
ExternalUrl https://tipalti.acumatica.com/(W(5))/Main?CompanyID=Sales+Demo&ScreenId=PO301000
ShouldPersist ‘True’ 
customFieldsValues CustomFieldValues (Dimensions on the PO should be included)
LineItems LineItems
Description Line description 
Custom Fields Project 
Custom Fields Project task 
Custom Fields Subaccount
Quantity Order qty. 
ExternalGlAccountId Account
TipaltiGlAccountId N/A
TipaltiTaxCodeId N/A
ExternalTaxCodeId N/A
DiscountAmount Discount amount 
ExternalLineId LineNbr
TaxAmount N/A
Amount ExtendedCost
UnitPrice Unit cost 
ExternalItemId Inventory id 
LineType

If inventory ID = NULL, expense

otherwise item
Notes  N/A
UnitCode FromUnit
UnitExternalId FromUnit-ToUnit
BillLineMatches
ExternalPoId POOrderNbr
ExternalPoLineId POLine
NA POOrderType

TAX DETAILS

TaxableAmount Amount
TaxAmount TaxAmount
TaxID ExternalTaxCodeId
N/A TipaltiTaxCodeId
TaxRate N/A

VENDOR INFO

Vendor tax zone  Custom Fields
customFieldsValues (Dimensions on the PO should be included)  
GRNs

All GRNs that were released are synced from Acumatica to Tipalti.

Mapped fields

TIPALTI

Acumatica

Header 

Tipalti ID  
External ID  ReceiptNbr
Notes N/A
payeeID (VendorId) VendorID
IDAP N/A
PayerID  
PayerEntityID Entity id 
PurchaseOrderNumber POOrderNbr
ReceiptDate Date
ReceiptNumber ReceiptNbr
Status (see mapping above)  Status 
ShouldPersist ‘True’ 
Custom Fields Posting period
TipaltiUrl N/A
ExternalUrl https://tipalti.acumatica.com/(W(13))/Main?CompanyID=Sales+Demo&ScreenId=PO302000&ReceiptType=RT&ReceiptNbr=PR002322

Details 

ERP line ID LineNbr
Tipalti line id  N/A 
GRN ID (parent ID)  POReceiptNbr
Description TransactionDescription
InvoiceNumber N/A
ItemCode InventoryID
Notes N/A
PoLineId POLineNbr
QuantityShipped ReceiptQty
UnitCode FromUnit
UnitExternalId FromUnit-ToUnit
Tax codes

Tax codes are synced to Acumatica.

Mapped fields

Acumatica

TIPALTI
CalculateOn N/A
CashDiscount N/A
CreatedDateTime N/A
DeductibleVAT N/A
Description + (TAX ID) Name
EnterFromTaxBill N/A
ExcludeFromTaxonTaxCalculation N/A
IncludeInVATExemptTotal N/A
IncludeInVATTaxableTotal N/A
LastModifiedDateTime NA
NotValidAfter N/A
PendingVAT N/A
ReverseVAT N/A
StatisticalVAT N/A
TaxAgency N/A
TaxClaimableAccount N/A
TaxClaimableSubaccount N/A
TaxExpenseAccount N/A
TaxExpenseSubaccount N/A
Tax ID ExternalId
TaxPayableAccount N/A
TaxPayableSubaccount N/A
TaxType N/A
TaxRate Rate
N/A TipaltiPayerEntitiesIds
N/A ExternalPayerEntitiesIds
‘TRUE’ Active
Start date N/A
Tax zone ID  N/A
Tax category  N/A
N/A TipaltiId
https://tipalti.acumatica.com/(W(4))/Main?CompanyID=Sales+Demo&ScreenId=TX205000&TaxID=CABCPST ExternalUrl
Payments

All payments in Tipalti that were added since the last sync are collected and synced to Acumatica.

Mapped fields

Acumatica

TIPALTI
ApplicationDate TransactionDate
  ExternalAccountType
CurrencyID CurrencyCode
Description  
Hold  
PaymentAmount AmountSubmitted
N/A IsFinalized
Cross rate  ExchangeRate
PaymentMethod  
PaymentRef RefCode
Zero Payment RefCode
Non-zero Payment Acumatica ReferenceNbr
Whatever ID we generate  TipaltiId
Screen in Tipalti  TipaltiUrl
https://tipalti.acumatica.com/(W(12))/Main?CompanyID=Sales+Demo&ScreenId=AP302000&DocType=CHK&RefNbr=002617 ExternalUrl
  ExternalPayerEntitiesIds
  TipaltiPayerEntitiesIds
N/A IsManuallyPaid

If IsManuallyPaid = T,

CashAccount =

 ManualPaymentExternalAccountId
If IsManuallyPaid = F, CashAccount = PaymentAccountId
Status Status
Type See algorithm 
UnappliedBalance  
Vendor VendorId
LastModifiedDateTime  
VendorCreditsFields
Branch  InvoiceNumber
N/A TipaltiId
ApplyInfos (within VendorCreditsFields)
NA TipaltiBillId
Amount paid AppliedAmount
N/A ExternalBillId
N/A InvoiceNumber

BillFields 

Branch  InvoiceNumber
N/A TipaltiId
Reference nbr. ExternalId
Amount paid RealPaidAmount

PayeeFeeDetails

N/A PayeeTxnFees
N/A ExternalExpenseAccountId
N/A ExternalVendorId
N/A ExternalPaymentAccountId
CustomFields  
Payment Terms

All payments terms that were added since the last sync are collected and synced to Tipalti.

Mapped fields

Acumatica

TIPALTI

 
What the erp returns  ExternalId  
Terms ID + (Description) Name (unique)   
Visible to  N/A  
Installment type  N/A  
Number of installments  N/A  
Whatever ID we generate  TipaltiId  
https://tipalti.acumatica.com/(W(2))/Main?CompanyID=Company&ScreenId=CS206500&TermsID=4432423 ExternalUrl  

If ‘discount %’ > 0 then TRUE

(discount % is the name of the field, there is only one such field name associated with the credit term screen ID) 

 IsWithDiscount  
paymentTermPeriod (ENUM)
due date 1 Quantity   
Fixed number of days: due date 1= days day  
N/A week  
  month  
N/A year  
'Unmapped' Unmapped