Exporting TimeTrack Data to a Third-Party Payroll Module
You can export TimeTrack data to a third-party payroll module. To set up the export file, you map TimeTrack fields to third-party payroll module fields. You also specify a file name and location for the export file.
Currently, you can export TimeTrack data for the ADP PC/Payroll module.
Setting up and using the TimeTrack export feature involves the following:
Step 1: Enable the export feature
To enable the export feature, you must mark the setup option and select the file format to be used for the export file.
- Choose Microsoft Dynamics GP > Tools > Setup > Time Track > Setup Options.
- In the Third Party section, mark the Create a Text File for Export checkbox. The File Format drop-down is enabled.
- In the File Format drop-down list, select ADP as the file format.
- Choose Save.
Step 2: Set up the export file
To set up the export file, you map TimeTrack fields to third-party payroll module fields. You also specify a file name and location for the export file. The export file must contain a .CSV (comma-separated values) extension.
- Choose Microsoft Dynamics GP > Tools > Setup > Time Track > Export File Setup.
- Enter a company code.
In the Default Pathname for Export File field, enter a location followed by a file name for your export file. Click the yellow folder button to search for a location. The recommended location for ADP files is: C:\ADP\PCPW\ADPDATA\<filename>
When you click the yellow folder button, the Default Path for Export File window opens. If you select a location from this window, you must also type the file name in the same window. If you include the file extension in the file name, you must type it manually. The value (.CSV) in the File type field does not carry over into the Default Path for Export File field in the Export File Setup window.
The Export File Setup window fills in with the available fields.
- Each row represents a single field of data that can be exported. The most commonly-used (and required) fields are already selected, as indicated by the checkboxes in the Include column. To view additional rows, use the scroll bar on the right side of the window.
- The Column Name column references a corresponding column in the Signature holding table (This is an internal table that stores information to be included in the export file). The Field Name column contains the ADP fields.
Some of the default fields are required by the third-party payroll module. See Fields required by ADP Payroll below for a list of fields required by the third-party payroll module to which you are exporting.
- To include a field in the export file, mark the Include checkbox for that field. Fields required by the third-party payroll module are selected by default.
- Use the Mapped Field lookup button to select a TimeTrack field to map to the corresponding ADP field.
The SQL Statement column contains code that is automatically generated when you map a TimeTrack field in the Mapped Field column. You can customize the mapping of the fields by editing these statements and/or SQL stored procedures.
To edit SQL statements or stored procedures, you should be familiar with Microsoft SQL Server. For help, contact WennSoft Support.
- When you're finished with the Export File Setup window, click OK.
- To print the Export File Setup List for the selected company only, click the printer button. To print the Export File Setup List for all companies, click the Clear button to clear the window, then click the printer button.
Fields required by ADP Payroll
The following payroll fields are required by ADP Payroll module:
- Co Code
- Batch ID
- File #
See the ADP PC/Payroll user manual for more information on ADP requirements.
Step 3: Create an export file
You create an export file using the TimeTrack Export Wizard. You can also choose to commit the TimeTrack batch as part of the export process. This is analogous to clicking the Commit button in the Time Card Commit window.
- Choose Transactions > TimeTrack > Time Card Commit.
- Select a batch. You can create an export file for multiple batches.
Choose Edit List to view the transactions before exporting. Transactions are verified after choosing Edit List.
If errors appear in the edit list, do not continue with creating the export file. After correcting the errors, you can continue with the export process.
- Choose Export to display the Welcome to the TimeTrack Export Wizard window.
- Choose Next to display the Company Code and File Pathname window.
- In the Company Code field, use the lookup button to select a company code.
- The file and location default from the Export File Setup window. You can change the file and location of the export file. To change the location, use the folder button in the File Pathname field to search for a location.
- Enter the Period End Date for each technician record. If there are multiple daily hours logged for the week, all hours for a technician appear under one record with this end date.
- Choose Next. After a few moments, the Report Destination window appears. Select a destination for the report. We recommend that you mark the Screen checkbox to view the report on screen. The TimeTrack Export Wizard creates an Export report that shows the batch ID(s) and other information relating to the batch(es).
- When you finish viewing the report, close the report window. The Time Track Export Wizard continues and the Create export text file window appears.
- Choose Next to create the export file. When the export is finished, the Commit selected batch window appears:
Choose Commit to commit the batch. When finished, the Report Destination window appears. The TimeTrack Export Wizard creates the TimeTrack Commit report.
If you choose Cancel or Back instead of Commit, the information in the export file is deleted. To create a new file, you must start the TimeTrack Export Wizard from the beginning.
- When the commit process is finished, choose Finish.