Common QuickBooks Sync Issues and Resolutions

In this article, we outline common QuickBooks Online (QBO) sync issues and the steps required to resolve them.

Invalid Reference Id – Product/Service Deleted

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 has been deleted. The transaction cannot be modified or synced until the deleted product or service is restored.

QuickBooks guide:
Restore Products or Services in QuickBooks

Business Validation Error – Amount Must Be 0 or Greater (Unbalanced Ticket)

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 usually occurs when the ticket amount is unbalanced. Please contact support@franpos.com for assistance.

Invalid Reference Id – Account Deleted (Cash Drawer Overage/Shortage)

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 has been deleted in QuickBooks. Restore this account in QuickBooks, then retry the sync.

Initialization Error (-20999) – General Item Inactive

Error Message:

"Initialization. BadRequest. Validation Exception was thrown. Details: 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.

Align Cash to Deposit Value – Cash Drawer Must Be Zero-Balanced

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 in QuickBooks Sync Settings, QuickBooks requires all cash drawer records to be zero-balanced. Adjust any non-balanced cash drawer records in the Close Day Report in Franpos, then retry the sync.

Required Parameter "Name" Is Missing – Invalid or Missing Entity Name

Error Message:

"BadRequest. Validation Exception was thrown. Details: Required parameter Name is missing in the request. Item: (779324)"

Resolution:
This error may occur when one of the synced entities does not have a valid name, or the name contains invalid characters for QuickBooks (for example, only special characters).

Verify that all tax categories, categories, and custom payment methods have valid names, then retry the sync.

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