Resource Center Home
Resource Center Home

HR and Payroll for Dynamics GP

HR and Payroll for Dynamics GP

Clock Data Import

From your Advanced Time and Attendance Dashboard, click the Payroll Functions tab and select Imports.

Click on Add New Record.

  1. Name the import Clock Data Import, (or what ever type of import you are doing)
  2. Select File Type Delimited
  3. Delimiter use: ,
  4. Start import at row 2 (Use position 1 as a header)
  5. Special formats:
    1. Decimal separator use: .
    2.  Date format: MM/dd/yyyy hh:mm    *MM stands for month, mm stands for minute*
  6. File Structure (position #’s correlates to columns A, B, C etc. on import template)
    1. Card ID          Position 1
    2. Start Time     Position 2
    3. End Time       Position 3
    4. Total Time    Leave blank
    5. Punch Type   Position 6
    6. Punch Class  Position 1

Click Save

Now you will see it under your imports