simplifying jde reporting

QuestDirect.org

Simplifying JDE Reporting

The Colas Story

QuestDirect.org

Agenda

• Introduction to Colas• Selecting the right ad-hoc reporting tool• Enterprise reporting best practices• Colas reporting strategies & successes• Introduction to ReportsNow

QuestDirect.org

INTRODUCTION TO COLASScot Fahrenbruch – ERP Manager

QuestDirect.org

Colas Inc.

• US division of Colas SA, owned by Bouygues (France, CAC40 stock:EN)

• 5,700 employees in 70 offices over 43 states• Heavy Civil contractor: roads, bridges, ports,

airports, industrial sites• Manufacturing of materials required for

construction activity (vertically integrated): rock and sand quarries; asphalt, concrete and emulsion plants

4

QuestDirect.org

Colas Inc.

5

QuestDirect.org

ERP at Colas

• JD Edwards EnterpriseOne 9.0• Applications

– Financial Suite including Job Cost– HCM Suite– Capital Asset Management– Sales, Inventory, Purchasing– Contract/Service Billing

• 1500 Users

QuestDirect.org

Additional Enterprise Applications

• HCSS - Heavy Bid, Heavy Job, Dispatcher, FuelerPlus

• JWS Apex & CommandAlkon• OnBase• ReportsNow• QSoftware• Vertex

QuestDirect.org

SELECTING THE RIGHT SOLUTIONScot Fahrenbruch – ERP Manager

QuestDirect.org

Reporting Challenges

• Writing reports in JD Edwards is not possible for the user community. Currently, for a report to be written or modified it requires a request to the ERP team at Colas ISS which could take weeks to complete. Additionally, there is a backlog of development work and a long list of reports that are needed.

QuestDirect.org

Business Objectives

• Purchase & implement a reporting tool that will equip users with the ability to write their own ad-hoc reports and analytical tools.

• The solution should have access to live JDE data real-time, utilize JDE security, and be user friendly.

• The solution should have the ability to report across multiple data sources.

QuestDirect.org

Solution

• ReportsNow Data Access Studio was selected as the ad-hoc report writing tool of choice. The solution fulfills the stated goals as well as many other bonus functions including: shared/published reporting capability, scheduled report processing capabilities, and Excel based functionality.

QuestDirect.org

SELECTION BEST PRACTICESScot Fahrenbruch – ERP Manager

QuestDirect.org

Selection Criteria

• Ease of use• Free trial?• Cost• Ability to report over multiple data sources• Licensing options• Meets business needs across all business areas• Web based enterprise solution• Does the solution speak “JDE”?• Training Options

QuestDirect.org

Selection Approach

• Involve business leadership (key)• Try before you buy• Proof of concept• Narrow your options and take a second

look• Understand the technical and

implementation requirements ahead of time

QuestDirect.org

COLAS REPORTING STRATEGIES & SUCCESSES

Scot Fahrenbruch – ERP Manager

QuestDirect.org

Reporting Strategies

• Promote End-user Ownership• Enable the User Community• Utilize JD Edwards Security• Redevelop Official Colas Reporting• Train the Trainer• Develop Structured Storage and

Publishing Capabilities

QuestDirect.org

Successes

• Live on ReportsNow May 15, 2013• Trained 17 super users• Super users trained ## users• Developed a structured file storage and publishing

standard• Widely accepted and used by the user community• Over 400 reports developed in the 1st month• Nearly 20 official Colas reports being redesigned

using ReportsNow

QuestDirect.org

INTRODUCTION TO REPORTSNOWAlan VanNice - VP Customer Solutions

QuestDirect.org

ReportsNow®

Hundreds of corporations Thousands of users

Founded 2003 in Denver, Colorado200+ customers worldwide20 partners worldwide Oracle Gold Partner 100% focus on J.D. Edwards Product lines

QuestDirect.org

JD Edwards reporting is challenging

Over 5000 Tables Finding data can be difficult

Reporting is time consuming and risky

Package builds & damaged data

Language support 13 Languages and growing

JDE Formatting Dates, Currency, Visual Assists, etc.

Inherit Security at the column level

Inherit current groups and roles

QuestDirect.org

What a Reporting Tool Should do…

Allow business users to create their own reports

Build any report in minutesDesign and run over the web

Have built-in automation & distribution abilitiesCombine data from multiple databases

Drastically improve process times

Data Access Studio is the Solution!

QuestDirect.org

Our Simple Solution

Data Access Studio

Automator

QuestDirect.org

A Simple Solution

• Installs in 20 minutes

• Enterprise Scalability - Web Based

• Concurrent Licenses

• Works over all modules

• Works on Custom Tables and other Databases

• Low Learning Curve

QuestDirect.org

Say hello to Productivity

Eliminate manual tasks

Automate processes

Email with ease

QuestDirect.org

Get a running start

Hundreds of pre-written reportsFast user adoptionReport writing service

QuestDirect.org

The Industry uses ReportsNow®

Hundreds of corporationsThousands of usersMillions of rowsEvery continent

QuestDirect.org

Company We Keep

QuestDirect.org

Contact Us

ColasScot FahrenbruchERP Managersfahrenbruch@colasiss.com(720) 446-1065

Reports Now IncAlan VanNiceVP Salesalan@reportsnow.com303-790-8484

QuestDirect.org

QuestDirect.org

Please fill out your session evaluations

THANK YOU

QuestDirect.org

April 7-11, 2014The Venetian and Sands Expo CenterLas Vegas, Nevada

QuestDirect.org/COLLABORATE

Attend COLLABORATE 14 to hear high-level, strategic education for the JD Edwards audience. Register through Quest to receive exclusive JD

Edwards updates, materials and networking events.

Registration OPEN! Early Bird rates end February 12, 2014.