This article gives you step by step instructions for creating orders in QuickBooks and having them appear in Salesforce.
Salesforce is missing several fields from QuickBooks. Does your software add custom fields to Salesforce?
Install this package, that creates a custom object called invoice. The invoice object contains a list of fields from the QuickBooks transaction. When prompted, select install for all users. Here is a screenshot of the fields:
Project and FOB were added on November 1, 2019.
Can I see a list of QuickBooks orders for an account?
In the layout, you can add a section for invoices. When you search for an account, you will see a list of associated orders. Here are the steps:
- On the top right of Salesforce, click your profile icon.
- Click switch to Salesforce classic.
- In Salesforce, click accounts.
- Select an account.
- Click edit layout.
- Click related lists:
- Drag and drop the invoice to the bottom of the form:
- On the top, click save.
If you look up the JMA Web Technologies account, you will see a list of invoices:
How do I sync an order from QuickBooks Online to Salesforce?
Each order will have a class called Salesforce. This tells our software to send the orders to ShipStation. This class prevents orders from Salesforce from going into QuickBooks and back to Salesforce. To enable class tracking, follow these steps:
- In QuickBooks, click the gear > company settings.
- Click track classes > on:
- Click save.
- In QuickBooks, click customers on the left.
- On the top, click new > invoice or new > sales receipt.
- On the top of the order, enter Salesforce as the class.
- Complete the order.
- Click save.
In our install Wizard, you must ask Connex to sync from QuickBooks.
- Login to Connex
- On the My Connections page, add a new connection and choose Salesforce. Follow the on-screen instructions.
- In the install wizard, select sync orders from QuickBooks to Salesforce.
- Complete the form and click submit.
- Wait a few minutes.
- Check the log for progress.
How do I sync an order from QuickBooks Desktop to Salesforce?
You must set-up your Salesforce connection on the my connections page:
- Login to Connex.
- On the my connections page, add a new connection and choose Salesforce. Follow the on-screen instructions.
- Choose sync orders from QuickBooks as the sync direction.
- Follow the install wizard to the end.
You must create an invoice or sales order in QuickBooks. It must have a class called Salesforce. Here are the steps:
Each order must have a class called Salesforce. To enable class tracking in QuickBooks, follow these steps:
- In QuickBooks, go to edit > preferences > accounting > use class tracking for transactions.
- Create a new invoice in QuickBooks and mark the class as Salesforce.
In QuickBooks, create a new invoice or sales order.
You must run the web connector to send orders to Connex:
- In QuickBooks, go to File > Update Web Services.
- Next to Connex, check the box on the left.
- Click update selected.
If you have auto run enabled on the web connector, you could wait for it to run. Updating or creating an order in QuickBooks will cause the web connector to send the order to us for processing.
How do products match?
Connex matches the QuickBooks item name to the Salesforce product code.
How do accounts match?
Our software matches the QuickBooks customer name to the Salesforce account name field.
Can I sync orders as opportunities?
By default, Connex syncs QuickBooks orders using our custom invoice object. To sync orders as opportunities, follow these steps:
- On the Connex configure page, expand sync orders from QuickBooks.
- Next to the send orders to box, select opportunity.
- Click submit.
What does an order look like?
Here are some examples: