Summary
The Audit Data Export tool is used to export GL data for state auditing purposes. This tool generates a set of pipe (|) delimited files that can be submitted through state auditing processes. The tool will generate an export file for each of the following tables:
- Table: gl_acct_1, Filter: Fiscal Year
- Table: gl_acct_2, Filter: Fiscal Year
- Table: gl_acct_3, Filter: Fiscal Year
- Table: gl_account_type, Filter: All data in table
- Table: gl_chart, Filter: Fiscal Year
- Table: gl_history, Filter: Fiscal Year
- Table: pr_employee, Filter: All data in table
- Exclude SSN from pr_employee export
- Table: pr_history, Filter: Batch Year
- Table: pr_deduction, Filter: All data in table
- Table: pr_pay_type, Filter: All data in table
- Table: ap_vendor, Filter: All data in table
- Exclude account_no, fed_tax_id, state_tax_id, and other_tax_id from ap_vendor export.
- Table: ap_history, Filter: Expense Fiscal Year *or* Check Fiscal Year
- Table: cr_category, Filter: All data in table
- Table: cr_distribution, Filter: All data in table
- Table: cr_type, Filter: All data in table
- Table: cr_line_item, Filter: Batch Year
- Table: cr_receipt, Filter: Batch Year
- Table: cr_receipt_payment, Batch Year
Step by Step
1 Export Audit Data tables.
- Open the Audit Data Export window (GL> Utilities> Audit Data Export).
- Select a Fiscal Year for the export file.
- Only the account data associated with this fiscal year will be included in the export file.
- Click the Submit button to export the audit data.
- The export files will be in pipe (|) delimited format.
- Once the export file has been generated, the Notifications icon will display a new notification. Open the Notification window and click the Job Completed Successfully link to download the export file.