OnTrax Timesheets allows for the exporting of Payroll information for both Quickbooks and the Sage Accpac ERP system. In order to access the Payroll Export screen use the 'Integration' and 'Payroll Export' menu path.
Note: In order for individual users to be included in the Payroll Export they must have the 'Export to Payroll' setting set to Yes within the 'Rates' tab of the users 'User Maintenance' configuration.
Export Data:
1. Select the target system from the Payroll Export drop list.
2. Select the appropriate Version from the Version drop list.
3. Enter a Job ID and File Name.
4. Select "Full Load", "Delta Initialization" or "Delta Load" based on your requirements. For descriptions of how each load type works, please see the white paper entitled "9A. Exporting Data".
5. Select Payroll Options - chose which data will be exported, and chose if you want the hours to be marked as 'billed' in the target system.
6. Create your export file by selecting the 'Create Payroll Export' button
7. Download your payroll file from the bottom grid by selecting the download button for the appropriate run.
Mappings:
All three mapping sections need to have green indicators. If the export is not mapped properly, you may export information that will not be imported properly.
Ensure that all items within the "Project Mappings", "Project Item Mappings" and "User Mappings" screens are correctly mapped. This can be done by entering each of the mapping screens and verifying that Projects, Items and Users are mapped correctly.
Note: Mapping values within the mapping screen are accessible from an embedded drop list. In order to access the list double click the light yellow mapping cells. Values contained within the drop lists are configured thought the appropriate value entry screens accessed through the menu path Configuration --> Application
8. Select the 'Create Payroll Export' button in order to generate Payroll data for review prior to processing.