Tipalti Help Center home page
  • Get started
    • Onboarding tools
    • Video tutorials
    • Live training
  • User guide
    • Log into the Tipalti Hub
    • Administration
      • Administrative operations
      • User roles
    • Multiple entities
    • Funding
      • View funds required
      • Fund Tipalti accounts
      • Multi-FX
        • Currency cutoffs and validations
    • Payees overview
      • Search payee information
      • Manage payee status and settings
      • iFrame/ Supplier Hub
      • Manage Supplier Hub payees
      • Documents review
    • Taxation
      • US tax forms
      • Tax form expiration
      • Tax withholding
        • Withholding rates
        • Income types
        • Tax form and entity types
      • Certificate of No US Activities
      • Additional documents
      • Non-US tax collection
      • Tax form statuses
    • Procurement
      • System overview
      • Create and track purchase requests
      • Approve purchase requests
      • Mark goods and services as received
      • Vendor registration
      • Send PO PDF
      • Back office
        • Set reminders
        • Run parallel PR/ vendor approval
        • Emails
        • PO PDF customization
        • Upload budget
        • Customize Procurement forms
        • Contract repository
      • Workflow integrations
    • PO Matching
      • Matching process
      • Handle matching exceptions
      • Bill routing
      • Matching policies
      • Bill coding
      • Bill approval for PO-backed bills
        • Approvable bills
        • Non-approvable bills
        • PO updates
      • Prepayments (NetSuite 2.0)
      • Track and match a dropship invoice
        • Set payees up as dropship vendors
        • Upload and match a dropship invoice
    • Bills
      • Bill flows
      • Usability
      • Add invoices
      • Manage bills
      • Add comments and files to bills
      • Bill approvers
        • Invoice processing approvals
          • Email security
      • Tax collection in Bills
      • Bill statuses
    • Tipalti Expenses
      • Get started
      • Create and submit expenses
      • Manage and approve expenses
      • Reimburse expenses
      • Connect your corporate cards
    • Tipalti Cards
      • Funds flow
      • Manage cards
      • Card transactions overview
      • Process transactions
      • ERP sync
      • Credit card statement report
    • Submitting payments
    • Payment information
      • Payment statuses
      • Payment methods coverage
      • Payment methods coverage: US and ROW
      • Payment methods coverage: UK and EU
      • Payment error codes
    • Generate reports
      • Smart report builder
      • Payment reports
      • Bill reports
      • Payee reports
      • Tax reports
      • User reports
    • Security practices
      • Email security
      • Business continuity practices
      • Two-factor authentication
    • Detect
  • Integrations
    • 3rd Party Apps
      • Partner Platforms
      • SSO
    • ERPs
      • Sage Intacct
      • NetSuite 2.0
      • Microsoft Business Central
      • QuickBooks
      • Xero
      • Tipalti Connect
      • Acumatica
      • SAP B1
        • Setup
        • SAP B1 PO Matching
    • File Integration
      • Configure auto-sync settings
      • Import files
      • Export files
  • FAQs
    • General FAQs
    • User guide FAQs
      • Bill FAQs
      • Card FAQs
      • PO Matching FAQs
      • Payment FAQs
      • Detect FAQs
      • Taxation FAQs
      • Administration FAQs
      • Expenses FAQs
    • ERP FAQs
  • Release notes
  • Dev docs
Sign in
  • Get started  
    • Onboarding tools  
    • Video tutorials  
    • Live training  
  • User guide  
    • Log into the Tipalti Hub
    • Administration  
      • Administrative operations
      • User roles
    • Multiple entities
    • Funding  
      • View funds required
      • Fund Tipalti accounts
      • Multi-FX  
        • Currency cutoffs and validations
    • Payees overview  
      • Search payee information
      • Manage payee status and settings
      • iFrame/ Supplier Hub
      • Manage Supplier Hub payees
      • Documents review
    • Taxation  
      • US tax forms
      • Tax form expiration
      • Tax withholding  
        • Withholding rates
        • Income types
        • Tax form and entity types
      • Certificate of No US Activities
      • Additional documents
      • Non-US tax collection
      • Tax form statuses
    • Procurement  
      • System overview
      • Create and track purchase requests
      • Approve purchase requests
      • Mark goods and services as received
      • Vendor registration
      • Send PO PDF
      • Back office  
        • Set reminders
        • Run parallel PR/ vendor approval
        • Emails
        • PO PDF customization
        • Upload budget
        • Customize Procurement forms
        • Contract repository
      • Workflow integrations
    • PO Matching  
      • Matching process
      • Handle matching exceptions
      • Bill routing
      • Matching policies
      • Bill coding
      • Bill approval for PO-backed bills  
        • Approvable bills
        • Non-approvable bills
        • PO updates
      • Prepayments (NetSuite 2.0)
      • Track and match a dropship invoice  
        • Set payees up as dropship vendors
        • Upload and match a dropship invoice
    • Bills  
      • Bill flows
      • Usability
      • Add invoices
      • Manage bills
      • Add comments and files to bills
      • Bill approvers  
        • Invoice processing approvals  
          • Email security
      • Tax collection in Bills
      • Bill statuses
    • Tipalti Expenses  
      • Get started
      • Create and submit expenses
      • Manage and approve expenses
      • Reimburse expenses
      • Connect your corporate cards
    • Tipalti Cards  
      • Funds flow
      • Manage cards
      • Card transactions overview
      • Process transactions
      • ERP sync
      • Credit card statement report
    • Submitting payments
    • Payment information  
      • Payment statuses
      • Payment methods coverage
      • Payment methods coverage: US and ROW
      • Payment methods coverage: UK and EU
      • Payment error codes
    • Generate reports  
      • Smart report builder
      • Payment reports
      • Bill reports
      • Payee reports
      • Tax reports
      • User reports
    • Security practices  
      • Email security
      • Business continuity practices
      • Two-factor authentication
    • Detect  
      • Usability
      • Manage Payee risk
  • Integrations  
    • 3rd Party Apps  
      • Partner Platforms
      • SSO
    • ERPs  
      • Sage Intacct
      • NetSuite 2.0
      • Microsoft Business Central
      • QuickBooks
      • Xero
      • Tipalti Connect
      • Acumatica
      • SAP B1  
        • Setup
        • SAP B1 PO Matching
    • File Integration  
      • Configure auto-sync settings
      • Import files
      • Export files
  • FAQs  
    • General FAQs
    • User guide FAQs  
      • Bill FAQs
      • Card FAQs
      • PO Matching FAQs
      • Payment FAQs
      • Detect FAQs
      • Taxation FAQs
      • Administration FAQs
      • Expenses FAQs
    • ERP FAQs
  • Release notes
  • Dev docs
  1. Tipalti
  2. Integrations
  3. ERPs
  4. Acumatica

Articles in this section

  • Acumatica
  • Setup
  • Integration workflow
  • Synchronization
  • Sync monitoring
    Skip To Main Content
    Account
    Settings
    Logout
    • placeholder
    Account
    Settings
    Logout
    Filter:
    Submit Search

        Synchronization

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

        ClosedPayment terms
        • Payment terms only exist in Acumatica and are synced to Tipalti.
        ClosedPayees
        • Updated payees are synced from Tipalti and Acumatica.

        • Created payees are synced from Acumatica to Tipalti.

        ClosedCustom 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
        ClosedBills/ 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):
          • 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 Tipalti to Acumatica as "Balanced" bills, before approval:
          • Pending approval

          • Pending AP action

          • Pending payee invoice

          • Pending payee approval

        ClosedPayments
        • 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.

        ClosedGL accounts
        • GLA general ledger (GL) is used for recording transactions related to business assets, liabilities, equity, revenue and expenses. and bank accounts sync from Acumatica to Tipalti.
        • In Acumatica, there are four types of accounts:

          • Liability

          • Assets

          • Expense

          • Income account class

        ClosedTax 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 codeA code for the type of tax applied to a bill line (e.g., VAT-UK) applied to the entire amount on the PO from Acumatica.
        ClosedPurchase orders
        • POs are synced from Acumatica directly into Tipalti.

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

        • 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
        ClosedGRNs
        • 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 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
        ClosedFees
        • 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.

        ClosedGL 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

        ClosedPayees

        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

        ClosedBills

        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

        ClosedPurchase 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)

        ClosedGRNs

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

        ClosedTax 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

        ClosedPayments

        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

        ClosedPayment 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 

         
        • ZD.4.log-1212665864.zip
          20 KB Download
        Was this article helpful?

        We’d love the opportunity to improve. Submit your feedback.

        We’re glad you enjoyed the article!

        Have more questions? Submit a request
        Return to top
        Privacy Policy | Terms of Use | Payer/Sender Rights | Customer Assistance Policy
        LinkedIn Instagram Facebook Twitter YouTube
        Contact support