QuickBooks errors and troubleshooting

After importing the job, contact and invoice file into QuickBooks (Reckon Accounts Premier), you may receive errors. Below are explanations for these errors and solutions.

General Errors

-	QuickBooks (Reckon Accounts Premier) found an error when parsing the provided XML text stream.	Solution Check for duplicates in QuickBooks (Reckon Accounts Premier).
-	The QuickBooks (Reckon Accounts Premier) user has denied access.	Solution For the first time when you run the synergy sync a message appears to allow applications to access the QuickBooks (Reckon Accounts Premier) data file. If you've clicked No, this message will appear. You need to select Yes, Always
-	This application does not have permission to access this QuickBooks (Reckon Accounts Premier) company data file.	Solution The QuickBooks (Reckon Accounts Premier) Administrator can grant access permission through the Integrated Application preferences. The datafile has been opened in multiuser mode. You must be logged in as single user mode.
	The message 'Unable to start QuickBooks (Reckon Accounts Premier)' is shown when using Synergy Connect.	Solution Within QuickBooks (Reckon Accounts Premier) open the Preferences configuration window. Locate the 'Integrated Applications' preference, and click the 'Properties' button. On the 'Access Rights' tab check the box for the setting 'allow this application to login automatically'. Click OK to save this change. Click the image below to see this setting in QuickBooks (Reckon Accounts Premier).
-	An internal QuickBooks (Reckon Accounts Premier) access error occurred while trying to access the QuickBooks (Reckon Accounts Premier) company data file	Solution The RDS drivers need to be installed as the QuickBooks (Reckon Accounts Premier) data files resides on a different server/PC to where the sync is being run.
-	Unable to cast COM object of type 'interop.QBxmlRp2.requestProcessor2Class' to interface type 'Interop.QBXMLRP2.IRequestProcessor4'. See full error details:	Solution Install the QuickBooks (Reckon Accounts Premier) drivers.
-	Unable to cast COM object of type "Interop.QBXMLRP2.RequestProcessor2Class" to interface type "Interop.QBXMLRP2.IRequestProcessor4". This operation was aborted.	Solution Contact QuickBooks (Reckon Accounts Premier).
-	The version of QBXML that was requested is not supported or is unknown.	Solution Open Synergy. Open QuickBooks (Reckon Accounts Premier) Connect. Select Settings. General tab. Change the Version to the installation version on the PC.
-	Please check QuickBooks (Reckon Accounts Premier) API is installed.	Solution Open Synergy. Open QuickBooks (Reckon Accounts Premier) Connect. Select Settings. Review all settings, check Invoice items is correct. Locate QuickBooks Connect settings to learn more.

Contacts Errors

The name "Joe Bloggs" of the list element is already in use; Invalid argument.

Payments Errors

-	Payment of $xx for Invoice 'xx' cannot be imported because Invoice status (Paid) does not allow payments to be imported.	Solution A credit has been created in Synergy and then gone over to QuickBooks (Reckon Accounts Premier), however when the credit was applied, it was made as a payment. When a sync is done, a new payment is trying to go over to Synergy, but shouldn't. Remove the credit / payment in QuickBooks (Reckon Accounts Premier), apply credit correctly. The system won't try and import a payment from QuickBooks (Reckon Accounts Premier) again.
-	Payment of $ invoice skipped because the invoice was not found.	Solution Administrator is required to log in to QuickBooks (Reckon Accounts Premier) to enable the unlock of the data file.
-	Payment import error 'a query request did not find a matching object in Reckon Accounts'.	Solution This error was caused by a product name change in the Reckon Accounts API. The error was only shown if reckon Accounts Connect was run and there were no payments available to be imported. Upgrade to the 4.9.4 release (or higher) of Synergy, and the interface has been updated to handle this situation.

Invoices Errors

The messages that are displayed in Synergy after performing a sync are returned from QuickBooks (Reckon Accounts Premier). So it is difficult for Synergy to display a solution for these errors. So below are the key words to look out for in the errors that are returned and suggested modifications to be carried out in Synergy so the sync will continue error free.

What to look for in a message

A Standard error that would be received is:

Invoice 'xxx' failed to export: Error: There is an invalid reference to Quickbooks Account '0' in the items. QuickBooks (Reckon Accounts Premier) error message: Invalid Argument. The specified record does not exist in the list.

The key words in this error are Account and Items - it is something in these areas of the data setup in either Synergy or QuickBooks (Reckon Accounts Premier). So, i've highlighted the keywords in each of the errors that we've reproduced so you know which areas will affect the sync outcome.

-	Invoice status does not allow payments error when parsing the provided xml.	Solution Setup account items and then ensure client name is spelt the same.
-	Invoice 'xxx' failed to export to QuickBooks (Reckon Accounts Premier) because: Error: There was an error when saving a Invoice. QuickBooks (Reckon Accounts Premier) error message: the transaction is empty	Solution QuickBooks (Reckon Accounts Premier) does not accept $0.00 invoices. Open Synergy. Open QuickBooks (Reckon Accounts Premier) Connect > Settings >. General tab. Change the Start from date to after the $0.00 invoice date.
-	Invoice 'xxx' failed to export to QuickBooks (Reckon Accounts Premier) because - Error: there is an invalid reference to QuickBooks (Reckon Accounts Premier)customer "yyy" in the invoice. QuickBooks (Reckon Accounts Premier) error message: invalid argument. The specified record does not exist in the list.	Solution Open Synergy. Open QuickBooks (Reckon Accounts Premier)Connect. Select Settings. Select Customers tab. Ensure either Export All contacts or Export Contacts with Invoices is selected.
-	Item 'yyy' failed to export: Error: There is an invalid reference to QuickBooks (Reckon Accounts Premier)Account 'yyy' in the items. QuickBooks (Reckon Accounts Premier) error message: Invalid Argument. The specified record does not exist in the list.	Solution Go to the Invoices settings tab. If you've selected the option for Use Header item in QuickBooks (Reckon Accounts Premier), check that the Header Item Account is correct and exists in QuickBooks (Reckon Accounts Premier).
-	Item 'yyy' failed to export: Error: There is an invalid reference to a parent 'yyy' in the Items list. QuickBooks (Reckon Accounts Premier) error message: Invalid Argument. The specified record does not exist in the list.	Solution The word Parent is the key here, as this record that is skipped is reliant on subsequent data being added to QuickBooks (Reckon Accounts Premier), before this record can be added. Fix other sync errors and this error will then no longer occur.
-	Invoice 'xxx' failed to export: Error: There is an invalid reference to QuickBooks (Reckon Accounts Premier)Account 'yyy' in the items. QuickBooks (Reckon Accounts Premier) error message: Invalid Argument. The specified record does not exist in the list.	Solution Check the Income Account in Synergy and QuickBooks (Reckon Accounts Premier) as they need to be the same. If the Income Account in Synergy doesn't exist in QuickBooks (Reckon Accounts Premier), then you will need to manually enter it into QuickBooks (Reckon Accounts Premier), as Synergy is unable to create new Income Accounts in QuickBooks (Reckon Accounts Premier) during a sync, as a detailed setup is required. Ensure that if you use sub account names, that the colon (:) is included in the Account Name, e.g. Consulting Income:Variations. This will be found at the Invoices settings, Project Attributes, Discipline or Cost Centre maintenance.
-	Invoice 'xxx' failed to export: Error: There is an invalid reference to QuickBooks (Reckon Accounts Premier)item 'yyy' in the invoice line. QuickBooks (Reckon Accounts Premier) error message: Invalid Argument. The specified record does not exist in the list.	Solution An Item will be rejected if the Income Account associated with it doesn't exist in QuickBooks (Reckon Accounts Premier) or is not spelt the same in the 2 systems. An Invoice will be rejected from the sync when part of the area that you are using to pull data from on the project is incorrect. Once these areas have been rectified, then Invoice will successfully sync to QuickBooks (Reckon Accounts Premier). Ensure that the Item indicated at the Source, has an income account allocated to it. For example If you are setting Cost Centres as Items, then open Cost Centres in Synergy and allocate the Income Account against each Cost Centre. NOTE the income account must exist in QuickBooks (Reckon Accounts Premier).
-	Invoice 'xxx' failed to export: Error: There is an invalid reference to QuickBooks (Reckon Accounts Premier)InvoiceLineItem Class 'yyy' in the invoice line. QuickBooks (Reckon Accounts Premier) error message: Invalid Argument. The specified record does not exist in the list.	Solution Go to the Class tab in the Connect settings. Make a note of the Source that is selected. Source = Discipline or Cost Centre Open the Sub Project and make sure a relevant Discipline or Cost Centre is attached. Open the Discipline or Cost Centre maintenance area and make sure the values are less than 20 characters. Source = Project Attribute Open the Project and make sure an Attribute is attached. Open the Attribute maintenance area and make sure the values of the Attribute are less than 20 characters.
-	Invoice 'xxx' failed to export: Invoice 'xxx' cannot be exported to QuickBooks (Reckon Accounts Premier) because the invoice number already exists in QuickBooks (Reckon Accounts Premier).	Solution Invoice shouldn't already be in QuickBooks (Reckon Accounts Premier) Remove the Invoice or renumber the invoice in QuickBooks (Reckon Accounts Premier) and create another sync. Invoice number in Synergy is wrong If by chance you've manually added an Invoice to QuickBooks (Reckon Accounts Premier), however an Invoice number used correlates to a different invoice in Synergy you can actually change the Invoice Number in Synergy to 'skip over' an invoice number. Locate Change the invoice number to learn more.
-	Warning - "Invoice 'xxx' was skipped: Invoices must have at least one (1) non zero line".	Solution The message occurs if you have raised a $0 (zero dollar) invoice for a project. As QuickBooks (Reckon Accounts Premier) cannot accept the $0 invoice, the item is blocked from being included in the sync. This warning message will be shown only once, in the first sync to QuickBooks (Reckon Accounts Premier) after the $0 invoice is created. If you require the information to be in QuickBooks (Reckon Accounts Premier), the information will need to be manually entered.
-	Warning - "Credit 'xxx' for invoice 'xxx' was skipped: Credits must have at least one (1) non zero line".	Solution The message occurs if you have raised a $0 (zero dollar) invoice for a project, and then later selected to cancel the invoice. When you cancel the invoice the system creates a $0 credit note. As QuickBooks (Reckon Accounts Premier) cannot accept the $0 credit note, the item is blocked from being included in the sync. This warning message will be shown only once, in the first sync to QuickBooks (Reckon Accounts Premier) after the $0 credit note is created. If you require the information to be in QuickBooks (Reckon Accounts Premier), the information will need to be manually entered.

'xxx' represents your Invoice Number, where 'yyy' represents the data that needs to be modified at the statement 'there is an invalid reference to QuickBooks (Reckon Accounts Premier)...'.

Troubleshooting

-	Job number doesn't appear in QuickBooks (Reckon Accounts Premier).	Solution Open Synergy. Open QuickBooks (Reckon Accounts Premier)Connect. Select Settings. Select Class tab. Select the setting Export Project Number as a Class.
-	Cancelled invoices appear on statements.	Solution Resolve Credits Go to Receive Payments. Select the Client. Tick / select the invoice that is outstanding that you have actually now cancelled. Further down the screen you will notice a button Set credits, click this. A little window will appear with the credit invoice (negative amount). Select done then save and close. Print statements Then when you go to create the statements, there is an option at the top to set Statement date and type, select the option All open transactions as of statement date. This will ensure the applied credits are not printed on the statement.
-	Credits not appearing in QuickBooks (Reckon Accounts Premier).	Solution Open QuickBooks (Reckon Accounts Premier). Go to Edit > Preferences. Select Sales & Customers from the left panel, click on the Company Preferences tab and uncheck 'Warn about duplicate tax invoice numbers'. Run the Connect sync.
-	QuickBooks (Reckon Accounts Premier) invoices imported with zero values.	Solution The setting in QuickBooks (Reckon Accounts Premier) for Sales figures needs to be set to Net (exclusive of tax). Check QuickBooks Net Sales Setting. To then update the Invoices that have sync’d with zero amounts, you can do 1 of 3 things: Option 1 Restore your QuickBooks (Reckon Accounts Premier) backup. Delete the last QuickBooks (Reckon Accounts Premier) sync in Synergy. Locate QuickBooks (Reckon Accounts Premier) Delete a Sync topic for more. Edit the Sales figures setting in QuickBooks (Reckon Accounts Premier). Locate QuickBooks (Reckon Accounts Premier) Net Sales Setting topic for more. Re-run the sync. Option 2 Open each Invoice in QuickBooks (Reckon Accounts Premier) and manually enter the Invoice amount. Edit the Sales figures setting in QuickBooks (Reckon Accounts Premier). Option 3 Delete the Invoices with zero amounts from QuickBooks (Reckon Accounts Premier). Delete the last QuickBooks (Reckon Accounts Premier) sync in Synergy. Locate QuickBooks (Reckon Accounts Premier) Delete a Sync topic for more. Edit the Sales figures setting in QuickBooks (Reckon Accounts Premier). Locate QuickBooks (Reckon Accounts Premier) Net Sales Setting topic for more. Re-run the sync.
-	Undo a Completed Sync.	Solution

Want to learn more?

Looking for more help? Try reviewing the following topics: View Topics

Open topic with navigation