Page History

...

• If Quickbooks QuickBooks Customer and Salesforce Account object has hierarchy structures enabled, then the following changes have to be implemented within your DBSync mappings/template to facilitate hierarchy mappings. A typical hierarchy structure in Salesforce Accounts and Quickbooks Customer entities is as shown below.

                                              Image Removed        Image Removed    Image Removed

• Let's say Avankia & DBSync are Parent & Child Account respectively in Salesforce. Also, Avankia & DBSync are the Customer & Job in QuickBooks respectively.

• The default mappings within DBSync standard template integrates the above Salesforce Account records as two separate Customer records  "Avankia" and DBSync" and not  - as opposed to Parent & Child records.

• Login to your DBSync account accounts with the your user credentials to make changes or create hierarchy mappings. Once you have the user has logged into your his/her DBSync account, then click on Launch to Launch DBSync integration console.

Image Removed

• Click on Manage ? Edit  to navigate to the Process Builder page.

Image Removed

• Double click on BiDirectionalSync process on the extreme right hand corner of the Process Builder Page.

...

• Once inside the process builder page, create new State / Wokflow named as Account to Customer2 as illustrated in the below two screenshots.

...

• After Creating the state AccountToCustomer2, link it with AccountToCustomer state as shown in screen shot below.

...

• Open the AccountToCustomer2 State/Workflow and add Reader, Writer, Map & Status Writer properties from AccountToCustomer statethe Development Studio to go to the DBSync Project page.

• Click on Projects page user will get a list of available projects and select the relevant project from the list.

• Users will get a list of available processes under the project section. Click on the relevant process to see a list of available workflows.

• Click on Create New Workflow and enter the workflow name AccountToCustomer2 and Save.

• After Creating the workflow 'AccountToCustomer2', move this next to the 'AccountToCustomer' workflow.

• Open the 'AccountToCustomer2' workflow to add Trigger and Rule properties from the 'AccountToCustomer' workflow.

• Once all the properties are filled, copy all the mappings from AccountToCustomer mapping windowthe 'AccountToCustomer' mapping page.
• Once the mappings are completed, add the following changes in the Mapping window as shown in the below screen shots"Mapping page".
  
  

Target == "CustomerAddRq/CustomerAdd/ParentRef/FullName"

...

Source Field == "VALUE("Parent/Name")"

...

• Now make use the following changes query in 'AccountToCustomer2 reader ' Trigger using Advanced Query Builder.
  Make change in Reader Query with the below
  

...

 select {!.} from Account where AVSFQB__QuickbooksQuickBooks_Id__c = '' and Parent.Name!='' 

Image Removed

• Similary change AccountToCustomer reader query Similarly, replace 'AccountToCustomer' query with the query below code.:
  
  

 select {!.} from Account where AVSFQB__QuickbooksQuickBooks_Id__c = '' and Parent.Name ='' 

• Once you are the user is done with all the above-mentioned changes, run the sync and data then "initiate the integration through web connector". Data will be integrated into Quickbooks QuickBooks with their respective hierarchies in place as shown below.:
  Image Modified

• This concludes Account hierarchy mappings for the data-flow from Salesforce into QuickbooksQuickBooks.