MEMO TO: Members of the City Council
FROM: Mayor John Marchione
SUBJECT:
title
Approval of Contract Amendment with Tyler Technologies in the Amount of $50,000 for Custom Report Building in the 2019 - 2020 Budget Process
I. RECOMMENDED ACTION
recommendation
Approve a contract amendment with Tyler Technologies for $50,000 to build customized reports for the new Dynamics Budget Planning Tool being implemented for the 2019-2020 budget process.
body
II. DEPARTMENT CONTACTS
Malisa Files, Finance Director 425-556-2166
Kelley Cochran, Financial Planning Manager 425-556-2748
Dawn Johnson, Business Systems Analyst 425-556-2179
III. DESCRIPTION/BACKGROUND
Background
In March, the Council approved a contract with Tyler Technologies for $150,000 to add Budget Planning to the City's Dynamics ERP environment. For the past 10 years, the City has used an in-house developed Budget Tool to prepare its biennial budgets. The tool gathers narrative and financial information from each of the various offer writers and, through reports, publishes the budget documents. The system is also essential balancing budgeted funds. The current tool was developed on a sequel server platform that is now out-of-date and in danger of failing.
Since March, a cross-departmental team has been working on implementing the new tool in conjunction with Microsoft and Tyler Technologies. The partnership between the City and its technology partners is essential due to the unique nature of the City's process. The new tool is also being deployed in the Microsoft Dynamics 365 for Operations (D365) which is a "software as a service" environment.
Budget Reporting
There are currently twelve reports developed as a part of the Budget Planning Tool. However, staff has identified the need for six customized reports unique to the City of Redmond. The reports include the narrative reports directly published in the budget, FTE accounting reports used to audit the number of authorized FTE...
Click here for full text