(Alert) Error syncing... QuickBooks String or binary data would be truncated. The INSERT statement conflicted... statement has been terminated.

Alert

Example: Error syncing Sales Tax Item FL State Tax from QuickBooks String or binary data would be truncated. The INSERT statement conflicted with the FOREIGN KEY constraint 'FK_tblTaxItem_tbIItem'. The conflict occured in database 'Production'. table 'dbo.tbItem'. The statement has been terminated.

Cause

There is an Inactive Tax Item or Group.

Resolution

The Alert must be cleared or retried three times. This will clear the alert from the different location it is impacting.