Set up Sage 200cloud

About Sage 200cloud

Sage 200cloud is an accounting solution for small to medium-sized businesses. This cloud-based application provides a flexible tool for organisations to manage their stock, financials, sales, purchases, and sales orders.

📘

Supported versions

Codat currently supports Sage 200cloud Standard only.

Set up Sage 200cloud

❗️

Changes in authenticating integrations

Sage has recently modified the way applications and integrations are authenticated in Sage 200 API. You can find out more about the changes in Sage 200 API - Guide to Sage ID Changes.

If you're a Codat customer who already has an account with Sage, please refer to section Request new credentials below. Customers who need to set up their Sage accounts are requested to follow the process described below.

Before you can access data from customers using Sage 200cloud for their accounting, you need to set up a Sage 200cloud integration in the Codat Portal. You'll need to:

  • Request an account from Sage and obtain API credentials.
  • Wait for Sage to send through your secure keys.
  • Retrieve a subscription and signing key from the Sage API site.
  • Add your secure keys to the Codat Portal.

Request an account and obtain API credentials

  1. Request an account from Sage by filling out the Sage Developer Services API - Request an Account form. Provide the required details and choose Sage 200 Standard API as the application you are developing for.
  2. Once your account has been created you will receive an email from Sage with a link to a my.sage.co.uk page, where you can sign in to get your account number under My account > My accounts.
  3. Request your API credentials by filling out the Sage 200 API Credential Request Form.
    When your API credentials have been generated, Sage will email your Client ID and Secret to you.

Note: When submitting the Sage 200 API Credential Request Form:

  • Request the maximum expiry time for the refresh token, namely 90 days.
  • Request via the form for each environment for which you require credentials.
  • For the question 'Desktop or Web Application' select 'Web'.
  • For the question 'Redirect URL(s)' enter:
    https://sage200cloud-uat.codat.io/oauth/callback for UAT
    https://sage200cloud.codat.io/oauth/callback for Production

Retrieve the API subscription and signing keys

Subscribe to the Sage API for Sage 200 Unlimited.

  1. Go to the Sage API page.
  2. In the top-right corner, select Sign in, and follow the instructions to register your details.
    When your registration is complete, you're automatically taken to your account profile.
  3. Return to the Sage API page.
  4. Under Products, choose Sage 200 Unlimited. The Sage 200 Unlimited page is displayed listing the APIs available for this product and it covers both Sage200 Standard and Sage200 Extra/Professional.
  5. Select Subscribe.
  6. Select the By subscribing to Sage 200 Unlimited... checkbox and select Confirm.

Retrieve your signing keys

  1. From your profile, in the Your Signing Keys section, select Get Keys.
  2. Select Show and then copy the Primary key value to a Word document or similar. This is the signing key that you need to set up your integration in the Codat Portal.
  3. Close the dialog box to return to your profile details.
  4. In the Your subscriptions section, again select Show and copy the Primary key value. This is the subscription key that you also need to set up your Codat integration.

Add your secure keys to the Codat Portal

📘

Use the correct Codat Portal

  1. Open the Codat Portal and log in.
  2. In the left pane, select Integrations > Accounting.
  3. Scroll down to the Sage 200cloud integration and select Manage.
  4. From the details you received in the email from Sage support, paste in:
    • Client ID
    • Client Secret.
  5. From your Sage API subscription, paste in your Subscription Key.

📘

Spaces in secure keys

Make sure that your secure keys don't contain any spaces.

  1. Select Save.
  2. Enable your integration. Go back to Integrations > Accounting, and use the toggle to update the Sage 200cloud integration from Disabled to Enabled.

Your Sage200 cloud integration is now set up.

Test your integration

We recommend that you test your integration before sending link URLs to customers. You'll need your own Sage200cloud account to do this.

📘

Sage200cloud trial accounts

Unfortunately, you can't use a trial account to test your integration. Sage doesn't allow the creation or update of records from their trial accounts.

  1. Set up some test data in your Sage200cloud account. For example, some new or amended invoices.
  2. Next, go to the Codat Portal where you've enabled your integration and create a test company.
  3. Find the link URL for your test company. Select View Link URL next to the company name.
  4. Use the link URL to connect your Sage 200cloud account.
    • When the link site opens, select Sage200cloud, and then select Continue to Sage 200cloud.
    • Log in to your Sage 200cloud account.
    • Authorise access to your account details.
  5. Make sure that test data from your account is displayed for your test company in the Codat Portal.

Request new credentials

If you already have a Sage Developer account, you won't need to register an account and can just request credentials. To request credentials:

  1. Sign in to your account on My Sage page and go to ‘My Accounts’ where you can find your account number.
  2. Fill out the Sage 200 API Credential Request Form to request new API credentials.
  3. Retrieve subscription key by subscribing to the Sage 200 API on the Sage 200 API page for developers.
  4. When your API credentials have been generated, Sage will provide Client ID and secret via email.

Note: When submitting the Sage 200 API Credential Request Form:

  • Request the maximum expiry time for the refresh token, namely 90 days.
  • Request via the form for each environment for which you require credentials.
  • For the question 'Desktop or Web Application' select 'Web'.
  • For the question 'Redirect URL(s)' enter:
    https://sage200cloud-uat.codat.io/oauth/callback for UAT
    https://sage200cloud.codat.io/oauth/callback for Production

🚧

Balance sheets in Sage 200's sandbox data

If you link a Codat test company to one of the Sage sandbox accounts, the balance sheet dataset will fail to sync, and shows the status ValidationError. This is because the dataset fails Codat's checks, which make sure that a balance sheet balances, that is, net assets are equal to equity.

📘

Tax rates on line items

Due to a Sage 200cloud limitation, tax rates on line items for invoices, credit notes, bills, and bill credit notes appear differently to other integrations. For more information, see Sage 200cloud limitations.


Did this page help you?