Customer Knowledge Base

Space shortcuts

Page tree

Harmony supports seamless 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 seamless integration with Microsoft Dynamics 365®Business Central. If you are looking  for the standard/file-based 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 created your account codes/numbers in Microsoft Dynamics 365® Business Central
  • Know if you require the export by document or by detail

Note: The remainder of this article will refer to Microsoft Dynamics 365® Business Central as "MSD365BC". 

Solution:

I. Setting Up Your Microsoft Entra Application in MSD365BC

  1. In MSD365BC, click the magnifying glass icon to open the search bar. 
  2. Search "Microsoft Entra Applications". Open the search result. 
  3. Click "+ New" to create a new Microsoft Entra Application Card. 
  4. In "Client Field", copy and paste "40cd915e-a20b-449d-814b-6dfd73c11b25" without the quotation marks. This is the application or client ID for Harmony Payroll. 
  5. Enter a "Description". For example, you can enter "Harmony Payroll". 
  6. In "State", select 'Enabled'. 
  7. Assign the permissions to the objects as required. 
  8. Click "Grant Consent". This will open a pop-up window that will require you to log into MSD365BC. 
  9. Log into MSD365BC in the pop-up window. 
  10. Accept the permissions as requested by the application. You will see a confirmation message. 
  11. Click "OK". 

II. Setting Up Your Default GL Export Interface in Harmony

  1. In Harmony, navigate to the Payroll module.
  2. Navigate to Admin Settings > Interfaces > GL Export Interfaces.
  3. Find “DYN365D* - Microsoft Dynamics 365 Business Central Detail (Seamless)” or “DYN365DO - Microsoft Dynamics 365 Business Central By Document (Seamless)”. 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. 

III. Connecting Harmony with MSD365BC

  1. In Harmony, navigate to the Payroll module.
  2. Navigate to Admin Settings > Interfaces > GL Export Interfaces.
  3. Find “DYN365D* - Microsoft Dynamics 365 Business Central Detail (Seamless)” or “DYN365DO - Microsoft Dynamics 365 Business Central By Document (Seamless)”. Click the three (3) dots to review the setup. 
  4. Enter the connection information as required. 
    1. Your "Tenant ID" can be found in MSD365BC. You can go to the Help & Support section in MSD365BC to verify (it is under the 'Report a Problem' section). 
    2. "Company" refers to the name your company. You may need to take extra caution if you have special characters in the name of your company. Take a look at the URL in your application - it should match accordingly. Please refer to the image below. 
    3. Identify whether you're using the "Production or Sandbox" environment in MSD365BC. You can go to the Help & Support section in MSD365BC to verify (it is under the 'Report a Problem' section). If you are using a 'UAT' environment, please enter the correct UAT name. 
  5. Click the save button to save your changes. 
  6. Click the "Test Connection" button to confirm that your connection information was entered correctly. You will see if the test connection was successful or not. 

Example Breakdown of the Microsoft Business Central URL (note: your URL may look similar, but not identical to this image): 

IV. Define Your GL Account Codes

There are two (2) ways for you to enter your general ledger account c odes in Harmony. 

A. Using Harmony's GL Code Finder

  1. In Harmony Payroll, navigate to Admin Settings > Payroll Preferences. 
  2. Activate the "Use GL Code Finder" toggle. 
  3. Click the save button to save your changes.
  4. Navigate to Admin Settings > Interfaces > GL Export Interfaces. 
  5. Find “DYN365D* - Microsoft Dynamics 365 Business Central Detail (Seamless)” or “DYN365DO - Microsoft Dynamics 365 Business Central By Document (Seamless)”. Click the three (3) dots to review the setup. 
  6. Click "Refresh Code Finder". This will refresh the list of codes from MSD365BC to input into Harmony. 
  7. Navigate to Payroll Setup > General Ledger Setup > Account Setup. 
  8. You should now see three (3) dot buttons next to the "Debit Account" and "Credit Account" fields. Click these buttons to view a list of all your account codes from MSD365BC. 
  9. You can either select the entire account code, or if you have a more complex structure, identify the string of characters to input. Click "Select" next to the payroll category to insert the account code into Harmony. If you're not sure which option to use, please contact Paymate Support. 
  10. Repeat steps 8 through 9 for each payroll category. 
  11. Click the save button to save your changes.

B. Manually Entering 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/payroll category/dimension that you have identified in your application. 
  3. Click the save button to save your changes.

V. 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.

VI. 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 four, Define Your GL Account Codes, and section five, 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 GL records should be exported to MSD365BC automatically if the connection was successful. 
  9. In MSD365BC, open your journal template as mentioned in step #7. 
  10. Click on the identified journal template as mentioned in step #7. Your transactions should be in this  batch with the batch date you entered earlier. 

What is the difference between detailed and by document exports?

Harmony Payroll offers two types of exports to MSD365BC: By document or by detail. By document means that the interface will create your transactions by net check/cheque for each employee. This is ideal for bank reconciliation. It will not require you to enter the journal document number, as the check/cheque number will be used instead. By detail means the interface will create transactions in the General Journals section of MSD365BC showing the complete check and GL details. You will be required to enter the journal document number when exporting.