You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 3
Next »
Many of the business user want to integrate QuickBooks reports with the Database object , I always come across with the one very question from a standard business user of the QuickBooks that Can QuickBooks reports be integrated to Database ? The short answer is yes if a user wants a specific report to be sent to Database, DBSync can handle it . In this tutorial we would be learning how a data from QuickBooks P&L report is read and exported to Database using DBSync Platform.
QuickBooks P&L Report To Database Import
- Login to DBSync with valid credentials
- Create a project with name of your choice.
- Create connectors preferably of type DataBase and QuickBooks Desktop.
- Configure the QuickBooks Desktop connector which is supported by DBSync, Please refer to DBSync QuickBooks Desktop connector documentation.
- Configure the DataBase Connector with any DB which is supported by DBSync, please refer to DBSync DBConnector documentation for more information.
- Create a process with meaningful name like QBP<oDB which will be easy for other users to understand .
- Create a workflow with valid name , Trigger and Rules as explained in latter sections .
Trigger Setup
- Select the data-source as QB
- Build a query from the Advanced Query builder which would fetch the data from the Report.
Rules Setup
- Add a rule with name of user choice, select the DB connector and operation as insert.
- Choose an object as customdetail report.
- Now user has to do the mapping as per their need.