Customer Name Here Date Here Presenter Jim Halepaska

Customer Name Here Date Here Presenter: Jim Halepaska Productivity Tools for your SAP System 1

Agenda • Introduction and Z Option Company Background • GLSU Product Overview • Why you need a General Ledger Spreadsheet Uploader • How GLSU works • Functional Demo • Hands-On/ Show and Tell • Specific Examples • Wrap-Up Productivity Tools for your SAP System 2

Z Option Company Background • Located in Lewisville, Texas (Near Dallas) • Formed in 1998 • Started by accountants and programmers • SAP Software Partner • World-class products and support • Customers of all sizes in all industries Productivity Tools for your SAP System 3

Z Option Customers Productivity Tools for your SAP System 4

General Product Overview Productivity Tools for your SAP System 5

Why you need FI Document Uploader: Functional: • Use all the standard Excel functionality to calculate values • Never re-key your GL entries again • Minimize the chance of errors • Create more detailed data in less time with less effort • Improve variance analysis Productivity Tools for your SAP System 6

Why you need a General Ledger Spreadsheet Uploader: New Implementation / Re-Implementation: • avoid throw-away, custom legacy data interface programs • use for FI balances and have an everyday tool on day one of go-live • free up development resources to work on enhancements you can't buy off-the-shelf Productivity Tools for your SAP System 7

Why you need a General Ledger Spreadsheet Uploader: Technical: • GLSU works now (Free Remote Installation Assistance requires 1 – 2 hours) • Reduce support and ongoing development costs • Simplify SAP upgrades • Thousands of users to let us know of problems Productivity Tools for your SAP System 8

How GLSU Works: • Easy user interface • Leverage existing Excel skills • Directly posts from the spreadsheet • Flexible layouts • SAP Document Numbers returned to the spreadsheet • Attach source workbook to posted document in SAP Productivity Tools for your SAP System 9

How GLSU Works (cont’d): • Pre-validation of data before loading • Master Data lookups • Post more than 1, 000 line items • Post multiple documents from 1 worksheet • Post / Park / Accrual / Foreign Curr Adj • 双重字节字符 (Asian character support) Productivity Tools for your SAP System 10

How GLSU Works (cont’d): • Free Trial Period • Premium and Standard Users • SAP 4. 6 c and later • Unicode Support • ECC 6. 0? / New. GL? • SAP GUI Productivity Tools for your SAP System 11

LSI Logic Efficiencies using GLSU – Prepared by Laurie Keene at LSI Logic Productivity Tools for your SAP System 12

User-Configuration Productivity Tools for your SAP System 13

On-line Pre-Validation of Data Productivity Tools for your SAP System 14

Off-Line Pre-Validation of Data Productivity Tools for your SAP System 15

Pre-Validation of Data • • Business Area Fund Commitment Item Company Codes Cost Centers Cost Element Currency Customer • • Document Types Employee Number Field Status Group Fixed Asset Fund Center GL Accounts Internal Order Productivity Tools for your SAP System • • Material Posting Keys Profit Centers Tax Code Trading Partner Vendor WBS Element 16

Additional Validation Info • Custom Pre-Validations • Write your own GLSU pre-validations • Written in ABAP using your own resources • All errors are returned to Excel • SAP validations • All SAP occur at posting • Displayed one at a time in Excel Productivity Tools for your SAP System 17

Direct Posting Process Productivity Tools for your SAP System 18

Hands-on Portion of Demo – Spreadsheet Walkthrough – Initialize a new GLSU page – Key two-line JV with minimum field status group requirements – Show balancing feature – Add/change/delete columns with GLSU-> Choose Fields – Validate Documents with GLSU>Validate – Add Blank Columns – =glsu_description functionality – Add formulas to columns – Add document number to header and show autopopulation – “Skip” feature in “A” column – Spreadsheet Options – Multiple Systems – Post/Park/Accrual – Formatting options – Posting – – Save file GLSU->Post Document Show error handling Login is maintained between postings – Exporting Productivity Tools for your SAP System – Save file – GLSU->Export Document 19

Hands-on Portion of Demo (cont’d) – ZGLSU Walkthrough – Validation Options – Turn on/off specific fields – Turn on/off master data texts for specific fields – Premium user site-wide configuration over Suppressed/Required/Optional – Company Code specifier – Initial order of fields in picklist – Administrative Functionality – Upload/Download Templates – Maintain License – Maintain Premium Users – Technical Settings – Post an Export file – Maximum lines per document – Balancing account maintenance – User History – Show history for user – Show reset functionality – Configurable retention period (new in version 2. 1) Productivity Tools for your SAP System 20

GLSU Example Templates – Expense Report – Journal entry form – Multiple Misc. Vendor invoices – Asian character support Productivity Tools for your SAP System 21

Travel & Expense Form Productivity Tools for your SAP System 22

Journal Entry Form Productivity Tools for your SAP System 23

Multiple Misc. Vendor Invoices* *Dropped Header feature may be used on most header fields on any transaction Productivity Tools for your SAP System 24

Asian Character Support (unicode) Productivity Tools for your SAP System 25

Z Option Future Focus • Planned Enhancements • Development Prioritization • Annual Attendance at SAPFI, ASUG, and GFOA Events Productivity Tools for your SAP System 26

Wrap-Up • General Q & A • Contact Information: Shari Alexander (512) 259 -7277 shari@zoption. com www. zoption. com Charles Cathcart (972) 315 -8800 ext. 202 charles@zoption. com Productivity Tools for your SAP System Jim Halepaska (972) 315 -8800 ext. 205 Jim@zoption. com 27