Versions Compared

Version Old Version 27 New Version 28
Changes made by

Frank Gambino

Frank Gambino

Saved on

Key

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

...

  1. Open the Import Hours and Rates Adjustment CSV file.
    Click here to open the Import Hours and Rates Adjustment CSV file.

    Info
    iconfalse

    Note: If you are unable to open the file or have any problems completing the file, contact your UniFocus Partner Relationship Manager.

  2. In the worksheet, enter each adjustment in a separate row. For each adjustment, complete the fields as necessary.

    Anchor
    field-descriptions-hra-csv-file
    field-descriptions-hra-csv-file
    Fields in the Import Hours and Rate Adjustment CSV file

    FieldDescriptionNotes
    Start DateDate on which the adjustments begins.

    REQUIRED.

    Format: MM//DD/YYYY

    End DateDate on which the adjustments ends.

    REQUIRED.

    Format: MM//DD/YYYY

    Reconcile Code

    Reconcile code (or T&A Code) configured for the job class.

    Tip

    Tip: Copy and paste the Reconcile Code from the exported T&A Codes file.

    REQUIRED.

    You must enter the reconcile code that is configured for the job class.

    Job Name

    Name of the job to which the adjustment is applied

    Tip

    Tip: Copy and paste the Assignment from the exported T&A Codes file.

    REQUIRED.

    You must enter the full path name of the job. Example: "Resort\Administration and General\Innkeeper".

    Amount

    Amount for the adjustment.

    The number can be for either dollar values or hours.

    REQUIRED.

    Numeric only.

    You can enter positive or negative values.

    Adjustment Type (R, H, OT)

    Enter the type of adjustment:

    • RAT—Rate adjustment
    • HRS—Hours adjustment
    • OT—Overtime Adjustment

    REQUIRED.

    Format:

    • RAT—Rate adjustment
    • HRS—Hours adjustment
    • OT—Overtime Adjustment
    Description

    A brief description of the adjustment. This description appears with an asterisk ( * ) in the Adjust Hours and Rates screen.

    Examples:

    • New Rate
    • Remove Vacation
    • Rate Increase

    REQUIRED.

    Although there is a 50-character limit in the corresponding database, UniFocus recommends that you keep this description as short as possible.

    NotesA note about the adjustment. 
    Job Rate Override (Y/N)

    Yes (Y) or No (N)—the amount will override the average rate for the job in the selected date range.

    Options include:

    • Y—Yes. The entered amount will override the average rate for the job in the selected date range. If you select Y, you must include all dates in each period to which you applying a new average rate. You cannot apply it to a partial period.
    • N—No. The entered amount is not a job rate adjustment; it is a date range adjustment.

    REQUIRED.

    Format:

    • Y—Yes.
    • N—No.
  3. Save the file to your computer . As as a CSV file.

Anchor
import-csv-file
import-csv-file
3. Import 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 Adjust 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 from your computer.
  7. Click Open.
    The Import File field updates with the selected file name.
  8. Click Add.
  9. Click Save (  ). Are these last two steps necessary? Necessary - YesClick Refresh ( Image Removed ).
    The screen updates and displays your imported adjustments. Not necessary.  If they do this before saving, they will lose data as the refresh goes back to the database and get the information stored in the database, not the local application.

 

...