2022

Page tree

Versions Compared

Key

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

...

  • Go To www.mydbsync.com select Customer Login. Enter your User Name and Password and click on Sign in. Click on Launch to launch DBSync integration Project console.
  • In DBSync console click on Edit Link from Manage Toggle Button.
  • Click on Edit link for Salesforce Adapter. Enter Salesforce User Name and Password and click on Save Properties button. Click on Validate button to validate the Adapter.
  • Click on Edit Link for QuickBooks Adapter. Enter QuickBooks File Path in file text box and click on Save Properties.
  • Double Click or Right Click to open the BiDirectionalSync Process for editingClick on Project on the left panel, you will see list of project. You will see a default project for Salesforce & QuickBooks integration.
  • Click on the project, you will see the process. Click on that process to open available workflows.
  • On the left side of the project console, click on Connectors, you will see Salesforce and QuickBooks Connectors. Ensure that both the connectors are validated.
  • If you are using SalesforceQuickBooksBiDirectional profile process, you will find a list of states with control flow on process Builder Screen. Double click on ProductToInventory State to open data flow as highlighted below.
  • Right Click on Properties on Map to open the mapping properties.
  • Click on Edit link for **********_map.xml file to open the mapping screen.
  • The mapping screen contains all the default mappings as shown below.
  • workflows. Click on the workflow ProductToInventory.
  • You will see the list of available fields in Salesforce in the main section of mapping screen. On the right section of the mapping screen, you see schema. Schema will have list of QuickBooks fields.You can add a new mapping by Entering the target field path in target field followed by the entering VALUE("ColumnApiName") in description field and clicking Save button. An Example of the mapping is shown below:Similarly add the rest of the the field next to the required Target field i.e. QuickBooks field. You can just drag & drop the required field from Schema into the target field.
  • Add the mappings as shown below
    • ItemInventoryAddRq/ItemInventoryAdd/ItemType =VALUE("Item_Name__c")
    • ItemInventoryAddRq/ItemInventoryAdd/ReorderQuantity =VALUE("Reorder_Quantity__c")
    • ItemInventoryAddRq/ItemInventoryAdd/Weight = VALUE("Weight__c")
  • Once done, click on the close button on the top right to close. Move to Previous window (Data Flow screen) and click on Save & Close button on the top right . This will save the BiDirectional sync profile.to close.
  • Go to Windows Start > Programs > QuickBooks > Web Connector.

...