Atrieve Import/Export Timesheet/Variable Deduction Batch
How to export a timesheet/variable deduction batch and then re import back into atrieve
During this time of schools being closed and employees possibly unable to enter their timesheets in TEW from home, a quick way to create mass timesheets for employees is to use the Timesheet/Variable Export and Import process. This will allow you to export a previously created timesheet batch in payroll, edit as necessary and import back into atrieve.
Generate Payroll > Payroll Data Entry > Timesheet/Variable Deduction Export Process
The Timesheet/Variable Deduction Export Process offers the ability to export out a Timesheets or Variable Deduction records from a selected batch into .CSV files. The .CSV export file is defined in the exact format as used by the Timesheet/Variable Deduction Interface Process.
The Excel icon can be used to open the CSV export file to adjust the entry values before importing them back into the payroll.
Generate Payroll > Payroll Data Entry > Timesheet/Variable Deduction Interface Process
The Timesheet/Variable Deduction INTERFACE Process offers the ability to load Timesheet Entry or Variable Deduction records into a standard payroll batch that can then be processed by the payroll stream. For example, you can generate timesheet batch through a spreadsheet and load into the Payroll system as timesheets by this interface process.
This process validates all information per entry. Any rejected entries will be listed on a separate error/rejection listing along with the reason for the rejection. Each rejected entry includes a record number of the error. This number refers to the record number of your original file, providing a way for you to identify the invalid record. This interface process follows all the same rules as the Payroll Timesheet and Variable Deduction Entry processes.
