The Adjustments selection criteria can be used to determine which adjustments, if any, should be included within the output. The options include:
No Adjustments -- all adjustments will be excluded from the export.
Include Adjustments using Posted Date -- only those adjustments that have Post Date within the specified date range will be included in the export.
Include Adjustments using Worked Date -- all adjustments that were applied to the specified date range will be included in the export.
ONLY Adjustments using Posted Date -- no other data than the time data with adjustments within posted date will be exported.
ONLY Adjustments using Worked Date -- no other data than time data with adjustments within worked date will be exported.
Further, you have two additional options related to the inclusion of adjustments (when an option other than "No Adjustments" has been selected in the drop-down above):
Note that both of these options are disabled if the "No Adjustments" option is selected.
For example, suppose you had a timesheet cell of 4 hours entered on 1/1/2010 that was extracted at the end of the period. You subsequently changed the entry from 4 to 6 hours on 1/10/2010 and again extracted that time. You then again modified that entry changing it from 6 to 8 hours on 1/18/2010 followed by another extraction. This would leave you with the following adjustment entries if you were to export the data:
Original entry 4 hours
Adjustment entry -4 hours
Adjustment entry +6 hours
Adjustment entry -6 hours
Adjustment entry +8 hours
Checking this option, the resulting output would include only the following adjustment entries -- with the intermediate entries suppressed:
Original entry 4 hours
Adjustment entry -4 hours
Adjustment entry +8 hours
Note that the adjustments included in the output are in no way influenced by the options selected in the "Timesheet Status" selection criteria.
Note: Pending End User Adjustments will not be included in the output.
Timesheet Post Date Tidbits
The Post Date field related to each timesheet cell entry will be populated as follows:
Regular Time Entries - The Post Date field stamped on regular (non-adjustment) timesheet entries (and item entries) will be the same as the Work Date for that entry. Regular/Original timesheet entries will always have the Post Date equal to the Work Date.
Administrative Adjustments - When a Unanet Administrator enters a timesheet adjustment via the Administrative Timesheet Adjustment feature, the Administrator has the option of setting the Post Date and as such it will reflect whatever the Administrator entered. Note that the post date must be >= the timesheet cell work date being adjusted.
End User Adjustments - When an End User Timesheet Adjustment is initially entered, the Post Date stamped on the record is equal to the Work Date for that timesheet or item cell. Once the Adjustment entry has been approved by the final approver, however, the Post Date is updated to reflect that final approval date.
Person Profile > Rate Tab Adjustments - For those adjustments resulting from an Administrative change to a person's profile rate tab information, the post date will be set to the date of the change (i.e., today's date).
Person Profile > Person Dilution Adjustments - For those adjustments resulting from an Administrative change to a person's profile dilution screen entry, the post date will be set to the latest un-extracted post date (if any un-extracted adjustments already exist on that timesheet), otherwise, today's date.
Time Import Adjustments - For those adjustments resulting from an Administrative user importing time, the file can optionally include a specific post date value, or if not provided, the run date of the import (i.e., today's date) will be used.
When using a Weekly Overlap or Every Two Weeks Overlap time period type, you may want to enable the Prevent Posting On Weekly or Every Two Weeks Overlap Day (unatime.prevent_post_on_weekly_overlap) property.
While your business policy may dictate a specific scheme for the use of post date, one common practice is to set the post date to a date in the current time period. Doing so will allow you to include in your time extract any adjustments for any prior periods along with the most recent regular timesheets, by selecting the adjustment option "include adjustments based on post date".
Note: This Post Date should not be confused with the Post Date set during any of the Financials Posting activities.