Synchronization with Acumatica

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

Custom fields

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

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 Zipalti.
- Debit adjustment corresponds to a vendor credit in Zipalti. 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 Zipalti 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 Zipalti 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):

Bill status during sync	Expected result in Acumatica
Bill not reapproved yet	Bill is voided in Acumatica (it will be re-created after it is approved again)
Bill reapproved	Only information that has changed will be synced to Acumatica as an update

Bills in the following statuses are synced from Zipalti to Acumatica as "Balanced" bills, before approval:
- Pending approval
- Pending AP action
- Pending payee invoice
- Pending payee approval

Purchase orders

POs are synced from Acumatica directly into Zipalti.
2-way PO matchingThe process of matching goods and services from purchase orders to invoices (2-way matching), and receipts (3-way matching) - invoices are matched against synced POs in Zipalti, and sync matched invoices to Acumatica, allowing for seamless reconciliation between Zipalti and payers’ Acumatica accounts.
The PO status is synced from Acumatica to Zipalti.

Purchase order status in Acumatica	Purchase order status in TIPALTI
On hold	N/A
Pending Approval	N/A
Rejected	N/A
Pending Printing	N/A
Pending Email	N/A
Canceled	Closed
Open	Active
Completed	Active
Closed	Closed

GRNs

Only released GRNA goods received note (GRN) is an internal document that acts as proof of goods received to match against invoices and purchase orders. GRN, receipt, and receiving report are synonymous. are synced to Zipalti.
The GRN status is synced from Acumatica to Zipalti.

GRn status in Acumatica	grn status in TIPALTI
On hold	N/A
Balanced	Active
Released	Active

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 Zipalti.

Mapped fields

Mapping table for Expense and AP accounts

Acumatica	Zipalti
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	ZipaltiId
	ExternalPayerEntitiesIds
	ZipaltiPayerEntitiesIds
N/A	Category

Mapping table for cash accounts

Acumatica	Zipalti
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 Zipalti returns	ZipaltiId
Branch	ExternalPayerEntitiesIds
What Zipalti returns	ZipaltiPayerEntitiesIds
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 Zipalti.

Mapped fields

Acumatica	Zipalti
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
Zipalti to Acumatica status mapping: Active –— Active Suspended –— Hold payments Blocked –— On hold Closed –— Inactive Unmapped –— On hold	Acumatica to Zipalti 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	ZipaltiId
URL of payee within Zipalti	ZipaltiUrl
https://tipalti.acumatica.com/(W(2))/Main?CompanyID=Company&ScreenId=AP303000&AcctCD=32242+++++	ExternalUrl
	ExternalPayerEntitiesIds
	ZipaltiPayerEntitiesIds
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 > Zipalti	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 Zipalti to Acumatica.

Mapped fields

Acumatica	Zipalti
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)	ZipaltiId
Take from Zipalti	RefCode
Go to Zipalti screen	ZipaltiUrl
https://tipalti.acumatica.com/(W(2))/Main?CompanyID=Company&ScreenId=AP301000&DocType=INV&RefNbr=000003	ExternalUrl
N/A	ZipaltiAttachmentId
N/A	ExternalAttachmentId
	ExternalPayerEntitiesIds
BranchID	ZipaltiPayerEntitiesIds
Status	Status
TaxTotal
Terms
Type	Bill or debit adjustment
Vendor	ExternalVendorId
Take from Zipalti	VendorId
VendorRef	BillNumber
Take from Zipalti	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	ZipaltiGlAccountId
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	ZipaltiTaxCodeId
TaxRate	N/A
CustomFieldsValues
PurchaseOrders

Purchase order

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

Mapped fields

TIPALTI	Acumatica
Header
Date	Date
Number	OrderNbr
Currency	CurrencyID
Status (mapping provided above)	Status
ExternalId	OrderNbr
ZipaltiId
ExternalPayerEntitiesIds	The id of the entity (in Acumatica)
ZipaltiPayerEntitiesIds	N/A
ZipaltiVendorId
Notes	N/A
IDAP	N/A
ExternalVendorId	VendorID
ZipaltiUrl	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
ZipaltiGlAccountId	N/A
ZipaltiTaxCodeId	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	ZipaltiTaxCodeId
TaxRate	N/A
VENDOR INFO
Vendor tax zone	Custom Fields
customFieldsValues (Dimensions on the PO should be included)

GRNs

All GRNsA goods received note (GRN) is an internal document that acts as proof of goods received to match against invoices and purchase orders. GRN, receipt, and receiving report are synonymous. that were released are synced from Acumatica to Zipalti.

Mapped fields

TIPALTI	Acumatica
Header
Zipalti 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
ZipaltiUrl	N/A
ExternalUrl	https://tipalti.acumatica.com/(W(13))/Main?CompanyID=Sales+Demo&ScreenId=PO302000&ReceiptType=RT&ReceiptNbr=PR002322
Details
ERP line ID	LineNbr
Zipalti 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	ZipaltiPayerEntitiesIds
N/A	ExternalPayerEntitiesIds
‘TRUE’	Active
Start date	N/A
Tax zone ID	N/A
Tax category	N/A
N/A	ZipaltiId
https://tipalti.acumatica.com/(W(4))/Main?CompanyID=Sales+Demo&ScreenId=TX205000&TaxID=CABCPST	ExternalUrl

Payments

All payments in Zipalti 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	ZipaltiId
Screen in Zipalti	ZipaltiUrl
https://tipalti.acumatica.com/(W(12))/Main?CompanyID=Sales+Demo&ScreenId=AP302000&DocType=CHK&RefNbr=002617	ExternalUrl
	ExternalPayerEntitiesIds
	ZipaltiPayerEntitiesIds
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	ZipaltiId
ApplyInfos (within VendorCreditsFields)
NA	ZipaltiBillId
Amount paid	AppliedAmount
N/A	ExternalBillId
N/A	InvoiceNumber
BillFields
Branch	InvoiceNumber
N/A	ZipaltiId
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 Zipalti.

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	ZipaltiId
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