How does the QuickBooks Enterprise and Connex Inventory Planner integration work?

A step by step guide on what steps Connex takes to create reports.

How do I set up the integration?

Here are the steps:

  1. Log into QuickBooks Desktop as an admin and open the company file.
  2. Log into Connex Inventory Planner.
  3. Click connections on the top right.
  4. Click QuickBooks Desktop.
  5. Enter QuickBooks Desktop in the text field.
  6. Click the green button:
  7. From the wizard, download the pairing file.
  8. Double click the file.
  9. A dialog will appear. Click OK.
  10. Another dialog may appear with radio buttons. Choose the last one, run even if the file is closed.
  11. To the left of Connex, check auto run and set an interval. We recommend 86400 to run it daily.
  12. Check the box to the left of Connex on the web connector.
  13. Click update selected:

How does it work?

Our tool downloads data from QuickBooks to our database, using the QuickBooks Web Connector.

Connex will download your inventory and sales from QuickBooks using the inventory valuation report and sale by item report. Here are the steps:

  1. Connex downloads your inventory valuation report. The fields item, quantity on hand, average cost, and asset value are returned: 
  2. Connex saves the report to our database. Each time you run your web connector, Connex updates this report.
  3. Connex downloads your sales by item summary report. This report includes sales from selling channels, other QuickBooks syncing apps, and manual orders. Each time you run your web connector, Connex downloads the latest report into our database.

What do the reports look like?

Here is a screenshot of the inventory valuation report as a chart:

Here is a table:

The sales by item summary is located under products > sales by product: