2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Panel

Panel

Panel

Panel
Overview
DBSync for Inventiv has developed an easy to use integration solution for the customers of Inventiv where data has to be moved in and out of QuickBooks to integrate QuickBooks Customers, Items, Invoices and SalesOrders. DBSync provides Bi-directional sync with pre-built field to field map along with flexibility for more complex and dynamic mapping capability. DBSync also has an automatic online update, enabling DBSync customers to enjoy all the product updates and features with every new release.

...

The first section of the solution explained the very first Business Case .

 {*}Customer Integration:*

The customer integration dataflow constitutes of retrieving data on nightly basis from QuickBooks and integrating it with FTP and file using Inventiv specs on .FIL as file extension. The integration data-flow will always extract all Customers and move to Inventiv FTP system. The scheduler job consists of the following 

...

Proposed Data-Flow Between QB To Inventiv FTP


The Second Business Case data flow is as follows and explained in detailed followed by the data flow diagram 

 Order Integration:

The Order integration from Inventiv SQL Server instance and will periodically retrieve Order data and integrate with QuickBooks Sales Order transactions. The integration data-flow will be incremental in nature and uni-directional with transfer of data into QuickBooks system. 

Proposed Data-Flow Between inventive SqlServer To QB


Image Added