If constraint violation columns appear on the sync dashboard, try the following verifications and fixes. Once verified or updated, run another sync.
- Ensure you're in Single User Mode
- Verify that your role is a QuickBooks Admin
- Delete the current Sync Profile in the Bill.com Sync Dashboard
- Select New and add the company file again
- Run another sync