{"id":15377,"date":"2019-04-11T11:03:02","date_gmt":"2019-04-11T11:03:02","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=15377"},"modified":"2021-06-04T11:10:57","modified_gmt":"2021-06-04T11:10:57","slug":"integrate-intuit-quickbooks-dynamics-365-crm-using-inolink-maintain-data-integrity","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2019\/04\/integrate-intuit-quickbooks-dynamics-365-crm-using-inolink-maintain-data-integrity\/","title":{"rendered":"Integrate Intuit QuickBooks with Dynamics 365 CRM using InoLink to maintain data integrity"},"content":{"rendered":"

\"\"<\/p>\n

Have you ever wondered a scenario where you could view the accounting data of your organization within Dynamics CRM to expedite your business process? We have just the right solution for you! InoLink is a tool that integrates Dynamics 365 CRM with your accounting software Intuit QuickBooks. It allows Sales team of an organization, which does not have access to Intuit QuickBooks or accounting information of its organization, to view this data in Dynamics CRM.<\/p>\n

In our last release<\/a>, we hosted InoLink on Azure, made it real-time, and extended the support of one instance of Dynamics CRM to multiple QuickBooks companies. As we believe in keeping ourselves updated with technology we came up with another recent release. Yes! We have modified InoLink and added one more functionality to it, now you have the option to promote data from Dynamics CRM to QuickBooks based on option set. What is option set? As InoLink supports multiple QuickBooks companies\u2019 data sync with single instance of Dynamics CRM, how can you segregate different QuickBooks companies\u2019 data while syncing?<\/p>\n

Here option set comes in the picture, basically, you can have option set<\/strong> type of field on your Account and Contact entity to sync your QuickBooks companies\u2019 data based on the option set field which is present on Account and Contact in Dynamics 365 CRM. This makes promoting data from Dynamics CRM to QuickBooks Company more organized.<\/p>\n

Let\u2019s consider a use-case. Suppose you have two companies in your QuickBooks, one to manage Supplier<\/strong> Type<\/strong> of customers and another to manage Client Type<\/strong> of customers. Type<\/strong> is a field that exists in Dynamics CRM. Now you want to sync data between QuickBooks and Dynamics CRM in such a way, that data from first QuickBooks<\/strong> customer is synced with Supplier<\/strong> Type <\/strong>in Dynamics CRM and data from second QuickBooks <\/strong>customer is synced in Client Type <\/strong>in Dynamics CRM. For this we can use option set field, we define the filter criteria as Type<\/strong>. The data with customer Supplier<\/strong> will search if there is a same record with Type<\/strong> Supplier<\/strong> in Dynamics CRM. If a same record exists, it will simply update the record and if not, it will create a new record with Type<\/strong> as Supplier<\/strong> in Dynamics CRM and similarly, it will search and perform action for Type Client<\/strong>. Thus data is synced in corresponding companies based on option set. This maintains data integrity and allows data sync in a streamlined manner.<\/p>\n

This was the update of our latest release. Let\u2019s understand InoLink\u2019s functionality better.<\/p>\n

As you know, InoLink provides two-way synchronization of data in Account, Contact, Products, and Prices, which means as soon there is a data update in QuickBooks or Dynamics CRM in these Entities, it reflects in both the systems by synchronization. Here, if a record doesn\u2019t exist in one of the systems it is auto-created. These entities can be unlinked at any time allowing you to choose to stop synchronization of this data.<\/p>\n

There is no provision to send data from Transaction History (Estimate, Credit Memo and Invoice) from QuickBooks to Dynamics CRM in OOB entities, so we ship a custom Entity Sales Transaction <\/strong>with InoLink. We have only one-way one-time promotion from Dynamics 365 CRM to QuickBooks. Once this synchronization takes place you cannot repeat the process. However, you can alter the data in these Entities manually. At any point of time, you can choose to bulk transfer data from Dynamics CRM to QuickBooks or otherwise. This transfer runs in batches as there is concurrency error in QuickBooks if all the data is transferred at once. Apart from bulk transaction, there is also real-time synchronization of data from Dynamics 365 to QuickBooks which means as soon there is an update in Dynamics CRM it is reflected in QuickBooks.<\/p>\n

Using InoLink you can also trace the Aging Details i.e., when an invoice is created but payment is still pending, one is able to see for how long the payment has been pending and is reflected in Accounts and Contact entity of Dynamics CRM. As both the systems are linked so there is seamless data synchronization but no duplication. Using InoLink it is also possible to calculate tax in Quote\/Order\/Invoice.<\/p>\n

Thus you have seen how using InoLink all your accounting needs are met from within Dynamics 365 CRM. Let\u2019s explore further and take a glance at the benefits of InoLink:<\/p>\n