Colorado December Financial Report - Edit the Data & Create the Export File

Any edits done within this screen will not affect what has been posted within AptaFund.

If you click Report to Grid when the report has already been run for the specified parameters, the Generated Data Exists popup opens. This window tells you when the report was generated and who did it, as well as when the data was edited, if ever, and by whom. You can choose to continue with the previously generated data, OR you can delete that set of data and generate fresh data. If you had to change any of your element parameters, you will want to delete and generate new data so that the report utilizes the new parameters.

Edit the report

1. If you're not already in the Report to Grid window, select Colorado December Financial Report from the Reports > General Ledger menu.

2. Click the Continue with Previous Editing button at the bottom of the parameters, and the Report to Grid window opens. See Anatomy of the Report to Grid Window for information on using the commands in this window to edit the data.

3. Edit the data.

• If there are errors, you will need to resolve them before generating the export. You can make sure you see all the validation errors by clicking on the Validation Error(s) column to sort it.

• You can correct any errors by returning to the appropriate entries within AptaFund, by fixing any parameter problems in the report setup window, or by selecting row(s) and editing them within the report.

4. When you're finished editing the data, click the Export to File button at the bottom of the grid. This command will generate a .CSV file for submission to the CDE.

NOTE: DO NOT OPEN THE EXPORT FILE IN EXCEL!
Excel will remove any formatting such as leading zeros and may corrupt the data, causing submission errors with the CDE.
Instead, open the file with a text editor, such as Notepad to review the data.

Return to Colorado December Financial Report