eFollow these steps to set up the Exact Online integration between GoMeddo Subscription Management and Exact Online.

1. Create a Connected app in Exact Online.

Use the following steps to create a connected app in Exact Onlinehttps://support.exactonline.com/community/s/knowledge-base#All-All-DNO-Process-appcenter-eol-appcenter-dev-registerapp-p. When creating a new connected app, set the Redirect URI to a mock value, like https://www.gomeddo.com .

Make sure to note down the Client Id and Client secret, you need these in step 2.

2. Create an Auth. Provider in Salesforce.

In Setup, navigate to Identity -> Auth. Providers and click “New”. Create an Auth. Provider with the following settings. The values for Consumer Key and Consumer Secret should be copied from the fields Client ID and Client Secret of Connected app that was created in the first step.

After the Auth. Provider is saved, copy the value of “Callback URL” from Salesforce to the Redirect URI field in the connected app in Exact Online (which you filled with the mock value in step 1).

3. Create a Named Credential in Salesforce.

In Setup, navigate to Security -> Named Credentials, and at the top right, click “New Legacy”. Create a Named Credential with the following settings:

We will set up a connection to https://start.exactonline.nl, depending on your country this URL can change (for example for Germany we use https://start.exactonline.de).

After saving the Named Credential you will be redirected to Exact Online, where you will be asked to confirm the connection between Salesforce and Exact Online.

4. Update fields on the administration

You need to provide a couple of details on the administration record in GoMeddo Subscription Management related to the data that you want to sync with Exact.

• Named Credential - Fill in the name of the Named credential created in step 3 (Exact in the example)

• Balance Sheet For Debtors - The standard balance sheet used for debtors

• Default Ledger Account - The standard ledger code

• Company code - You need to fill this with the value of the division id in exact online. To find this:

  • Go to Exact Online click on the administration selector and click ‘all options’

  • Hover the administration from the list, in the url you will find the division id.
    

    

5. Correct Data

Now that you have a connection between GoMeddo Subscription Managament and Exact Online. You need to set some data so the connection works. You will need to create Debtor numbers (e.g. assign to an account which debtor number it has in exact when there is already a debtor in Exact Online). You can do this with the “manage debtor numbers” action on the account. You have to do the same for products, there is a button on a Product in Salesforce named “Manage Administrations” in which you can assign a ledger (which needs to be of type Profit & Loss in Exact Online).

VAT codes need to be created, they are related to the administration. in Exact Online you can find these under Master data (Stamgegevens in the screenshot below).

Make sure to include the leading zeros in the value if it is a number. For each VAT Rate, you require a corresponding VAT Code in GoMeddo Subscription Management under administration. In the image below you will find our VAT Code is VBI.

6. (Optional) Schedule the Job_GetOpenAmounts to retrieve the open amounts from Exact

Under the tab “GoMeddo Jubscription Jobs” you are able to schedule various tasks. One of them is a task to retrieve the open amount from your finance system. The name of this job is Job_GetOpenAmounts. If you schedule this from the page everyday the system will retrieve the open amounts from Exact Online.

🎉 After this the connection has been set up. You are now able to create debtor numbers in exact from Salesforce (or map account to existing debtor numbers) and invoices will be synced between GoMeddo and Exact Online.

Sync overview

The following fields sync between GoMeddo Subscription Management and Exact Online.