Error "Cannot update, can’t find the record"

| November 1, 2017

With CCRQInvoice you may see an error in the “processing results” window as follows:

Cannot update, can’t find the record, possibly deleted by another user? (3120)

There are two reasons why you would see this.

First, the obvious. You “loaded” an invoice into CCRQInvoice, and then before you could click the “process” button, another user deleted the order. Yes, that can happen, but we’ll admit that the odds are against that.

Second, the less obvious. You are doing some sort of processing that saves a value in a custom field (such as “total weight” or “total quantity”). You specified a custom field in the CCRQInvoice preferences to hold the value. Then, at some later point, somebody changed the name of the custom field (or deleted it) in QuickBooks, without updating the preferences in CCRQInvoice. When CCRQInvoice processes the order, it tries to add the total value in the custom field that you specified, but it doesn’t exist in QuickBooks and an error occurs. Unfortunately, the error from QuickBooks is misinterpreted, and this misleading error is displayed.

The simple fix is to determine what the name of the custom field is in QuickBooks, and then updating the preference setting in CCRQInvoice to match.

Tags:

Category: CCRQInvoice

Comments are closed.