Troubleshoot QuickBooks Integration

Start here to diagnose any QuickBooks Integration issues.

QuickBooks Error Code 6240

Explanation

  • QuickBooks won't accept duplicate names, even between employees and customers.

  • This also means you cannot list the same person in both the employees and the contacts in QuickBooks.

  • Other than that, if you delete an item in QuickBooks, it will not automatically be deleted in FrameReady.

Resolution

  • Rename or delete the record in QuickBooks.

QuickBooks Error Code 5010 (Update Fails)

Explanation

  • Generally, when FrameReady is integrated with QuickBooks, all record level edits should be initiated from FrameReady.

    • If the same records are being updated in both QuickBooks and FrameReady, then the systems won't be in sync.

    • FrameReady only pushes data to Quickbooks and does not check if newer data exists in QuickBooks.

  • Each time a record is edited in QuickBooks, it is assigned a numeric "version".

    • For example, if a record was edited 4 times, the record version would be set to 4. This versioning is called a "Sync Token" and it is used to validate that the system requesting to change data is the system with the most recent data.

  • The error pictured below is the result of the data in QuickBooks being newer than the data in FrameReady, for example, QuickBooks has a sync token stored as 1 and FrameReady has a sync token stored as 0.

Resolution

  • Click the green Refresh button to the right of the sync token ID.

  • The newest sync token will be updated in FrameReady so it matches QuickBooks.

  • The record in FrameReady should be manually updated, as needed, to match the newer data in QuickBooks. 

FileMaker Error Messages

"Error 5"

  • FileMaker error 5 is frequently just bad JSON code often caused by a foreign character such as a quote mark (to indicate for inches). Remove the offending character and re-try.

Software License invalid or expired

 

© 2023 Adatasol, Inc.