Company Overview

Download Report

Transcript Company Overview

10th November 2010
Peter Oosterhoff ( Incotec )
Bill Isherwood ( Excelogy )
LUA Conference Eindhoven
AGENDA
Incotec
( PO )
About Incotec
Why we needed Spreadsheet Server
Excelogy
( BI )
About Excelogy
Spreadsheet Server presentation
Questions
World leader in creating and delivering
sustainable added value to seeds and
vegetative genetic materials to support the
increasing need for healthy food and to
make our contribution to the welfare of the
world population
INCOTEC’s technologies
 Upgrading
 Priming
 Disinfecting
 Film coating
 Encrusting & Pelleting
 Adding Actives (e.g. PPP’s)
 Analytical Testing
(e.g. markers, loading)
Background to Spreadsheet Server
 Running Movex RPG v 11.3
 New Financial Controller 2010
 Identified Need for more facilities for Financial Reporting
 HUGE Management Excel Reports populated manually
 Inefficient, liable to errors
 Delayed Management Reports.
 Introduced to Spreadsheet Server by KPIT Cummins
 Excelogy arranged web-presentation to Finance & IT
 Agreed to trial one licence
 Installation and training – 8/9 Sept to new Controller
 By end of 9th Sept Jan had recreated main management
report - populated automatically by LIVE Movex data
Benefits
 Cut and Paste no longer needed
 Less effort to produce reports
 Correction cycle much quicker
 Reports contain more recent data
 Easier to add history data for comparison
 Drill down functionality quickly reveals causes
Future:
 Distribute reports to managers (view function)
 Consolidated reports
 Access to AR, AP and FA data ?
Excelogy  Based North West England (www.excelogy.co.uk )
 Key Staff ex-Intentia/ Lawson
 Member of LUA since 2005
 Experience - Ex ERP Users...
 Finance, Logistics, Manufacturing, Integration, Implementation
 Specialise in Spreadsheet Automation
 Main Distributor for Spreadsheet Server
 with local partners
 Project Management
 Supplement Project Team
 Movex/ IT Consultancy
Excelogy - Specific Skills
Main Distributor/ Partner Global Software
- Select, Train, Support other Partners
Vendor trained/ accreditations
- Lawson
- Sage
-Global Software
-Others
Professional Qualifications
Excelogy Spreadsheet Automation products
 Spreadsheet Automation
 Spreadsheet server,
 Distribution Manger
 Budget Manager,
 Dash
 Business Systems


Lawson / M3
Sage
 e-Commerce


B2B & B2C Web sites
Integration
 Infrastructure & Systems Management


Installation – hardware/ networking/ Back office Systems
Outsourcing IT & Facilities Management
Selection of SSS/ M3 Customers
Excelogy Business Ethos ( thanks Mike ! )
 Pragmatic Approach to Client Business Systems
 Kindergarten Values:
 Don’t Hit Anyone
 Don't Tell Lies
 Clean up your own mess
 Attain & Keep “Trusted Advisor” Status
Spreadsheet Server Concept
DATA
REPORT
M3 GL
• Direct LIVE link between MS® Excel client and M3
• No staging areas or data warehouses
• Drill down and refresh reports on demand
DRILL DOWN
Spreadsheet Server
Technical
User Interface– Microsoft® Excel
Totally PC Based
Excel Add-in
Optional Server
Config / Security
Direct Connect to GL Databases

Connection executed via
OLEDB or ODBC to
Databases

Dynamic Link between
Microsoft® Excel client
and database

One-way SQL query
dialog with database

No staging areas or data
warehouses
Available Pre-Configured for M3, S3, SAP,
Oracle, BPCS, JDE etc etc
Excel Add-in
Formulae obtain data
Canned Demonstration - Graphics……
Canned Demonstration – Financial Report
Canned Demonstration – Drill to Content
Canned Demonstration - Journal
Canned Demonstration – Journal Lines
Canned Demonstration – Subsystem
Canned Demonstration – Source Tranasactions
Spreadsheet Server Recap....
Implemented and Supported world-wide
( Virtually all of the Movex users in the UK….. )
Real-time access to critical financial data from Microsoft ® Excel
No IT involvement - users ‘live’ producing reports within hours
No downloading, cut/paste or re-keying of data
Retrieve real-time Period, Year-to-Date, Quarter-to-date, Opening/closing
balances and account descriptions
Retrieve balances and group accounts
Drill-down to the lowest level of detail ( source transaction ) and across
multiple columns
Reduce the number of days to close periods and publish Management
Reports
MANAGEMENT REPORTING AND FINANCIAL ANALYSIS
Questions ?
( Or speak later for a One-on-One discussion/ live demonstration
)