320 likes | 542 Views
Simplifying JDE Reporting. The Colas Story. Agenda. Introduction to Colas Selecting the right ad-hoc reporting tool Enterprise reporting best practices Colas reporting strategies & successes Introduction to ReportsNow. Scot Fahrenbruch – ERP Manager. Introduction to colas. Colas Inc.
E N D
Simplifying JDE Reporting The Colas Story
Agenda • Introduction to Colas • Selecting the right ad-hoc reporting tool • Enterprise reporting best practices • Colas reporting strategies & successes • Introduction to ReportsNow
Scot Fahrenbruch – ERP Manager Introduction to colas
4 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
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
Additional Enterprise Applications • HCSS - Heavy Bid, Heavy Job, Dispatcher, FuelerPlus • JWS Apex & CommandAlkon • OnBase • ReportsNow • QSoftware • Vertex
Scot Fahrenbruch – ERP Manager Selecting the right solution
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.
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.
Solution • ReportsNowData 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.
Scot Fahrenbruch – ERP Manager Selection best practices
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
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
Scot Fahrenbruch – ERP Manager Colas reporting strategies & successes
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
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
Alan VanNice - VP Customer Solutions Introduction to reportsnow
ReportsNow® Founded 2003 in Denver, Colorado 200+ customers worldwide 20 partners worldwide Oracle Gold Partner 100% focus on J.D. Edwards Product lines Hundredsof corporations Thousandsof users
What a Reporting Tool Should do… Allow business users to create their own reports Design and run over the web Build any report in minutes Combine data from multiple databases Have built-in automation & distribution abilities Drastically improve process times Data Access Studio is the Solution!
Our Simple Solution Data Access Studio Automator
Installs in 20 minutes Enterprise Scalability - Web Based Concurrent Licenses Works over all modules Works on Custom Tables and other Databases Low Learning Curve A Simple Solution
Say hello to Productivity Eliminate manual tasks Automate processes Emailwith ease
Get a running start Hundreds of pre-written reports Fast user adoption Report writing service
The Industry uses ReportsNow® Hundreds of corporations Thousands of users Millions of rows Every continent
Contact Us Colas Scot Fahrenbruch ERP Manager sfahrenbruch@colasiss.com (720) 446-1065 Reports Now Inc Alan VanNice VP Sales alan@reportsnow.com 303-790-8484
Please fill out your session evaluations Thank you
April 7-11, 2014 The Venetian and Sands Expo Center Las 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.