George Weston Foods SAP Integration

George Weston Foods SAP Integration
George Western Foods were looking to improve the transfer of historical data from their mixers into their SAP ERP system.

The Challenge

Historically, data was entered manually; with the predicted amounts for each ingredient (flour, water, yeast, etc.) being first transcribed onto a paper based system by the operator. These target figures would then be entered into the SAP system by approved personnel. The challenge was getting the data from the mixers straight into SAP without any manual interaction.

The Solution

The mixers were already fitted with monitors to measure the actual amounts of each ingredient.  Working with the IS department, we agreed on an interface exchanging CSV files over FTP.  We utilized the customer's existing Wonderware Historian to monitor the ingredient additions, and used a SQL Database to collate all of the ingredients used, synchronize those individual ingredient weights to the associated batches, and synchronize those batches to production orders.  The database used Microsoft SQL's Integration Services to map the data into a CSV file for transfer to the SAP System.

The system's capability was later extended by integrating a Production Order feature which allowed an operator to select batches of bread to be created from a range of Production Orders provided by the SAP system.

Featured Technology

  • Wonderware Historian
  • Wonderware InTouch
  • Microsoft SQL Services
  • Microsoft SQL Data Transformation Service
  • Allen-Bradley ControlLogix PLC

Benefits

The old manual system was based on the target amount for each ingredient, but often the actual amount measured differs slightly.  We were able to take advantage of the much more accurate measurements already being monitored by the mixers allowing for more accurate predictions for ingredient quantities.

The mixer usage data collection is now fast, accurate and automated.

The selection of batches for the day’s production was made user friendly with the integration of the Production Order System.

You might also like these articles

Crossmuller a founding member of the Wonderware Model Driven MES competency program
Crossmuller a founding member of the Wonderware Model Driven MES competency program
1 minute read
Achieving low cost multi site ownership with a model driven MES
What's in an Interface?
What's in an Interface?
4 minute read
It’s like two people negotiating from separate countries, separate cultures, separate forms of reference. Neither can speak each other's language, but they both know English.
Solar Reflector Robotic Manufacturing Cell
Solar Reflector Robotic Manufacturing Cell
4 minute read
An American based designer and manufacturer of solar steam generators with installations in the USA and the Middle East, set out to expand to Australia.