Description
The existing Timesheet Import process has been enhanced to support the following scenarios:
Ability to import multiple timesheets for the same job and the same week ending date
Currently when using Timesheet Import to support importing timesheets and adjustments, a user can only import one adjustment timesheet for the same job and same week ending date. This is limiting where data from the third party system needs to be imported in bulk, with all of the timesheet’s iterations. To support this requirement, a new setting ‘Adjustment Only’ has been added to the Client and Job record’s Pay/Bill section. Once ticked where the job is Submitted to Timesheet, zero result adjustment only timesheet headers set to ‘Released’ are automatically generated. These headers only display in the Time & Attendance 'Historical’ Tab, providing users with the ability to bulk import the original timesheet and subsequent adjustment timesheets in one file.
The system will be able to generate multiple timesheets for the same job and the same Where this To determine what file data for the same job and week end date is Users will not be able to key data into these timesheets and they will only be used as the original target shell timesheet where an Adjustment Timesheet is imported.
Field Mapping Changes
In stage 2 of the import process ‘Import Settings’ page, we have made some changes and additions (shown in red) to the existing Field Mappings ‘Map to Fields’:
New / Updated Map to Fields | Description | Data Format |
Attendance / Absence Item Name | Updated to provide ability to map to an Attendance Item Name or an Absence Item Name | Alphanumeric (maximum 255 characters) |
General Validation Changes
If an item in the import file can be matched to a unique job order in the database, Timesheet Import will then perform general validation to ensure that the data provided in the item is correct.
We have made some changes to the conditions that may cause an item in the import file to fail the general validation where the timesheet includes Reimbursements, Absence Items or the Timesheet is an Adjustment Timesheet. These condition errors will be reported in the exception report as per the existing process.
Condition | Error Message |
|---|---|
Data has already been keyed in and saved on the target timesheet in Time and Attendance and there is no Adjustment Reason provided | The timesheet item has been keyed so may be a duplicate. If this is an Adjustment Timesheet, a valid Adjustment Reason must be assigned to the timesheet for an Adjustment Timesheet to be created. |
Benefits
Th
Configuration
No changes to p