This guide helps administrators identify and resolve common Sage 50 US integration issues between VeriClock and the Companion App, including connection errors, employee/job/service item binding conflicts, ODBC configuration problems, and time synchronization failures. It provides step-by-step solutions for login errors, database connection issues, and Companion App status problems to help restore proper system communication quickly.
The article also outlines how to properly bind employees, jobs, service items, and payroll items to prevent sync failures and rejected exports. Learn how to interpret dry run results, resolve error codes, and ensure all time events are fully validated before syncing. Following these best practices helps minimize export errors, protect payroll accuracy, and maintain clean job costing data within Sage 50 US.
Section
Connection issue
Q: I encountered the error 'Sage 50 is not installed or installation is corrupted', how do I resolve it?
A: First, try closing the companion app, opening Sage and then launching the companion app again.
If you already have Sage open, please try opening Sage first as the Administrator, then open the Vericlock companion app as the Administrator
Q: I encountered the error 'Unable to log into the database', how do I resolve it?
A: Try clicking retry and enter the username or password again. Make sure you use 'Peachtree' for the username and the password you set for the ODBC data source.
Q: I have installed the companion app and want to connect my Sage 50 US with VeriClock, why does it say ‘Companion app not found’ on my VeriClock?
A: If you open your companion app by clicking on your Windows toolbar and see the Accounting App Status shown as connected, click on ‘Launch’ again to resend another connection request. This message usually prompts if it exceeds the system time limit to confirm the connection with Sage 50 US.
Q: I have my Sage 50 US installed on a server, can I still use the integration?
A: Absolutely. Just make sure you install your browser and the companion app on the same server and follow the steps in this guide to create your data sources.
Employee, Job and Service Item binding issue
Q: I have made some changes to a job in Sage 50 US, will those changes be applied to the bound job in VeriClock?
A: Any changes you made in Sage 50 US after binding jobs will not be reflected on the corresponding VeriClock jobs. You’ll need to make those changes in VeriClock manually.
Q: I have already bound my jobs and /service items, why does VeriClock still tell me the job/service item is not synchronized?
A: Search the job or service item in your VeriClock account, be sure to use the keyword instead of the full job name in case you have created a duplicate job/service item with similar different names. Then check Time -> Add Time - Grid and see if the affected employee selected the synced job. If not, change it to the synced job and dry the dry run again.
Q: I am trying to bind my Sage 50 US job with an existing VeriClock job, why can’t I select its corresponding VeriClock job and only show ‘Create’?
A: Click ‘Manage Bindings’ and see if the VeriClock job is already linked to another Sage 50 US job, if so, click ‘unbind’ and try to bind it again.
Time Synchronization issue
Q: I have done a dry run and some of the time events are shown in pink. I tried to synchronize the hours without error messages, why can’t I find those time events in my Sage 50 US?
A: To successfully synchronize the time events, you need to ensure all events are ready to sync, which means you need to either resolve all errors or filter out the erroneous time events. Otherwise, none of the events will be imported into your Sage 50 US.
Q: How do I find the time events in Sage after the synchronization?
A: Open your Sage 50 US, and find it here:
Q: I’m trying to set up the data source, but there are many options, how do I know which is the correct one?
A: Try to follow these steps
- Find the folder path for your company file (ie. C:\Company\MyCompanyFileName
- There should be a file called CrystalReports.udl in this directory.
- Open the file with notepad.
- The database name can be found on the last line under “Data Source=databasenamehere”.
- Click OK after you select your database.
- You will now be able to use the new ODBC connection in a 3rd party application of your choice that supports ODBC.
Reference: How do I connect to the program using ODBC/OLEDB?
B: Another way to identify the correct company file is by following these steps:
- Select each company file from the list
- Click on the “Test” option
- When prompted, enter the same Peachtree credentials you use in Sage for that file
If you see a “Connection Successful” message, that confirms you’ve selected the correct file. If not, simply choose another file from the dropdown and repeat the steps until you find the right one.
Q: I’m trying to set up a password for Peachtree, but I don’t see any listed requirements. Are there any?
A: Yes, Sage does have specific requirements for Peachtree passwords. You can find the details outlined below:
Q: When I run the dry run, everything is shown in green, but when I click on ‘sync time’ the results are all shown in red. Why is that?
A: Click and expand any of the error events and see if you see any of the below code:
| Error Code | Solution |
| Employee is not synchronized with Sage 50 US | The employee in VeriClock has not been bound to any employee in Sage 50 US. You can create bindings from the Employees tab in the integration tool. |
| Employee/Job not found in company file | Please check if the employee/job exists in Sage 50 US and is set to active. |
| Service item (Your service item name) is not synchronized with (Your accounting software name) | The service item in VeriClock has not been bound to any service item in Sage 50 US. You can create bindings from the Service Items tab in the integration tool. |
| Job/Service item is not set in clock event | A service item is required to sync data to your Sage 50 US, but it wasn’t set in the clock event. You can add a job/service item by editing the clock event. |
| This event is time guarded and must be addressed | Time-guarded events require Administrators to review them before the data can be available for time syncing. To resolve this, you must edit the clock event and fix the clock-out time to the correct value. Once you are done, click Save and the event can now be used in time syncing. |
| A payroll item is required | Payroll items are required when exporting time to Sage 50 US. You can set one by setting up custom payroll item rules. This is found on the VeriClock website under Settings -> Payroll Items -> Rules. |
Comments
0 comments
Please sign in to leave a comment.