Description of Issue

Need EERP data exported from General Ledger so it can be brought into ACFR

Context

Cause

EERP Export must be completed before importing to ACFR

Resolution

Browse Financials > General Ledger Menu > Inquiries and Reports > ACFR Statement Builder/GASB34 Interface
Click Accounts
Enter desired find set of account selection criteria
Click Accept
- Selected record count will display below.
Click Report Options
Enter desired report options. ASCII File Name and needed file extension (example file name: ACFRExport.txt)
- Must be populated for ASCII export,
Click Accept
Click Report Format
Select 24 Column Report
Click Create ASCII
Browse System Administration > Miscellaneous Administration > File Transfer
Select Download from spool directory
Order by Date and double click your file or select Accept

Additional Information

Never use the Excel option it adds incompatible characters CAFR cannot process though import
- ACFR Import Error - Fund Account number cannot contain a single quote
Excel option is only used for quickly checking selected data for review, not for CAFR import
Always use the Create ASCII" option with 24 column format
EERP can only export Current Year or Last Year EERP data.
- Sites can create their own files manually if CAFR needs data from before Last Year EERP. CAFR Trainers will tell sites no its not possible, logically it is though. Just not built into design of EERP to allow it.
  - Run reports in EERP to pull needed data (YTD Budget Report, Balance Sheet, Account Trial Balance)
  - Update a copy of working EERP export for CAFR in Excel then save once correctly populated to needed file format for CAFR Import.
Export file is created with a user name of **Unknown** so it cannot be found in Saved Reports as an invalid user name will not work with any EERP permissions.
How to find an exported file of a **Unknown** user name

Browser not supported