Section 6: Accounting > Exporting to QuickBooks

Resolving QuickBooks Export Errors

QuickBooks returns a descriptive error message whenever it cannot accept data. When At Your Service receives an error message, it simply skips over the corresponding record and records the error message in a log file to be viewed at the end of the export process. If the problem described by the error can be resolved then the record will be successfully exported the next time that export routine is processed.

The log file is called QBExport.log and can be found in the Log subfolder where At Your Service was installed (by default C:\Program Files\At Your Service\Log on 32-bit systems or C:\Program Files (x86)\At Your Service\Log on 64-bit systems).

The following table lists some common error messages that you may encounter, and how to resolve the problem.





Error 3140: There is an invalid reference to QuickBooks object "" in object.

This error is caused because some of the QuickBooks options have not yet been configured. To resolve this problem, set up all QuickBooks options (see QuickBooks Export Options).

Error 3171: 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.

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). 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.

Error 3180: There was an error when saving a Invoice. QuickBooks error message: The credit limit for the name on this transaction has been exceeded.

This error is caused when you try to export invoices that total an amount that exceeds the credit limit for a customer. To resolve this problem, you must open the customer account within QuickBooks, select the Payment Info tab, and either increase or remove the credit limit.






QuickBooks Integration