Automation

ERP system gets help from flexible reporting tool

Lesaffre Yeast Corporation gains direct access to Oracle financial data via Excel-based software, improving reporting efficiency and management support.


Source: Excel4apps.

Lesaffre Yeast Corporation and Red Star Yeast Company LLC, a joint venture between Lesaffre Yeast Corporation and Archer Daniels Midland Company Inc., is a producer of yeast for a variety of applications throughout North America. These applications include bakeries and food service, retail stores for home baking, wine, animal feed additives, human health care and ethanol.

In 2004, Lesaffre installed the Process Manufacturing version of Oracle E-Business Suite (OPM), designed specifically for recipe-based manufacturing. It was one of the first subsidiaries within the Lesaffre Group family, a global company of 6,000 employees based in France, to install a fully integrated ERP system. 

According to Michael Roach, controller for Lesaffre Yeast Corporation, implementation of the system provided immediate benefits, including improved coordination across functional departments and increased efficiencies in doing business. However, soon after installation of the system, Lesaffre’s finance and accounting group discovered challenges in working with Oracle’s Financial Statement Generator (FSG).

After a period of using FSG reports (FSGs), Roach and his team began searching for a tool that could expedite financial reporting while providing better access to detailed OPM data. “The Oracle system provided a backbone of data that was not previously available, but the key was being able to efficiently access, manipulate and analyze this data to help drive the business forward,” says Roach.

 “To modify a report, you accessed a separate template and used a type of code to enter the necessary account numbers, decimals places, etc.,” says Jordan Lueck, senior accountant. “Then, you ran the report from Oracle, which took over an hour, only to often find out it didn’t work, requiring a repeat of the process. It took a whole day to run our monthly 100-page package.”

In 2008, the Oracle reporting challenges prompted Lesaffre to explore a new solution. The search led to a one-hour demonstration of GL Wand from Excel4apps, an Excel-based reporting tool that links directly with live Oracle data. Roach was convinced it was the right solution and decided on a one-month trial.

“After just two or three hours of GL Wand training, our finance and accounting users could build reports and drill right into live Oracle data via the Excel front end,” Roach describes. “It was so easy compared with FSGs, and without the time required for coding.”

In May 2008, Lesaffre installed GL Wand, but there was a snag: GL Wand did not yet have drill-down capabilities for OPM, a less common version of Oracle. Working together, the two companies put the functionality in place, plus additional capabilities.

“Within a few months, GL Wand had all the drill-down capability we needed,” Roach explains. “In addition, Excel4apps implemented drill-down for Oracle Trade Management on the accounts receivable side, which basic Oracle didn’t have.”

After converting all existing FSG reports to GL Wand, Lesaffre’s finance group saw major improvements in reporting efficiency (see table).

“It used to take an entire day to run our monthly report package, but with GL Wand it takes about two hours,” says Lueck. “I simply modify the report set by changing dates, file names, etc. Each report takes just 15 minutes.”

Lueck also appreciates the ease of the Excel front end, which allows her to email the reports, whereas using ADI required printing and scanning. “The person requesting the report can modify it as necessary in Excel, which was impossible with the scans,” she says.

While GL Wand met Lesaffre’s goal for a more efficient reporting process, the software’s biggest impact has been in improved support of business analytics and management requests. “We get a number of requests for information from management on a daily basis, and our channel managers are asking for more detailed, customized reports to help them stay on budget,” states Lueck. “With GL Wand, it’s easy to modify an existing report to give them the detail they want in 10 minutes, whereas with the old FSG report writer, it took days.”

For more information about GL Wand, visit Excel4apps.

Did you enjoy this article? Click here to subscribe to Food Engineering Magazine.

You must login or register in order to post a comment.

Multimedia

Videos

Image Galleries

Plant of the Year 2015

Mars Chocolate was chosen as Food Engineering’s 2015 Plant of the Year. The first new Mars candy plant in North America in 35 years is not only LEED Gold certified, it’s highly automated as well.

Podcasts

Burns & McDonnell project manager RJ Hope and senior project engineer Justin Hamilton discuss the distinctions between Food Safety and Food Defense as well as the implications for food manufacturers of the Food Safety Modernization Act.
More Podcasts

Food Engineering

Food Engineering April 2015 Cover

2015 April

The April 2014 issue of Food Engineering features the Plant of the Year: Mars Chocolate. The first new Mars chocolate candy plant in North America in 35 years is not only LEED Gold certified, it’s highly automated as well.

Table Of Contents Subscribe

Plant Facility/Site Issues

What issue about your current plant facility/site keeps you up the most at night?
View Results Poll Archive

THE FOOD ENGINEERING STORE

Food-Authentication-Flyer-(.gif
Food Authentication Using Bioorganic Molecules

This text provides critical tools and data needed to augment routine food analysis and enhance food safety by aiding in the detection of counterfeit, and potentially deleterious, foods.

More Products

Clear Seas Research

Clear Seas ResearchWith access to over one million professionals and more than 60 industry-specific publications,Clear Seas Research offers relevant insights from those who know your industry best. Let us customize a market research solution that exceeds your marketing goals.

STAY CONNECTED

FE recent tweets

facebook_40.pngtwitter_40px.pngyoutube_40px.png linkedin_40px.pngGoogle +

Food Master

Food Engineering Food Master 2015Food Master 2015 is now available!

Where the buying process begins in the food and beverage manufacturing market. 

Visit www.foodmaster.com to learn more.