Improve Your Business Processes: Upload Financial Transactions and Report from SAP Without Ever Leaving Excel!

Please download to get full document.

View again

of 27
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report



Views: 231 | Pages: 27

Extension: PPT | Download: 0

Related documents
Improve Your Business Processes: Upload Financial Transactions and Report from SAP Without Ever Leaving Excel! [Presented by: Z Option and Excel4apps
Title: Improve Your Business Processes: Upload Financial Transactions and Report from SAP Without Ever Leaving Excel! 1 Improve Your Business Processes Upload Financial Transactions and Report from SAP Without Ever Leaving Excel! Presented by Z Option and Excel4apps 2 Agenda In This Session
  • Z Option Information
  • Excel4apps Information
  • GLSU and GL Wand Demos
  • QA
  • Wrap-Up
  • 3 Learning Objectives
  • Learn how you can streamline financial data entry from Excel directly into SAP (using GLSU from Z Option) and then be able to immediately report on posted results (using GL Wand from Excel4apps), without ever leaving Excel.
  • See how financial data can be uploaded into SAP using a flexible, configurable spreadsheet interface.
  • Learn how to automate monthly uploads.
  • Observe how data can be extracted from SAP to Excel in real time.
  • Experience the difference between static vs. flexible ad-hoc reporting and analysis.
  • Discover how to accelerate month-end processing and error resolution.
  • 4 Welcome Spreadsheet Integration For the SAP Professional 5 Presenter Tim Curtin Solution Specialist 6 About us
  • Located in Lewisville, Texas (Near Dallas, TX U.S.)
  • Formed in 1998 by accountants and programmers
  • SAP software solutions partner
  • Customers of all sizes and industries, worldwide
  • 7 Customers Z Option has hundreds of customers with thousands of users worldwide. For a more complete list of our customers, visit 8 Software Tools
  • GLSU
  • Budget Loader
  • EzySolutions
  • 9 Software Tools
  • Powerful, flexible, user- friendly solutions
  • Reduce support and development costs
  • GLSU uses standard SAP authorizations
  • Start posting documents in a few hours with a free Remote Installation Service
  • Free Trial
  • 10 Current Challenges
  • Non-flexible upload tool
  • Large external file uploads
  • Errors on large journal entries
  • SAP upgrade
  • Mergers/acquisitions
  • New implementations
  • Month-end closing process
  • Multiple currencies
  • Cross company postings
  • Multiple vendors
  • 11 Key Features of GLSU
  • Easy user interface
  • Leverage existing Excel skills
  • Post directly from the spreadsheet
  • Flexible layouts
  • SAP Document Numbers returned
  • Pre-validation of data before posting
  • Master Data lookups
  • Post more than 1,000 lines
  • Attach source workbook to posted document in SAP
  • 12 GLSU Common Uses
  • Attach source document (entire workbook)
  • Misc. vendors
  • Payroll
  • Travel and Expense process
  • COPA
  • Multiple currency entries
  • Cross-company transactions
  • P-cards i.e. phone bills, lease payments
  • Accrual entries
  • Acquisition/Migration moving legacy information
  • Customer Success Stories http// myfiles-c8-Success_Stories.aspx 13 Customer Comments
  • With GLSU, we save time and money. FI Project Manager
  • Well have been using GLSU for two years and I cannot tell you what a positive impact it has had on our finance users. Director
  • Since implementing GLSU, weve managed to achieve our goal of a much shorter closing, down from 8 weeks. ICT Officer, FI Unit
  • There is simply no limit to how you can use GLSU if youre familiar with Excel. SAP Business Analyst
  • We use GLSU to improve overall productivity. Senior Accountant
  • SAP is dynamic, my clients businesses are dynamic, and they need dynamic tools like GLSU. Independent SAP Consultant
  • 14 Welcome 15 Presenter Ryan Schmidt Territory Manager 16 About us
  • Founded 2004
  • gt420 customers, gt10000 Users
  • gt60 countries
  • Largest installed base is NA
  • HQ Sydney, Australia
  • NA Offices Raleigh Pittsburgh
  • 17 Currently Reporting cycle Many organizations employing dual SAP Microsoft strategies 18 GL Wand for SAP Reporting cycle 19 Business Intelligence (Hyperion, OBIEE, Business Objects, etc.) Executive Information for strategic decisions Reports Dashboards Graphics Data Cubes Business Intelligence Tools (e.g., Hyperion, Business Obj.) Datawarehouse Operational Intelligence Data transformation (summarized, filtered) ETL Process Operational Information for Daily Analysis Periodically Updated (e.g., weekly, monthly) Reports Dashboards Graphics ERP Systems (Oracle, SAP, JDE, PS) Microsoft Excel Real-Time Data Transactional Data (GL, AP, AR, FA, PO) Datasheets Drill-Down Capability 20 Architecture MySAP Technology Microsoft .NET environment GL Wand for SAP v1.1 (Excel Add-in) Excel Add-in Installed as a Transport Client PC SAP connector for Microsoft .NET v2.01 RFC Layer WAN support Read only access Remote PC upgrades 21 History Brief product history Mar-03 Proof of concept released Sep-04 First sale to listed Investment Bank, Schroders, running Oracle 11i Jan-06 GL Wand 3.00 series released with HTTP framework Feb-07 GL Wand 3.20 - Twenty Three New features including Office 2007 support Dec-07 GL Wand 3.50 Thirty Three enhancements Aug-09 GL Wand for SAP V1.0 for New GL Nov-09 GL Wand for SAP v1.1 Jan-10 Sales Wand for SAP v1.1 April 10 SAP Certified Integration with SAP Applications May 11 Support for 4.7 included from GLW 1.15 Feb 12 Version 3.45 SAP ERP SAP ERP SAP Version ECC 5.0 ECC 6.0, 4.7 Connectivity options SAP connector for Microsoft.Net v2.01 SAP connector for Microsoft.Net v2.01 GL Wand versions Compatible 1.10 1.15 2.00 3.45 MS Office requirements Office 2000 Office 2003 Office 2007 Office 2010 Office 2000 Office 2003 Office 2007 Office 2010 22 Customers NATO Adcock Ingram Al Fahim Enterprises Auscott Limited Australian Prudential Regulation Authority (APRA) Australian Red Cross Blood Service Avista Corp Avtec Limited Bank of Scotland Treasury Bartter Enterprises Pty Ltd Bateman Projects Limited Bossini Enterprises Limited Brick Warehouse Capital Finance Australia Limited Cell C (Pty) LTd Clark County Cochlear Ltd Coogee Chemicals Department of Indigenous Affairs (DIA) Destination Hotels Resorts DHL Excel Supply Chain Singapore Pte Ltd Edgars Consolidated Stores Ltd Ellerine Furnishers (PTY) Ltd Epol a Division of Rainbow Farms Euramax Exterior Products Geratech GFI Group Inc Glatfelter Insurance Group Harmony Gold Mining Pty Ltd HBO Films Indianapolis Airport Authority Insurance Commission of Western Australia (ICWA) Integro Insurance Brokers Internet Solutions ITV Plc JSC Severstal Kawasaki Kisen Kaisha, Ltd. (K Line) Knapp KPMG Lancashire County Council Lancashire Fire Rescue Lancashire Police Authority Louisville Metro Government MasterCard International MB Petroleum Services LLC Mediacom Communications Corp MediMedia Metrobus Multiplex Limited National Health Laboratory Service NATO CIS Services Agency Network Ten Nextel Communications Argentina SA North-West University Optium Corporation Paramount Citrus Association (PCA) Paramount Farms Parliament of Victoria PAS Technologies Perry Equipment Corp Red Rock Consulting Pty Ltd Resmed Roll International Rural Ambulance Victoria Samim SARCC Schroders Investment Management Limited Schweitzer Mauduit Intl Inc SITA (Pty) Ltd South African Tourism Spectranetics The British Library The University of Melbourne Tourism Australia University of Johannesburg University of the Witwatersrand University of Western Sydney Vodacom (Pty) Ltd VW Credit Inc Wesbank Wesfarmers Energy Limited Wyndham Hotels and Resorts 23 Demonstration 24 Wrap Up
  • With GLSU and GL Wand
  • Simply and efficiently generate reports and inquiries from SAP Financial (FI) modules using Excel with full drill down to transactional details
  • Improve the efficiency of financial data entry functions including cutover data, FI postings, and vendor invoice processing directly from Excel to SAP and even enhance your SAP environment by posting more than 1,000 lines and multiple documents from one worksheet, and attaching source documents in SAP
  • Start streamlining your accounting processes for better error resolution, improved data accuracy, reduced time and effort, and a shorter month-end close cycle
  • 25 Looking For More Information? Next Steps Z Option GLSU Schedule a No-Obligation WebEx Demo one hour Set Up Your Free 30-day Trial Excel4apps GL Wand Schedule an Online Demonstration http// Try GL Wand free for a 30-day Trial 26
  • Thank you.
  • Recommended
    View more...
    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks

    We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

    More details...

    Sign Now!

    We are very appreciated for your Prompt Action!