Page Comparison

...

To achieve the ability to bulk import timesheet iterations, for example on an import file will contain all of the adjustment timesheet iterations may contain more than one timesheet for the same job and same week ending date - for example an original and its subsequent adjustment(s), in the Import Wizard Import Settings, a new value setting is available and will need to be populated. This item, labelled ‘Grouping’, will enable you the system to determine from know the import file which field is to be sourced targeted to determine the timesheet iteration grouping. This In the import file, the Grouping value will need to be provided with assigned to each data row for the same job and week ending date. Where multiple adjustment timesheets need to be generated, the system will use the Grouping value to determine the rows required for each timesheet and the order of the timesheets. The ability to sequence the order is very important as each iteration of the timesheet needs to target the timesheet it is adjusting.

In the example below, I we have used the new Alternate Timesheet value as the grouping value, as this is a value from my VMS export that I will display that will be included in the import file and will be displayed next to each data row. Where there is data for more than one iteration of a timesheet for the same job and week ending date, the system will use Alt. TS Id to determine each timesheet and the order of each timesheet ie; Adjustment 1, Adjustment 2, based on the order of the group field. I We have also mapped this field in the Field Mapping area, as it is a value that is available on the timesheet, which will be helpful if I we need to cross check data with my the VMS.

If your system does not provide a Timesheet Id, you can add a row to your data import and label it ‘Grouping’, then add values to determine each timesheet required ie; 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.

...

In the data sheet example below, Alt ‘Alt TS No No’ was used for Grouping. I have 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).

...