Johnny Rockets Case Study
Integration Manager Tool Implementation
TMC has a great deal of experience with integrating restaurant industry Point of Sales and Back Office solutions with Microsoft Dynamics GP. Johnny Rockets’ corporate offices process the financial information for over 50 individual corporate owned JR restaurant locations, as well as over 100 franchised locations.
When TMC first implemented Great Plains at Johnny’s in 2000, each restaurant was using Radiant Systems Aloha product for its POS system and MenuLink for its back office and payroll financials. At the corporate stores, the desired business process was for the stores to handle their day to day AR and inventory activities in Aloha and send summary level information to corporate on a weekly basis. On the purchasing side, the stores would each do their own product purchasing and payroll in MenuLink and then send the resulting invoices back to corporate for payment. Finally, the franchised stores were only required to send their revenue information back to corporate, so that they could be charged their royalty fees.
The TMC technical team was able to provide the synchronization between Johnny Rockets restaurants and corporate offices using the Integration Manager tool. Three main integrations were written and then duplicated for each store. First, the AR summary from the Aloha POS system was set up to sync back to corporate once per week from both franchise and company stores. Secondly, an inventory level integration was created form Aloha to corporate, so that once a week the company would receive and updated value of inventory across the all corporate stores. Finally, TMC built an integration from MenuLink to Dynamics GP that would send daily purchasing invoices from each store back to the corporate headquarters for payment.
As new stores are added quarterly, the TMC technical team duplicates and modifies the integrations for each new location. Johnny Rockets recently made the decision to move off of the MenuLink solution and implement ERS by Allen Metrics. Because of the easily adaptable interface of the IM integration that TMC has written, ERS has been able to plug directly into the existing AP integration with no additional customization.
In addition to these restaurant industry application integrations, TMC has implemented many of the additional core financial functionality of Dynamics GP for Johnny Rockets. Besides the GL, AR, and AP modules, TMC has implemented the Bank Reconciliation and Fixed Asset Management functionality of GP for Johnny’s. TMC’s application specialists have also customized Johnny Rockets FRx reporting solution to allow the generation of a single financial statement for the company, which is then segmented into individual reports that are sent out to each store monthly.