GLSU PDF Presentation from SAP Financials Europe 2009 - Z Option

58 Pages·2009·1.46 MB·English

0
Vendor Solutions and Services
How SNV Automated Its Everyday
Financial Postings from Microsoft®
Excel to SAP Using Z Option’s
General Ledger Spreadsheet
Uploader (GLSU) Tool
Akil Walji, SNV World – Netherlands
Development Organization
Jim Halepaska, Z Option
© 2009 Wellesley Information Services. All rights reserved.
In This Session ...
Find out how SNV used Z Option‟s GLSU tool to create foolproof
•
templates that enable remote users to streamline spreadsheet-based
processes for SAP.
Learn how SNV increased accuracy, reduced time and effort, and
•
shortened its month-end close cycle by using automated Microsoft
Excel processes to improve accounting procedures.
Understand how SNV trained its users, most of whom had no
•
professional accounting or SAP knowledge, to post hundreds of
documents per day without fear of entering inaccurate data.
Come away with an understanding of how the GLSU spreadsheet
•
loading tool uses standard SAP-provided functionality to seamlessly
upload G/L entries, vendor invoices, and accounts receivable (A/R)
documents directly from Microsoft Excel to SAP.
2
What do we mean by “Extreme”
These Are Sports
These Are “Extreme” Sports
3
What We‟ll Cover …
SNV and Z Option Information
•
The Problem: SNV‟s Financial Close Process
•
The Solution: SNV‟s “Extreme” Z Option Templates
•
Tips and Tricks to Make Your Spreadsheet Template Work for You
•
Demonstration of GLSU
•
Ideas for Automating Other Accounting Processes
•
Wrap-Up
•
4
SNV at a Glance – Akil Walji
Economist by profession
•
Over 20 years experience in the field of Finance, Administration,
•
{Project} Management, Internal Control and ERP solutions
Most of this in Africa and Central America
•
Currently managing SAP FI/CO and SAP BI/BW applications, based
•
in The Netherlands
In charge of translating SNV‟s Business processes and needs into
•
“SAP unless” solutions.
5
SNV at a Glance – “Global Presence, Local Impact”
Netherlands-based International Development Organisation since
•
1964
Up until 2003, under the umbrella of Directorate General for
•
International Cooperation (DGIS) of the Netherlands Ministry of
Foreign Affairs
After 2003, a private NGO (still 100% financed by DGIS)
•
Annual budget of over € 110 million (DGIS) and € ±30 million from
•
other bi-lateral and multi-lateral donors
Our Motto: “Global Presence, Local Impact”
•
Operations in 33 countries with 107 offices

Over 1,600 employees and over 600 consultants

Working closely with over 2,200 local “partners”

6
SNV at a Glance – SAP Environment : ERP Setup
Current Version: ECC 6.0
•
BW
•
Enterprise Portal/Share Point Portal
•
Time writing (in TimeTell)
•
R/3 Modules:
•
FI

CO

HR + Payroll

CATS

{Commitments/Funds Management}

{Project System} – in development

{Adobe Interactive Forms}

SAP BW

7
SNV at a Glance – SAP Environment : SAP Use
6 Locations where SAP R/3 is available
•
107 Offices where Income and Expenditures are incurred
•
One SAP Company
•
One Controlling Area
•
One Depreciation Area
•
33 Company Codes
•
200 Profit Centers
•
1200 Cost Centers
•
4000 Internal Orders
•
46 Currencies
•
5 Languages
•
8
• Located in Lewisville, Texas
(Near Dallas)
• Formed in 1998 by
accountants and programmers
• SAP Software Partner
• World-class products and
support for customers of all
sizes and industries
9