Harmony integrates with Sage 300.

Prerequisites:

• Have posted the payroll you want to export from Harmony

• Have created your account codes/numbers in Sage 300

Solution:

I. Setting Up Your GL Export Interface

1. In Harmony, navigate to the Payroll module.

2. Navigate to Admin Settings > Interfaces > GL Export Interfaces.

3. Find “SAGE300* - Sage 300”. Toggle this to activate it and set it as your default export interface.

II. Define Your GL Account Numbers/Names

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 of this window 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.

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. Change the “Batch Date” at the top of the page. By default, it will use the current date.

8. Enter the other fields as required.

   1. The “Source Type” may be “JE” for ‘Journal Entry’.

   2. Note: The “Source Type” and “Fiscal Year” will be saved for next time. You will have to enter the “Batch Number” and “Fiscal Period” with each export.

      Open

      

9. Click “Export”. Your file should now be downloaded to your browser’s default downloads folder. Use this file to import into Sage 300.

V. Import Your Journal Entry to Sage 300

1. In Sage 300, navigate to G/L Transactions > Batch List.

2. Click “New…”.

3. Enter the fields as required.

4. In the window, navigate to File > Import.

5. Change the “Type” to ‘Single CSV File’.

6. Click “Browse” and select the file you exported from Harmony.
   
   

   Open

   

7. Click “OK”. The file should be processed/imported without any errors. Click “Close”.

   1. If you have any errors, review the error messages and resolve in Harmony. You may have to re-create the GL records if required.

      Open

      

8. Review the journal entry in Sage 300 before clicking “Post”.