...
- 9. The QC data in EMISFFE includes the following. If the ITC has Cash Reconciliation, Civil Proceedings and Federal Assistance Summary and Detail information to enter for the reporting period, they may enter it in manually in EMISFFE
- 10. Once the QC data have been imported into EMISFFE, use the ‘Export data’ option to extract the reporting year's “H - July/Financial” data set and select only the ‘QC’ record to export and click on 'Export File'. It will create an IRN#_FFE-SEQ file that will need to be loaded into the Financial Data Source in EMIS-R. We strongly recommend running a test collection of the flat file data in the financial folder to ensure everything formatted correctly
EMISFFE Import Troubleshooting
CSV Invalid format error, this error will occur when the CSV layout does not match the Chapter 5 layout minus the filler, fiscal year and reporting period fields.
Negative numbers, must be formatted with a minus ( - ) sign. Negative values that are represented using parenthesis rather than a minus sign will cause an error during the import.
Please ensure leading zeroes are included in the account code dimensions before importing into EMISFFE (i.e. 025 fund code contains the leading ‘0’)