Versions Compared

Version Old Version 1 New Version Current
Changes made by

Knowledge Assistant

Knowledge Assistant

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution
  1. Browse Financials
>
  1.  > General Ledger Menu > Inquiries and Reports > CAFR Statement Builder/GASB34 Interface
  2. Click Accounts
  3. Enter desired find set of account selection criteria
  4. Click Accept
    • Selected record count will display below.
  5. Click Report Options
  6. Enter desired report options. ASCII File Name must and needed file extension (example file name: ACFRExport.txt)
    • Must be populated for ASCII export, 
  7. Click Accept
  8. Click Report Format
  9. Select 24 Column Report
  10. Click Create ASCII
  11. Browse System Administration > Miscellaneous Administration > File Transfer
  12. Select Download from spool directory 
  13. Order by Date and double click your file or select Accept


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleAdditional Information
  • Never use the Excel option it adds incompatible characters CAFR cannot process though import
  • 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

...