A large number of ArchiOffice/EngineerOffice users sync their data with QuickBooks. Users are getting the following error when sending time entries from ArchiOffice/EngineerOffice to QuickBooks:
Error Code: 3000
The given object ID “” in the field “list id” is invalid.
Sometimes a particular Preferences setting is removed or no longer exists. This error typically means a time entry contains a job code linked to such a (deleted) setting.
A specific SQL Query must be executed against the database. Please do the following:
UPDATE pjc SET pjc.pref_job_code_id = NULL FROM project_job_code pjc LEFT JOIN pref_job_codes prefjc ON pjc.pref_job_code_id = prefjc.pref_job_code_id WHERE prefjc.pref_job_code_id IS NULL AND pjc.pref_job_code_id IS NOT NULL
This should resolve the issue.