2022

Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 21 Next »

Overview
Data Flow
Process Map

Overview

DBSync for SkuVault & QuickBooks Online is easy to use integration template to integrate SkuVault  Supplier, Item, Sales Order, Purchase Order with QuickBooks  Vendors, Item, Estimate and Purchase Order respectively. This template provides Uni-directional sync with a pre-built field to field map along with the flexibility for more complex and dynamic mapping capability. 

Data Flow

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


Process Flow

The data flow is explained in the later sections of this tutorial which is a standard predefined template provided by DBSync iPaaS to its customers.

  • SkuVault warehouse management system to QuickBooks online

The predefined template provided by DBSync iPaaS platform constitutes the data-flows in a template which makes ease of use to maintain and for running the data sync as per the convenience of customer business requirements.

SkuVault warehouse management to QuickBooks online

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

  • Vendor Integration:

SkuVault Suppliers are integrated with QuickBooks Online Vendors module. The data flow between the entities are unidirectional with the transfer of data from SkuVault into QuickBooks Online, based on last success run in DBSync.

  • Purchase Order Integration:

The Purchase Orders are generated within SkuVault. The integration retrieves Purchase Orders and Purchase Orders Line items from SkuVault and constantly link them with QuickBooks Online Purchase Order and Purchase Order Line items on an incremental basis and also flag them as completed Purchase Order. Purchase Order with Kit information is not supported in the present integration template. Any update in SkuVault Purchase Order can be integrated within Purchase order QuickBooks Online.

  • Customer Integration:

SkuVault Contact details from Sales Order will be integrated with QuickBooks Online Customer module. Integration is invoked based on last success run in DBSync, the Contact details will be transferred from SkuVault into QuickBooks Online as Customer. The data flow between the entities will be unidirectional with the transfer of data from SkuVault into QuickBooks.

  • Sales Order Integration:

The Sales Order and Sales Order  Line items are generated within SkuVault and constantly link them with QuickBooks Online Estimate on an incremental basis and also flag them based on the status of SkuVault SalesOrder. Integration is invoked when shipment status in SkuVault is set as “Pending Payment”, the Sales Order details are transferred from SkuVault into QuickBooks Online based on Customer Name. SalesOrder with Kit information is not supported in the present integration template. 

  • Item Integration:

SkuVault Products are integrated with QuickBooks Online Item as flat structure. Integration is invoked based on last success run in DBSync, the Item details are transferred from SkuVault into QuickBooks Online. The data flow between the entities are unidirectional with the transfer of data from SkuVault into QuickBooks.


Running The Integrations


DBSync integration of SkuVault & QuickBooks can be triggered by

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

Using Run-Now Buttons From DBSync platform

The user can login to DBSync with his valid credentials and hit the Run-now button from the process listing page or from the workflow listing page. 

Using DBSync Scheduler 


  • No labels