2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

Process of customizing DBSync Mapping is explained with the example in this section. Three custom fields are created in MS CRM  Product Object & QuickBooks Item. The steps shown below explains DBSync customization process to integrate these custom fields of MS CRM and QuickBooks.

  • Create custom fields in Product Object of MS CRM named as
    • ReOrder Quantity
    • Inventory Site
  • Create the same fields in Item of QuickBooks.
  • 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 Project console.
  • Click on Project on the left panel, you will see list of project. You will see a default project for MS CRM & 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 MS CRM and QuickBooks Connectors. Ensure that both the connectors are validated.
  • If you are using MSCRM & QuickBooks BiDirectional process, you will find a list of workflows. Click on the workflow ProductToInventory.
  • You will see the list of available fields in MS CRM 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 VALUE("ColumnApiName") in 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
    • new_reorderquantity = VALUE("Re-Order Quantity")
    • new_inventorysite= VALUE("Inventory Site")
  • Once done, click on the Save & Close button on the top right to close.
  • Go to Windows Start > Programs > QuickBooks > Web Connector.
  • Web connector is launched with the selected integration profile. Select the integration profile/profile Name, Enter DBSync password and finally click on "Update Selected" to perform the sync. The Custom Fields in QuickBooks will be populated with Data in MS CRM.
  • Check your MS CRM and QuickBooks Instance for updated data.

Note- If the QuickBooks field is Custom Defined, Add Custom Defined Label.