User would like Classic's AMDCERT report recreated in the Redesign.  

The AMDCERT program generates the "Amended Official Certificate of Estimated Resources" report to be submitted to the county auditor. The program offers the option to create a spreadsheet file which can be used to electronically send the information to the auditor's office. AMDCERT is an option located under the main USACERT menu.

The AMDCERT program has the ability to properly report permanent funds. Reporting requirements state that only interest earnings are supposed to be considered available for expenditure when certifying year-end balances of a permanent fund to the county auditor. AMDCERT allows the user to enter the fund and special cost center along with the associated principal amount for any permanent funds. The amount entered for each fund/scc will be subtracted from the beginning cash balance reported for the fund.

AMDCERT also allows you to indicate how you want property tax allocations (receipt codes 3131, 3132, 3133, 3134, 3135 and 3139), Income Taxes (receipt code 1130), and Other Taxes (receipt code 1190) to be reported. You are given the option to have them included in the "Taxes" column or in the "Other Sources" column of the report. You may also choose to exclude funds. This might be utilized when it becomes necessary to exclude a budget reserve fund, student activity funds, or auxiliary service funds, etc. There is also an option that allows you to select whether you would like estimated receipts for Income Tax (receipt code 1130) included under the column "Taxes" or under the column "Other Sources".

This program also offers the functionality of allowing you to specify the reporting level of certain funds. By default, all funds will be reported at the fund/scc level. However, you can choose to enter ranges of fund numbers and specify a reporting level of either fund or fund/scc.

There are a few things that need to be fixed along with implementing AMDCERT functionality to make sure we get correctly beginning balances on the report.

• Fix getInitialCash on CashAccount

  • Instead of going directly to the HistoryRepository we need to first check if the fiscal period for the prior year is closed.  If it is then we can go ahead and trust the CashAccountHistory from the prior fiscal year.  If the prior fiscal period is still open then we need to find the last available period of the prior fiscal year and use PostingPeriodService.doInPeriod { CashAccount.getCurrentRemainingBalance } to calculate an estimate initialCash amount.

• Fix AccountHistoryJob calculation of beginning balance

  • Update the createCashAccountHistory() method to use CashAccount.initialCash when creating the history record.  This should work correctly after the prior fix is implemented.

To generate the AMDCERT report we will need to create a report object to wrap the Fund/CashAccount information.  The idea is to create a stream of report objects that expose the necessary fields for the report.  There are a couple of different options available when creating the AMDCERT report for detail levels.  We will be adding a CertificateReporting enum that has two values: Fund and FundSCC.  A new stream repository that produces instances of the new report object will use this to determine what data needs to be places in each report row.  We need to keep in mind that the user will need to be able to enter ranges of Funds and specify different levels of detail for different ranges.  i.e. 300-level funds may be just a Fund level summary and all other funds show CashAccount-level detail.

You should also note that it is necessary to enter any advances that have not been repaid when generating the report.

Documentation and sample report: https://mcoecn.atlassian.net/wiki/x/XR85

See additional notes on epic issue.