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. Microsoft Business Central

Articles in this section

  • Microsoft Business Central
  • 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 BC and Tipalti.

        ClosedPayment terms
        • Tipalti supports only payment terms that depict a number of days after the invoice date, thus only terms of the format shall be synced.
        • Only payment terms that were synced from BC may be used on payees (otherwise their sync will fail).
        ClosedPayees
        • Existing vendors are synced from BC to Tipalti during the first time sync.
        • Vendors in BC have a Vendor Posting Group (VPG) field which indicates their AP account. This should be configured in Tipalti as a custom field of type list, and mapped in the configuration wizard, or else the default VPG will be set in BC.
        • The payee’s selected payment method is synced to BC. If the payment method wasn’t selected, the payment method configured as default in BC will be set in BC. If the payment method is CASH - BC will automatically mark the approved bill (posted purchase invoice) as ‘Paid’ in BC, and the actual payment details won’t be synced.

        ClosedCustom fields
        • In BC, ‘location’ is a native field and can be mapped as a custom field of type list on bill/VC header/ lines.
        • Dimensions are read from BC to Tipalti and may be mapped with Tipalti’s custom fields.
        • The chosen custom field value on a bill or VC header / line is synced to BC, as part of the invoice’s sync.
        • Custom field value deletions and status change (active/inactive) in BC are not synced to Tipalti. Thus, if you delete a value in BC you need to manually delete it in Tipalti, under Administration > General > Custom fields.

        • Project and task fields are mapped as custom fields in Tipalti.

        ClosedBills
        • Bills in the following statuses are synced automatically from Tipalti to BC as posted purchase invoices:
          • Pending payment
          • Scheduled for payment
          • Submitted for payment
          • Paid
          • Partially paid
        • Currently, syncing bills before approval is not available.
          • Edit post approval is supported (according to the bill’s settings), but this will be synced to BC same as retract approval, since BC doesn’t allow editing posted invoices.
          • Retract approval is supported. The bill will be reversed in BC (by applying a purchase credit memo to it) and a new invoice with the original invoice number with a suffix will be created, with the updated information, once it is reapproved.
        ClosedBill attachments

        Invoice files can be automatically synced to BC and downloaded from within the bill record under Incoming Document Files.

        To sync bill invoice files:

        • In the Sync Wizard screen, under Sync Preferences, check the Sync bill image box.

         

        ClosedVendor credits

        Vendor credits are synced as ‘Posted Purchase Credit Memos’ to BC, similar to bills, with the exception of:

        • Voiding and updating vendor credits is currently not supported: the purchase credit memo should be canceled manually in BC.
        ClosedPayments
        • Payment are synced from Tipalti to BC.
        • Currently only payments paid from accounts with the same currency as the payment will be synced to BC (No payer Fx). Multi-currency payments with Fx must be entered manually to BC.
        • Void payments are not synced, thus a voided payment must be handled manually in BC (E.g., a rejected payment).
        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 BC to Tipalti.
        • Currently all accounts (excluding bank accounts and AP accounts) are displayed on the bill line expense accountThe general ledger (GL) account that is debited for the payment amount drop down.
        • Bank accounts with no currency are set in Tipalti with the company’s base currency from BC.
        • A deletion of a GL account or bank account in BC is not synced to Tipalti, but blocked accounts aren’t synced and will be updated as inactive in Tipalti if already synced.
        ClosedTax codes
        • Tax tables sync as codes from BC to Tipalti

        • Support for synchronizing tax codes and their associated amounts on transaction lines in BC.

        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

        This section details the mapped fields between Tipalti and BC.

        Mapped fields

        Tipalti

        BC

        Number Number
        Name Display name
        External ID System ID (internal)
        ClosedBank accounts

        Mapped fields

        Tipalti

        BC

        Number Number
        Name Display name
        Currency* Currency
        External ID System ID (internal)

        * If the currency from BC is empty - the company’s currency in the ERP will be used.

        ClosedPayees

        Mapped fields

        Tipalti

        BC

        Payee ID Not mapped with BC
        Alias No.*
        Company name / or first + last + middle name** Name
        Email Email
        Payee entity type Partner type (individual maps to person)
        Company name Name (if payee entity type = ‘Company’)
        First name Name - first part (if payee entity type = ‘Person’)
        Last name Name - second part (if payee entity type = ‘Person’)
        Street 1 First Address line
        Street 2 Second Address line
        City City
        State State
        Zip Postal code
        Payment term Payment term
        Payment method Payment method***
        (ExternalID) - Appears in Sync failures as BC ID System ID (internal)

        *Only synced during the first time sync from BC, since the numbering convention can be set in BC and must be unique.

        **When syncing a payee from Tipalti, the name is determined according to the payee entityAn entity can be a subsidiary, division, business unit, brand, etc. of your organization. Entities can have similar or different AP processes and workflows. type:

        • Company: the Name will be equal to the company name

        • Person: first + middle + last name (whichever exists)

        When syncing a payee into Tipalti - the same logic will apply in reverse (for person - first name will contain the first word from the name field, and last name will contain the last word from the name field).

        ClosedBills

        Mapped fields

        Tipalti

        bc

        Payee external ID Maps to vendor
        Due date Due date
        Invoice date Invoice date
        Invoice date Posting date
        Invoice number Vendor invoice number
        Currency Currency code
        Bill line Quantity Bill line Quantity
        Bill line Unit price Bill line Unit price
        Bill line Description Bill line Description
        Bill line Expense account Bill line Account
         
        ClosedVendor credits

        Vendor credits are synced to BC as credit memos. The mapping is identical to bills.

        ClosedPayments

        Mapped fields

        Tipalti

        Xero

        Tipalti payee Maps to vendor
        Account (Virtual Account ID) Bal. Account No.
        Transaction date Posting Date
        Refcode External document ID
        Payment Amount Amount
        * In Xero UI: Details to appear on your bank statement
        • 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