When transferring EW transactions to QuickBooks using the transfer wizard you may get some errors.
These are responses given by QuickBooks itself so they are a bit cryptic.
Below is a list with the most common error codes you may encounter. If you need explanation for another code please let us know.
Please Note: these error messages are in no way a reason for you to undo the transfer. The items that were not transferred now will remain in the transfer queue and they will be added to the next transfer and if the reasons for the error have been resolved the transfer will be successful.
Code -2: Data check error: Not all invoices are transferred to QB
Explanation
You are trying to transfer a payment for one or more invoices that are not known to be in QB.
This can happen when you enter and invoice manually in QB instead of transferring it from EW or when the invoice was not transferred due to an error.
Resolution
First of all check the invoices linked to that payment and see if they have been transferred to QB.
If the invoice is in QB and you still get this error then you can force the payment to be transferred without being applied to the invoice.
1. on the second step of the transfer wizard select the box "Transfer Received Payments even when related Invoices are not in QuickBooks"
2. perform the transfer
3. open QB and allocate that payment manually
Code -1: Verification error: ARRefundCreditCardAdd. RefundAppliedToTxnAddList: required list is empty
Explanation
A credit card refund couldn't be transferred to QB. This can happen for multiple reasons, mostly related to QB.
Resolution
There is no way to transfer this item to QB by using the EW transfer wizard. You will need to manually enter this record in QB and then mark this payment as Never Export in EW at next transfer.
Code 3120/3240: Object "..." specified in the request cannot be found.
When transferring item changes:
Explanation
If this message comes up when transferring a modification of an item previously transferred to QB it means that the item can't be found in QB anymore.
This usually happens when you transfer an item to QB which later on is either manually deleted or overwritten by restoring a previous QB backup.
Resolution
There is no way to transfer this change to QB by using the EW transfer wizard. You will need to manually make these changes QB and then mark the item as Never Export in EW at next transfer.
When transferring new payments:
Explanation
If this message comes up when transferring a new payment it means that the payment refers to an invoice previously transferred to QB but that can't be found in QB anymore.
This usually happens when you transfer an invoice to QB which later on is either manually deleted or overwritten by restoring a previous QB backup.
Resolution
There is no way to transfer this item to QB by using the EW transfer wizard. You will need to manually enter this record in QB and then mark this payment as Never Export in EW at next transfer.
Code 3160: Cannot delete the object specified by the id "..."
Explanation
You deleted an item from EW that was previously transferred to QB.
The transfer wizard is trying to get QB to delete this transaction.
When QB tries to do that some error is triggered. Read the full error to see what the exact reason was.
Resolution
Depending on the error message itself, you may try to fix the situation that generated the error.
If that's not successful the easiest way to get rid of this is:
1. delete the item manually in QB
2. during the next transfer in EW mark these items as "never transfer". They will be ignored during all subsequent transfers.
Code 3160: Message = Cannot delete the object specified by the id = "...". QuickBooks error message: The transaction could not be locked. It is in use by another user.
Explanation
The QB error message suggests that you are trying to delete an item that is locked by another user in QB.
Resolution
You may try restarting QB in Single User mode and try again. If the error keeps coming up simply delete the item manually in QB and mark it in EW as Never Export at next transfer.
Code 3175: There was an error adding, modifying or deleting [...] because it is already in use. QuickBooks error message: The transaction could not be locked. It is in use by another user.
Explanation
The QB error message suggests that you are trying to modify an item that is locked by another user in QB.
Resolution
You may try restarting QB in Single User mode and try again. If the error keeps coming up simply modify the item manually in QB and mark it in EW as Never Export at next transfer.
Code 3180: There was an error when saving a Invoice. QuickBooks error message: Transaction amount must be positive.
Explanation
You are trying to transfer an Invoice that has a negative total amount. QB expects all Invoices to be positive and all Credit Memos to be negative.
Resolution
Check the invoice in EW and adjust the type accordingly: if it's a negative invoice you need to change the type to "Credit Memo".
Code 3200: The provided edit sequence "..." is out-of-date
Explanation
This message comes up when trying to transfer a modification on a previously transferred item.
This comes up when the item has been modified in QB after it was transferred from EW.
Any change made in QB would be overwritten by the new EW item, that's why this error is triggered.
Resolution
You can force EW to overwrite that item by checking off the "Overwrite changes made in QuickBooks..." box on the second step of the wizard.
Code 3210: The "AppliedToTxnAdd payment amount" field has an invalid value "...". QuickBooks error message: You cannot pay more than the amount due.
Explanation
In this case the message from QB is pretty clear: you are trying to apply a payment that is larger than the current balance on the invoice. QB does not allow this.
Resolution
If there is a credit on the same invoice you need to transfer that credit first. This way the balance on the invoice will increase and you'll be able to transfer the payment.
If that is not possible then you will need to manually enter this record in QB and then mark this payment as Never Export in EW at next transfer.
Comments
1 comment
Many thanks Florin. We appreciate the help.
Article is closed for comments.