Customer Knowledge Base

Space shortcuts

Page tree

Harmony supports standard/file-based integration with SYSPRO. You can easily import your GL entries into SYSPRO, in either a detailed or summary format.

Import/Exporting GL Entries

Prerequisites:

  • Have posted the payroll you’d like to export from Harmony
  • Have created your account codes/numbers in SYSPRO

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 “SYSPROS - Syspro Summary” or "SYSPRO - Syspro Detail". Toggle on either of these to set it as your default export interface.

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. Update the "Batch Date" as required. 
  8. Enter the "Date Range" as required, such as "mmddyy". If you do not enter anything, the default date format is yymmdd.
    1. Do not enter any slashes and the maximum length is 6 characters. Invalid entries include "mmddyyyy" or "mm/dd/yy". 
  9. Click “Export”.
  10. Enter the "File Name".
    1. Note: By default, without a file extension in the file name, the file will be downloaded as a .TXT file since this is a fixed-length file. You may enter ".CSV" at the end of the file name if you'd like to download the file as a comma-delimited (.CSV) file. 
  11. Click "Export". Your file should now be downloaded to your browser’s default downloads folder. Make a note of where the file was downloaded.

IV. Import Your File to SYSPRO

  1. In SYSPRO, you can now import the file you exported from Harmony. Navigate to Import > Financials > General Ledger Entries. 
  2. Ensure that the "Import Method" is set to "From File". 
  3. Ensure that the "File Location" is set to the correct place where you downloaded your file - either the server (on the network server) or client (on your local computer). 
  4. Click the magnifying glass button to browse for the file that you exported from Harmony.
  5. Select the file and click "Open". 
  6. You can click "Review File" to review the file. There may be errors that you can review in the Import Results section at the bottom.
  7. Ensure that you enter the correct "Period" and "Year".
  8. Enter the correct "Source Code". You can click the "View Source Codes" button to view all available source codes to select the correct one. 
  9. Tick "Post Journal". 
  10. Tick "Enter Reference, Date, and Comment". This will allow you to enter additional fields to the batch and enter a standard date.
  11. Enter any "Reference" or "Comment" if required. 
  12. Select the correct "Date" as your batch date. 
  13. Click "Import". Your imported records should appear on the right side of the window. Scroll to the far right to verify and see if there are any error or warning messages.