Errors for QuickBooks

Webconnector Errors

When using Quickbooks you may encounter error after running it. The errors are returned with a message or error number. Below are the most common:

You Can Not Pay More Than The Amount Due

Transaction Amount Must Be Positive

3140- Sales Tax Setting

400 or 6140 - Duplicate Error

1085- Problem with Log File

3171- Accountant Copy/ Closing Date

1039-Problem Adding Application

3120

The customer for this item was rejected by QuickBooks.




Error Code: "You Cannot Pay More Than The Amount Due"

After running QuickBooks Web connector QuickBooks sometimes indicates “Some items are rejected by QuickBooks”. To see the errors, from ServiceMonster go to Orders >Accounting and click the following tabs:

Non-Posted Invoices

Non-Posted Payments

What does it mean?

The Invoice in ServiceMonster has an amount due that is larger than the one in QuickBooks. Web Connector will not post a payment more than the amount due on an order.

How do I fix it?

Option 1: Fix the invoice in QuickBooks to match what you have in ServiceMonster, so that the amount you are trying to post to the invoice matches the amount due on the order.

Option 2:Delete the invoice in QuickBooks: it was transferred prior to actually being completed, thus causing the issue. Then, go to the order in ServiceMonster, un-mark the posted box at the bottom, and press Save. This will allow both the invoice and the payment to transfer together with the corrected amount on the order, clearing the error.




Error Code: Transaction Amount Must Be Positive

After running QuickBooks Web connector QuickBooks sometimes indicates “Some items are rejected by QuickBooks”. To see the errors, from ServiceMonster go to Orders > Accounting and click the following tabs:

Non-Posted Invoices

Non-Posted Payments

What does it mean?

Payments (A/R) are always positive amounts. QuickBooks doesn’t recognize negative payments from ServiceMonster. Negative amount would be considered credits (A/P) and thus need to be entered as a Credit Memo in order to be recognized by QuickBooks.

How do I fix it?

You will need to go in and fix those entries by removing the payment and entering it as a credit memo instead.




Error Code: 3140

What does it mean?

Sales tax is not enabled.

How do I fix it?

To start, you need to enable the sales tax preference. Select Edit > Preferences > Sales Tax. Click on Yes for the question Do you charge sales tax.

clip_image004

In the lower half of this screen there are several options to review to make sure they are set properly for your business (how often you pay sales tax, and so forth).




Quickbooks Online Error 400: Bad Request: Validation Exception was thrown or 6140: Duplicate Number Error

From the export section in ServiceMonster the error will indicate the following: 400: Bad Request: Validation Exception was thrown

In the Log file, you will see the following error: 6140: Duplicate Number Error  Duplicate Document Number Error: You must specify a different number. This number has already been used.

When does this happen?

When unique orders numbers are set to not transfer in the settings.  You will notice that your orders will not transfer and the transfer log will specify the specific error.

To fix the error:

Turn OFF Custom Transaction numbers. Go to the Gear Icon > Company settings > Sales.

So what are Custom transaction numbers? Quickbooks lists this as “Lets you use your own numbering system.” If left blank, invoice numbers are automatically assigned by Quickbooks.”

6140 error

Another option is to turn OFF Warn if duplicate bill number is used. Go to the Gear Icon> Company Setting> Advanced > Other Preferences.

6140 error 2




Error Code: QBWC1085

When opening QuickBooks Enterprise Solutions or starting your computer, you see one of these errors:

QBWC1085: QuickBooks was unable to write to the log file. QuickBooks will open without writing to log file.

QBWC1085: There was a problem with the log file. QuickBooks Web Connector will continue without the log file.

In some cases, you may see the following error instead:

Exception TypeError: Unknown name

What does this mean?

This error occurs when the QWCLOG.TXT file used by the Web Connector program becomes damaged or it cannot be accessed.

How do I fix it?

  1. Close completely out of QuickBooks and Web Connector
  2. Go to:
  3. Win 8, Win 7, or Vista – C:ProgramDataIntuitQBWebConnectorlog
  4. Windows XP C:Documents and SettingsAll UsersApplication DataIntuitQBWebConnectorlog
  5. Rename the QWCLOG.TXT to QWCLOGOLD.TXT
  6. Reopen Web Connector.
  7. Restart the computer then open QuickBooks and login to your third-party application.

The computer will now start and QuickBooks will open without the error. You will also be able to sync successfully with your third-party application.




Error Code: 3171- Accountant Copy/ Closing Date

After running QuickBooks Web connector QuickBooks sometimes indicates “Some items are rejected by QuickBooks”. To see the errors, from ServiceMonster go to Orders > Accounting and click the following tabs:

Non-Posted Invoices

Non-Posted Payments

3171: An attempt was made to modify an Invoice with a date that is on or before the closing date of the company.

What does it mean?

This error is caused when an invoice that has already been exported to an earlier QuickBooks accounting period is modified within At Your Service (although At Your Service warns the users before editing exported invoices). Web Connector is trying to export the modifications, so it needs access to the closed accounting period.

How do I fix it?

When At Your Service tries to export the modifications, it needs access to the closed accounting period. To resolve this problem, select Preferences from the Edit menu within QuickBooks, and then click the Accounting icon. On the Company Preferences tab, click the Set Password button and then clear the passwords.




When you try to reconnect the company file to the QuickBooks Web Connector on a new computer, you see this message:

Error Code: QBWC1039There was a problem adding the application. Check the QBWCLog.txt for details.

Followed by: Error Unique file ID required.Why this is happening

This error could be caused by either of 2 things:

  • The company file has been moved from its original location.
  • The un-registration from QuickBooks Web Connector failed.

How to fix it:

The fix is an advanced solution. Instructions to fix this can be found here:https://www.help.servicemonster.net/help-articles/quickbooks-error-code-qbwc1039-there-was-a-problem-adding-the-application




Error Code: 3120

3120: Order number XXXXX : Object “XXXX-XXXXXXXXXX” specified in the request cannot be found.

What does it mean?

An Order was transferred using Web Connector and is being synced back to QuickBooks. However, the Order has been deleted in QuickBooks, prior to syncing, so that the original line item(s) no longer exist. This makes it impossible for Web Connector to link the transactions. Deleted orders will not sync back to QuickBooks and the transactions will be orphaned in Web Connector.

How do I fix it?

Step 1: Verify if the payment is already created in QuickBooks or Manually create the payment in QuickBooks.

Step 2: Mark the payment as Posted in ServiceMonster so it no longer tries to transfer with Web Connector.




Error Code: The customer for this item was rejected by QuickBooks.

What does it mean?

Web Connector couldn’t identify a unique account to apply the payment. We see this when a customer is also listed under the Vendor List, or Employee List.

How do I fix it?

Fix Option #1: You can sometimes find a conflict with the same name you are trying to transfer in to the customer list is in the Vendor or Employee list. If that is the case, then you will want to edit the names in that list so it’s not a match to the one you are trying to add to the customer list. Adding an asterisks ** to the end of the name would be enough to eliminate the conflict.

To fix it:

In QuickBooks, search in the Vendor or employee list for the conflicting name.

Change the name, add an asterisk (*) or some other uniqueness to the record.

Reattempt the transfer.

Fix Option #2: The key here is to make sure the customer name is unique. The names have to be an exact match for the invoice or payment to transfer through. So if you find the account formatting is no matching you can adjust them to match in both ServiceMonster and QuickBooks.

Example:

ServiceMonster has the Account Name: Jill Smith

QuickBooks has the Customer Name:  Smith, Jill

To fix it:

Edit the ServiceMonster Account Name to Smith, Jill so that both match.

Reattempt the transfer.