GL> Utilities> Audit Data Export

Audit Data Export

 

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.