Case Studies

Making Product Information Accessible Using Lotus Notes

July 2000

Situation...

A distributor and converter of paper and paper-based products has service centers throughout the southeastern United States. These centers are grouped by region. Product and pricing information is maintained by region, and distributed to the sales representatives within the region. Lotus Notes was already the e-mail system for this company.

Problem...

Each month the company published over a thousand copies of its price lists, with distribution costs ranging from eight to twelve thousand dollars per month. The process was labor-intensive, consuming precious IS resources and yielding lists that were unmanageable and inherently outdated. This client needed a more timely and efficient way to share product and pricing information with its sales representatives.

Solution...

A custom Lotus Notes application consisting of a template used to create a price list database for each of the five regions. Key features provided in this Notes application include:

  • Import agent allows quick and easy update of price list databases on a scheduled basis.
  • Updates affect only fields that have changed.
  • Dial-in database replication enables sales representatives to quickly receive updated product and price documents, then use them locally at their convenience
  • Document views allow alternate sorting and searching on key fields.
  • Powerful custom-tailored query features allow sales representatives to search on any field and save search criteria for future use.
  • Setup documents allow for easy maintenance of master class, class, and manufacturing codes and descriptions.

Screen shot of Lotus Notes custom price record query form

The custom query screen allows the user to specify free-form criteria, or choose from available picklists. Up to three criteria can be entered for each field. In addition to specifying the overall query criteria of either "And" or "Or", the user can also specify "And" or "Or" for the Description field criteria.

Screen shot of Lotus Notes record details

The criteria shown above yielded the two records shown at right. If the results were too restrictive, the sales rep could easily revise the criteria, which are saved for each user.

Results & Benefits...

Sales representatives now have access to timely information when they need it and have the ability to search and drill down to specific information. Resources required from IS are reduced. The company saves time and money in reducing — and ultimately eliminating — hardcopy price lists.

Conclusion...

The client used Notes to share its internal information in a more convenient and efficient manner. In addition, Notes provided a way to access and search on the information that did not exist before. Notes provides a strong platform for future projects, including a document library to provide a repository of marketing information and a sourcing database to provide information on vendors and their products.

For More Information...

To discuss how technology usage and business process improvements could be applied to the issues facing your business, call us at 336.297.4200 to schedule a no-obligation consultation, or click here to contact us online.

Popular Case Studies

Applying Technology to Reduce Unbilled Charges

Accession Inventory graphSometimes, brute force gets a job done. Sometimes, a little finesse is all it takes. Other times, you need to combine the two to accomplish your goal!

Investing vs Spending

AvaCare-screen-shot-v4What's the difference "investing" and "spending"? From the perspective of current cash outlays, nothing is different - yet, taking the long view, there's a great deal of difference.

Deliver Major Cost Savings by Using Technology and Improving Process

Read how this fast growing company partnered with Todd Herman Associates, and found short-term and long-term cost savings through technology and process.

Making Reports Useful: A Case Study

Read how a CIO found a profitable innovation idea in the way the business delivers lab reports.

Activity Versus Achievement

Establish Accountability and Evalutate Results

The Wall of Knowledge

Clarifying Business Needs

Ending the Spreadsheet

Managing Job Costs and Timelines

Tip of the Iceberg

Delivering Meaningful Information to Executives

"Culture" is a Verb

Redefining "The Hottest Topic in Business Today"

Category:Leadership Relationships

Start transforming your business and yourself by signing up here:

captcha 

EIGHT TIME WINNER OF THE
APEX AWARD FOR WRITING EXCELLENCE!

2018a winner2017 winnerApex 2016 winner Apex 2015 winner Apex 2014 winner Apex 2013 winner Apex 2012 winner Apex 2011 winner

Business Book Reviews

Need more resources for growing your business? Get great business book suggestions from Todd.

A Picture Is Worth a Thousand Words - 2017 Summer Book Reviews

thebackofthenap Is a picture truly worth a thousand words? Todd's annual summer book reviews cover four books that have helped either hone thinking skills by using doodles and simple drawings, or spark ideas for improving doodles or other visuals.

 

Nothing Changes Until Somebody Feels Something

Whoever Tells The Best Story Wins(June 2016) Hugh MacLeod of Gapingvoid Art gave Todd inspiration for this summer's book reviews when he said "Attach emotion to logic and anything is possible" — A common thread in the four books Todd reviews.

 

Free Range Staff — 2015 Summer Book Reviews

Leadership and the One Minute Manager book coverTodd describes his idea of how to develop "Free Range Staff" — Employees who can take an idea, develop and run with it with little or no supervision — as he reviews four books he uses to teach and develop his staff.

 

Seeing Around Corners — And Four Books That Can Help

Book Cover of Data CrushTodd's review on books that can help you and your business see around corners better.

 

Interested in reading past case studies? Visit the Case Study Archive.

Todd Herman Associates

336.297.4200

620 Green Valley Road
Suite 104
Greensboro, NC 27408
/strong>

About Todd Herman Associates

Todd Herman Associates is a business technology consulting firm focused on non-routine technology issues such as replacing QuickBooks, getting two systems to "talk" to each other, shrinking process cycle time, and taming large volumes of data.