Errors for QB Desktop

Webconnector Errors

When using Quickbooks Desktop Webconnector 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 DueTransaction Amount Must Be Positive3140- Sales Tax Setting400 or 6140 - Duplicate Error1085- Problem with Log File3171- Accountant Copy/ Closing Date1039-Problem Adding Application You Can Not 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

Error Code

  • You cannot pay more than the amount due.

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.

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

Error Code

  • Transaction amount must be positive.

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.

3140- Sales Tax Setting

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).

400 or 6140 - Duplicate Error

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

1085- Problem with Log File

Error Code

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.

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

Error Code

  • 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.

1039-Problem Adding Application

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

Error QBWC1039: There 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:http://old.servicemonster.net/support/qbunreg/