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 new Rate Sets can be updated within the timesheet import, as such the logic will not reject timesheets where a items are 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.

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.