With AccountLinx, you can export your employees' time data from ExakTime Connect into a compatible file for Microsoft Dynamics GP Project Timesheet. As Dynamics GP may be customized to fit your company's needs, it is possible that the default AccountLinx export for Dynamics GP will not match your Dynamics GP setup exactly. Please read through this article before setting up AccountLinx to understand what is needed ahead of time.

If you have any questions or concerns during setup and/or use, you can contact us with the "Request Support" link at the top of the page and we will try to assist as best as possible. Keep in mind, however, that we are not Dynamics GP support. We will try to help you as much as we can, but there are aspects of Dynamics GP that are out of our area of expertise and your questions may be better answered by Dynamics GP support or your trusted contact to answer/assist.

Selecting Dynamics GP as your Exporter

1. Go to Tools and click Exporter Settings.... 
2. The Exporter Settings window should open. Click Select Exporter.... 
3. A window with a list of available exporters should open. Select "Dynamics GP Project Timesheet" and click OK.
4. From the Exporter Settings window, click Advanced...
5. Select Create a custom export filename.
6. In the Filename field, enter "GPHeader". In the Increment Number field, enter "0". Then click OK.

AccountLinx Settings Unique to Dynamics GP Project Timesheet

The Dynamics GP export for AccountLinx offers a variety of settings when exporting your time data to help tailor the time data to your company's needs. These settings are unique to AccountLinx and will not affect ExakTime Connect or Mobile. If any of the settings offered do not sound familiar, you may not be using the setting in Dynamics GP and can leave it as <None>. 

1. Go to Tools and click Exporter Settings.... 
2. The Exporter Settings window should open. Click Configure....
3. The Configuration window should open. You should see the following options:
   
   • Default Payroll Codes
     • Regular - Enter the regular payroll codes as used in Dynamics GP.
     • Overtime - Enter the overtime payroll codes as used in Dynamics GP.
     • Overtime2 - Enter the overtime 2 (doubletime) payroll codes as used in Dynamics GP.
     • Currency Code - Enter the currency code that would be used by Dynamics GP.
   • Use Alternative Payroll Codes
     • Map Payroll Codes to - Specify if an alternate payroll code should be associated with specific employees, locations, or cost codes. This allows particular employees, locations, or cost codes to have an alternate set of payroll codes when exported. The related mapping screen will show fields to enter the payroll codes that should be associated with exported time records. If an entity does not have an alternate payroll codes, it will use the default payroll codes instead.
   • Other Export Options
     • Map Bill Type to - Specify which entity the bill type should be associated with. The related mapping screen will have additional fields for you to complete.
     • Department - Specify which entity the department should be associated with. The related mapping screen will have additional fields for you to complete.
     • Position - Specify which entity the position should be associated with. The related mapping screen will have additional fields for you to complete.
   • Comments/Notes Export
     
     • Specify if employee, location, cost code, or time record comments should be included with your time data export.
   • Timesheet Number - Used to denote each row of a unique employee.
4. Click OK on the Configuration window and click OK on the Exporter Settings window to return to the main page of AccountLinx.
5. Click the appropriate "Map Employee/Location/Cost Code" option to see the columns from the options enabled in Step 3.

General Use of AccountLinx

After setting up the configuration of AccountLinx to better match Dynamics GP in the previous section, you will need to:

• Map your entities so any time data associated with an ExakTime entity will match with a Dynamics GP entity and fill in any relevant fields enabled in the previous section. Refer to the following article if you are unfamiliar with mapping your data in AccountLinx.
• After mapping your entities, you can export your time data into two files to import into Dynamics GP. Refer to the following article if you are unfamiliar with exporting time data from AccountLinx.

Example of AccountLinx Export

An example of an AccountLinx export has been provided below. The data have been preformatted based on Dynamics GP Project Timesheet template. The presented values can differ depending on your settings.

Header File

Detail File

While you can manipulate the exported data after it has been exported, it is highly discouraged as it can result in data discrepancies when double-checking any data.

How to Import Time Data into Dynamics GP

The file you created is now ready to import into Dynamics GP Payroll Transaction. You must first have installed the "Integration Manager" with the "eConnect Destination Adapter", and applied all service packs for both Integration Manager and eConnect. Once both are installed, reinstall Integration Manager using the "Add Features" option and select "eConnect components"

To configure the Integration Manager:

1. Open the Integration Manager.
2. Create a new integration and call it something meaningful like "Exaktime Import".
3. Right-click on Sources and choose Add Source.
4. Choose Text, then Define New Text.
5. Under File, browse to the location of the output file and select it.
6. Make sure Comma is set as the delimiter, and First Row Contains Column Names is selected.
7. Click OK.

It is recommended to consult with Dynamics GP for further assistance with importing and using the time data as they are more knowledgeable of utilizing their system.