Common QuickBooks Sync Issues and Resolutions

Common QuickBooks Sync Issues and Resolutions

Common QuickBooks Sync Issues and Resolutions

In this article, we will describe common issues with QuickBooks sync and the actions needed to resolve them.

Error Message:

"Sales receipt. Date: XX/XX/XXXX. BadRequest. Validation Exception was thrown. Details: Invalid Reference Id: Product/Service assigned to this transaction has been deleted. Before you can modify this transaction, you must restore Bath (deleted)."

Resolution: This error occurs when a product or service assigned to a transaction in QuickBooks Online (QBO) has been deleted. The transaction cannot be modified or synced until the deleted product or service is restored.
Refer to this guide to restore products or services in QuickBooks:
https://quickbooks.intuit.com/learn-support/en-us/help-article/small-business-processes/remove-merge-product-service/L3iSvRjH4_US_en_US

Error Message:

"Sales receipt. Date: XX/XX/XXXX. BadRequest. Validation Exception was thrown. Details: Business Validation Error: Enter a transaction amount that is 0 or greater."

Resolution: This error occurs when the ticket amount is unbalanced. Please reach out to support@franpos.com to resolve this issue.

Error Message:

"Drawer info. Date: XX/XX/XXXX. BadRequest. Validation Exception was thrown. Details: Invalid Reference Id: Account assigned to this transaction has been deleted. Before you can modify this transaction, you must restore Cash Drawer Overage/Shortage (deleted)."

Resolution: This error occurs when the Cash Drawer Overage/Shortage account is deleted in QuickBooks. Please restore this account in QuickBooks to proceed with the sync.

Error Message:

"Initialization. BadRequest. Validation Exception was thrown. Details: Business Validation Error: Unexpected critical error. (-20999).. Business Validation Error: Unexpected critical error. (-20999). Item: General (386711)"

Resolution:

  • Make the General product active in QuickBooks Online.
  • Ensure SKUs 000, 001, and 002 are active in Franpos.

Error Message:

"Sales receipt. Date: XX/XX/XXXX. BadRequest. Validation Exception was thrown. Details: Business Validation Error: Enter a transaction amount that is 0 or greater."

Resolution: If "Align Cash to Deposit Value" is enabled under QuickBooks Sync Settings, QuickBooks requires all cash drawer records to be zero-balanced. Please adjust non-balanced cash drawer records under the Close Day Report in Franpos before syncing.

If further assistance is needed, please contact support@franpos.com.

    • Related Articles

    • QuickBooks

      You can sync financial data from FranPOS to your QuickBooks online account as Sales receipt. Follow the steps below to Integrate your Quickbook with Franpos: 1. In your Back Office, please go to Settings >> QuickBooks 2. Turn on the "Enable ...

    • PAX - Common Error Messages

      This article shows the most common error messages in or while using Franpos and PAX (*Please click the arrows below for more details) Transaction Error:Connect Error Description: This error message is caused when the Communication type in BroadPOS is ...

    • QSR Drive Thru Sync Register Set up

      Follow the steps below to enable local sync communication between your DT registers.  Local sync should be turned off and kept off at front of house registers. Steps on DT1 (drawer side): On register go to Settings > Devices > Local Sync Server Turn ...

    • Device Sync

      In order to sync transactions and customer information to other devices, the system will need to sync. The system will automatically sync every 15 minutes. Additionally, you can manually prompt it to sync the most current information at any time by ...

    • Local Sync orders not communicating between registers

      Steps to fix orders not appearing on Hold 1.     ON SERVER SIDE: o   SELECT (i) o   SELECT RESTART o   WAIT 30 SECONDS   2.     ON CLIENT SIDE: o   SELECT (i) o   SELECT RESTART   3.     ON CLIENT SIDE (IF NECESSARY) o   SELECT SETTINGS o   SELECT ...