Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Formatting grammar. Also added a link to the QB developer page at the bottom of the article and a table of contents at the top.

Table of Contents
maxLevel3
excludeRelated articles

QuickBill (Formerly QuickBooks Push)

...

If QuickBill fails to push a document as a QuickBooks transaction, a log containing the error message will be recorded. By default, the error logs are kept in “CC:\GetSmart\CaptureProcessing\QuickBooks\Errors”Errors. This location is defined in the “qbPushConfigqbPushConfig.xml” file, xml file, and it is found in “CC:\GetSmart” by defaultGetSmart by default on the GlobalSearch server, or C:\Program Files (x86)\Common Files\Square9\GetSmart on a client machine . Generally, these logs will say the same text showed in the initial error message window.

...

When trying to push a document to QuickBooks, you receive an error “Cannot create QBXMLRP2e COM component.”

Desktop Client Error

LAN ErrorImage RemovedLAN ErrorImage Added

Web Client Error

Web ErrorImage RemovedWeb ErrorImage Added

Image Removed

...

Image Added

Solution

GlobalSearch 4.4.1 or newer

The qbXMLRP2e COM component is registered as part of installing the QuickBill extension. To install the latest version of the QuickBooks connector, simply install or reinstall QuickBill through the GlobalSearch Extensions Manager. If you do not use the GlobalSearch web client, you can use the same steps for GlobalSearch 4.4.0  or older.

GlobalSearch 4.4.0 or older

Register the QBXMLRP2e COM component.

...

Make sure the URL for the Square9API is accurate. In the above example, “myserver” is myserver is not a valid servername server name for a GlobalSearch server or a Square9API.

  1. Navigate to your GlobalSearch installation directory. By default, this is “CC:\GetSmart” on GetSmart on the server, or “CC:\Program Files (x86)\Common Files\Square9\GetSmart” on GetSmart on a client installation.
  2. Open the file “Square9Square9.QBPush.exe.config” in config in a plain text editor, such as Notepad, Notepad++, or VIM.
  3. In the <appSettings> section, make sure there is a value key for the Square9API. If there is, make sure that it has a key for the Square9API, and that the value is accurate. If the key is missing, you will need to add it manually by typing in the text.
  • For example, if the name of your GlobalSearch server is GS-SERVER, then your <appSettings> section should look like this:


Image RemovedImage Added


...

Exception from HRESULT: 0x80040408 (Desktop and Web)

When trying to push a document to QuickBooks, you receive an error “Exception from HRESULT: 0x80040408”

Desktop Client Error

LAN ErrorImage RemovedLAN ErrorImage Added

Web Client Error

Web ErrorImage RemovedWeb ErrorImage Added

Solution

Make sure that the QuickBooks desktop application is open , and you have opened the company file where you want to push the document. Please note that only one company file can be opened at a time when using QuickBill.

...

When trying to push a document in with the GlobalSearch Web client to QuickBooks, you receive an error “Failed to connect with endpoint.”

Web Client Error

Image RemovedImage Added

Solution

Make sure that GlobalSearch Extensions is installed and running and the QuickBill extension is installed. Please note that you must have GlobalSearch 4.4.1 or newer in order to use QuickBill in the web client.

...

When trying to push a document to QuickBooks, you receive an error “There is an invalid reference to QuickBooks…”

Desktop Client Error

LAN ErrorImage RemovedLAN ErrorImage Added

Web Client Error

Web ErrorImage RemovedWeb ErrorImage Added

Solution

Make sure that the listed item exists in QuickBooks. To resolve the issue, either change the value on the GlobalSearch document to a valid list item, or add the desired list item in QuickBooks. In the above example, there is no "account" in QuickBooks called “10100 - Checking”.

Info
titleRegarding QuickBooks Accounts
When using

...

an account name with

...

an account number, the GlobalSearch Index Field value must match exactly how it appears in QuickBooks. For example, “10100 · Checking” is not the same as “10100 - Checking”. For root-level accounts

...

, using just the account name without the account number is valid (in this example, just “Checking” would be accepted). For subaccounts, you will need to specify the parent account as well, separating each parent with a colon “:” (such as “Payroll Liabilities:Federal Withholding” instead of just “Federal Withholding”) or use the account number ( such as “24010 · Federal Withholding”).

...

Error: 80040154 Class not registered (Desktop)

When trying to perform a QuickBooks push, you receive an error "Retrieving the COM class factory for component with CLSID ... failed due to the following error: 80040154 Class not registered"

Image RemovedImage Added

Solution

You may have the 32-bit version of the QuickBooks SDK installed, but GlobalSearch is looking for the 64-bit version. Typically, this will only happen on systems using QuickBill with GlobalSearch 4.5.2 or newer, after having upgraded from GlobalSearch 4.4.1 or olderan older version. To resolve this, uninstall the 32-bit QuickBooks SDK and install the 64-bit version. This can be done by taking the following steps.

  1. Open Control Panel and navigate to "Add/Remove Programs". This will vary based on your version of Windows.
  2. Look for a program called "QBFC 12.0" and  and uninstall it.
  3. Use GlobalSearch Extensions to install and configure QuickBill. If QuickBill is already installed this way, remove it first and reinstall it. This will apply the 64-bit QBFC 12.0.

...

When initiating a sync, you receive an error “Error writing data to database: Error finding document in db: Unable to connect to server <server>:27017: No such host is known”

Desktop Client Error

Image RemovedImage Added

Solution

Make sure that the link reference to the MongoDB is valid in the QuickSync config file. In the above example, “myserver” is not a valid server name.

  1. Navigate to your QuickSync install directory. By default, this is in “CC:\QuickSync”QuickSync
  2. Open the file “qbSyncConfigqbSyncConfig.xml” in xml in a plain text editor, such as Notepad, Notepad++, or VIM.
  3. In the <DatabaseInstance> section, make sure that the path URL to a valid MongoDB is present. If using QuickSync in conjunction with GlobalSearch, this is most likely the GlobalSearch server.

...

  • For example, if the name of your GlobalSearch server is GS-SERVER, then your <DatabaseInstance> section should look like this:

Image Added


...

Error writing data to database: An existing connection was forcibly closed by the remote host

When initiating a sync, you receive an error “Error writing writing data to database: Error finding document in db: Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host..”


Image RemovedImage Added

Solution

Ensure that the MongoDB service is running on the target server.

...

When initiating a sync, you receive an error “Failed to connect to QuickBooks. Exception from HRESULT: 0x80040408”


Image RemovedImage Added

Solution

Ensure that the QuickBooks desktop application is open and you have opened the company file where you are pulling the data to sync. Please note that only one company file can be opened at a time while using QuickSync.

Other QuickBooks Errors

If you receive an error with an HRESULT error code, it may be an error in QuickBooks connector itself. The Intuit Developer web site has a page that details what the different error codes mean and may help point you in the right direction.

Filter by label (Content by label)
showLabelsfalse
max5
spacesS9SKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("quikbill","quikbooks","quiksync") and type = "page" and space = "S9SKB"
labelsQuikbooks QuikBill QuikSync

...