Microsoft Dynamics® Navision (NAV)

Import/Exporting GL Entries

Prerequisites:

• Have posted the payroll you’d like to export from Clarity
• Have installed and configured the add-on in Microsoft Dynamics^® NAV

Solution:

I. Setting Up Your Default GL Export Interface and Parameters

1. In Clarity, navigate to Setup > Preferences > Interfaces.
2. From the dropdown list, there are three (3) seamless interfaces associated with Microsoft Dynamics^® NAV: “Microsoft Dynamics Navision By doc (Seamless)”, “Microsoft Dynamics Navision By emp (Seamless)”, and “Microsoft Dynamics Navision Detail (Seamless)”. If you’re not sure what the differences are, view the end of this document.
3. In the same Interfaces tab, check the parameter box “Use code finder”. This parameter will provide you with a “Refresh GL Code Finder” menu option that will allow synchronization of GL accounts between NAV and Clarity.

II. GL Account Synchronization

1. Synchronization of the GL Account codes from NAV to Clarity allows the Clarity software to validate the accuracy of the accounts entered before making any attempts at transferring data.

III. General Journal Posting

1. General Journal Posting is the creation of General Journal entries in NAV so that the expenses and liabilities associated with doing payroll can be communicated to NAV.
2. You will need to define your General Journal Batches in NAV.

IV. Exporting Your Payroll / GL Entries

1. In Clarity Payroll, navigate to Payroll > Export > Export GL or Export GL Special.
2. You can change the parameter values for “1^st dimension segment” and “2^nd dimension segment” here if needed.
3. Once the parameters are entered, you can begin the export, in which Clarity will seamlessly connect to the NAV web service and export your GL entries into NAV.
   
   

Import/Exporting Employee Records

Prerequisites:

• Have existing employee records in Clarity or Microsoft Dynamics^® NAV
• Ensure that the statistic Group Codes in NAV match the Payroll Group Codes in Clarity
• Have installed and configured the add-on in Microsoft Dynamics^® NAV

Solution:

1. In Microsoft Dynamics^® NAV, navigate to the employee records. 
2. Select either “Import into Clarity from Microsoft Dynamics Navision Detail (Seamless)” or “Export from Clarity to Microsoft Dynamics Navision Detail (Seamless)”.
3. There will be two checkboxes: one for adding employees, and the other for overwriting (updating) employees. Make sure to only select one as the software does not allow you to add and update employees simultaneously.
4. In the following screens, you will see the employee information and details, which you can verify before completing the process.
   
   

Differences Between Export Interfaces

If you are using “Microsoft Dynamics Navision By Document (Seamless)”, the interface will create your transactions by net check/cheque payment for each employee. This is ideal for bank reconciliation.

If you are using “Microsoft Dynamics Navision By Employee (Seamless)”, the interface will create your transactions by employee number. When multiple paycards are transferred for the same employee, the information will be summarized into a single record.

If you are using “Microsoft Dynamics Navision Detail (Seamless)”, the interface will create transactions in your “Check” section of Microsoft Dynamics^® NAV, showing the complete check and GL Details.