Use this tab to set up and determine timesheet export requirements. You can specify those UDT codes that should not be exported by including them in the Export Filter table and determine the file layouts for labor distribution and payroll.
For more information on exporting time information, refer to Export_Timesheets and to the Time & Expense with ESS Technical Guide.
For each UDT you are using, you can indicate in this table if you want to export charges entered for any of the UDT codes. You can also list codes in Export Filter that you do not want to export.
Select the Recast UDT10 check box if you want the option to reassign hours entered for one UDT10 code to another for labor distribution purposes when exporting time to another application.
If you have a UDT value that you do NOT wish to export, enter that value in the appropriate UDT cell to remove it from those timesheets that contain it.
If you have a range of UDTs that should not be exported, you can use a wildcard character to remove values that start or end with a specific character or characters. Enter a “%” after the characters to remove any UDT that starts with those characters. Entering the % before the character or characters filters out any UDT that ends with those characters.
Check the Export check box for those UDTs you want to export. If Export is checked, Time & Expense with ESS will export all UDT codes of that type, except for any you specify in Export Filter.
Select MO Only in Export In-Process Timesheets if you only want to export charges for manufacturing orders that have not yet been signed or approved. Select All Charges if you want to be able to export unsigned or unapproved charges of all types.
This option can speed up the billing process and provide more accurate data for reporting in Costpoint or other target applications.
Timesheets or manufacturing order hour cells that have been included in an in-process export are marked as "Sent." If you need to mark them as "Open" again, use the Change Timesheet Status utility.
Check Allow Export of Multiple Timesheet Periods if you want to allow the export of timesheets for more than one timesheet period in the same batch. For larger companies, this may reduce processing time.
Select the ASCII layout that should be used for your export file:
Costpoint 5.1/5.2
Costpoint 6x
Costpoint 7x or greater
GCS
Generic - Detail
Generic - Summary
None
During setup, select the value that matches the accounting system used by your company. If you later upgrade from one version to another or change from one product to another, change this selection accordingly.
If you select None, the exported timesheet labor records will not be transformed, but will instead stay in the staging tables. If you select a value other than None, the transformer will create an ASCII file that contains the records for the exported batch.
This field is only available when the ASCII Layout option is Costpoint 7.x or greater. Select this check box to enable the Salary Proration feature, which enables you to export timesheet data to Costpoint work schedules. You must also select the Export Work Schedules check box in Time ›› Process ›› Export Timesheets.
This field is only available if ASCII Layout contains GCS. It is used to indicate whether WBS (UDT02) data should be copied to another UDT field. These are your options:
Ref 1 - UDT04
Ref 2 - UDT05
None
If Time & Expense with ESS is configured to track Rate 1 information, check Export Labor Amounts to include the rates in the ETS file.
If ASCII Layout contains one of the Costpoint versions, check Summarize if you want to summarize the export data by timesheet line.
If Disabled is not selected from the Export In-Process Timesheets drop-down list and either Costpoint 6.x or Costpoint 7x is selected from the Export ASCII Layout drop-down list, the Summarize check box is automatically unchecked.
If you are going to export time to another application for labor distribution reporting, select the Recast UDT10 check box if you want the option to "recast" hours entered for one UDT10 code to another UDT10 code.
"Recasting" results in the creation of another export record that is essentially identical to the original export record except that it is associated with a different UDT10 code and labor amounts are recalculated based on the rate and other information associated with that UDT10 code. The UDT10 code to which a record is recast is specified when you set up the original UDT10 code in Time & Expense with ESS.
If the second UDT10 code also has a recast code specified, the export process creates a third record for that code. This process continues until a recast record is created for a UDT10 code that has no recast code.
Using recasting, you can simplify data entry for your employees while still being able to reclassify or subdivide that time for project labor reporting (to break the hours down into regular and overtime, for example).
If you are exporting your payroll information to ADP, specify the layout of the ACSII file in ASCII Layout in the Payroll group box. These are the options:
ADP - The exported payroll file is transformed using the standard ADP format.
ADP Rate - The ADPRATE format is used when the exported payroll file is transformed. This format contains all the columns of the standard layout and a temporary rate that overrides ADP's rate for the employee.
None - The file is not transformed.
If you export a payroll file to ADP, select the option that your company uses. This selection controls how batch IDs are built for ADP exports. These are the options:
Batch ID
Code 1
Code 2
Code 3
If you are going to export time to a payroll application, select the Recast UDT10 check box if you want the option to "recast" hours entered for one UDT10 code to another UDT10 code.
"Recasting" results in the creation of another export record that is essentially identical to the original export record except that it is associated with a different UDT10 code and pay amounts are recalculated based on the rate and other information associated with that UDT10 code. The UDT10 code to which a record is recast is specified when you set up the original UDT10 code in Time & Expense with ESS.
If the second UDT10 code also has a recast code specified, the export process creates a third record for that code. This process continues until a recast record is created for a UDT10 code that has no recast code.
Using recasting, you can simplify data entry for your employees while still being able to reclassify or subdivide that time for payroll processing (to break the hours down into regular and overtime, for example).