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
3171- Accountant Copy/ Closing Date
1039-Problem Adding Application
The customer for this item was rejected by QuickBooks.
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
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.
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.
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
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.
You will need to go in and fix those entries by removing the payment and entering it as a credit memo instead.
Sales tax is not enabled.
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.
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).
Error 3140 can also sometimes be triggered if the product or service associated with the error message has special characters such as :, $, #, % or the like. Please remove any you may see & then attempt to export again to see if that resolves the 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 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.
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.”
Another option is to turn OFF Warn if duplicate bill number is used. Go to the Gear Icon> Company Setting> Advanced > Other Preferences.
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
This error occurs when the QWCLOG.TXT file used by the Web Connector program becomes damaged or it cannot be accessed.
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.
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.
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.
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:
This error could be caused by either of 2 things:
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
3120: Order number XXXXX : Object “XXXX-XXXXXXXXXX” specified in the request cannot be found.
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.
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.
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.
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.
