2022

Page tree

Versions Compared

Key

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

...

DBSync for SkuVault & QuickBooks Online is easy to use integration template to integrate . It integrates SkuVault  Supplier, Item, Sales Order, Purchase Order with QuickBooks  VendorsVendors, Item, Estimate, and Purchase Order respectively. This template provides Uni-directional sync with a 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 Warehouse Management System and QuickBooks online application is as shown in the table below table.    


Panel

Anchor
_Toc498733199
_Toc498733199
Process Flow

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

  • SkuVault warehouse management system Warehouse Management System to QuickBooks online.

The predefined template provided by DBSync iPaaS platform constitutes the data-flows in a template that 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 online:

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

...

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

...

The Purchase Orders are generated within SkuVault. The integration retrieves Purchase Orders and Purchase Orders Line items from SkuVault and constantly link links them with QuickBooks Online Purchase Order and Purchase Order Line items on an incremental basis and also flag . Furthermore, the integration also flags 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.

...

SkuVault Contact details from Sales Order will be integrated with QuickBooks Online Customer module. Integration is invoked based on the last successful run in DBSync. Then, 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.

...

The Sales Order and Sales Order  Line items are generated within SkuVault and constantly link links them with QuickBooks Online Estimate on an incremental basis and . Furthermore, the integration also flag them based on the status of SkuVault SalesOrder. Integration is invoked when shipment status in SkuVault is set as “Pending Payment”. Then, 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. 

...

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


Panel

Anchor
_Toc498733299
_Toc498733299
Running The Integrations:


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 the Run-now button from the process listing page; or, from the workflow listing page. 

Using DBSync Scheduler 

...