SB Enterprise Help Center

GL Audit Data Export

Updated on

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.
Previous Article GL Import GL Budgets
Next Article GL Refresh GL Keywords
Still Need Help? Contact Us