RMS Company – Laserfiche Workflow and SQL Reporting Tools

RMS Company – Laserfiche Workflow and SQL Reporting Tools

Laserfiche SQL Reporting

RMS Company specializes in the contract manufacturing of complex, tight-tolerance medical device implants and surgical instruments related to spine fracture, reconstructive orthopedics, cardiovascular components, neurological stimulation components, drug delivery systems, and endoscopy devices. The Minneapolis, Minnesota headquarters 154,000 square foot facility focuses on the manufacture of implants and endoscopy devices. The Memphis, Tennessee 21,000 square foot facility is dedicated solely to the manufacture of orthopedic instruments. RMS manufacturing equipment includes over 300 highly sophisticated CNC (computer numerical controlled) machines organized to utilize cellular workflow principles to achieve the lowest total cost.


RMS staff realized that it was getting more and more difficult to predict the order ship date as the number of orders grew to over one thousand a month. They would have to continually notify customers of changes in ship dates.

RMS staff set out on a mission to determine the bottlenecks in their order entry and scheduling process and set goals to have firm order ship dates confirmed to the customer within 72 hours of receiving the order, thereby reducing it from the average 7 weeks it was currently taking.

Vicky Benz, RMS CFO said, “When we had a meeting to discuss what our bottlenecks were and how to improve our numbers, we had only people’s perception of what the problems were. What they seemed to remember most were the jobs that had certain exceptions or issues. We had a lot of data and reports to look at, but it was too much to even begin to analyze.”


Vicky said, “Fortunately, we used Laserfiche Workflow to control every aspect of tracking and routing our jobs through our manufacturing process. Laserfiche Workflow recorded every transaction in a SQL database. We had three years of production data sitting in SQL that had all the detailed transactions. We just did not know how to make sense out of the data.”

RMS hired Hemingway Solutions (formerly Solbrekk), a local Microsoft partner and Laserfiche VAR to assist with this project. Chad Brinkman, Solbrekk’s SQL and Laserfiche expert, quickly realized that SQL 2005 Reporting Services was the tool they needed to analyze the data and help determine the actual facts related to the manufacturing process.

Chad said, “I used the audit trail information stored in a couple of SQL tables in the Laserfiche SQL 2000 server, and wrote a couple of stored procedures to compile the audit trails on the SQL 2000 Server. The timing information was then calculated and stored in SQL 2005 on another server. Then I designed some SQL Reporting Services reports modeled after the business processes work flow RMS described for me.  I used the business process work flow information and the timing information to create charts and graphs to help identify bottlenecks as the parts move from department to department.  RMS now has the ability to display a graph showing how each department, individual, part type, and job is performed.”


Vicky Benz said, “When I looked at the new reporting tool, I was completely in awe of what Chad can do and what he is able to pull out of our raw data. We now have the tools to determine our bottlenecks. We can make changes to our processes and track the results.  We now are able to work on achieving our goals and objectives.”

how can we help you?

Contact us with questions and requests of service, or submit a business inquiry online.

I cannot even begin to express how elated I am with this product!!!!!!

Even when there are data elements that need to be fixed, the process is so painless and intuitive and easy that it is absolutely a JOY to work in the system.

Ben (and Mark) have been so supportive and even suggesting fixes I would not have required. I get the feeling he is just as invested in getting us up and running as I am.

This has been the best software rollout experience I have ever had —- and I have launched a LOT of software programs (and written a few myself).

THANK YOU for all of your help and support!!!!!!!!

Dee Bradshaw
Director of Purchasing
Community Health Centers, Inc.

community health goes paperless using laserfiche and hemingway solutions
Dee Bradshaw
Director of Purchasing, Community Health Centers, Inc

I wanted to thank you for all of the work you have done for us! We could not have done it without you!
When the pressure was on, you really stepped up to help us, and I really appreciate it!

Tracy Boggs
IT, Viking Materials

Our client’s personal and sensitive information is handled with the utmost care to ensure the privacy and security of the data thanks to Laserfiche Forms.

CAP using forms portal and electronic signatures
Rand Clark
Community Services Supervisor, Douglas County

Your Laserfiche engineers are great. They are so nice and easy to work with.

community health goes paperless using laserfiche and hemingway solutions
Dee Bradshaw
Director of Purchasing, Community Health Centers

“There is virtually no chaos in our offices now. Nobody is looking for information, it’s all right there. My staff is able to instantly access files regardless of who last worked on them.”

Community Action Partnership Laserfiche client
Catherine Fair
Senior Director, Programs and Technology Innovation, Community Action Partnership of Ramsey Washington

“In an effort to be more efficient and effective, the Agency made
the decision to go paperless and EAP developed workflow
processes utilizing Laserfiche scanning software. This software
allows us to work on applications from any of our offices.” From 50 Year Anniversary Booklet

Mahube paperless for Energy Assistance
Liz Kuoppala
Executive Director, Mahube-Otwa Community Action Partnership

We increased productivity in our Energy Assistance department by 129% in one year using Laserfiche Workflow

Laserfiche imporved productivity
Robin Tousley
EAP Administrative Coordinator, Community Action Partnership Hennepin County

Laserfiche saves our staff so much time.

CAP using forms portal and electronic signatures
Rand Clark
Community Services Supervisor, Douglas County Community SAction

Looking for a First-Class Business Plan Consultant?