Unlock The Untapped Potential Within Your ERP

Presented by: Melissa Penfield, Majestic Realty CompanyPhil Walton, InsightSoftware.com

There is an elephant in the room

“Those in the room who pretend the elephant is not there might be concerning themselves with relatively small and even irrelevant matters, compared to the looming big one.”

Why do you need so many reports?

Be More Ambitious Than Just Reporting

Driving Enterprise-Wide Productivity & Profitability

Optimize Your Performance

Insight™ Benefits• Built for business/end users• Quick install• Real time information• Built in “ERP Smarts”• Exceptional performance• Inherits ERP security• Improves efficiency• No additional IT infrastructure• 100s of prebuilt SmartViews™• Immediate value and results

Market Position- Total Cost of Ownership (TCO) vs. Time to BenefitLowest TCO

Highest TCO

Time to B

enefit L

ess than 30 daysTim

e to

Ben

efit

G

reat

er th

an 1

yea

r

Traditional BI Tools1

InsightSpreadsheet Plug-ins

Report Development Tools

Insight Software is

one of four “Cool

Vendors” in 2008- Gartner Group

1Time to Benefit and TCO for BI based on BASE Consulting Group Article, Calculating ROI for BI Projects• TCO Includes BI License, ETL License, Servers, Consulting, Ongoing IT Development & Maintenance

Why not BI?• Lengthy and costly implementation • Costly ongoing IT/developer resources required• Not Real Time – Lengthy update process (generally

24 hours)• Data & Views can become out of sync with the ERP

– integrity issues• Report creation/edits require developer resources• Users still require data dumps to Excel* to augment

information gaps• Auditing and Sarbanes-Oxley issues

*“When it comes to BI, no option has been more deployed than integration with Microsoft Excel. 57%, say they've implemented

desktop integration [to Excel]- Information Week, September 8, 2008 - Smart Stuff: The State Of Business Intelligence,

Why Not Traditional Reports?

• Static reports do not keep up with requirements of an agile business

• Very costly to develop reports• Often takes weeks or months to develop

reports• Requires costly development & IT staff to

maintain and create new reports• Users still require data dumps to Excel to

augment information gaps

Why Not Spreadsheets?• 95% of spreadsheets contain at least 1 error (KPMG white

paper) • Results can be manually adjusted - no audit trail on what’s

changed• Can easily be proliferated without security both internally &

externally• Many local copies are created, which is the correct

version?• Difficult to manage if the person who wrote them leaves• No Control: Who publishes what/when? Multiple versions

of the truth!• Plug-in solutions require ongoing IT involvement to define

table mappings and joins.• Auditing and Sarbanes-Oxley issues

What Is Needed?• Users create and edit reports

• Users create ad-hoc, real-time inquiries

• ERP security is honored

• Manages integrity resolution

• Single source of the truth

• Drives compliance with Sarbanes-Oxley

• Summary and detail data is available

• Prebuilt Optimization Solutions drive demonstrated economic benefit

• Delivers business benefit within days/weeks

• Low total cost of ownership

Rapid Time to Benefit• Built for JD Edwards EnterpriseOne & World• Allows end-users to create ad-hoc inquiries

and reports• Easy to learn, easy to use (2-3 days of

training)• Accesses data real time (no staging or

delay)• Easy to install/configure (2 hour install)• Exceptional performance• Enterprise tool that leverages JDE security• Users can easily (immediately) share reports

and inquiries

A Success Story

• Melissa Penfield

• Director of Business Systems

• Business / Accounting background

• Former World/E1 consultant

Majestic Realty• Headquarters: City of Industry (Greater LA Area)

• Largest Private Commercial Developer

• Vertically Integrated

• Acquire: Land Acquisition, Entitlement

• Develop: Commerce Construction Co.

• Manage: Majestic Management Co

• Industrial, Office, Retail

• Remote offices across US

Technology• EnterpriseOne 8.12 Tools 8.98.3.3

• Financials, Project Costing, Real Estate

• Blue Stack

• BI Publisher Desktop (Invoices, Checks)

• Microsoft BI & Dynamics CRM

• Cisco, IBM Blades, VMWare

Oh yeah – 200+ Custom ERW Reports!

Oh, That NFL Thing…..

majesticrealty.com

losangelesfootballstadium.com

sgvtribune.com/stadium

Beyond JD Edwards-so JDE doesn’t solve everything?

• Yes and No

• ERW is a powerful tool

• But it is a developer tool

• Not nimble, Not ad hoc

• Lives in I.T.

Post Implementation CommentarySeparate screens for invoices and cash? Takes too long!

How do I retrieve a report

again???

Report changes and requests require Programmer Expertise

ERW ≠User Friendly

What The Insight Software Suite means to us

• Began with a need soon after implementation – AR Combined Inquiry

• Solves ERP Information Challenges

• Grew to be our “Can’t Live Without” Application• THEME = Streamline Business Processes to Achieve

Operational Efficiencies

• Surprise Benefits – Inquiry Tool, Integrity Tool• The InsightSoftware Company is very collaborative

and responsive

Quotes from those who use it most

Insight has become my team’s “Go To” tool. VP of Property Management

It helps especially for auditor requirements. Project Accountant

My AR issues are solved! And I find my GL details quickly. The ease of running reports on the fly by any category code is wonderful. In JDE inquiries I have to key in the business units one by one which is much more time consuming. Regional Property Manager

Searching for many vouchers GL Coding –I go to many screens one by one. With Insight I quickly located all coding in one search.

In short, it is a must-havesoftware that compliments JDEProject Accountant

More comments…I enjoy Insight very much. It is user friendly and quick with my requests.

Assistant Property Manager

It is a real time saver. I utilize it on a daily basis looking up and comparing prior year expenses to current year. With Insight I’m able to find it with just a couple of clicks. In JDE it can be very time consuming.

Regional Property Manager

When I download reports from JDE to Excel I have to spend a lot of time formatting. When I download a report from Console to Excel it is already formatted. When you run hundreds of reports for auditors this becomes an enormous timesaver.

Controller – Investment Properties

Focus on Analysis- Not Assembling Data

• Combined AR and AP Inquiries

• Consolidated Partnership Financial Statements• Auditor requests – Saves Accounting and IT an

estimated 120 hours twice a year

• Daily Cash Log – saves accounting 10 hours PER DAY• Delinquency Report – saves accounting 20 hours per

month

• 1099 Data Analysis Inquiries

Examples of Areas of Opportunity• Summary and Detail Reports (Report Packs)• Consolidation Reports, Nimble Comparisons• Any spreadsheets being used to compile and

present data• Problem JDE reports – redo them in Insight.• Using a new category code? No problem.• Integrity checking• JDE Upgrades• Many more…

System Support and Maintenance• = VERY low maintenance for I.T.• Uses a small SQL database to house inquiries and

settings• Administration Tool Provided, easy to use• Inherits JDE Security Settings, Import Users from

JDE• Easy/Fast upgrades (I do them!)• Support website for logging questions / issues• Insight team – very accessible and responsive

Insight Reporting Welcome Screen

User Friendly Welcome Screen

• Open Inquiries from here

• Access Favorites

• Open Report Packs

• Click on ‘Recents’

Click a Button1-Click PDF

1-Click Excel

DownloadDouble-

click to Drill Down

Click ‘New’

• Many templates provided

Add your:• Logo• Filters and Layout• Titles• Drill downs• …and more.

Filter Field Chooser

Columns and Sorting Setup

• Users save sets of filters and apply to other inquiries• Visual Indicators

• Stop-lighting, ranking, calculations, charting

• User doesn’t need JDE file names or field aliases

• IT not needed for ‘report’ deployment or security

Other Features We Like

Dynamic Columns

Pivot on Cat Code, Company…

•Pivot on an item to display it as columns instead of rows

•Here, we add in BU Cat Code 21

•The same report is blown out with more detail with one simple change