...
| Info |
|---|
If the 3rd party system does not provide a unique timesheet ID, you can add a row to your data import and label it ‘Grouping’, then add values to define the relevant grouping sequence (e.g. 1, 2, 3 etc.). It is important to note that where multiple timesheets for same job and date are required, each row in the import must contain a grouping value. The values provided for grouping must be able to be sequenced ie; 1, 2, 3, 4 and must be whole numbers. For example, the system will not be able to sequence 1.2, 1.3, 1.4. |
...
In the data sheet example representation of an import file below, ‘Alt TS No’ was is used as the grouping. There are three iterations of the same timesheet, where the original timesheet is a Zero Result Adjustment Only Timesheet (click here for more details on this strategy). zero result adjustment only timesheet, as follows:
Alt TS No: 4556 - First timesheet is for 8 hrs of Ordinary.
Alt TS No: 4559 - The first adjustment, changes this to 7 hrs of Ordinary 8 hrs was not correct.
Alt TS No: 4563 - In the third iteration, the hours have not changed, however a reimbursement item was missed in the previous iterations.
...