Application error syncing account with QuickBooks: PG::NotNullViolation: ERROR: null value in column "customer_id" violates not-null constraint

You may be staring at this error crossed-eyed but not to fear. We can rifle shoot this problem.

Focus on the second line and notice any person's name. That name is an additional contact that is listed as a second primary contact. You should only have one primary contact.

Here is how to zero in on the culprit:

1. In the error locate the additional contact's name (e.g. Janet, Gilreath)

2. Copy and paste the full name or just the last name into the Kickserv search box

3. Click on the Additional Contacts tab

4. Typically choose the second or bottom instance of this contact

5. Once in the customer record click on [Locations/Contacts] tab

6. Off to the right you should notice 2 contacts listed as "Primary"

7. If they are the same contact listed twice, then you can delete one

8. Otherwise, you can click the edit button on either of these and uncheck the primary box to resolve the issue.