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.
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.
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 missing or misconfigured settings 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:
In Sage 50 Canada, go to Settings > Project > Allocation.
Under Allocate Other Transactions by, select Percent.
Select OK, then sync in the Connect App or select Refresh integration data in Dext.
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 configured with the CAN code. Both refer to Canadian Dollars but Sage treats them as different currencies.
To resolve it:
In Sage 50 Canada, go to Settings > Currency.
Update the currency code from CAN to CAD.
Sync in the Connect App or select Refresh integration data in Dext.
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:
In Sage 50 Canada, go to Settings > Company > Date Format.
Set the date format to DD MM YY.
Sync in the Connect App or select Refresh integration data in Dext.
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:
In Sage 50 Canada, go to Settings > Credit Cards > Used.
Add the credit card to the list.
Sync in the Connect App or select Refresh integration data in Dext. The card will then appear in your payment methods list.

