Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

tk

Process for importing hours and rate adjustments

  1. Export T&A Codes
  2. Complete spreadsheet
  3. Upload CSV file

Export T&A Codes

  1. In the toolbar, click the System Setup icon (  ).
  2. From the drop-down list, select Time & Attendance > T & A Codes.
    The T & A Codes screen appears.
  3. If necessary, click Filter (  ) and select the types of codes to display on the screen.
  4. Click Export.
    A dialog box appears. The message asks whether you would like to export assignments.
  5. Do one of the following:
    • Click Yes to export assignments.
    • Click No to not export assignments.
  6. Select the destination folder for the exported file.
  7. Click Open.
    A dialog box appears to confirm that your file was exported successfully.
  8. Click OK.
    The dialog box closes.

Completing the CSV file

W

Uploading the CSV file

  1. In the toolbar, click the Main Menu icon (  ).
  2. From the drop-down list, under the Financial section, select Budgeting.
    The Budgeting screen appears in a separate tab.
  3. In the Adjust Hours and Rates row, click Update.
    The Hours and Rates screen appears.
  4. Click Related Tasks and select Import Adjustments from the drop-down list.
    The Add New Adjustment dialog box appears.
  5. Click Browse.
  6. Select the file.
  7. Click Open.
    The Import File field updates with the selected file.
  8. Click Add.
  9. Click Save ).
  10. Click Refresh ).
    The 

 

Fields in the hours and rate adjustment .CSV file

FieldDescriptionNotes
Start DateTheREQUIRED.
End Date REQUIRED.

Reconcile Code

 REQUIRED.
Job Name

Name of the job to which the adjustment is applied

You must enter the full path

REQUIRED.
Amount

Value for the adjustment.

The number can be for either dollar values or hours

REQUIRED.

Numeric only.

You can positive or negative values.

Adjustment Type (R, H, OT)

Enter the type of adjustment:

  • RAT—Rate adjustment
  • HRS—Hours adjustment
  • OT—Overtime Adjustment
REQUIRED.
Description REQUIRED.
Notes  
Job Rate Override (Y/N) REQUIRED.

 

tk

 

 

  • No labels