Exact Online Debtors Extension

Installing the extension

In Vertec, open Interfaces > Extensions in the folder Settings. Open the Exact Online Debtors Extension and click Install.

Register the Vertec app in Exact Online

Log in to your Exact Online.

Navigate to Manage my apps and click Register app.

• You are free to choose the Application name.
• Under Redirection URI enter the URL where your Vertec instance can be reached, followed by /callback, e.g. https://mycompany.vertec-cloud.com/callback
• Copy the Client ID to the system setting Exact Application ID
• Copy the Client Secret to system setting Exact Application Secret
• The Webhook Secret is not required for Vertec.

Settings in Vertec

System settings

Some system settings are installed for all debtors extensions. These are listed in System settings > Accounting.

Specific system settings for the Exact Online Debtors Extension are:

Prerequisites

• When transferring addresses, send 2-digit ISO code for the country. The Vertec field standardcountry will be checked for a two-digit entry, otherwise an error message will appear. Make sure that the country on your addresses is filled with the correct code.
• The Payment Terms in Vertec must be identical to those in Exact.
• The Vat codes must be identical in Vertec to those in Exact.
• Collective account debtors and creditors must be entered in Vertec System Settings Account, but are irrelevant for Exact. The collective account defined in Exact in the posting journals is always taken, see section Settings in exact online.

User rights

Vertec requires the following user rights to work with the Vertec Exact Online Extension. It is best to set up your own User Group and assign the appropriate users.

Authentication

When a user logs in to Exact Online for the first time via Vertec, a login page appears where they can log in with their user.

The question appears whether the app should be accepted access. If the answer is yes, and the user has sufficient rights to the FAR client, the login is done via OAuth.

Settings in Exact Online

If you want to work with foreign currencies and exchange rates, you have to select Variable: Currency and Variable: Exchange rate in the posting journals in Exact.

The collective account is also defined on the posting journal in Exact.

Post / write addresses

How debtors are written is explained in detail in the article Posting debtors with Vertec.

With Exact Online, these special features apply:

• The REST API of Exact is limited to a maximum of 60 entries per API request with the standard licensing.
  • The Vertec Exact Online extension throttles the sending of requests before the limit is reached to prevent the user from being locked out of Exact for 10 minutes. This can lead to a couple of minutes waiting for larger postings or cancellations, or for a global Payment import with vertec.
  • It is important that the session does not terminate during the wait times, so do not exit Vertec during this process. Python Console logs when the throttling occurs and how many seconds to wait.
  • Depending on the size of the company, licensing the premium solution from Exact is recommended.
• Exact works with GUIDs in the background. These are unique and allow you to verify an object in Exact. With the Vertec Exact Online Extension, the GUID is stored in Vertec on addresses and invoices in a Key named ExactGUID.
  • When interacting with the objects in Exact, the Exactguid is used, not a new request is made via API in order to handle requests sparingly due to the above limitations.
• As a personal account, the internal ID of the Vertec posting address is entered in Exact.
• The exchange rates of Exact are taken into account. In the extension there is no conversion with a Vertec exchange rate.
• Posting journals: For debtors, the number 70 – Sales is transmitted.

 The addresses in Exact are populated with the following values from Vertec:

Multi-client capability

Each FAR client in Exact has its own root data. The address master data applies to debtor and creditor addresses. Whether it is a debtor or a creditor is distinguished by a flag in Exact.

If the same Vertec address is used as Exact accounts receivable and accounts payable, the same PK PersonalAcc is entered in Vertec in the personal account debtors and personal accounts payable fields.

The same address cannot be posted or created in several Exact divisions at the same time, since the personal account in Vertec is unique and only one GUID of Exakt is written in Vertec (see above).

If there are invoices / creditors from different Exact divisions in a list posting, a message is shown:

Cancellation

There are 2 Cancellation Methods:

• Cancellation: Delete the posting in Exact
  • The system setting Exact Delete linked documents (cancellation) in Vertec defines whether all document objects linked to the posting in Exact should be deleted.
• Internal credit note: Creates a counter posting with reversed signs in Exact.

Payment import

In order for the payment to be found at Payment import with vertec, it must be ensured that it is linked to the corresponding posting in Exact.

The payment is always created in Vertec based on the currency on the invoice. If, for example, a USD payment is entered on a EUR invoice in Exact, the payment import converts the amount to EUR and writes this value in Vertec to the payment. Thus, small rounding differences may occur if several partial payments are entered.