Last Updated: December 06 2023
Overview
The following is a list of error messages you may see if you encounter an issue with the accounting link.
In Australia and New Zealand, the accounting package is known as Reckon. In the United Kingdom and United States, it is known as QuickBooks Desktop.
| Issue | Solution |
|---|---|
|
The string [Customer Name] in the field "Addr1" is too long. Cause: The customer name exceeds 42 characters. |
Shorten the name to 42 characters or less. This includes spaces. |
|
There is an invalid reference to QuickBooks Customer "xxx xxx" in the Invoice. QuickBooks error message: Invalid argument. The specified record does not exist in the list. Cause: The customer on the invoice has either not been created in Reckon / QuickBooks Desktop or the customer name in the two systems does not match. |
Post the customer across first if it does not exist, or update the customer name as required. |
|
There is an invalid reference to QuickBooks Customer "xxx xxx" in the CreditMemo. QuickBooks error message: Invalid argument. The specified record does not exist in the list. Cause: The customer on the invoice has either not been created in Reckon / QuickBooks Desktop or the customer name in the two systems does not match. |
Post the customer across first if it does not exist, or update the customer name as required. |
|
Object "xxxx-xxxx-xxxx" specified in the request cannot be found. Cause: You are trying to send a payment that either is for the wrong customer, or the invoice has been fully paid. Alternatively, there could be multiple accounts receivable accounts in Reckon / QuickBooks Desktop. |
Go to the Setup tab in the accounting link and specify the accounts receivable account. Delete the additional accounts in Reckon / QuickBooks Desktop. |
|
There is a missing element: "TxnID" Cause: The invoice may be missing in Reckon / QuickBooks Desktop. |
Post the invoice across. |
|
Finance Charge Invoice Creation Failed: There is an invalid reference to QuickBooks Customer [Customer Name] in the Invoice. QuickBooks error message: Invalid argument. The specified record does not exist in the list.[Error (3140)] ERROR - (3140)There is an invalid reference to QuickBooks Customer "xxx xxx" in the ReceivePayment. QuickBooks error message: Invalid argument. The specified record does not exist in the list. The "AppliedToTxnAdd payment amount" field has an invalid value "xxx.xx". QuickBooks error message: You cannot pay more than the amount due. Cause: You are trying to apply a payment greater than the outstanding amount on this invoice in Reckon / QuickBooks Desktop. For example, if the invoice in Reckon / QuickBooks Desktop is for $100.00 and it has a payment of $50.00 against it, and you send over another payment of $100.00, it will fail. |
You can either remove the current payment(s) in Reckon / QuickBooks Desktop and send over the payment from Simpro Premium, or manually adjust the payment in Reckon / QuickBooks Desktop and skip the Simpro Premium payment in the accounting link. |
|
An attempt was made to modify a Invoice with a date that is on or before the closing date of the company. If you are sure you really want to do this, please ask a user with Admin privileges to remove the password for editing transactions on or before to closing date (this setting is in the Accounting Company Preferences), then try again. ERROR - (3000)The given object ID "nai" in the field "transaction id" is invalid. Cause: You are trying to send an invoice for a locked invoice period that has been edited. |
Either unlock the period and repost or enter the invoice manually in the accounting package. |
If you experience the following issue - Unable to Connect to QuickBooks / "Could not start QuickBooks"- it means the accounting link cannot access Reckon / QuickBooks Desktop for one of the following reasons:
| Cause | Solution |
|---|---|
| Reckon / QuickBooks Desktop isn't open or the company file isn't loaded. | Open Reckon / QuickBooks Desktop and the company that you want to connect to. |
| Your version of Reckon / QuickBooks Desktop version does not support third party integration. | In Reckon / QuickBooks Desktop, go to Edit > Preferences. If you do not see Integrated Applications on the left side, Reckon / QuickBooks Desktop does not work with the accounting link. Contact Simpro Premium Support about finding a supported version. |
| Integration is turned off. | In Reckon / QuickBooks Desktop, go to Edit > Preferences > Integrated Applications > Company Preference. Clear the Don't allow any applications to access this company file check box. If there is a Simpro Premium Accounting Link option in the menu that does not have a tick, remove it and try again. |
| The user that is logged in does not have sufficient privileges. | Log in as an admin user. |
| On Windows Vista or Windows 7, User Account Control is blocking communications between the two applications. | Turn off UAC, then restart the computer. |
| Anti virus or firewall software is blocking the link. | You may need to add the accounting link as an exception in the anti virus software. |
| There is more than one version of Reckon / QuickBooks Desktop on the system. | Open the Intuit program files directory and run reboot.bat. |
| The Reckon / QuickBooks Desktop file is not accessible. | If you have a network environment, your Reckon / QuickBooks Desktop file needs to be in a public folder. If you are a single user, your file needs to be in a private folder. |
| Either Reckon / QuickBooks Desktop or the accounting link is not being run as administrator. | Run both applications as administrator. |
Additional troubleshooting
If you are unable to select options from drop-down boxes in the Default Quickbooks Items pop-up window, this is because the accounting link cannot connect to Simpro Premium. Check that Reckon / QuickBooks Desktop is open, and check that you have the correct tax codes set up in Simpro Premium.
Rounding adjustments occur because Simpro Premium and Reckon / QuickBooks Desktop calculate tax-inclusive amounts differently. If a line item in Reckon / QuickBooks Desktop is over 0.01, the line item does not have the correct tax code. Learn more about tax codes in Reckon / QuickBooks Desktop in Set up required items.