Customer Knowledge Base

Space shortcuts

Page tree

Harmony supports standard/file-based integration with Microsoft Dynamics 365®Business Central. You can easily import/export your employees, as well as import your GL entries.

Note: This article outlines the standard/file-based integration with SAP Business One®. If you are looking  for the seamless integration, please view this article instead.

Note: Harmony also supports standard integration with Microsoft Dynamics® Navision (NAV). For this integration, please view this article. 

Table of Contents:

Import/Exporting GL Entries

Prerequisites:

  • Have posted the payroll you’d like to export from Harmony
  • Have installed and configured the Microsoft Dynamics® add-on in Microsoft Dynamics 365® Business Central
  • Have created your account codes/numbers in Microsoft Dynamics 365® Business Central
  • Know if you require the export by document or by detail

Solution:

I. Setting Up Your Default GL Export Interface

  1. In Harmony, navigate to the Payroll module.
  2. Navigate to Admin Settings > Interfaces > GL Export Interfaces.
  3. Find “DYN365TD - Microsoft Dynamics 365 Business Central Detail” or “DYN365TO - Microsoft Dynamics 365 Business Central By Document”. Toggle on either one of these to activate it and set it as your default export interface. If you're not sure what the difference between these two are, see the bottom of this article. You can always change this at the time of your export. 

II. Define Your GL Account Codes

  1. In Harmony Payroll, navigate to Payroll Setup > General Ledger Setup > Account Setup.
  2. Define your debit/credit account numbers for each department and/or payroll category that you have identified in your application.
  3. Click the save icon at the top right to save your changes.

III. Define Your GL Account Structure

  1. In Harmony Payroll, navigate to Payroll Setup > General Ledger Setup > Structure.
  2. You can either create a new structure, or modify the pre-existing one that comes default in Harmony. By default, the structure is “Category GL” only. If you require departments code and/or department GL account numbers, you can make this change.

IV. Export Your Payroll / GL Entries

  1. In Harmony Payroll, navigate to Processing > Create GL Records.
  2. Select the appropriate filters for “Payroll Group” and “Filter by”.
  3. Click the refresh icon to pull up a list of employees according to your filters.
  4. Select the employees you want to create GL records for.
  5. Click “Create”. A document icon will appear next to your employees’ names. Click this icon to view their GL record and verify that the amounts are going to the correct GL account. If not, return to section two, Define Your GL Account Codes, and section three, Define Your GL Account Structure, above to modify the accounts and structure respectively. You will need to recreate these GL records once you've made your changes.
  6. Select the employees you want to export. Ensure that the correct GL Export Interface is selected in the far right dropdown list and click “Export”.
  7. Enter the appropriate "Journal Template Name" and "Journal Batch Name". If you are exporting 'by document', you will also need to enter your "Net Pay Bank Code". 
  8. Click “Export”. Your file should now be downloaded to your browser’s default downloads folder. Make a note of where your file is exported.

IV. Import Your File to Microsoft Dynamics 365® Business Central

  1. In Microsoft Dynamics 365®Business Central, navigate to General Journals > Actions > Payroll.
  2. Click “Import GL from Harmony” and select the file that you exported from Harmony. 

Import/Exporting Employee Records

Prerequisites:

  • Have existing employee records in Harmony or Microsoft Dynamics 365®Business Central
  • Have installed and configured the Microsoft Dynamics 365®Business Central add-on

Solution:

I. Importing Employee Records From Harmony / Import Into Microsoft Dynamics 365® Business Central

  1. In Harmony, navigate to Configuration > Employee > Employee Reports. 
  2. Select the "Employee Import/Export" report. Click "Open".
  3. Download this file into .CSV format. This file will be downloaded to your browser's default downloads folder. 
  4. In Microsoft Dynamics 365®Business Central, navigate to Employees. 
  5. Click the “Import Employee from Harmony” button to select the .CSV import file you exported from Harmony.

II. Exporting Employee Records From Microsoft Dynamics 365® Business Central / Import Into Harmony

  1. In Microsoft Dynamics 365®Business Central, navigate to Employees. 
  2. Click the “Export Employee to Harmony” button to download the .CSV export file to your computer.
  3. In Harmony, navigate to Configuration > Employee > Import. 
  4. Click "Click to Start" under Employee Exchange. 
  5. Click "+ New Interface" to set up the interface. If you've already set up the interface beforehand, select the interface and go to step 7. 
  6. After you've entered all the correct parameters, click the save icon to save your interface.
  7. Click "Choose File" and select the file you exported from Microsoft Dynamics 365®Business Central.
  8. Click "Upload". 

What is the difference between detailed and by document exports?

If you are using the Detailed GL export layout, then the interface will create transactions in your "Check" section of Microsoft Dynamics 365® Business Central showing the complete check and GL Details.

If you are using the By Document GL export layout, then the interface will create your transactions by net check/cheque payment for each employee. This is ideal for bank reconciliation.