Connex can pull a list of objects from Salesforce. You could create an object called events and map the event to a sales receipt in QuickBooks. Based on the one you select, Connex will pull a list of fields to map. In this example, we created a custom object called invoice and we will map the fields.
What does a mapping look like?
Here is an example mapping.
How do I add field mappings?
In this example, our custom object is called Invoice__c. Here are the steps:
- Login to Connex.
- At the My Connections page, select Salesforce under existing connections.
- Click configure.
- Go to the custom object mapping page.
- Click add.
- Select your custom object, the field name, and the field name to map. In this example, we will map the QB date and Salesforce date fields:
How do I map order items?
Connex can search the Salesforce order items table for line items. You must map the order ID. Add this mapping:
My custom object has no order items. It has a single product. How do I map the fields?
You can select the order detail field. Refer to the example mapping at the beginning of this article.
How does Connex filter custom objects?
Connex can filter custom objects by their creation date or their Salesforce Id. To filter by date, go to the Connex configure page. Scroll down to Export settings and change the date. To filter by ID, go to the order export tab. In the order list field, enter a comma-separated list of IDs.
How can I map a relationship to the contact or account objects?
In the custom field name drop down, you can select account ID or contact ID. Connex will map the name, phone, and email from those fields.
If I update my custom object in Salesforce, can Connex update the order in QuickBooks?
Yes, Connex can track updates. Login to Connex. Click configure. Expand the advanced transaction tab and select update orders.
How do I test the field mappings tool?
You can use our order previewer:
- In Connex, click the settings gear on the right.
- Click reports.
- Select order previewer.
- Enter a date range when the custom objects were created in Salesforce.
In this example, our tool will query for all custom invoices made since 2015.