Note: New sync connections with Microsoft Dynamics GP are no longer available. If you currently have a sync connection with MSDGP, that sync will remain active and unchanged at this time.
Here are some details on transactions and list items to help you make the best of the sync between Bill.com and Microsoft Dynamics GP (MSDGP). This applies to MSDGP version 2015 or newer.
| Object | MSDGP to Bill.com | Bill.com to MSDGP | Notes and Best Practices | |
|---|---|---|---|---|
| General | Close Books Date | No | No | |
| Chart of Accounts | Yes | No | - Account category in MSDGP sets the account type in Bill.com. If no account category is selected in MSDGP, the account in Bill.com will be set to unspecified type. - GL accounts need to have Allow Account Entry (checkbox) enabled GL accounts for transactions to be able to sync to them. - If a user repurposes any categories in MSDGP and changes the type from the default, those accounts will still sync to Bill.com, but the type will be set to the original category in MSDGP. |
|
| Departments | Yes | No | - 1-way from MSDGP to Bill.com - Records from the Departments segment in MSDGP named in sync preferences sync to Bill.com as Departments. |
|
| Locations | Yes | No | - 1-way from MSDGP to Bill.com | |
| Classes | Yes | No | - 1-way from MSDGP to Bill.com - Records from the Classes segment in MSDGP named in sync preferences sync to Bill.com as Classes. |
|
| Employees | Yes | No | - 1-way from MSDGP to Bill.com - Records from the Employee segment in MSDGP named in sync preferences sync to Bill.com as Employees. |
|
| Jobs | No | No | ||
| Currency | No | No | ||
| Bank Account Balance | No | No | ||
| Attachments | No | No | ||
| Approvals | No | No |
| Object | MSDGP to Bill.com | Bill.com to MSDGP | Notes and Best Practices | |
|---|---|---|---|---|
| Payables | Vendors | Yes | Yes | - If a vendor is set to Hold in MSDGP, the vendor in Bill.com will be set to inactive. Remove the hold on the vendor to reactivate in Bill.com. - If you delete/inactivate a vendor in Bill.com, the vendor will be updated to Hold in MSDGP. - The vendor address fields in Bill.com syncs to the Primary address fields in MSDGP. - If the phone number syncs from MSDGP to Bill.com, it is digits only. - If a vendor is flagged as 1099 in MSDGP, transactions created via sync will be marked 1099. |
| AP Funds Transfers | No | Yes | - Bill.com uses the Money Out Clearing GL Accounts to help with bank reconciliation. Because GL accounts only sync 1-way from MSDGP to Bill.com, you'll need to create a checkbook ID and related GL account for each of these accounts in MSDGP. - Sync as Bank Transfer to the checkbook ID for the payment bank GL in MSDGP. |
|
| Bills/Purchase invoices | Yes | Yes | - Bills coded only to GL accounts in Bill.com sync to MSDGP as Payables Transaction Invoices with the details on the distribution table. - Bills coded to items or items and GL accounts in Bill.com sync to MSDGP as Receivings Transactions, with any GL coded expenses detailed on the distribution table. - Unpaid Payables Transaction Invoices or Receivings Transactions in MSDGP sync to Bill.com as bills. - Bills in Bill.com will sync to MSDGP as unposted transactions. - Unpaid posted and unposted Payables Transaction Invoices/Receivings Transactions in MSDGP will sync to Bill.com as bills. - Bills in Bill.com will sync to the AP account linked to the vendor in MSDGP. If there isn't one, it syncs to the default AP in MSDGP. - Class, department, employee, job/project, and customer do not sync on bills/Payables Transaction Invoices/Receivings Transaction as MSDGP uses coding on GL accounts to categorize expenses. These classifications should only be used for the approvals process in Bill.com. |
|
| Bill Payments | No | Yes | - Payments sync to the checkbook ID for the payment account in MSDGP as Manual Payments. - Payments need to be posted in MSDGP. - Payment voids don't sync. Void in Bill.com and MSDGP manually. - Any time you add a new bank account in Bill.com, you’ll need to make sure the account also has a checkbook ID and related GL account before you can sync payments from that account. - Sync to the Payment Journal selected in sync preferences. - Payments won't sync to MSDGP unless the Payables Transaction Invoice/Receivings Transaction is posted. - Non-USD payments will not sync. |
|
| Vendor Credits/Purchase Credit Memos | Yes, unposted purchase credit memos only | Yes, unapplied vendor credits only | - Vendor credits in Bill.com will sync to MSDGP as unposted Payables Transaction Credit Memos. - Unposted Payables Transaction Credit Memos in MSDGP will sync to Bill.com as unapplied vendor credits. - Vendor credits in Bill.com will sync to the AP account linked to the vendor in MSDGP. If there isn't one, it syncs to the default AP in MSDGP. - Applying vendor credits in Bill.com won't sync to MSDGP. You need to apply and post in both sides manually. - If you edit a vendor credit in Bill.com, the update won't sync to MSDGP if the Payables Transaction Credit Memos is posted. - Vendor credits/Payables Transaction Credit Memos with items will not sync. - Class, department, employee, and customer do not sync on payables transaction credit memos as MSDGP uses coding on GL accounts to categorize transactions. These classifications should only be used for the approvals process in Bill.com. - Vendor credits in Bill.com won't sync to MSDGP if the payables transaction credit memo is posted. |
| Object | MSDGP to Bill.com | Bill.com to MSDGP | Notes and Best Practices | |
|---|---|---|---|---|
| Receivables | Customers | Yes | Yes | - If a customer is set to Hold in MSDGP, the customer in Bill.com will be set to inactive. Remove the hold on the customer in MSDGP to reactivate in Bill.com. - If you delete/inactivate a customer in Bill.com, the customer will be updated to Hold in MSDGP. - Customer email address only syncs from MSDGP to Bill.com. Email addresses added to a customer record in Bill.com will not sync to MSDGP. - If the phone number syncs from MSDGP to Bill.com, it is digits only. |
| Invoices/Sales Invoices | Yes | Yes | - Invoices in Bill.com will sync to MSDGP as unposted sales invoices. - Unpaid posted and unposted sales invoices in MSDGP will sync to Bill.com as invoices. - External doc no. is required in MSDGP for a sales invoice to sync to Bill.com. - Invoices in Bill.com will sync to the AR account linked to the customer in MSDGP. If there isn't one, it syncs to the default AR in MSDGP. - Once a sales invoice syncs between Bill.com and MSDGP, you can't edit the invoice in Bill.com. Make edits in MSDGP, and those will sync to Bill.com. - If you add items to an invoice in Bill.com, the related GL account will not sync to MSDGP. The item on the invoice will have the GL mapping set in MSDGP when it syncs. - Sales invoices with item charges, taxes, and discounts will only sync 1-way from MSDGP to Bill.com. - If you create a sales invoice in MSDGP with taxes, discounts, freight charges or misc. charges, the details won't sync to Bill.com, but the total tax amount will, as a separate line item. - Best practice is to create and edit sales invoices in MSDGP. |
|
| Items | Yes | No | - 1-way from MSDGP to Bill.com - Items put on hold in MSDGP will deactivate in Bill.com. Remove the hold in MSDGP to reactivate in Bill.com |
|
| AR Payments | No | Yes | - Payments sync as a Cash Receipt to the checkbook ID for the payment account in MSDGP. - Payments need to be posted in MSDGP. - Payment voids don't sync. Void in Bill.com and MSDGP manually. - Update your payment GL accounts to Bank account type in Bill.com so they can be used for payments and sync preferences. - Any time you add a new bank account in Bill.com, you’ll need to make sure the account also has a checkbook ID and related GL account before you can sync payments to that account. - Payments won't sync to MSDGP unless the sales invoice is posted. - Non-USD payments will not sync. |
|
| Credit Memos/Sales Credit Memos | Yes, unposted sales credit memos only | Yes | - Credit memos in Bill.com will sync to MSDGP as unposted sales invoice returns. - Unposted sales invoice returns in MSDGP will sync to Bill.com as unapplied credit memos. - Credit memos in Bill.com will sync to the AR account linked to the customer in MSDGP. If there isn't one, it syncs to the default AR in MSDGP. - Posting sales invoice returns in MSDGP won't sync to Bill.com. Applying credit memos in Bill.com won't sync to MSDGP. You need to apply and post in both sides manually. - Class, department, employee, and customer do not sync on Credit Memos/Sales Invoice Returns. - Sales credit memo deletions in Bill.com won't sync to MSDGP if the memo is posted. |
|
| AR Funds Transfers | No | Yes | - Bill.com uses the Money In Clearing GL Accounts to help with bank reconciliation. Because GL accounts only sync 1-way from MSDGP to Bill.com, you'll need to create a checkbook ID and related GL account for each of these accounts in MSDGP. - Sync as Bank Transfer to the checkbook ID for the payment bank GL in MSDGP. |
