How to give access to Reckon/ QuickBooks Desktop

1. Create a gtruck connector in the users interface : Settings >> datasources >> gtruck. Call it something like XXXvets Reckon

2. Download the Windows TRAY gtruck to the desired workstation

3. Ensure you have access to the Admin username and password for the Reckon file

4. Install QODBC from here: from here: https://www.flextools.com/qodbc . You may be able to get a 30 day trial to make sure it works, but after 30 days you have to buy a license from the same site.
   in the old days we also kept a copy here, but this could be out of date and is no onger free to use - http://assets.slyncy.com/install/qodbc1.exe

5. go to  file >> utilities >> configure odbc again after running and you will see a different screen this time (or just go on the start menu and search qodbc >> select the qodbc setup program) . Note the data source name is what will be required in the connection screen in reports-admin

   Open

   

   
   
   
   
   

6. Note that the above window you should set the 'Locate Company File' to the right file, otherwise the data will only sync if reckon is open. It does not however let you set this at this point, so will mention it later.

   Open

   

   
    

7. You can optionally validate if the data source has been installed by going to: C:\Windows\SysWOW64 and executing odbccad32.dll. Here you will see the same  data source under system DSN

   Open

   

   
    

8. Open Reckon and login 

9. In Reports Admin, click on Commands >> Request Connection Status - this will make a pop up appear on the users screen. Click the 'yes' option and select Admin

   Open

   

   
    
   
   

10. Close all Reckon programs. Search for qodbc in the start menu and open the QODBC setup screen. This will start the same window as you had opened previously
    
    

    Open

    

    
     
    
    

11. Make sure the company file is mapped otherwise we can't pull data unless Reckon is open

    Open

    

    
    
     

12. On the reports-admin overview screen set the connection string as follows:

    Open

    

     
    
    

13. The data should now be able to dump. In slyncy-admin, go to the connector and 'queue' the data for the first time. This will cause a windows warning to show on the client PC. Click 'ok/allow' on this screen.
    This should only happen the first time.
    
    

Troubleshooting:

If the data still does not allow connection then you may have to open reckon and go to edit >> preferences >> integrated applications >> make sure the box belowis ticked

Open

Another option is to:

Open QODBC Setup Screen > Advanced > Tick "Launch QuickBooks UI". Apply and Ok

Open

Open Reckon >> Log in

In Reports Admin, Request Dump
Close Reckon
A message will pop up saying flex/qodbc is being used and cannot close

Dump starts

Problem with connection

Use this solution

The .dll was a 2007 version. rename it to bad then reinstall the QODBC will bring an up to data version

Open

This is how to find it quickly

Open

Open

All we did was rename the QBXMLRP2.DLL to .bad the reinstalled the QODBC

14:07:21 Error gtruck-desktop: STATUS: [QODBC] QuickBooks Begin Session Failed. Error = 8004042c, This application's certificate has been revoked by its certification authority. An application must have a valid certificate to access Reckon Accounts company data files.

If you get the above error, then you need to upgrade the java version.
Until Ben upgrades the installer, you will need to go to Dropbox/CloudSwirl/gtruck/jre.zip.
* stop the agent
* Go to "C:\Users\bill\AppData\Local\Programs\slyncy" location (as appropriate)
* rename the jre7 folder
* extract the zip such that <slyncy>/jre7/bin/ exists
* restart the agent