HR to ERP
ADP Workforce Now to Dynamics 365 integration: workers from ADP as employees in Business Central, with dimensions and status
With an integration between ADP Workforce Now and Microsoft Dynamics 365 Business Central, every worker from ADP appears automatically as an employee in the right Business Central company, with department and cost centre as default dimensions. Leave and departure in Workforce Now set the employee in Business Central to inactive or terminated, with the end date from ADP.
What the integration does
Organisations with North American employees in ADP Workforce Now and their accounting in Business Central retype employees to post costs and expenses on the right dimension. People who change department still post to the old cost centre in Business Central, and leavers are still listed as active.
- Workforce Now reports a hire, leave, organisation change or termination; KoppelHet reads the worker.
- KoppelHet picks the Business Central company that belongs to the ADP company.
- The employee is created or updated, and home department and home cost number become default dimensions.
- Leave sets the employee to inactive; return sets it back to active.
- A termination sets the employee to terminated, with the end date from ADP.
What to watch for with ADP Workforce Now and Microsoft Dynamics 365
- Dimension values can only be read through the Business Central API, not created. A new home cost number in Workforce Now must therefore first be created by finance as a dimension value; KoppelHet checks this and keeps the employee on a list until then.
- Business Central has three statuses for an employee: active, inactive and terminated. Workforce Now sends a separate event when someone goes on leave. KoppelHet then sets the employee to inactive, so no new costs are posted to them, and back to active on return.
- The Business Central API works per company. If Workforce Now has a US and a Canadian company that are each a separate company in Business Central, KoppelHet writes every worker to the company that belongs to their ADP company, and moves them along on a transfer.
- A new home department or home cost number triggers its own event in Workforce Now. KoppelHet then only changes the employee's default dimensions, so expenses from that moment fall on the new cost centre.
- Changes that arrive in Workforce Now through the API, for example from a recruitment system, produce no event. KoppelHet's nightly comparison catches those changes, so Business Central is up to date then too.
- The employee record in Business Central also has fields for date of birth and bank account. Those are masked by default in Workforce Now and are not needed for postings; KoppelHet leaves them empty and does not request them unmasked.
How we build and run it
- The integration runs on the KoppelHet platform, hosted in a data centre in the EU.
- Every sync and every error is visible in the functional log; on an error your administrator is notified.
- A change that cannot go through is not half-applied but queued for another attempt.
- KoppelHet is ISO 27001 certified. Data travels encrypted and stays on the platform no longer than needed.
- After go-live we manage the integration and adjust it when your process changes.
- The integration fits next to your existing integration layer. Only the fields in the design are transferred; the platform keeps no register of its own.
Implementation and price
This is not an app you switch on. We build the integration for your organisation on our platform, with building blocks we reuse on every project. So it is custom work that does not start from scratch.
A consultant prepares the intake and analyses both systems. We then record the mapping and exceptions field by field, test in the test or acceptance environment and go live at a moment you choose. Costs are a one-off amount for the setup and a monthly amount for platform, monitoring and support.
Frequently asked questions
Does this also work with Dynamics 365 Finance?
This page assumes Business Central. Dynamics 365 Finance uses other entities for workers and employments; we look at that at the start.
Does the payroll journal from ADP go to Business Central too?
Not in this integration. The journal is a separate payroll to finance integration, which can be added later as an extension.
Technical details for IT
For those who want to know how it works under the hood: APIs, fields and sources used.
- ADP Workforce Now through the Worker Management API: GET /hr/v2/workers ($top up to 100, asOfDate MM/DD/YYYY, masked by default) and events worker.hire, worker.rehire, worker.onLeave, worker.terminate and worker.workAssignment.homeOrganizationalUnits.modify; events only on changes in Workforce Now itself.
- Business Central through API v2.0 per company: employees (POST, PATCH; number, givenName, surname, jobTitle, email, employmentDate, terminationDate, status Active, Inactive or Terminated) and defaultDimensions with parentType Employee; dimensionValues GET only.
Which fields are transferred
The key fields. The full mapping is agreed per customer.
| Field in ADP Workforce Now | Field in Microsoft Dynamics 365 | Notes |
|---|---|---|
workers/workerID/idValue | number | Business Central number of up to 20 characters |
legalName (givenName, familyName1) | givenName en surname | |
Job title van de primaire positie | jobTitle | |
Werk-e-mail | email | |
Company | Business Central-bedrijf | Through a table |
Home Department | defaultDimensions (afdeling) | |
Home Cost Number | defaultDimensions (kostenplaats) | Value must already exist |
hireDate en terminationDate | employmentDate en terminationDate | |
workerStatus en worker.onLeave | status (Active, Inactive, Terminated) |
Related
ADP Workforce Now → 4PS Construct
ADP Workforce Now to 4PS Construct integration: employees with company, dimensions and statistics group in 4PS
ADP Workforce Now → Active Directory
ADP Workforce Now to Active Directory integration: accounts in your own domain, with expiry date and rehire from ADP
ADP Workforce Now → AFAS Profit
ADP Workforce Now to AFAS integration: Dutch employees from the US HR system in AFAS Profit
ADP Workforce Now → AllSolutions
ADP Workforce Now to AllSolutions integration: employees with department, cost centre and manager in AllSolutions