2022

Page tree

Versions Compared

Key

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

...

DBSync for SkuVault & QuickBooks desktop is an easy to use integration template to integrate . It integrates SkuVault item, supplier, sales-order, purchase order with QuickBooks item, vendors, sales orders and purchase order respectively. This template provides Bi-directional sync with pre-built field-to-field map mapping along with the flexibility for more complex and dynamic mapping capability. 

...

The Data-Flow of SkuVault warehouse management system and QuickBooks desktop application is as shown in the table below table.    

Panel
Process Flow 

The data flow is explained in the latter sections of this tutorial which - it is a standard pre-defined template provided by DBSync iPaaS to its customers.

  • SkuVault warehouse management system to QuickBooks desktop desktop. 
  • QuickBooks desktop to SkuVault warehouse management system.

The predefined template provided by DBSync iPaaS platform constitutes both the data-flows in one single template which makes ease of use to maintain and for running . This results in easy maintenance and enables customers to run the data sync as per the convenience of customer their business requirements.

SkuVault warehouse management to QuickBooks desktop 

This section explains the data flow from the SkuVault warehouse management system to the QuickBooks application and sensationalized . It is customized as per entity so that the readers can understand the integration requirement and configure their template without any help from DBSync support teams. 

  1. Customer Integration: The customer integration Customer Integration data flow constitute of constitutes retrieving data from Sale-Order contact Contact details of the SkuVault and integrating it with QuickBooks as a customersCustomers.
  2. Items Integration: The item integration Item Integration data flow constitute of constitutes retrieving data from the items of the SkuVault system and integrating it with the item module Item Module of the QuickBooks as items Items. 
  3. Supplier Integration: The supplier  Supplier integration data flow constitute of constitutes retrieving data from the Supplier module of SkuVault and integrating it with the vendor module Vendor Module of the QuickBooks as vendors Vendors. 
  4. Purchase-Order Integration: The purchase order  Purchase Order and its line items integration data flow constitute of constitutes retrieving data from the purchase order Purchase Order module of the SkuVault and integrating it with the purchase orders Purchase Orders of QuickBooks.
  5. Sales-Order Integration: The sales order  Sales Order and its line items integration data flow constitute of constitutes retrieving data from the sales module Sales Module of the SkuVault system and integrating them it with the sales orders Sales Orders of QuickBooks.
QuickBooks desktop To SkuVault

...

Warehouse Management:

This section explains the data flow from QuickBooks application to the SkuVault warehouse management system and sensationalized Warehouse Management System. It is customized as per entity so that the readers can understand the integration requirement and configure their template without any help from DBSync support teams. 

  1. Items Integration: The item integration Item Integration data flow constitute of constitutes retrieving data from the item list of the QuickBooks and integrating it with the inventory module Inventory Module of the SkuVault system as productsProducts.
  2. Supplier Integration: The vendor integration  Supplier Integration data flow constitute of constitutes retrieving data from the vendor's list of the QuickBooks and integrating it with the supplier module Supplier Module of the SkuVault system as productsProducts
  3. Purchase-Order Integration: The purchase order  Purchase Order and its line items integration data flow constitute constitutes retrieving data from the customer module Customer Module of the QuickBooks and integrating it with the PO module of the SkuVault system as the purchase ordersPurchase Orders.
  4. Sales-Order Integration: The Sales  Sales Order Integration and its line items integration data flow constitutes of retrieving data from the sales module Sales Module of the QuickBooks and integrating it with sales module Sales Module of the SkuVault system like the sales order Sales Order and its line items respectively.

...

DBSync integration of SkuVault & QuickBooks can be triggered ushered by:

  1. Using the run-now button from the process listing page of DBSync.
  2. Using DBSync Scheduler.

Using Run-Now Buttons From DBSync platform:

The user can log in to DBSync with his/her valid credentials and hit . Then, either click on the Run-now button from the process listing page; or, from the workflow listing page. 

Using DBSync Scheduler Scheduler: 

  • Scheduler available in DBSync Account can be used to schedule the integrations and the detail . Details pertaining to DBSync scheduler is available from the link http://help.mydbsync.com/docs/display/dbsync/Scheduler.