The Exact Globe connector is a standard ERP connector that links Exact Globe to Tradecloud. It is supplied by AB Software and runs on the A.B. Entiteiten Interface (ABEI).
For: buyers using Exact Globe, and their IT partner
System requirements
A Windows server with an Exact Globe workstation installed. The ABEI tool (3 jobs version) is installed on it.
ABEI creates three databases in your Exact SQL Server: ABEI, ABEI_WS (web server) and ABEI_SSC. SQL Server version as required by Exact (currently 2012 to 2019).
A web server to receive data from Tradecloud. It runs inside ABEI (not IIS), on the same server or a separate one.
An HTTPS certificate installed on the server, in the default (Personal) store.
Port 8510 open from outside and forwarded to the ABEI web server. Another port, such as 443, is possible. Example URL: https://<customer>:8510/Generic/v1.1/od/SupplyChainConnector
The web server is secured with a bearer token, generated in ABEI.
SMTP or Exchange server details, so the connector can email unexpected errors.
[Image to add: generating the bearer token in ABEI]
Service account
A Windows service account runs the ABEI service. It needs read rights on the Exact Globe database and owner rights on the ABEI and ABEI_WS databases. The connector uses three SQL tables and some stored procedures, created in the Exact Globe database by default or in a separate database if preferred.
In Exact Globe, the service account must be able to edit order lines, add order lines, approve (fiatteren) orders within the purchase limit, process (verrichten) orders, and confirm orders. Turn off print preview for the service account.
Exact Globe settings
Entity Services and the SDK must be available.
Add a service under System / HR & security / Workstations, on the server where both ABEI and Exact Globe run.
Order approval (fiattering) must be switched on. Approval is the moment the order is sent to Tradecloud. Because changes from Tradecloud remove the approval, the service account must be allowed to re-approve.
For suppliers who use Tradecloud, tick Confirm order, so Exact Globe shows whether the whole order was confirmed in Tradecloud.
Tradecloud settings
Configure the integration under Integration in the Tradecloud company settings, including the webhook with the user and URL of the ABEI web server endpoint.
[Image to add: integration settings and webhook messages in Tradecloud]
Job SCC-1: sending orders to Tradecloud
This job sends orders from Exact Globe to Tradecloud, always as a whole order. If a line is added, the whole order is sent again. It needs both the Exact Globe and the Tradecloud connection configured.
Orders sent | Not completed; approved; last changed more than 5 minutes ago; at least one line with an item code and no goods receipt yet. |
Lines sent | Item code filled (no text lines); positive quantity (no returns). |
Multiple lines for the same item, and the open remainder after partial receipts, are grouped and shown as one line in Tradecloud. Orders and lines are never deleted in Tradecloud: if they are deleted in Exact Globe, they get the status Cancelled.
Job SCC-2: processing confirmations from Tradecloud
This job processes order lines with the status Confirmed, in four phases: import (store the data), translate (to the Exact Globe structure), enrich (add data from Exact Globe) and entry (update the order in Exact Globe).
For confirmed lines, the connector updates the net price, delivery date and total quantity (grouped by order, item code and date), re-approves the order, processes it, and confirms it once all lines are Confirmed.
Split deliveries
The delivery schedule is always initiated from Tradecloud, with partial deliveries grouped by delivery date. In Exact Globe, the original order line is changed to the first delivery moment and the other moments are added as new lines at the bottom of the order. Each item and delivery date combination can occur only once per order. The whole order is then sent to Tradecloud again.
Other logic
The contact person of the order in Tradecloud is set from the buyer's email address in the Exact order.
Allocations (toewijzingen) are not taken into account.