SB Enterprise Help Center

CR 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 Confirm icon to export the audit data.
      • The export files will be in pipe (|) delimited format.
    • Once the export file has been generated, the Export Settings window will open.
      • Check the Open toggle if you would like to open the exported file after it is saved locally.
      • Enter the Full Path location and click the Save icon to export the data to the local path.
Previous Article CR Activity Details Report
Still Need Help? Contact Us