Support Center

Setting up your connection with QuickBooks

Last Updated: Jul 23, 2013 04:22PM EDT

Connecting with QuickBooks Online

If you are using Quickbooks Online, do not proceed to The Connector section. Go to http://www.qodbc.com/QODBConline.htm and select Ticket GUID.Do not create the Login GUID, we are looking for the Ticket GUID Key only.

This will take you directly into QB Online where you will create your connection and upon completion, receive your key. You need to select "No Security" for the QODBC connection to work properly.  Create the Ticket GUID, we are not looking for the Login GUID Key. Please email the key to us.

Connecting with your QuickBooks Company file on a server

Note:  The full version of Quickbooks needs to be installed on the server we're going to be accessing.

The IBIZ Connector

The connector is a very small piece of software that allows InterWeave servers to connect to your QuickBooks installation. It runs automatically when you login and stays in the background. Note that integration can only work when the Windows user you install this under is logged in.

1. Installation is to be done on the same machine that has the complete QuickBooks installation (client, server, DB manager, etc.).
2. Download ZIPped package from http://interweave.biz/downloads/IW_QBConnector.zip
3. Open the provided ZIP file package (shown as "compressed folder" in some versions of Windows).
4. Right-click on the "IW_QBConnector" folder and click "Copy"
5. Navigate to the "C:\Program Files" directory in Windows Explorer, right-click and click "Paste" (placing the above folder under "Program Files")
6. Navigate into the newly-created "IW_QBConnector" folder and double-click on "RunMe.reg" (may appear as simply "RunMe"); click "Yes" when prompted
7. Double-click on "connector.exe"; a white window may flash briefly, and a square tray icon with "IBiz QuickBooks" tooltip will appear

Note: If you have selected ITX Corp to install “Connection as a Service”, please disregard above.

Port 2080 and your Firewall

Most companies' servers are behind a so-called "firewall" or similar devices that block external access to improve security. For InterWeave to work, your firewall needs to allow inbound connections to your QuickBooks company file on port 2080. Please make sure that this is the case (you may need to contact your hosting provider or IT support for that).

Once the access is allowed, please send the following pieces of information to support:

your static IP address (you may need assistance of your IT contact for that)
location of your company file(s) (including filename) on the computer (e.g. "C:\QBFiles\Company.qbw")
location of your test company file copy (similar to above)

Ensuring Connectivity for InterWeave Servers in Salesforce

In Salesforce, Rackspace Servers running InterWeave need to be authorized. Go to Setup, Security Controls, Network Access, New - enter the below addresses (each one is a from/to address). 

72.3.142.149

67.192.84.146

74.205.126.77

71.235.4.1

72.32.50.205

99.232.241.169

173.34.63.79

199.195.139.97

199.195.139.96

 

Note: If you are using the CC Payment Gateway and integrating with First Data, Authorize.net, etc - you need to enter that server IP address into Salesforce.

Testing your connection for correct Port Forwarding

From another computer inside local network run

telnet LLL.LL.LL.LLL 2080 where LLL.LL.LL.LLL is a local IP address of the server IBiz Connector is installed. Telnet window should open. When it is closed you should see the message in the logging tab of IBiz connector. This test shows that Connector is installed properly and Windows (and other –if present) firewall is properly configured

From another computer outside of local network run

telnet XXX.XX.XX.XXX 2080 where XXX.XX.XX.XXX is an external IP address of the server IBiz Connector is installed. Telnet window should open. When it is closed you should see the message in the logging tab of IBiz connector. This test shows that port forwarding is done correctly and external (router) firewall is configured properly.

Contact Us

support_iw@interweave.biz
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete