MetaPro Systems Inc.

A MetaPro Systems Success Story

Our most recent new client is a company that installs vending machines such as washers and dryers at various vendor sites. The money collected is divided between my client and their vendors. The formulae for dividing the money are quite complex.

Besides being difficult to use and hard to change, the old system was not able to handle the complexities of the commission payments. Also, the old system could not handle the large quantity of data required due to the expansion of my client’s business.

The new system is able to handle more complex commission formulae. This allows the salespeople more flexibility to negotiate deals with the vendors. Through improved reporting, our client’s management has gained a better understanding on how the money is collected and paid. The new system will allow the company to increase their profits by an estimated 1% the first year.

We worked with the original development team to put the finishing touches on the new system. After the rest of the development team left we had responsibility for the support and additional enhancements to this system. Among other improvements, we developed several interfaces that feed data to the new system to other systems and from other systems to the new system. We also created a number of new reports, some quite complex.

The system has now been taken over by in-house staff. Of course, we are always available for advice and support.

The system has a front end written in Visual Basic and the backend is written in MS SQL Server. This system used very complex SQL stored procedures. Working on this product has allowed us to increase our SQL Server skills dramatically. Crystal Reports was used for reporting.