Easing the Inquiry, Consolidation and Reporting Processes

1
Easing the Inquiry, Consolidation and Reporting
Processes
Customer Success Story
T3.1,Thursday 19 February 2004200pm to 245pm
2
Agenda

• GL Inquiry An Overview Paul Yarwood, The GL
  Company
• GL Inquiry A Customer Experience Steve Issac,
  Hydro Tasmania
• GL Inquiry Demonstration Paul Yarwood, The GL
  Company
• GL Reporting An Overview Paul Yarwood, The GL
  Company

3
Who are we?
The GL Company

• We are specialists in providing Really Real
  Time solutions for the PeopleSoft General
  Ledger.
• By specialising we understand the real issues
  associated with inquiry, consolidation and
  reporting.

Perceive

• Are exclusive agents of The GL Company in
  Australia New Zealand offering effective
  information solutions to organisations striving
  to produce quality management information.

4
Our Products

• Currently Available
• GL Inquiry (Pre Cut Off)
• GL Reporting (Post Cut Off)which enables
• Statutory Management Consolidation
  Works with PeopleSoft World and
  EnterpriseOne

PeopleSoftWorld User
PeopleSoftEnterpriseOne User
5
The Problem

• PeopleSoft has a very functional database but
  most of the data is stored at transactional
  level
• The data that is stored at summary level is very
  slow to extract and inquire upon
• Its not just PeopleSoft, all ERP vendors suffer
  from this problem
• ERP systems have been developed using relational
  technology, technology that has been designed for
  building business processes.

6
Management Decisions

• Summary Data OLAP

Targets Performance
Analysis
Decisions

• Real time
• Full drill down
• Consolidations

Consolidation
Transactional Data Relational
7
Business Un-Intelligence?

• Export to a separate database
• Not real-time
• Issues of accuracy, auditability
• Issues of security
• Not designed to help with cut off.

JDE Ver 1
JDE Ver 2
JDE Live
8
Month End Close

• Data is changing all the time
• Control accounts are out of balance
• No point in doing reporting until the trial
  balance actually balances
• Need a full audit trail
• BI can become counter productive!

9
PeopleSoft Database
PeopleSoft World and EnterpriseOne has a great
database

• Category Codes
• Ledger Types
• Sub Ledgers
• Designed for off-line reporting
• but has limited summary online capability

10
ODBC Open Database Connectivity

• Real time direct to PeopleSoft
• Read Only
• No amendments to the underlying database
• Does not require World or EnterpriseOne on your
  machine

11
GL Inquiry
GL Inquiry An enhanced Inquiry consolidation
tool that works directly over PeopleSoft

• Real-time inquiry and analysis
• Fast consolidation aggregation
• Quick easy install. Less than 20 mins.
• Minimal training
• Immediate ROI
• Uses World or EnterpriseOne data
• Respects PeopleSoft security
• Enhanced functionality beyond that provided in
  PeopleSoft
• 30 Business Unit 23 Object categories
• Grouping, sub-totalling calculations
• Windows functionality even for World
• User profiling report sharing
• Export to Microsoft Excel
• Sequencing exception reporting
• Drill down to transactional data
• Virtual OLAP

New versions driven by our customers
12
GL Inquiry
View Summary Balances F0902
13
GL Inquiry
Drill Down to Transactions F0911
14
GL Inquiry
View Posted and Un-Posted Transactions
Instantaneous Scrolling
15
GL Inquiry
Drill Down to Composite Journal Entries
16
BU Category Codes
BU Cat 1
BU Cat 2
BU Cat 3
BU Cat 4
BU Cat 5
BU Cat 6
 
 
 
 
 
 
 
Business Unit
 
 
 
 
 
 
 
 
 
 
 
 
MA
LON
UK
EUR
HQ
MA
LON
UK
EUR
HQ
MA
LON
UK
EUR
HQ
 
 
 
 
 
 
BS
LON
UK
EUR
HQ
BS
LON
UK
EUR
HQ
 
 
 
 
 
 
BS
LON
UK
EUR
HQ
MA
LON
UK
EUR
HQ
PRO
BS
LON
UK
EUR
HQ
PRO
Store
Area
Country
Region
Group
Project
17
BU Category Codes
Real Time Business Unit Category
Code Consolidations
18
Object Category Codes
23 Object Category Codes
Obj Cat 1
Obj Cat 2
Obj Cat 3
Obj Cat 4
 
 
 
 
 
Object Account
 
 
 
 
 
 
 
 
 
 
FEE
400
FEE
400
COS
400
 
 
 
 
 
COS
400
 
 
 
 
 
FEE
400
 
 
 
 
 
 
 
 
 
 
FEE
500
 
 
 
 
 
400
BAL
CON
400
BAL
CON
400
BAL
400
BAL
 
 
 
 
400
BAL
PL
Statutory
B/S
Control
 
 
 
19
Object Category Codes
Real Time Multi-company / Business Unit
Consolidation
20
Excel Integration
21
GL Inquiry Summary
GL Inquiry
An Enhanced Inquiry consolidation tool that
works directly over PeopleSoft

• Pre month-end cut off application
• Real time
• Volume intensive
• Great speed of performance
• Windows rich environment

PeopleSoftWorld User

• 20 minute install
• 1 day training
• No consultancy

PeopleSoftEnterpriseOne User
22
Our Customers (1)
23
Our Customers (2)
24
What Our Customers Say
GL Inquiry has revolutionised access to the
EnterpriseOne General Ledger. Reports that would
typically run in around 20 minutes can be
generally fully replicated in GL Inquiry and run
in around 20 seconds. This has transformed the
month end process from both a timing and resource
perspective. Our accounts love it! Andrew Dunn,
Crane Group, Australia
25
What Our Customers Say
GL Inquiry stands above and beyond all other
products because it is easy to use for all levels
of accountants, offers real-time access to the
original data and utilizes the category codes for
both business units and objects. The user
interface is easy to understand with minimal
training. Mark Reynolds, Wolters Kluwer Health,
USA
26
What Our Customers Say
Our two main concerns with EnterpriseOne has
been the lack of available inquiries over the GL
and the complexity for users around data
selection and processing options when running
reports. GL Inquiry has provided the solution to
these problems without the need for costly
development time. In addition, with GL Inquiry,
run time for inquiries will be significantly
reduced. Errol Akom Nikki Evans, Thiess Pty
Ltd, Australia
27
Customer Success Story
Steve Issac Information Analyst Financial
Systems
28
GL Inquiry
Demonstration
29
GL Reporting
GL Reporting A true web-enabled reporting and
analysis tool for PeopleSoft

• Web based, zero client reporting solution
• Optimized for PeopleSoft
• Creates highly stylized reports in minutes
• Anytime, anywhere information access
• Interactive drill down exception reporting
• Dynamic time series on-the-fly calculations
• Real-time reporting sharing collaboration
• Elegant printing
• Export to Word or Excel
• Report scheduling and e-mailing
• Secure data access
• Custom user capabilities
• Overcomes the issues of OLAP

New versions driven by our customers
30
OLAP Databases
Hyperion Essbase
Any OLAP cube (that conforms to the OLE DB for
OLAP industry standard)
The GL Company
Microsoft Analysis Services
31
What is Multi-dimensional?
What are Dimensions ? Any element that measures
your business General Ledger (GL) Data

• Company
• Business Units
• Business Unit Cat Codes 1 to 30
• Ledger Types
• Years

• Object Account
• Sub Ledger
• Object Cat Codes
• Periods

Data
32
What are Members?
What are Members ? The elements that make up the
Dimensions

• Ledger Types
• AA, BA, CA, XA, PA
• Years
• 2000, 2001,2002,2003
• Object Accounts
• Revenue, Sales

Data
33
Few People Can Use OLAP
Complexity!!
34
You End Up Confused!
35
We Only Think in 3 Dimensions
36
(No Transcript)
37
(No Transcript)
38
(No Transcript)
39
(No Transcript)
40
Data Frequency

• Real-time
• Hourly
• Daily
• Monthly

41
Microsoft Analysis Services

• Very cost effective
• Relatively easy to build cubes
• Has database triggers that updates the cube
  semi-real time
• FREE with SQL Server

42
What Our Customers Say
Were really using and enjoying GL Reporting.
Its surpassed my expectations as to how much we
would be using it and in such a short amount of
time. It has also been embraced like no other
software weve installed. Kudos to you and your
team! Kyle Husen, NRG Energy, USA
43
What Our Customers Say
GL Reporting provided us with an excellent
reporting solution in a very short time from
installation to production. Its relatively flat
learning curve was appealing as well as the speed
at which it could reproduce reports. Rick
Hertzberg, The Scoular Company, USA
44
Whats Next
Trial GL Inquiry and/or GL Reporting for 30
days!
45
QA
Any Questions