Minimum Version Required: 24.04
Pre-Conditions
Encompass Financials customers only
Companies.EnableEncompassAP = True
In scope of the integration:
Vendors
Accounts
Bank Accounts
Bills
Bill Credits
Documents
Bill Description
Line item Description (Pull Purchases only)
Outbound Payments
AP Payment Application
Multiple Currencies
Multiple Companies/Entities
Approval Status respected
Not in scope of the integration:
Sales Invoices
AR Receipts
Accounts Receivable
Products/Items
Classifications (Locations, Departments, Classes, etc.)
Steps
The Bill.com Sync dashboard has 5 primary workflows:
1. Login: Connects ECP to Bill.com using the saved login credentials
2. Send Vendors: Sends AP Accounts with ListID IS NULL to Bill.com and matches on/creates Vendors in Bill.com (populates APAccounts.ListID with LIKE '009%’)
3. Pull Accounts: Pulls Accounts from Bill.com, finds an exact match in Encompass (Account to Accounts.Account) and links (populates Accounts.ListID with LIKE '0ca%’) and creates new ECP Accounts for any Bill.com Accounts that did not find a match
4. Purchases Sync: (Note: The Vendor on the Purchase must be synced first)
Send Purchases: Sends Purchases in >= Confirmed Status with TxnID IS NULL and Open Balance <> $0 from ECP to Bill.com and creates Bills in Bill.com
Pull Purchases: Pulls Bills from Bill.com and creates Purchases with TransType = Accounts in ECP
5. Payments Sync: Pulls Payments from Bill.com, creates Check Runs in ECP and applies payments to the Purchases.
To get started:
Select the Company you want to connect to Bill.com and Click Login
Click Send Vendors
Click Pull Accounts
Select the appropriate date range - this references Purchases.PostDate. Click Send Purchases
Select the appropriate date range - this references Invoice Date in Bill.com. Click Pull Purchases
Payments Sync: Select the appropriate date range - this references Process Date in Bill.com. Click Payments Sync