fhs
Volume 9, Number 35 -- September 29, 2009

Lawson Finds Search Software a Good Fit for M3

Updated: October 12, 2009

by Alex Woodie

The search engine has become a ubiquitous and indisposable tool during the Internet Age. Without search sites like Google and AltaVista, many people wouldn't know where to start on the Web. As Internet technology trickles down into enterprise software, it's no surprise that ERP software developers are looking to include search-engine-like functionality in their products. Lawson Software is the latest i OS ERP developer to add the capability to its product.

Earlier this year, Lawson got started with search functionality when it added a search engine called Enterprise Search to its S3 suite of ERP software, which is run primarily by services organizations on big Unix and Windows boxes. Yesterday, the St. Paul, Minnesota, company announced that Enterprise Search is now supported on M3, its other ERP line, which is run primarily by manufacturers and distributors on the IBM i Power Systems (AS/400) platform.

Enterprise Search is a Windows application that allows M3 users to search structured and unstructured data housed in the M3 database, as well as for data stored outside the core ERP system, such as Lawson business intelligence software, and even the users' desktops.

Lawson's new search software allows managers to restrict users' searches to only the parts of the ERP system or other data store that they have permission to access. The software, which is part of the vendor's User Productivity Platform suite of tools, also supports the use of wildcards, allows users to search their personal transaction history, and lets users save their commonly used searches.

Lee Kilmer, global director of product management for Lawson, predicts Enterprise Search will fundamentally change how M3 users interact with the ERP system.

"Just as today's consumer search engines have transformed how people use the Internet, Lawson Enterprise Search will help transform how customers use their Lawson M3 applications," he says in a press release. "By strengthening and speeding the search function, user productivity can be enhanced for many day-to-day tasks."

In some cases, the new search capability will replace older ad hoc queries, which can be difficult to set up and slow to generate actionable data, Kilmer predicts.

For example, the new search functionality could come in very handy for a food manufacturer facing a product recall. If a company needed to recall a specific product due to food contamination, Enterprise Search could be used to find all related items in the company's inventory, including all purchase orders and requisitions, Lawson says. This process would be much faster than if the company had to search through its database "line by line," the company says.


RELATED STORIES

Lawson Boosts Profits Even as Economic Meltdown Bites

Lawson Retrenches as it Reconnects with Customers

Lawson Debuts Another M3 BI Tool



                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot


Sponsored By
S4i SYSTEMS

Document Management Case Study: Tankersley Food Service

S4i's document automation technology integrated with Retalix Power Enterprise eases fast-track food distributor's growing pains.

Speaking metaphorically, when a company grows faster than spinach, great computer technology can serve as a strong, supportive root system. Such is the story for Tankersley Food Service, LLC, the largest independent foodservice distributor in Arkansas, and Oklahoma.

Founded in 1928, Tankersley has accomplished something that seems rather improbable. It went from $8 million in annual sales in 1999, to yearly revenue of around $95 million in under eight years. This quantum expansion has been the product of a shift in business strategy, an increase in the number of field sales representatives, and a fervent commitment to technology.

In foodservice parlance, Tankersley is a broadliner, meaning they offer dry, frozen and refrigerated food items, fresh produce, meat, beverage service supplies and cleaning products to businesses and institutions. Early on, Don Tankersley, the company's CEO, decided to deploy powerful computing technology and licensed Retalix Power Enterprise, an ERP solution specially designed for the food industry. Their IT shop is using several important components in Power Enterprise including its web-based customer order entry portal and a voice recognition warehouse picking system. Here, Retalix Power Enterprise runs on a reliable IBM System i, model 520.

Tankersley's need for streamlined electronic document processing was a byproduct of its success. As an increasing number of independent, small regional chain, and non-commercial accounts partnered with them to satisfy their own foodservice requirements, what began as a small stack of daily, weekly and monthly reports that ran on impact printers, grew into an ungainly mountain of paper. According to Casey Carter, the company's director of information technology, "Problems like this start off small. You start by sending one report to one person and then it becomes a couple of pages and before you know it, you're spending a day printing, bursting, scanning, and emailing reports. As we grew the problem got bigger and we didn't even realize it. We thought we had to print all these documents to make the business work."

At one point, Retalix Power Enterprise would run end-of-day processes and 50 different reports would print. Many of these reports were referenced only periodically so the bulky 11" by 17" greenbar output was folded and stored. In an effort to eliminate waste, they started archiving report spool files on the System i but spool files take up a lot of disk space, and it was a hassle for users to find specific reports because searching for them involved scrolling through 2,000 documents.

In 2008, Carter attended a Retalix user conference in Dallas, and stumbled upon a solution from Retalix Business Partner, S4i. By then, he had already deployed a PC-based electronic document management solution that seemed to work, but had it's shortcomings. For one thing, it didn't have the ability to capture spool files, so System i reports would first run on a system printer, then get scanned into a PC-based system, and get emailed or faxed to hundreds of recipients. Carter also explains that the first document automation system was difficult to configure and maintain, and it was often necessary to hire a contractor to make changes. Finally, upgrades and additional modules were very expensive. "The total cost of S4i Express was less expensive than the cost of upgrading the other solution's scanning component," he says.

S4i Express is a complete document delivery system for IBM i that electronically captures, separates, indexes, bundles, and delivers or archives documents and reports. Output options include .pdf, .html, .csv, .rtf and other formats. It also supports automated report distribution to fax machines. At the Retalix conference, Carter discussed S4i Express with IT professionals from other foodservice companies and felt confident that it was a solution he could work with. His initial intention was to simply duplicate the level of reporting automation that he had with the previous system.

S4i Express was easy to implement because it captures spool files in defined outqueues, so programming is not necessary. Says Carter, "We started capturing spool files automatically, converting them to electronic reports and distributing them through distribution lists. This process was about as painless as it could be, and it eliminated a lot of unnecessary printing and labor. Honestly, the reporting process never operated this efficiently." Carter started by capturing 13 documents and is now doing roughly 200. Over a short period of time Carter says he acquired expertise with S4i Express and took off running. "It's a lot more useful than we thought it would be. Many times, when you license a product to do a specific task, and it does that task, you're satisfied. We thought we were going to replace our old system and trade apples for apples, but we got much more functionality at about the same cost of our old system. This has opened up new opportunities for us that we hadn't previously considered."

Carter is also using S4i express to place orders with vendors, a process that was once very paper-centric. Orders were once printed on roughly 1,000 pages of greenbar, and manually split. The segments were then mailed to dozens of vendors. "We don't have to spend a whole day going through these reports, labeling them, labeling the envelopes and mailing them," says Carter. "S4i creates PDF files and automatically emails them to our vendors."

Think document automation and then some. Since then, Carter has deployed S4i Express in ways that even S4i finds imaginative. As an example, some of the printed reports that Retalix Power Enterprise produced were difficult to read in places where the lighting was dim, so Carter configured S4i Express to grab specific spool files, increase the size of the type in critical areas of these reports, and send them to the printer. "When the end user tells it to print, the system handles all of these operations automatically and the report comes off a laser printer in a format that's much easier to read."

Tankersley attends two food shows every year, and meets with all of its vendors. Since Tankersley offers 12,000 different SKUs from 300 manufacturers, preparation for this event is intense, and up until this year, it has involved a great deal of printing. "Years ago, we would print a stack of reports that would stand about 24 inches high. Last year, the stack of reports was as tall as a man. It became a nightmare," says Carter.

Carter has different plans for the next food show: He is going to facilitate a shift to electronic documents. This will eliminate 90 percent of the paper used, and fewer temporary workers will be hired to help prepare for the show. "It's going to be phenomenal. It will also free up our buyers and sales managers who won't have to hand-deliver these documents. It will free much of their time so they can meet with our vendors."

Carter has also set up S4i Express' web-based document management portal to facilitate employee access to electronic documents. "Using their System i User ID and Password, employees can access the Portal and perform document searches in seconds. No training is necessary because it's very intuitive." Carter has set up indexes in S4i Express so users don't have to open documents to find the information they are looking for. Through database indexes and OCR, Carter's search mechanism can find specific values in column headers.

Has S4i Express eased Tankersley's growing pains? "There's no doubt about it," says Carter. "The number of processes needed to run our business has grown and is more complicated. Many of them involve reporting, so from every angle, S4i Express has been a good investment. It saves time and the expense associated with printing paper documents. We've gotten much more than we expected and it has helped us a great deal."

For more information visit: http://s4isystems.com/products/s4iexpress.asp


Editor: Alex Woodie
Contributing Editors: Dan Burger, Joe Hertvik,
Shannon O'Donnell, Timothy Prickett Morgan
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

System i Developer:  RPG & DB2 Summit in Minneapolis, October 13-15; 3 days of serious training
Manta Technologies:  Fall Sale on i training courses! Order by October 15 and SAVE 25%
Halcyon Software:  Automated operations software for IBM i i5/OS - for as little as $25 a day!


 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95


 
The Four Hundred
IBM to Mothball a Whole Bunch of Stuff with Power7

IBM, VMware Cooking Up vSphere 4.0 Support for i

What Apple Did That IBM Must Emulate

As I See It: After You're Gone (.com)

IBM Says Microsoft 'Grossly Exaggerated' Exchange Sales Data

Four Hundred Guru
WDSC vs. RDi

Let's Start Over from the Beginning

The Cost of Not Backing Up

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

System i PTF Guide
September 26, 2009: Volume 11, Number 39

September 19, 2009: Volume 11, Number 38

September 12, 2009: Volume 11, Number 37

September 5, 2009: Volume 11, Number 36

August 29, 2009: Volume 11, Number 35

August 22, 2009: Volume 11, Number 34

August 15, 2009: Volume 11, Number 33

TPM at The Register
Novell forces customers to pay for maintenance

Mainframe emulator goes commercial

Fujitsu battles WMDs with online survey

Red Hat mocks Meltdown in Q2

Super Micro gets dense with blades

Citrix ships virtual NetScaler accelerator

Mellanox kicks off race to 40 Gigabit Ethernet

IBM slots 'Lynnfield' Xeons into System x

AMD chipsets: the feeds and speeds

SGI births smaller baby super

Dell plus Perot - It's a start

HP bundles up services for data centres

THIS ISSUE SPONSORED BY:

looksoftware
PowerTech
Patrick Townsend Security Solutions
East Coast Computer
S4i Systems


Printer Friendly Version


TABLE OF CONTENTS
LANSA Gives aXes Screen Modernization Tool a Makeover

JAMS Brings Scheduling and File Transfer Capabilities to i OS

Trucking News: TMW Brings More Applications to i OS

VAI Adds Desserts to Food Distribution Package

Lawson Finds Search Software a Good Fit for M3

News Briefs and Product Shorts:

FalconStor Touts Big VTL Win at Insurance Company . . . Friedman Expands Offerings for Windows Manufacturers Beyond i OS . . . CYBRA Inks Deal with Chinese Government for RFID Project . . . Retalix Taps S4i Systems for i OS Electronic Document Management . . . Talend Helps British Housing Authority Integrate Windows and i5/OS Data . . .

Four Hundred Stuff

BACK ISSUES




 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2009 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement