Page History

...

1. QuickBooks To Inventiv FTP (.Fil) Data Exchange 
2. Inventiv DB To QuickBooks Data Exchange 

The first section of the solution explains the very first Business Case i.e. the data flow of Customer, Item, Invoice objects from QuickBooks to PocketAdvantage followed by the image which depicts the process map.

Customer Integration:The customer integration data flow constitutes of retrieving data on nightly basis from QuickBooks and integrating it with PocketAdvantage which involves file creation with .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 

...

•     QuickBooks Item with its respective attributes are retrieved and converted to a tabbed de-limited files with .FIL as its extension
•     The files converted is integrated to a specific folder under inventive FTP system with the folder bearing the naming convention, “latest<cust_id>” as item.fil

*Invoice Integration:*The Invoice Object dataflow will be unidirectional with transfer of data from QuickBooks and integrating it with PocketAdvantage which involves file creation with .FIL as its extension. Integration is invoked overnight at specified interval of time by the scheduler mechanism built inside DBSync platform. The data-flow will be uni-directional and incremental in nature with transfer of data into Inventiv FTP.

The below image depicts the object to object process map of QuickBooks to PocketAdvantage.

...

Proposed Data-Flow Between QB To PocketAdvantage

...

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

 Order Integration:

covers the data flow from PocketAdvatage order to QuickBooks Salesorder  followed by the image which depicts the process map.

*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

...