Timesheet Import - New Validations to Support Changes

Condition

Error Message

Comments

A timesheet includes an additional item for which a pay rate cannot be specified (non-direct valuation) on the timesheet but a pay rate has been specified.  This now only relates to Agreement Rate Jobs, as for Standard Rate Jobs a new pay rate can be added.

Additional item rate cannot be supplied.

The condition has been updated as this item will now only apply to timesheets for Agreement Rate Jobs.

A manual item is not available in the Job Order for the import date supplied.  This is now only applicable to Agreement Rate jobs.

Manual Item not available for this timesheet date.

This is now only applicable to timesheets for Agreement Rate Jobs as for Standard Rate Jobs, new Rate Sets can be updated within the timesheet import, as such the logic will not reject a timesheet where an item is not in the job’s rates.

For a Standard Rate Job, a new Pay Code/Import Code has been provided, however the related Bill Code/Import Code has not been supplied OR

A new Pay / Import Code and Bill /Import code has been provided in the import, however the corresponding Pay / Bill Rate has NOT been provided. OR

The new Pay and Bill code provided are not linked ie; Bill Code does not have the Pay Code provided, linked in the Bill Code Maintenance.

New Pay Code must include the corresponding Bill Code and the Pay and Bill rate values.

This is a new validation message to support where a user wishes to import a new Standard Rate set along with the import item. The right fields must be mapped and values provided to trigger the insertion of the rate set into the related job’s standard rates.

Please be aware that where you wish to include a new Reimbursement item, the values required are:

• Reimbursement Item/Reimbursement Import Code

• Net

• GST/VAT (if applicable to the reimbursement being claimed, not required for the new rate)

• Bill Code/Bill Code Import Code

• Bill Rate (please be aware this value will be applied to the Job’s new Rate Set as a FLAT RATE - if you wish to use the same Reimbursement item for future imports, provide the Bill Rate required for each reimbursement, and this value will be applied in the Interpreter as a superseded rate value).

Pay Code IS in the Job’s Standard Rates, and new Pay / Bill Rates have been provided, however they have provided a Bill/Import Code that is not linked to the Pay Code.

The Pay Code must be linked to the Bill Code provided and Flat Rate Bill Type must be available to the Job’s Country.

Where a new Rate Set is being imported, the system checks to see that the Pay Code provided is linked to the Bill Code provided.

To support providing new Rate Sets with the import file, your system must be configured in Maintenance > Hierarchy > Country to support Standard Rate Bill Type of ‘Flat’.

Target Timesheet is the system generated zero result timesheet and the first adjustment timesheet defined in the import file group is a negative timesheet.  We cannot support this, first adjustment timesheet where the target is the zero result timesheet, must be positive.

Target Timesheet is original zero result timesheet.  First Adjustment Timesheet must be positive

Where the ‘Debit / Credit’ timesheet strategy is being used to import Standard Rates, into a job flagged as ‘Adjustment Only’, the data first timesheet for the week ending date must be positive values as this will be the original timesheet for that week.

Grouping value has been provided however data cannot be grouped as unable to sequence the values provided ie unable to group the data using the values provided.  This could include where Grouping is only applied to some of the rows for the same week ending date.  Must be applied to all rows to sequence.

Grouping values provided can’t be sequenced OR grouping values have not been provided for all rows with the same week ending date for the same job.

Where multiple iterations of a timesheet (same job same week ending date) are being imported, the grouping value must be assigned to all rows for that week ending date so the system can determine each iteration of the timesheet and the order.