Use Chaser with Sage50

If you use Sage50 this article will explain how to connect Sage50 to Chaser, explain how the integration works and provide answers to some frequently asked questions of current Chaser customers who use Sage50.

Last updated: November 29, 2024

Frame 1707480122 (1)

Get started: Sign up for a free trial with Chaser

Before connecting to your Sage50 account, take out a free trial by filling out the following short form:  https://www.chaserhq.com/signup

Connect Chaser to Sage50

Once the trial is activated, connect Chaser to your Sage50 account.

Chaser connects with Sage50 through a connector that needs to be downloaded and run on your computer or a virtual machine. Follow the instructions below to get started.

Pre-requisites

  1. You are using a suitable version of Microsoft Windows:
    1. Windows Server 2022 Datacenter or greater
    2. Windows 11
    3. Windows 10
  2. You are using a 64-bit system. 
  3. You have created a Chaser account using the Chaser API option.

Set up instructions

Step 1 [Optional]: Setup your Windows machine for Chaser: Create a dedicated user (Recommended)

This step is optional but not required. You can just use your Sage credentials to log in to the Chaser Connector app if you prefer. 

  1. Open up Sage50 and select the desired organisation
  2. Select Settings, User Management, then Users
  3. Select New

  4. Select Read-only and click Continue.
  5. Provide a user name (ideally something easy to identify like "Chaser"). Then enter a secure password and click Continue

  6. In Level of Access, select Customers. by default access to Suppliers and Bank accounts will be automatically selected
  7. Select Continue
  8. Select Continue on the next step, Remote desktop access is not required.
  9. Review the changes and then select Save

Step 2 : Setup a Windows machine for Chaser: Create a dedicated DSN for Chaser to read your Sage50 data

  1. Locate your current Sage50 version and data storage directory. Inside of the company you would like to connect, got to Help then About

  2. In Program Details select the Data Directory link.
  3. In the window that opens, open the Accdata or ACCDATA folder 
  4. Copy your directory link and store this for use later.
  5. Check your Sage50 version and confirm you are running a 64bit operating system. Chaser Connector currently only works with 64bit operating systems. Should you need it on a 32bit system, please contact support@chaserhq.com
  6. Search for ODBC in your Windows search bar and select ODBC Data Sources (64-bit)
  7. Open the System DSN tab.
  8. Click Add

  9. You would usually select the latest driver version, but you can confirm by checking your driver version resembles your version of Sage50 seen in the previous steps. I.e. ‘Version Number 30.1.343.0’ - contains 30, will likely be Sage Line 50 v 30. Once you have confirmed and selected your driver version, select Finish.

  10. Enter your Data Source Name (recommended to use a memorable name)
    1. If you will be connecting multiple organisations to Chaser, provide these with a distinct name so that they are easy to identify.

  11. Paste your Data path (refer to step 4)

12. Save your data source name for later. Click OK.  Your new ‘Data Source Name’ or ‘DSN’ has been created. 



Step 3: Installing the Chaser Connector

  1. Download and open the Chaser Setup.exe.
    1. This will be provided to you by your Chaser Representative. Please contact support@chaserhq.com if you do not have this. 
  2. You may see the following pop-up, if so, select More info and Run anyway


  3. Read and agree to the License agreement and select Next.

  4. Select Create a Desktop Shortcut to make it easy to access the application from your desktop accessible on your desktop if preferred. This is not required. Select Next.
  5. Select Install
  6. Select Finish and Launch the Chaser Connector


Step 4: Test your Sage50 Database Credentials

  1. Enter the dedicated user details if you created one, otherwise, enter your Sage50 username and password. 
  2. In Data Source Name (DSN), select Custom and provide the dedicated DSN details for your Sage50 organisation.

  3. Enter your custom DSN name
  4. Select Test Login.
    1. You should see a notification Connection to Chaser Sage50 Demo successful.
    2. If you see an error, please verify that your credentials are correct.

Step 5: Entering your Chaser API keys into the Chaser Connector

  1. Go to your Chaser account and navigate to the Organisation settings.
  2. Select Integrations and Get API keys.
  3. Copy your Key and Secret and paste them into the Chaser connector app.

  4. Select your invoices folder if you would like to include invoice PDFs in your Chasing emails or if you want them to be visible in your Chaser account. This is optional.
  5. Auto-Sync should be turned off for your first sync.
  6. Select Sync and your data should start to pull to your Chaser account

    1. If you included a link to your Invoice you will notice a processed folder has been created which contains all of your successfully posted invoice PDFs. Any unsuccessful invoice PDFs will remain in the main folder and will be retried until they are successful or removed.
  7. Once your first sync is complete, turn on Auto-sync.
    1. Auto-sync will attempt to sync with Chaser every 30 mins. It is possible to perform a manual sync at any time if you wish by selecting Sync in your Connector App.
  8. You can minimise the Connector App.
    1. Avoid opening a new instance by clicking the desktop icon if it is already open. Rather open the existing instance in your icon tray.
    2. This will ensure you are not mistakenly syncing your data twice. We allow multiple instances open for businesses who wish to sync with multiple Sage50 organisations at once.


  9. Your data should now be available in Chaser

 

How does Chaser's integration with Sage50 work?

Chaser syncs with your Sage50 connector every 30 minutes. You can also trigger a sync anytime by selecting the sync button in your Chaser connector application. 

To have the most up-to-date data, Chaser will regularly pull accounting data from your Sage50 account. These syncs fetch data that has been created or updated since the last sync.

Chaser syncs with the Sage50 connector once before payment reminder emails are sent out. This ensures that all information is up to date before Chaser emails are sent out.

 

What information does Chaser pull from Sage50?


Customers

Through the Sage50 connector, Chaser retrieves your customers from your Sage50 account. Chaser pulls through the email addresses, phone numbers, physical addresses and invoices associated with a customer contact in Sage50.

Chaser pulls through all the main contact and also additional contacts under customer in Sage50. This means that you can have multiple recipients in Chaser. You can have a ‘Normal’ sender and an ‘Escalated’ sender. The main contact may appear twice in your recipients list in Chaser due to the way that Sage50 stores contacts, either can be selected as the recipient, and there is no impact on your chasing. 

Chaser uses the data stored in its Mobile number field to make Auto-calls or send SMS to avoid sending these to landlines. Sage50 does not have a dedicated Mobile number field, so Chaser will pull the Mobile number from the Telephone 2 field in Sage50. 

Chaser will pull Trading terms and display them as Tags.


Invoices

Chaser pulls your customer's invoice data directly from your Sage50 account.

Chaser uses the due date and the creation date from Sage50 to calculate how many days overdue an invoice is.

Only posted documents will be visible in Chaser.

Credit notes

Chaser pulls your credit note data directly from your Sage50 account. Chaser will display credit notes on your Monthly statements and Customer page.

Payments

Chaser pulls your posted payments directly from your Sage50 account. If payments are allocated to invoices, they will be displayed on the invoice page and the invoice values will be update appropriately. Otherwise, they will display as unallocated / overpayments on the account. 

Why am I not able to connect Sage50 to Chaser?

If you are having issues connecting Sage50 to Chaser

1. Check that your Chaser connector app is running. This must be running in order for Chaser to fetch data from your Sage50 account.

2. Check your credentials in your Chaser connector app. Go to your Connector app and select test credentials. If this fails, enter the correct credentials.

3. Go to your Chaser account, go to Integrations under organisation settings and select API Keys. Confirm that the API keys match those entered within your Chaser Connector application. 

If you are still experiencing difficulties connecting Chaser to Sage50, please contact support@chaserhq.com or via live chat.

Why does Chaser not reflect the latest changes in my Sage50 account?

If changes that you have made in Sage50 aren’t updating in Chaser, please follow the steps above. If you are still experiencing difficulties connecting Chaser to Sage50, please contact support@chaserhq.com or via live chat.


Why isn’t my expected payment date not visible in Sage50?

Chaser has one way sync functionality with Sage50 meaning no data will be sent from Chaser to Sage50.

 

Why are my Customer balances blank or incorrect in Chaser?

Currently, the Customer balances recalculate at certain times, for example when you first log in, if your organisation has not recalculated the balances in the last 24 hours, or before reminders are sent to your customers. To trigger this manually click the Sync button in Chaser.

This behaviour will be improved in a future version of the Sage50 integration. 

 

How can I tell why my connection to Sage50 is not working?

You will likely receive one of the error messages below, this combination of errors usually means the Username is incorrect:

28000: User ID or Password invalid

01000: The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 30.1

01000: [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behaviour that the application requested (see SQLSetEnvAttr).


This combination of errors usually means the Password is incorrect:

28000: User ID or Password invalid

01000: The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 30.1

This error usually means that the DSN name is incorrect:

28000: User ID or Password invalid

01000: The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 30.1

 

Why is the sync getting stuck and/or taking too long?

Check that you have not opened a duplicate instance of the Chaser connector app.
Check that you are only opening the application from the icon tray (if it is already open it will show in the icon tray). This is intentional because some organisations might need to run multiple instances of the Chaser Connector but for separate Sage50 organisations.

 

Why are my invoice pdfs not syncing?

Check that you have selected the correct folder on your desktop. Check that the invoice(s) that are missing are available in Chaser. Chaser requires the invoice to exist for the PDF to be associated.

The invoice PDF should contain the invoice number in the name of the file (example: ‘67.pdf’). 

We do also accept the following standard Sage50 formats : 

  1. The number on its own:  ‘35.pdf’
  2. The number with the word ‘Invoice’ : ‘Invoice 35.pdf‘
  3. This sentence: ‘Invoice 27 from Chaser Sage50 Demo.pdf’
  4. This sentence with a timestamp: ‘Invoice 30 from Chaser Sage50 Demo - 06112024.pdf’


Why are some customers displaying the contact ID instead of the customer company name?

If the contact name is missing when Chaser fetches the data from Sage50, the ContactID will be used in place of the company name.

In Receivables, you can filter on companies that are using the ContactID in place of the Company name to rectify this. Select the Filter option and then select Tags, and filter by No Company Name.  

This list will show you customers without a company name. If you add a company name, the record in Chaser will be updated on your next sync and the tag will be removed from the customer. 

Can I see my customer's payment terms in Chaser?

This will appear as a Tag in Chaser.

This will appear for all customers created in the Sales Ledger.


Why do some of my customers not have payment terms?

If the customer does not have a record available in the Sales Ledger table in the Sage50 database then Chaser will use the first contact person associated with the company in Sage 50 to generate a customer record in Chaser.

In Receivables, you can filter on Tags and click either Delivery, Registered Address or Registered Contact.

To rectify this, go to Sage50 and make any change to the company name (this could include adding or removing whitespace) and save. Then Sync with Chaser, this should update Chaser so that Chaser can recognise the Customer. Chaser will remove the tag and display the Customer name as expected.