Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Setting up and using the TimeTrack export feature involves the following:

Table of Contents

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

...

Anchor
timetrack_exporting_timetrack_da_7715
timetrack_exporting_timetrack_da_7715

Anchor
create-an-export-file
create-an-export-file
Step 3: Create an Export File

You create an export file using the TimeTrack Export Wizard. You can also select to commit the TimeTrack batch as part of the export process. This is the same as selecting the Commit button in the Time Card Commit window.

  1. Select Transactions > TimeTrack > Time Card Commit.
  2. Select a batch. You can create an export file for multiple batches.
  3. Select Edit List to view the transactions before exporting. Transactions are verified after choosing Edit List

    Note

    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.


  4. Select Export to display from the ribbon.
  5. In the Welcome to the TimeTrack Export Wizard window, select Next.
  6. Select Next to display the Company Code and File Pathname window.
  7. In the Company Code field, use Enter the following:
    • Company Code: Use the lookup button to select a company code.
    • File Pathname: 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.
    • Period End Date: Enter thePeriod 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
    .
  8. Select 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).
  9. When you finish viewing the report, close the report window
    • .
    The Time Track Export Wizard continues and the Create export text file window appears.
  10. Select Next to create the export file. When the export is finished, the Commit selected batch window appears:
  11. Select Commit to commit the batch. When finished, the Report Destination window appears. The TimeTrack Export Wizard creates the TimeTrack Commit report

    Note

    If you select 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.


  12. When the commit process is finished, the following reports are printed:
    • Export Report: Includes the batch ID(s) and other information relating to the batch(es).
    • Posting Report: Includes the posting information for the commit.
  13. When you finish viewing the report, close the report window.
  14. On the Export Completed window, select Finish.
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.

...