The Seattle Times and Microsoft Dynamics

Cash processing is a multi-sourced subject at The Seattle Times. The company is responsible for collecting a variety form of funds from coin/cash, some foreign currency (Canadian), electronic funds (ACH and Wire), checks (with or without remittance) and credit cards and image deposits. The form of cash and method of cash receipt varies based on the source of revenue.  

checking-graph-on-screen.jpg

We designed and developed a customer cash management portal in Microsoft Dynamics AX, replacing a Microsoft Access data-base which was used for manual entry of daily batch/deposit totals by source, revenue GL account and allows for daily cash balancing and interfaces to ERP system (General journal entries in SAP prior to implementing Microsoft Dynamics AX).

This dash-board provides a total overview which than can be drilled down by various operators and sources and transactions like credit cards can be imported, submitted and viewed on aggregated levels in Dynamics AX. Once the totals are reviewed and correct, all journals can be posted with one push of a button which then posts the journals and hits the appropriate bank accounts (sub-ledgers) and ledger accounts. AX then produces reports (summarized and detailed) for daily cash processing. In addition, various treasury reports are available for management. This solution was runner up in Microsoft Convergence Customer Excellence Awards. See About Us for more information.

We replaced SAP at The Seattle Times and saved the company money by providing lower cost of ownership and increasing productivity as well as enhancing user experience by providing a robust and complete mid-market solution and offering flexibility and a higher return on investment (ROI). We also delivered a scalable solution that will last for many years to come while accommodating growth and proving clients to respond quickly in an ever-changing world of business.

In addition to the implementation, integrations and customizations, we also helped with data-migration for various sources of data, deploying several methodologies including Microsoft Dynamics AX® Data Import/Export framework. One area which was challenging, was fixed assets due to the volume and history of the data and client needing 4 different tax books for each asset across 8 different entities. To optimize setup, sharing of tables through virtual companies was deployed as well as fixed assets tax book functionality, which is something that is only done by very few companies with very experienced specialized subject matter consultants. We embraced the challenge and were successful thanks to the cooperation with the very engaged and experienced client team. See Data-Migration for more information.

We also provide on-going post go-live support service for this and many other clients. See Training for more information.