Ingredient & Recipe Management for Mas90

IRIS integrates with Mas90 using a proprietary web service that allows us to gather data directly from the Mas90.  Because of this unique method of data extraction we can web-enable Mas90 where other products simply cannot and must resort to very inefficient methods, like the Microsoft Access engine.

IRIS communicates directly to Mas90 through our web-service using an XML data stream. What this means to you is that we can stream selected Mas90 data to any other database or website you may have by using this method.  Of course, there is security involved so only what data we bless can be pulled from Mas90.  In fact, IRIS uses a Mas90 login just like any other user, so you can limit the visibility of sensitive data.  By using our XML web service, you could create websites that show product availability or even sale pricing as a basis for an online catalog. Moreover that information would update in real time without placing any additional load on Mas90.

The inventory information as well as product groups, products, and warehouses is also pulled from Mas90.  Much of that data is cached in our system to make IRIS even faster than Mas90 for most common operations.  All of the data used by IRIS is stored in a Microsoft SQL Database and can be used as a target for reporting software such as Crystal Reports, COGNOS, Business Objects and others.  IRIS data is also architected to ease implementation of OLAP cubing and data mining, so that if these functions are needed at a future point, they can be implemented for business intelligence.

IRIS supports an infinite number of warehouses, products, recipes and work orders.  The only limitation is the physical storage available in your server hard drive.  Because IRIS is based on Microsoft SQL, it can perform around 200,000 transactions a second.  Other competitors products may seem equal initially, but realize that as their database fills, the application will slow.  Most of our clients have found that one years worth of data in a system like RMS will cause an ingredient query to slow considerably.  In one case, it took over 3 minutes for RMS to determine if their were enough eggs in inventory to create a work order, and that was one of 50 ingredients in the recipe.  IRIS does not suffer from the same architectural flaws and can maintain a query speed of less that 1 second for the entire recipe.

The screens in IRIS are also very smart.  For instance, the recipe screen not only shows you the ingredients, notes and other information, it slow shows the work order history for that recipe and when it was last made.  This makes historical tracking of a recipe effortless.  Note that lot codes are always displayed and clickable wherever possible so you can get that information quickly from just about anywhere.

The shop floor also can benefit from IRIS by using the Pocket PC interface to select lot codes and enter amounts using this wireless device.  IRIS works with any wireless Pocket PC brand that can run Internet Explorer.  Note that additional hardware for the wireless access points and actual Pocket PCs are not included in the price.  If you already have that infrastructure in place, we can utilize it for IRIS without additional cost.

When a work order is completed in IRIS, the final unit cost is calculated and inventory is adjusted in Mas90 using a custom Visual Integrator interface.  The new product will be given a unique lot code as well.  What is also unique about IRIS is that you can have non-ingredient items in your recipe such as lids and buckets that can be used in the unit price calculation.

Overall, IRIS is a scaleable and easy to use package that was built to handle years of abuse.  It can easily be expanded and altered to meet any client's requirements and interfaced with other systems to complete an enterprise system.  Contact us today about a demo.

 

The speed of web based formula and recipe information and Mas90 inventory is simply amazing.

Powered by Maelstrom Solutions CMS