Anchor
timetrack_exporting_timetrack_da_6582 timetrack_exporting_timetrack_da_6582

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.

1. Choose Microsoft Dynamics GP > Tools > Setup > Time Track > Setup Options.
2. In the Third Party section, mark the Create a Text File for Export check box. The File Format drop-down is enabled.
3. In the File Format drop-down list, select ADP as the file format.
4. 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.

...

1. When you're finished with the Export File Setup window, click OK.
2. 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.

Anchor
timetrack_exporting_timetrack_da_7715 timetrack_exporting_timetrack_da_7715

Fields required by ADP Payroll

The following payroll fields are required by ADP Payroll module:

...

See the ADP PC/Payroll user manual for more information on ADP requirements.

Anchor
create-an-export-file create-an-export-file

Step 3:

...

Create an export file

...

timetrack_exporting_timetrack_da_100timetrack_exporting_timetrack_da_100You 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.

...

Note: For SOP invoicing for Service Management users, if errors were found during the commit process, you must fix the errors and re-create the export file. See Correcting commit errors and re-creating the export file for more information.

...

If errors were found during the commit portion of creating the export file, you must fix the errors, re-create the export file, and copy and paste the corrected transactions into the original export file.
When you re-create the export file, valid transactions previously included in the original export file will not be re-created in the export file. Therefore, do not delete the original export file.
Note: This section applies primarily to users of SOP invoicing for Service Management, since errors are not reported until after the commit process and cannot be fixed until after the export and commit processes have finished.

1. Fix the transactions that contain errors.
2. Re-create the export file using a different file name than the original export file, and recommit the batch. See Create an export file.
3. Open both export files. These files should contain a .CSV extension, and appear in the folder you designated in the File Pathname field in the Company Code and File Pathname window of the TimeTrack Export Wizard. The default folder is C:\ADP\PCPW\ADPDATA.
4. In the re-created export file, copy a fixed transaction, highlight the corresponding transaction in the original file, then paste the new transaction into the original export file. Repeat this step for each transaction that was re-created in the export file.

Note: To copy an entire row in Excel, click the first column of the transaction, hold down the Shift key, then click the last column of the transaction.
Note: Make sure you do not overwrite valid transactions that appear in the original export file.

...