To help best manage your accounts payable and receivable, here are some things to know about the customer and vendor sync between Bill.com and Microsoft Dynamics GP (MSDGP).

Vendors

• 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 the phone number syncs from Bill.com to MSDGP, the field will populate area code first (3 digits), followed by prefix (3 digits), line number (4 digits), then extension (4 digits).
  • If there are fewer than 10 digits, it fills in the area code first. ex (xxx) xxx-xx.
  • If the number has between 10-14 digits, it will populate as (xxx) xxx-xxxx ext xxxx or (xxx) xxx-xxxx ext 00xx.
  • MSDGP adds leading zeros to the extension if the ext is less than four digits.

Customers

• 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.
• If the phone number syncs from Bill.com to MSDGP, the field will populate area code first (3 digits), followed by prefix (3 digits), line number (4 digits), then extension (4 digits).
  • If there are fewer than 10 digits, it fills in the area code first. ex (xxx) xxx-xx.
  • If the number has between 10-14 digits, it will populate as (xxx) xxx-xxxx ext xxxx or (xxx) xxx-xxxx ext 00xx.
  • MSDGP adds leading zeros to the extension if the ext is less than four digits.