Skip to main content

Sage 50 Canada error messages

Troubleshoot errors when publishing from Dext to Sage 50 Canada through the Dext Connect App.

Written by Alexander

This article covers errors and unexpected behaviour that can occur when publishing items from Dext to Sage 50 Canada. For help moving or reinstalling the Dext Connect App, see What is the Dext Connect App?


Connection and app errors

Connection and app errors occur when the Dext Connect App can't communicate with Sage 50 Canada. Most can be resolved by restarting the relevant applications or updating the Connect App.

"Please make sure Dext Connect App is online and try again"

This error has several possible causes. Work through the following:

The Connect App isn't running: The Connect App must be running on the computer used to set up the integration. If that's not you, contact the person who manages the integration to check the app is open and running.

The integration needs to be re-established: This error can appear if the Connect App has been moved to a different computer, or if the credentials of the user who manages the integration have changed, causing the account to appear under Integrated with other software in the Connect App. In either case, the integration needs to be re-established. See What is the Dext Connect App? for steps.

The internet connection is unstable: Check that the computer running the Connect App has a stable internet connection.

The app needs updating or restarting: Make sure the Connect App is running on the latest version. If it is, restart both the Connect App and Sage 50 Canada. Make sure both are running as administrator - right-click the application icon and select Run as administrator.

"Connection to Sage 50 accounts CA failed. Error: Sage version (2022.1) or below"

This error means the integration doesn't support the version of Sage 50 Canada you're using. Dext requires Sage 50 Canada version 2022.3 or above. Update Sage 50 Canada to a supported version, then make sure the Connect App is also running on the latest version and try publishing again.

Dext Connect doesn't recognise your Sage 50 Canada version

This happens when the Dext Connect App doesn't support your version of Sage 50 Canada yet. It's most common right after Sage releases a new version and you install it.

To resolve it:

  1. Update the Connect App to the latest available version. Select your email address in the top right, select About, then select Check for updates.

  2. Restart the Connect App and Sage 50 Canada.

  3. In the Connect App, select Refresh Clients.

  4. If the error continues, disconnect the integration and set it up again. Go to the "Moving or changing your Dext Connect integration" section in What is the Dext Connect App? for steps.

If none of these steps resolve the error, Dext may not support your version of Sage 50 yet. There's no set date for new versions, but the Connect App prompts you to install an update as soon as one is ready, so keep it running. You can contact the Dext support team to check where support for your version stands, or if the error continues after you install an update.

Integration failed: The company file cannot be opened because its version is not compatible with the application

This error appears when Sage 50 Canada reports an incorrect version number for the company file, causing a mismatch with what Dext Connect expects.

To fix it, tick Select Sage version manually on the connection credentials screen in the Dext Connect App and select the correct version of Sage 50 Canada from the dropdown, then select Integrate again.

Dext Connect App integration wizard showing the Select Sage version manually checkbox ticked and a version dropdown

Publishing errors

Publishing errors occur when Dext or the Connect App can't complete a publish action to Sage 50 Canada. Most are caused by settings that are missing or set up incorrectly in Sage 50 Canada.

After resolving any of these errors, select Sync in the Connect App, or select Refresh integration data in the Dext web app - the Connect App must be running for either to work. Then publish the item again. The error on the item will only clear once a new publishing attempt is made.

If an error continues after following the resolution steps, contact the Dext support team.

"Connection to Sage 50 failed: some users are currently working with this company, you can open the file in multi-user and try again"

This error means another user is accessing the same Sage 50 Canada company file.

To resolve it, either ask the other user to disconnect so you can access the file in single-user mode, or switch the company file to multi-user mode in Sage 50 Canada and try publishing again.

"The field you are trying to change or function you are calling is not accessible under current circumstances"

This error is caused by a Project Allocation setting in Sage 50 Canada. Dext only supports the Percent allocation method - if this is set to Amount, publishing fails.

To resolve it:

  1. In Sage 50 Canada, go to Settings > Project > Allocation.

  2. Under Allocate Other Transactions by, select Percent.

  3. Select OK, then sync in the Connect App or select Refresh integration data in Dext.

  4. Publish the item again. See How to republish an item for steps.

"The invoice currency (CAD) is different from supplier currency (CAN)"

This error occurs when Dext publishes using the CAD currency code, but the supplier or company file in Sage 50 Canada is set up with the CAN code. Both refer to Canadian Dollars but Sage treats them as different currencies.

To resolve it:

  1. In Sage 50 Canada, go to Settings > Currency.

  2. Update the currency code from CAN to CAD.

  3. Sync in the Connect App or select Refresh integration data in Dext.

  4. Publish the item again. See How to republish an item for steps.

"You are currently in history mode. Enter historical transactions through the Historical Transactions tab in the ledger"

This error appears when an item's date in Dext falls outside the current financial year in Sage 50 Canada. Sage rejects the transaction because it belongs to a closed period.

To resolve it, update the item's date in Dext to a date within the current financial year in Sage, then publish again.


Unexpected behaviour

Date is reversed in Sage 50 Canada but correct in Dext

If dates appear in the wrong order in Sage 50 Canada after publishing, the date format in Sage may not match the format Dext sends. Dext publishes dates in DD MM YYYY format.

To resolve it:

  1. In Sage 50 Canada, go to Settings > Company > Date Format.

  2. Set the date format to DD MM YY.

  3. Sync in the Connect App or select Refresh integration data in Dext.

  4. Publish the item again. See How to republish an item for steps.

A credit card or bank account isn't appearing in payment methods

Dext pulls bank accounts that are set up as assets in Sage 50 Canada. If a credit card is recorded as a liability in Sage, it won't appear in the payment methods list in Dext.

To resolve it:

  1. In Sage 50 Canada, go to Settings > Credit Cards > Used.

  2. Add the credit card to the list.

  3. Sync in the Connect App or select Refresh integration data in Dext. The card will then appear in your payment methods list.

Did this answer your question?