Module Navigation

Setting Up and Using SyncLinx & AccountLinx for Sage 50 Canadian Edition (API)

 Before Updating Sage 50 to a Newer Version

If you have a working connection between AccountLinx/SyncLinx and Sage 50, it is advised to consult us before updating Sage 50 to a newer version to ensure that we are compatible.

In the worst-case scenario, if Sage 50 is updated and AccountLinx/SyncLinx is not yet compatible, AccountLinx will not be able to export to Sage 50 and require you to manually enter time data into Sage 50 and/or SyncLinx will not be able to import data from Sage 50.

SyncLinx and AccountLinx are a set of applications we offer that can help you import entities (employees, locations/job sites, and cost codes/activities) from your Sage 50 Canadian Edition (API) and export the time data from ExakTime into Sage 50 Canadian Edition (API).

If you have any questions or concerns during setup and/or use, you can contact us with the "Request Support" link at the top of the page and we will try to assist as best as possible. Keep in mind, however, that we are not Sage support. We will try to assist you as much as we are able, but there are aspects of Sage 50 that are out of our area of expertise and your questions may be better served by Sage support or your trusted contact to answer/assist.

As Sage 50 allows flexibility to fit various needs, we cannot take every unique setup into account. It is advised to read through this article before setting up SyncLinx/AccountLinx to understand what is needed ahead of time.

Using Credentials for Sage 50 Canadian Edition (API)

To connect SyncLinx and AccountLinx to Sage 50 Canadian Edition (API), we must utilize a Sage 50 user credential every time you try to use SyncLinx or AccountLinx. As Sage 50 only allows a user to be logged in one at a time, you cannot be logged in to Sage 50 and use SyncLinx or AccountLinx at the same time.

Make sure that Sage 50 is also in single-user mode.

Connecting SyncLinx to Sage 50 Canadian Edition (API)

  • Go to Tools and click Select Data Source....

    SLX_-_Select_Date_Source_-_04.png

  • Select "Sage 50 - Canadian Edition [Simply and Quantum Accounting] - API. [Requires import via SyncLinx]" and click OK.

    SLX_-_Select_Date_Source_-_Sage_-_00.png

  • A message will appear to resolve connection issues. Click OK and the following window will appear.

    mceclip3.png

    • Browse for the Sage 50 database, enter your Sage 50 username and password, then click Test Connection in the "Data Connection" section towards the top.
    • Select the company to import data from from the "Company Selection" section towards the bottom.
  • Save your settings.
  • Once SyncLinx can connect to Sage 50, you will be able to import entities from Sage 50. You must import new entities through SyncLinx so the time data can properly export from AccountLinx for payroll purposes. If you do not use SyncLinx to import the entities, you may encounter issues when trying to export their time data via AccountLinx into Sage 50.

Using SyncLinx

For assistance with the basic use of SyncLinx, please refer to the following article.

Connecting AccountLinx to Sage 50 Canadian Edition (API)

  • Go to Tools and click Choose Exporter.... Click Select Exporter.

    ALX_-_QuickBooks_-_Exporter_Settings_-_05.png
    Select_Exporter_-_01.png

  • Select "Sage 50 - Canadian Edition [Simply and Quantum Accounting] - API. [Requires import via SyncLinx]" and click OK.

    ALX_-_Sage_50_Mapping_-_02.png

  • Click Configure... and the following window should appear.

    mceclip1.png

    • Browse for the Sage 50 database, enter your Sage 50 username and password, then click Test
    • Click the Other tab and use the drop-down menu for "Map Customer to". This is generally "Location", but you can change it to "Cost Code" if it applies to your setup. To export the time data with AccountLinx, a customer is REQUIRED for mapping purposes. 
      • If you do not have any customers set up for your Sage 50, you will need to create a dummy customer for us to use. You may also need to generate an invoice for the dummy customer in Sage 50 as they do not recognize the dummy customer as an official customer until at least one invoice is generated. 

      mceclip2.png

  • When mapping your Locations or Cost Codes, depending on your selection from "Map Customer To", you will need to specify the customer for the location/cost code.

    ALX_-_Sage_50_Mapping_-_00.png

Mapping Entities

Mapping is a required process that allows you to specify what an entity in ExakTime relates to in Sage 50 to help create your Sage 50 reporting and paychecks.

For information about mapping your data in AccountLinx, refer to the following dedicated article.

Exporting Time Data with AccountLinx

Now that AccountLinx has been connected to your Sage 50 company file and you have mapped your data, you should be ready to export your ExakTime time data into Sage 50.

For information about the basic use of AccountLinx, refer to the following dedicated article.

Was this article helpful?
1 out of 1 found this helpful