Bill.com

overview bill com is a 3rd party service for managing payments to vendors gravity has developed integration into the bill com application to synchronize core financial information such as accounts and vendors and transactions such as vouchers and payments gravity will retain the system of record for accounts payable, maintaining 100% of all payables master files and transactions bill com will be an extension of gravity allowing easy import of vendor bills and payments vendor bills can be entered in gravity or bill com all open bills will be synced to bill com for payment payments will be synced back to gravity synchronization data between gravity and bill com will be synchronized based on the table to the right for example, vendors and bills can be entered in either system and synced to the other settings in gravity in gravity users must turn on “require document numbers on vouchers” bill com requires that an invoice number (document number) be entered for all bill synced invoice numbers must be unique as bill com uses them as a key to the record setting in bill com in bill com you will need to set the following options under the settings >preferences area show account numbers = yes use locations = yes (if using inventory) use classes = yes (if using dimension 1) use items in payables = yes (if using inventory) vendor/customer sequence id = enter id manually show chart of accounts on bill and invoice items = yes show gl posting date on bills and invoices = yes limitations the following are limitations in v1 of the gravity to bill com sync payables only – currently only the accounts payable will sync, accounts receivable will be in a future version dimension 1 only – only dimension 1 will sync to bill com classes dimensions 2 and 3 will not sync only open bills – bill com will only maintain history of open bills synced and paid in bill com bills entered and paid in gravity will not sync to bill com on vouchers, document numbers must be unique if a document number is duplicated the bill will not sync setup to setup the bill com sync perform the following steps establish the bill com account – gravity will work with all versions of bill com create a bill com administrative user with a password install the gravity bill com solution in the gravity organization select bill com from the list of application in gravity select the down arrow next to dynamics 365 select the “bill com sync” application to return to gravity select “dynamics 365 custom” select bill com sync settings select new to create a new sync setting enter the following username – enter the username of the bill com admin password – enter the bill com admin password for the above user instance – select production unless setting up a sandbox for testing bank account – select the bank account in gravity that represents the account in bill com entity configuration – select the entity in gravity that represents the company being synced save the record select the bill com organization that relates to the login information save and close the record first sync the gravity sync uses the modified date on records to know if a record has changed on either side so it can sync the records to the other application to initially sync records for the chart of account, items, dimensions you should select a date that precedes the creation of your gravity database this will ensure that all master files are synced to bill com gravity will not sync paid bills the initial sync can take some time as gravity will be reviewing all the relevant records and syncing all the master files optionally you can show the real time sync and error logs you will receive errors when items cannot be synced syncing data the gravity sync uses the modified date on records to know has changed on either side and when to sync the records when selecting the start sync option the sync will automatically start from the date and time of the last sync if needed you can adjust the sync date to capture earlier activity each sync is recorded in the sync log at the bottom of the page syncing errors records will not sync to bil com if there are errors where bill com does not have enough information to process the record gravity keeps a log of all activity synced and sync errors the error log will identify the record id (guid in gravity), the entity name (bill or gr aptransactionheadr) and sync type (bill com to gravity) errors can be corrected in the appropriate system and a new sync performed examples are terms codes missing number of days due vouchers missing invoice (document) numbers vouchers with duplicate invoice numbers known issues on installation of the bill com sync solution the workflow is not enabled in some instances you will see it in the installation log to correct it you must open the bill com sync solution and enable it from the browser session where the solution was installed enter the following url https //make powerapps com/ select the organization that is using the bill com sync select the bill com sync solution select flow in the object type selection box select the one flow that is shown under the ellipses select the turn on option