...
Condition | Exception Report Message |
A row in the import file could not be matched to an existing, valid job order by any of the job ID fields. | Job Order cannot be found. |
A valid job has not been found for the provided Purchase Order Number. | Job Order Cannot Be Found for the Submitted Purchase Order Number. |
A row in the import file specifies a purchase order number but there are multiple job orders with the same purchase order number and item date and therefore the row cannot be matched to a single job order. | Multiple matching job orders identified for specified date. |
The Job Order has been identified by one of the Job Identifiers, but the interpreter manual item item date for this line does not fall between the job's start and end dates. | Specified Date Does Not Exist on the Job OrderThe manual item date must fall within the timesheet header date range. |
The Job has been determined from the provided information, and a Candidate has been identified from the provided information, but this candidate is not the candidate on this order. | Specified Candidate Does Not Exist on the Job Order |
...
Condition | Error Message | ||
No matching interpreted timesheet in the ‘Not Reviewed’ state is found that matches the Manual Item Date. | An Interpreted Timesheet with the state of ‘Not Reviewed’ cannot be matched to the manual item date. | ||
Multiple ‘Not Reviewed’ timesheets match to the Manual Item Date (for example where one is target and one is adjustment to target timesheet).
| Multiple Interpreted Timesheets match to the manual item date. |
...
The table below lists the conditions that may cause an item in the import file to fail the general validation. Except where stated otherwise, the entire timesheet to which an item in the import file corresponds will fail to import and an exception will be generated in the exception report.
Note |
---|
In the UK Reimbursement items can be flagged as ‘VAT UK - Exempt’. If an import file contains a Reimbursement item that has been flagged as VAT Exempt, and the VAT value has been provided, the row will not be excepted however only the Net value will be stored in the interpreted timesheet manual item, as the item is exempt from tax. |
Condition | Error Message |
A job order number has been provided in the import file but the corresponding job order does not exist in the system. | Job Order cannot be found. |
The Job ID field has been mapped but a job order number has not been specified for the item. | The job order number is mandatory. |
The Manual Item Date for an item falls outside of the date range of the timesheet. | The manual item date must fall within the timesheet header date range. |
The import code/item name of a Pay Code item within the import file does not match the import code/item name of any existing Pay Code item within the system for the Timesheet’s Country. | A Pay Code Import Code / Name does not exist in the system. |
The import code/item name of a Bill Code item within the import file does not match the import code/item name of any existing Bill Code item within the system for the Timesheet’s Country. | A Bill Code Import Code / Name does not exist in the system. |
A pay code name in the import file is not unique. | There are multiple pay codes with this name in the system. |
A bill code name in the import file is not unique. | There are multiple bill codes with this name in the system. |
The values for Timesheet Week Start Date and Timesheet Week End Date do not match an existing interpreted timesheet | Timesheet Week Start Date and Timesheet Week End Date values to not match an exiting interpreted timesheet. |
The Pay Code Name / Pay Code Import Code field is used in the field mappings but no item code is supplied in the import file. | Item code not supplied. |
The Bill Code Name / Bill Code Import Code field is used in the field mappings but no item code is supplied in the import file. | Item code not supplied. |
The Pay Code Name / Pay Code Import Code provided is not a Reimbursement Item, however values have been provided for other reimbursement fields. | Pay Code provided is not of type Reimbursement, however values have been provided for reimbursement fields. |
The Pay Code provided is a Reimbursement Item, values and mapping has been provided for Reimbursement Net and Reimbursement GST/VAT however value has also been provided for Pay Rate. | A Pay Rate and Reimbursement Net value has been provided for a Reimbursement Pay Code. Only the Reimbursement Net value is required. |
Pay Code provided is not a Reimbursement item, and Pay Rate value is null | Pay Rate value cannot be null. Zero is accepted. |
Bill Rate is null | Bill Rate value cannot be null. Zero is accepted. |
Pay Quantity is null | Pay Quantity cannot be null. Zero is accepted |
Bill Quantity is null or zero | Bill Quantity cannot be null or zero. |
The Enforce Project Codes option has been enabled on the job order to which an interpreted timesheet belongs, but the manual item does not have a project code. | Manual Item Project Code required. |
The Enforce Project Code Selection option has been enabled on the job order to which an interpreted timesheet belongs, but the project code provided for the manual item does not match any of the project codes defined as valid for the job order. | Manual Item with date <date><time> <date> has a Project Code that does not exist in the available pick list. |
...