• Login
    • Join
  • FOLLOW:
  • Subscribe Free
    • Magazine
    • eNewsletter
    Checkout
    • Magazine
    • News
    • Research
    • Markets & Technologies
    • Raw Materials
    • Top Companies
    • Directories
    • Jobs
    • Events
    • Microsites
    • More
  • Magazine
  • News
  • Research
  • Markets & Technologies
  • Raw Materials
  • Top Companies
  • Directories
  • Jobs
  • Events
  • Microsites
  • Current / Back Issues
    Features
    Business Corner
    Editorial
    Digital Edition
    eNewsletter Archive
    Our Team
    Editorial Guidelines
    Subscribe Now
    Advertise Now
    World Reports
    eBook
    Top Features
    Exterior Architectural Coatings Market

    CHINACOAT 2019 Reaches New Heights

    Automotive Refinish Market

    Asia Pacific Coatings Market

    The Marine Coatings Market
    Breaking News
    Online Exclusives
    Distributor News
    Financial News
    Paint & Coatings Manufacturer News
    People In the News
    Price Increases
    Product News
    Raw Materials & Equipment
    Suppliers News
    Live From Shows
    Top News
    Cristo Rey High School Educator Named 2019 Axalta All-Pro Teacher of the Year

    Michelman Makes United Way of Greater Cincinnati’s List of Top 25 Corporate Campaigns

    BCF: Coatings Industry Reports Record Improvement in Waste, Recycling, Accident Rates

    BASF Doubling Automotive Refinish Coatings Production Capacity at Jiangmen, China Site

    AkzoNobel’s Wanda Vehicle Refinishes Brand Celebrates 85th Anniversary
    Top Companies report
    Market Research
    White Papers / Tech Papers
    Technical Papers
    Product Spec Sheets
    World Reports
    Adhesives and Sealants
    Aerospace Coatings
    Architectural Coatings
    Automotive Coatings
    Automotive Refinish
    Business Operation
    Color Trends & Forecast
    Construction Chemicals
    Corrosion Control
    Industrial Coatings
    Laboratory Equipment
    Marine Coatings
    Market Trends & Forecast
    Powder Coatings
    Production Equipment
    Radcure Coatings
    Special Purpose Coatings
    Wood Coatings
    "Green" Coatings

    BASF Doubling Automotive Refinish Coatings Production Capacity at Jiangmen, China Site

    AkzoNobel’s Wanda Vehicle Refinishes Brand Celebrates 85th Anniversary

    Pursuit of Balance Inspires Pratt & Lambert’s 2020 Color of the Year

    PPG Announces Industrial Coatings Products Global Price Increase

    AkzoNobel Powder Coatings Featured on Varso Tower
    Additives
    Binders
    Pigments
    Solvents

    Pilot Chemical Corp. Acquires Órgano Síntesis

    Sun Chemical Releases 2018 Sustainability Report

    Brenntag Distributes Grupa Azoty ZAK S.A. Plasticizer Portfolio in DACH Region

    PPG Using TiO2 Pigment from Lomon Billions’ New Chloride Production Line

    CHT Group Acquires keimadditec surface
    Buyers Guide
    Company Capabilities
    Distributor Guide
    Add New Company
    International Buyers Guide Companies
    ROSS Mixers

    Siltech Corporation

    EPS

    Pilot Chemical Company

    Keim Additec Surface USA LLC
    Industry Events
    Webinars
    Live From Show Event
    Top Events
    Polymers & Coatings Winter 2020 Short Course

    2020 Greenbuild India Conference

    The Waterborne Symposium

    Spray Finishing Training 2020

    Middle East Coatings Show 2020
    Companies
    White Papers/Tech Papers
    Product Spec Sheets
    Equipment
    Literature/Brochures
    Videos
    International Buyers Guide Companies
    Siltech Corporation

    ROSS Mixers

    EPS

    Pilot Chemical Company

    Keim Additec Surface USA LLC
    • Magazine
      • Current / Back Issues
      • Features
      • Editorial
      • Business Corner
      • Digital Edition
      • eNewsletter Archive
      • Editorial Guidelines
      • Subscribe Now
      • Advertise Now
    • Breaking News
    • Directories
      • Buyers Guide
      • Distributor Guide
      • Corporate Capabilities
      • Trade Associations
      • Add Your Company
    • Markets & Technologies
      • Adhesives and Sealants
      • Aerospace Coatings
      • Architectural Coatings
      • Automotive Coatings
      • Automotive Refinish
      • Business Operation
      • Color Trends & Forecast
      • Construction Chemicals
      • Corrosion Control
      • Industrial Coatings
      • Laboratory Equipment
      • Marine Coatings
      • Market Trends & Forecast
      • Powder Coatings
      • Production Equipment
      • Radcure Coatings
      • Special Purpose Coatings
      • Wood Coatings
      • "Green" Coatings
    • Raw Materials
      • Additives
      • Binders
      • Pigments
      • Solvents
    • World Reports
      • Africa Report
      • China Report
      • India/Asia Pacific Report
      • Europe Report
      • Latin America Report
      • Market Research
      • Russian Report
    • Top Companies
    • Online Exclusives
    • Slideshows
    • Experts Opinions
    • Blog
    • eBook
    • Infographics
    • Videos
    • Podcasts
    • Whitepapers
    • Jobs
    • Microsites
      • Companies
      • White Papers/Tech Papers
      • Product Spec Sheets
      • Equipment
      • Literature/Brochures
      • Videos
    • Events
      • Industry Events
      • Live From Show Event
      • Webinars
    • About Us
      • About Us
      • Contact Us
      • Advertise With Us
      • Privacy Policy
      • Terms of Use
    Online Exclusives

    Case Study: Tnemec Paints a Better Business Intelligence Picture with Excel-based Reporting Tool

    Related CONTENT
    • Top Companies Report Provides Comprehensive Look at Coatings Industry
    • 75 Tnemec
    • Self-healing Coatings and Parts Are Next Frontier for Smart Materials
    • Self-healing Coatings and Parts Are Next Frontier for Smart Materials
    • MKS Umetrics Changes Name
    11.23.15

    As Tnemec, a Missouri-based manufacturer of architectural and industrial coatings, transitioned from a legacy IBM AS400 system to an Oracle enterprise resource planning (ERP) system, both users and internal developers encountered challenges. In particular, frustration with reporting became evident when Oracle’s modules for Financials were first installed.

    Accounting and information services (IS) at Tnemec began exploring third-party tools to bridge the gap between Oracle and more familiar applications like Excel – an accounting favorite. Discovery of GL Wand, an Excel-based financial reporting tool from Excel4apps, answered the needs of accounting and finance users, but Tnemec eventually sought easier reporting from a range of other Oracle modules. Excel-based Reports Wand, also from Excel4apps, became a likely candidate for fulfilling this need.

    Preparing to expand Oracle
    Installed in 2008, GL Wand provides real-time, drillable access to financial data in the Oracle General Ledger (GL) module with a simple mouse click, and it is used to build the Tnemec’s standard financial reporting package. But as the company faced a January 2013 “go live” with Oracle’s Order Management and Inventory modules, it needed a similar way to access the new data. 

    Specifically, Tnemec sought a replacement for the query functionality provided by its outgoing IBM Infinium system, which allowed users to embed queries in Excel spreadsheets. And, based on past experience, using Oracle Business Intelligence Discoverer for the newly-required queries wasn’t a practical option because it required IS support for creating, testing and validating reports, according to Michael Alkire, Applications Operations Manager at Tnemec.

    With the success of GL Wand for financial reports, Tnemec decided to trial another Excel4apps product in summer 2012. The Reports Wand tool could provide access to live data in a variety of Oracle modules via an Excel interface and supported easy creation of customized queries.

    “While migrating from the AS400 to Oracle was a big change for accounting and other users who were accustomed to data in Excel, it was also hard for our developers, who weren’t yet used to Java, XML and forms reports,” said Alkire. “Both Reports Wand and GL Wand provided a way to get back to the Excel workbook functionality our people had used for years.”

    From an IS standpoint, installation of the Excel4apps software was simple.

    “Their documentation is good, and if we encountered a hiccup I just contacted support and they got back to me within an hour,” Alkire described.  “It didn’t matter if we were working in a test instance or production instance; Excel4apps’ replies were timely and helpful.”

    Smooth transition to Reports Wand
    In preparation for the January 2013 go-live date for implementation of the Order Management and Inventory modules, Ken Lloyd, Operations Controller at Tnemec, gathered reporting requirements from the users and researched the inventory and shipping tables in the Oracle database.  The query tool Toad for Data Analyst was utilized to create the SQL statements for the Reports Wand reports. 

    After finalizing a query, Ken sent the SQL statement to IS for creation of the Reports Wand report.  According to Alkire, the process for creating these highly tailored reports was simple, with perhaps the biggest challenge coming from the end users, who often changed their requirements after seeing what Reports Wand could provide. “They’d want us to pull additional data,” explained Alkire.

    A big hit with shipping and inventory
    Ken created two Excel workbooks, one for inventory reports and one for shipping (delivery details) reports, each of which contained several refreshable Reports Wand reports. The query data was then summarized using Excel pivot table functionality, which could be updated each time a Reports Wand report was refreshed. The combination of live ERP system data and refreshable pivot table reports provided dashboards for the Shipping departments to manage orders throughout the day.  Both the inventory and delivery details workbooks are utilized by all eight of Tnemec’s domestic distribution centers. 

    “The delivery details workbook allows shipping clerks and supervisors to enter a shipping status and see what delivery lines are ready to pick release, are on an order header or order line hold, or are currently being pulled on the warehouse floor; optionally, these clerks can enter a specific order number to view the order’s delivery lines,” Lloyd described. “This same workbook also contains Reports Wand reports for delivery exceptions, soft ‘suggested’ allocations, orphaned deliveries, and shipment history. 

    The inventory workbook contains a perpetual inventory listing, an expired inventory listing, an aging inventory report, a cycle count report, and a material transactions report.

    “Reports Wand is the primary software tool used by inventory managers at Tnemec,” said Lloyd.  “Before Reports Wand, there were an unmanageable number of inventory report versions in circulation. Now, the Reports Wand inventory workbook ensures the data used throughout the company for management decision-making is consistent and reliable. Both the Reports Wand inventory and shipping workbooks have been big hits with users.”

    In addition to Reports Wand’s shipping and inventory applications, Tnemec’s Sales and Marketing departments use the tool for sales reporting. A wide range of other queries have also been converted to Reports Wand, such as reports for accounts payable distributions, physical inventory tags, variances, and more. 

    Alternative business intelligence tool
    With the addition of the Oracle modules for order-to-cash processes in 2013, about 70% of Tnemec runs on the ERP system. After upgrading to Oracle EBS Version 12.1.3 in 2013, Tnemec next recognized that Oracle support of Discoverer was questionable, as Discoverer’s functionality was being rolled into the Oracle Business Intelligence (BI) Suite as of June 2015. Given the steep learning curve and expense with an Oracle BI implementation, the company chose to utilize Reports Wand as its primary BI tool.

    Also, Oracle BI tools would still require exports of static data to Excel, while the real-time data from Reports Wand is always up-to-date immediately after adjustments are posted. This convenience leaves more time for analysis - instead of unnecessary busy work like cutting and pasting - leading up to the reporting deadline.

    “It’s an intelligence tool because it is helping us do what we want to do the way our company wants to do it,” said Alkire. “We are also leveraging the existing knowledge and skills of our staff.”
    Related Searches
    • Architectural Coatings
    • industrial
    • Industrial Coatings
    • tnemec
    Related Knowledge Center
    • Industrial Coatings
    • Architectural Coatings
    Suggested For You
    Industry and MPs Aligned on Future of REACH Industry and MPs Aligned on Future of REACH
    Tnemec Expands R&D Facility and Upgrades Capabilities Tnemec Expands R&D Facility and Upgrades Capabilities
    Axalta Welcomes Elizabeth Lempres to Board of Directors Axalta Welcomes Elizabeth Lempres to Board of Directors
    Mahesh Ramanujam Named U.S. Green Building Council President & CEO Mahesh Ramanujam Named U.S. Green Building Council President & CEO
    Analytics, Dashboards and Data Analytics, Dashboards and Data
    Axalta Presents Advancements in Intelligence Integration, Sustainability at EtQ User Conference Axalta Presents Advancements in Intelligence Integration, Sustainability at EtQ User Conference
    Penn State Researchers Develop Bio-based Self-healing Polymers Based on Squid Teeth Penn State Researchers Develop Bio-based Self-healing Polymers Based on Squid Teeth
    Nominations are Open for Tnemec Nominations are Open for Tnemec's 2016 Tank of the Year Contest
    Tnemec Introduces a Mastic Waterborne Acrylic Built Tnemec Introduces a Mastic Waterborne Acrylic Built
    Do or Die: Life Lessons for the Auto Industry (and Takeaways for Others) Do or Die: Life Lessons for the Auto Industry (and Takeaways for Others)
    Tnemec Company Inc. Names Chase Bean President, Chief Operating Officer Tnemec Company Inc. Names Chase Bean President, Chief Operating Officer
    The Synergies of Single-Sourcing Tanks and Vessels, Complete with Linings The Synergies of Single-Sourcing Tanks and Vessels, Complete with Linings
    MKS Umetrics Changes Name MKS Umetrics Changes Name
    Self-healing Coatings and Parts Are Next Frontier for Smart Materials Self-healing Coatings and Parts Are Next Frontier for Smart Materials
    Self-healing Coatings and Parts Are Next Frontier for Smart Materials Self-healing Coatings and Parts Are Next Frontier for Smart Materials

    Related Online Exclusives

    • Architectural Coatings | Corrosion Control | Industrial Coatings
      Major Coatings Manufacturers Exhibit at METALCON 2019

      Major Coatings Manufacturers Exhibit at METALCON 2019

      Experts from 256 exhibiting companies spanning 565 booth shared their knowledge with attendees.
      Kerry Pianoforte, Editor 10.29.19

    • Architectural Coatings | Breaking News | Color Trends & Forecast | Paint & Coatings Manufacturer News
      Hundreds Gather in NYC for Benjamin Moore Color Trends Event

      Hundreds Gather in NYC for Benjamin Moore Color Trends Event

      Benjamin Moore revealed its Color of the Year 2020 as First Light 2102-70 – a soft, rosy hue blooming with potential – during a Sept. 7 event at Starlight Modern in Manhattan. Hundreds of attendees – which included Benjamin Moore r…
      Anthony Locicero, Associate Editor 10.14.19

    • Industrial Coatings
      PPG Coats Jacob K. Javits Convention Center

      PPG Coats Jacob K. Javits Convention Center

      PPG DURANAR coatings were selected to reprise its role as the metal coating of choice for the Jacob K. Javits Convention Center in Manhattan.
      05.20.19


    • Construction Chemicals | Corrosion Control | Industrial Coatings | Marine Coatings
      Talking Corrosion Control with Sherwin-Williams Protective & Marine Coatings Experts

      Talking Corrosion Control with Sherwin-Williams Protective & Marine Coatings Experts

      Coatings World had the opportunity to interview two experts from Sherwin-Williams on the topic of corrosion control.
      Kerry Pianoforte, Editor 01.23.19

    • Industrial Coatings
      Industrial Coating Manufacturers Look Toward the Future

      Industrial Coating Manufacturers Look Toward the Future

      Despite a challenging market. Industrial coatings manufacturers are generally optimistic for the future and are seeking growth both organically and through strategic acquisitions. “The coatings market is expected to remain challenging in 2018,…
      Kerry Pianoforte, Editor 07.05.18

    • Industrial Coatings
      New Products for Industrial Coatings

      New Products for Industrial Coatings

      The June issue of Coatings World featured an article on industrial coatings. Here is a look at what new products the major industrial coatings manufacturers have launched. Hempel introduced a versatile high-build epoxy intermediate coating – H…
      Kerry Pianoforte, Editor 06.28.18


    • Architectural Coatings | Industrial Coatings
      San Francisco International Airport Air Traffic Control Tower San Francisco, California

      San Francisco International Airport Air Traffic Control Tower San Francisco, California

      PPG Case Study: Owner:   City and County of San Francisco Architect:   Fentress Architects; Denver PPG Metal Coating:  DURANAR SUNSTORM XL Coating Curtain Wall Manufacturer:  Wausau Window and Wall Systems; Wausau…
      05.21.18

    • Architectural Coatings | Industrial Coatings
      PPG Case Study:  The Emma and Georgina Bloomberg Center at Cornell Tech Roosevelt Island, New York

      PPG Case Study: The Emma and Georgina Bloomberg Center at Cornell Tech Roosevelt Island, New York

      PPG Case Study: Owner:    Cornell University; Ithaca, New York Architect:    Morphosis Architects; New York Metal Coatings:   PPG DURANAR VARI-COOL Coatings Coatings Applicator:   Precoat Metals;…
      05.14.18

    • Architectural Coatings | Breaking News
      NeverFade Façade Restoration Coating Shows Strong Color Performance After 8 Years in South Florida

      NeverFade Façade Restoration Coating Shows Strong Color Performance After 8 Years in South Florida

      Application in a coastal environment stands up to the elements.
      04.25.18


    • Industrial Coatings
      Sherwin-Williams Coil Coatings Case Study: Anaheim Regional Transportation Intermodal Center

      Sherwin-Williams Coil Coatings Case Study: Anaheim Regional Transportation Intermodal Center

      Paragon of Sustainability Focused Building for the Transportation Industry
      03.28.18

    • Industrial Coatings
      Valspar Case Study: Race Pace Bicycles Treads Forward with Challenging Renovation

      Valspar Case Study: Race Pace Bicycles Treads Forward with Challenging Renovation

      Since 1978, Race Pace Bicycles has provided Maryland with high-quality support and expertise on all things bicycle-related. Beginning as a small two-room storefront in West Baltimore, the business has expanded to five locations, the third location, w…
      03.15.18

    • Architectural Coatings
      Benjamin Moore & Co. Recognized for Modernizing Supply Chain

      Benjamin Moore & Co. Recognized for Modernizing Supply Chain

      Supply Chain Academy initiative led to promotion of 22 percent of its salaried employees.
      Kerry Pianoforte, Associate Editor 03.13.18

    • Industrial Coatings
      Case Study: Valspar Offers Colonial Exterior to the Shenandoah University History and Tourism Center

      Case Study: Valspar Offers Colonial Exterior to the Shenandoah University History and Tourism Center

      The historic Shenandoah Valley in Winchester, VA is widely recognized as a tight-knight community that exists as a beautiful embodiment of all that nature has to offer. Within the borders of the Blue Ridge and Alleghenies Mountains, the valley is hom…
      02.26.18

    • Industrial Coatings
      Valspar, McElroy Metal Team Up to Add Curve, Character to Tyler Fire Station No. 5 in East Texas

      Valspar, McElroy Metal Team Up to Add Curve, Character to Tyler Fire Station No. 5 in East Texas

      About halfway between Dallas and the Louisiana border lies the growing community of Tyler, Texas. Home to more than 100,000 residents, the city is recognized in the region as a destination for education and technology. Tyler is home to four colleges…
      02.05.18

    • Industrial Coatings
      Stepping Stones Preschool Enlists Dynamic Duo of Valspar’s Fluropon Coatings for New Building

      Stepping Stones Preschool Enlists Dynamic Duo of Valspar’s Fluropon Coatings for New Building

      When the Architect for Ancillae Assumpta Academy in Wyncote, Pennsylvania began designing its preschool, Stepping Stones, he wanted to build a playful and creative environment to reflect the Montessori program used in the classroom. John J. Di Bened…
      12.19.17

    Breaking News
    • MFG Chemical Upgrades Dalton, GA Pilot Plant
    • Cristo Rey High School Educator Named 2019 Axalta All-Pro Teacher of the Year
    • Michelman Makes United Way of Greater Cincinnati’s List of Top 25 Corporate Campaigns
    • BCF: Coatings Industry Reports Record Improvement in Waste, Recycling, Accident Rates
    • BASF Doubling Automotive Refinish Coatings Production Capacity at Jiangmen, China Site
    View Breaking News >
    CURRENT ISSUE

    December 2019

      View More >
    • About Us
    • Privacy Policy
    • Terms And Conditions
    • Contact Us

    follow us

    Subscribe
    Nutraceuticals World

    Latest Breaking News From Nutraceuticals World

    International Scientific Society Calls for Omega-3 Blood Testing in Future Research
    Pharmactive Affron Saffron May Help Relieve Depression Symptoms
    Warmer Temperatures Could Lead to Concerning Levels of Arsenic in Rice
    Coatings World

    Latest Breaking News From Coatings World

    Greenkote PLC Reports Upsurge in Powder Coatings Applications on Brake Calipers
    Addipel Moves to New HQ, Expands Production Facility
    HMG Paints Wins BCF's Corporate Social Responsibility Award
    Medical Product Outsourcing

    Latest Breaking News From Medical Product Outsourcing

    Gilero Opens New Design Center in California
    FDA OKs Roche's Nasal Swab MRSA Test
    Philips & Paige to Deliver Clinical-Grade AI Applications to Pathology Labs
    Contract Pharma

    Latest Breaking News From Contract Pharma

    AbbVie, Scripps Collaborate on New Therapeutics
    Sanofi Pasteur Awarded HHS Pandemic Flu Vax Contract
    Recipharm Invests in Inhalation Development Services
    Beauty Packaging

    Latest Breaking News From Beauty Packaging

    WWP Wins Three NJPEC Awards
    Cat-Themed Beauty Collection to Launch in Japan
    Pantone Names Classic Blue the 2020 Color of the Year
    Happi

    Latest Breaking News From Happi

    Lip Lab Opening in Brooklyn
    Raining Rose Expands Exec Team
    Scott’s Sells Personal Care Production Site
    Ink World

    Latest Breaking News From Ink World

    ePac Flexible Packaging Expands into Asia Pacific Market
    Haney, HP Developing Sustainable Fashion Packaging for Heron Preston
    Kodak, Uteco Sell First Ever Ultrastream Powered Flexible Packaging Press
    Label & Narrow Web

    Latest Breaking News From Label & Narrow Web

    HP teams with Haney for sustainable packaging
    Tags & Labels Printing adds Heidelberg’s Versafire EP
    Austrian converter installs first Nilpeter press
    Nonwovens Industry

    Latest Breaking News From Nonwovens Industry

    Thrace to Relocate U.S. Capacity
    FiltXPO Speaker Line-Up Announced
    Nölken Incorporates Sustainable Wipes Packaging
    Orthopedic Design & Technology

    Latest Breaking News From Orthopedic Design & Technology

    InVivo Therapeutics Attains 25 Percent Enrollment in Spinal Cord Injury Study
    BioPrax Biofilm Disruption Device Granted FDA Breakthrough Device Designation
    Orthofix Appoints New Spine Business Leader
    Printed Electronics Now

    Latest Breaking News From Printed Electronics Now

    IDTechEx Show! Announces Graphene Award Winner
    OE-A Continues to Bring Future of Printed Electronics to CES 2020
    Avancis, Smit Thermal, HZB, CNRS, Solliace Team for Higher Efficiencies in CIGS

    Copyright © 2019 Rodman Media. All rights reserved. Use of this constitutes acceptance of our privacy policy The material on this site may not be reproduced, distributed, transmitted, or otherwise used, except with the prior written permission of Rodman Media.