EwingCole provides design, architectural, and engineering services to clients throughout the United States. When Deltek discontinued support for its Sema4 system, EwingCole evaluated options for a more modern business management solution that would help eliminate duplicate date entry and provide employees with direct, secue access tp project accounting. EwingCole chose Microsoft Dynamics AX over the new product from Deltek because of the seamless integration between the solution and other Microsoft products and technologies, including Microsoft Office Sharepoint Server 2007. The company worked with Microsoft Gold Certified Partner Computer Generated Solutions to configure the system and build workflows to support unique bussiness processes. Now, EwingCloe employees have the information and tools they need to maximize cash flow, control project costs, and bolster profitability. Situation EwingCole is a nationally recoghized architecture, engineering, and desigh firm with more than 300 emplyees locoted in four regional offices. In 2007, the firm brought in roughly U.S $60 million in annual revenue. At any time, the company's 50 project managers handle roughly 450 projects, including the new Meadowlands Stadium, future home of the New York Giants and New York Jets. As with other project-based firms, EwingCole is continually trying to improve its ability to manage time and expenses. " We sell the time of our architects, engineers, and designers," says Jim McAleer, Controller at EwingCole. " To gauge and manage our performance, we need tho be able to get project details recorded and distributed to our project manager as soon as possible that veers off track can become a big problem for our profitability", The numbers that EwingCole project managers must watch include overall profitability, what consultants are charging to the project, outstanding receivables, and updated budgets. When EwingCole learned its project accouting software vendor was discontinuing support for its system, the company decided to evaluate its options for a new business managrment solution. " One of our guiding principles for the new solution was that information should only have to be entered once, " says Beth Carroll, Database Administrator at EwingCole. With the existing system, employees in the accounting department frequently had to reenter date into the system, such as when creating new projects on behalf or project manager. EwingCole also wanted to improve project managers/ and executives' ability to access project accounting information. Project managers received had to go to the accounting department to request custom report. " To ensure the security of the system, we could not allow anyone outside the accounting department to access the database," explains MxAleer. Solution After evaluting several options, including a newer solution from its existing, software vendor, EwingCole chose Microsoft Dynamics AX. The company was especially impressed with the solution's excellent project billing capatilities, reporting functions available through Microsoft SOL Server and opportunities to empower project managers with online with access to the system. " With Microsoft Dynamics AX, we were able to address a lot of the requests that we could not with out old system. It's mich more flexible, " say Carroll. " By using Microsoft Office SharePoint Server 2007 as the interface, we easily created a powerful solution that helps EwingCole employees complete critical tasks, like experise reporting faster and make well-informed decisions. " EwingCole worked with Microsoft Gold Certified Partner Computer Generated Solutions to implement and cofigure the system to fit EwingCole's unique bussiness processes, and create a customized portal for project manager and management. Built on Office SharePoint Server 2007 using HTML and standard Web parts from Enterprise Portal, the portal helps streamline a varety of tasks for project for project helps streamline a variety of tasks for project managers and other EwingCole employees who do not need direct access to the business management system. The EwingCole Employee Portal provides easy access to a number of key resourcec and functions, including submitting expense reports and timesheets. In addition to tabs for employee services and project resources, a project management. Show in Figure 1, the portal feature, called Project Wizard, lets project managers: Open, update, and close projects. Edit work orders. Create a request-for-proposal ( RFP) project. Convert an RFP project into a live project. EwingCole took advantage of the portal to streamline processes and ensure that employees only entered information once, wherever possible. Now, employees can enter expense reports and timesheets online, and the information will flow directly onto the accounting system. And, when creamting new project accounts, project managers can enter that information online and immediately route the form to the accounting department for approval. Previously, project managers created a draft spreadsheet and someone in the accouting department would create the project account in the system. From the portal, prtject managers can also access a raange of reports that pull up-to-date information from the accounting system, including: Acounts receivable aging reports showing outstanding receivables by customer and due date Projec burn-down reports showing progress and work left to be completed on a project. Project summary reports in overview, detailed, and for-print versions. These reports provide project managers at EwingCole with much more timely project accounting information and the ability to act on that information. " Previously, when someone charged wouldn't know of that until all the timesheets were entered at the end of the week," explains McAleer. " Now, project managers receive an alert when someone charges time against their project and can reject or move that charge to another project. In addition, they all can run reports themselves at any tim and receive the most up-to-date information from the accouting system." Benefits EwingCole has improved core business processes so that employees spend less time on clerical tasks and make decisions based on the latest data. The new project management protals let managers enter information and access data themselves instead of working through the accouting department. And because these tools are integrated seamleely with the project acounting system, updates are automatically reflected in self-services reports sp that project managers and company executives have the insight they need to optimize business performance. " Now, our project managers have the tools they needs to improve cash flow and make projects more prfitable," says McAleer. " At the same time, our people in the field and in the accounting department spend less time on routine date entry so that can focus on their core responsibilities." Greater Control over Cash Flow With project accounting information and functionality available any time and any place, EwingCole project managers have greater control over cash flow. Managers now have insight into their most up-to-date project accouting in Microsoft Dynamics Ax, and they can see the impact of expenses on profitability through the solution's integration with Microsoft Office Excel and Managers also have the most current view of receivables so that they can pursue outstanding bills and improve cash flow. Previously, the information we provided to project managers often came too late and was static, so they couldn't easily see the implications of that information," says McAleer. " Now, with Microsoft Dynamics AX, our project managers are equipped to improve casj flow and control costs. These capabilities are healthy in the current economic environment." Executive management at EwingCole uses the increased visibility into operation and accouting to better manaage the business. " Our Director of Operations has been the most enthusiatic about the reporting and ptoject management capabilities available online," says McAleer. Access to historical and the most recent information helps managers verify expenses and time spent on projects in any office or team. "The system allows us to review custom reports and find specific information quickly and efficiently," says Jared Loos, Director of Operations at EwingCole. " We are able to look up information on older projects for comparative purposes as well as track new data in a more consistent and meaningful way. Having real-time access to critical data is crucial in today's economic climate.'