110 likes | 532 Views
Really Real Time ® Inquiry Suite. NorCal OAUG January 17 th 2007 Streamline your financial processes with Phil Walton The GL Company. The GL Company ®. Accounting Intelligence A new paradigm. Accounting Intelligence is New. BI, Excel & Access. Reports.
E N D
Really Real Time® Inquiry Suite NorCal OAUG January 17th 2007 Streamline your financial processes with Phil Walton The GL Company
The GL Company® Accounting IntelligenceA new paradigm
Accounting Intelligence is New BI, Excel & Access Reports Online InquiriesDirectly fromthe JDE/eBSDatabase
Traditional Solutions • Paper Reporting • Dead data, no drill down, not real time, limited columns and not an end user tool • Business Intelligence • Data Cubes designed for summary information, but they are separate databases from your ERP systems • Excel Interface • Flexible, but lacks structure and control causing spreadsheet proliferation and SOX compliance issues
Accounting Intelligence Defined by the 5 “FAVOR” Factors lash Reporting Cycle ccounting tool, not IT irtual OLAP nline Publishing & Inquiries eally Real Time® F A V O R
Flash Reporting Cycle Accounting Intelligence “The 5 days before and the 5 days after the month end close” BU Managers • Flash Reports • Control Accounts • Commitments • Prepayments • Accruals Ready! Ready! Ready! Ready! Using Really Real Time: BU Managers are alwaysconnected to the financial data to speed up the month end close and provide greater financial visibility AccountingFunction
Accounting Tool, Not IT Accounting Intelligence Inquiry Suite: Power Users (Accountants) can buildonline Inquiries / reports in minutes Configurator: Super users (Again an Accountant) can change and bring in new data elements for the Power Users Executive Console: Accountants can publish these inquires to Business Unit managers. Inquiry only users Managers and budget holders can see all their data real-time with full drill down / through
Virtual OLAP Accounting Intelligence Relational:Designed for Transactions OLAP:Designed for Summary Balances The GL Company is the first company to combine both summary and transactional data into a single real time application
Online Accounting Intelligence Drill Thru:to integrate reports Summary Balance Sheetto GL Transactions Drill Down:to transactions Summary Balance Sheet to AR Aged Debt Report • Users work directly with the data to build inquiries and reports • Reports can be published instantly to other users
Really Real Time® Accounting Intelligence Accounting Intelligence TraditionalSolutions • Indirect. The data is often out of sync. • Lots of processes to extract, transform, load, aggregate, report, validate, adjust • The data is often more than 24 hours out of date • Lots of points of integrity failure • Breaks security link with the ERP system • Direct. As soon as a journal is entered the information changes • Eliminates the need for journals / adjustments outside of the GL • Speeds up and ensures that the figures are correct at month / year end • Inquiries run very fast