FastFacts Feature Presentation

1. We are using audio during this session, so please dial in to our conference line… • Phone number: 877-322-9648 • Participant code: 182500 FastFactsFeature Presentation July 3, 2008

2. Today’s Topic • We’ll be taking a look at… • R/3 Inbox tips • Uploading a string of document numbers into R/3

3. Today’s Presenter • Glenn Small • Business Solution Manager, Project Manager, HopkinsOne

4. Session Segments • Presentation • Glenn will review a few advanced moves in R/3—some tips and tricks to help use SAP R/3 more efficiently. • During the presentation, your phone will be muted. • Q&A • After the presentation, we’ll hold a Q&A session. • We’ll open up the phone lines, and you’ll be able to ask questions. • We will answer as many of your questions as time allows.

5. Contact Us • If you would like to submit a question during the presentation or if you’re having technical difficulties, you can email us at: fastfacts@jhu.edu • You can also send us an instant message! • GoogleTalk – HopkinsFastFacts@gmail.com • AOL Instant Messenger – HopkinsFastFacts • MSN – FastFacts@jhu.edu

6. Survey • Survey • At the end of this FastFacts session, we’ll ask you to complete a short survey. • Your honest comments will help us to enhance and improve future FastFacts sessions.

7. Agenda Today, we’ll be taking a look at: • Session Assumptions • What is R/3 • R/3 Inbox • R/3 Finance—Researching Transactionsby uploading a string of document numbers into R/3 • Questions & Answers

8. Assumptions • Participants have access to R/3 • Participants are beginning or intermediate users of SAP R/3

9. What is R/3?

10. R/3 Inbox • Grouping items by task • Filtering items by date

11. R/3 Inbox R-3 Inbox Tips—First, you can see your tasks grouped by clicking on the inbox and the Workflow button. Click on Workflow window, and it will open up items grouped. In this example, the 12 means there are 12 items in the inbox. Next, click on “Grouped according to task”

12. R/3 Inbox In this example, we click on “Quantity Discrepancy…” Notice the items in that work category appear to the right.

13. R/3 Inbox Double click on the divider line between subject line and status, and this expand the text display of the title line. Often this extra information is useful in analyzing the transactions. This shows the Title text with the full document number displayed.

14. R/3 Inbox Crowded Box Tip. Change selection period for outbox. Start by clicking on the “Work items executed by me.” Hint: Double click on the Title bar, and it will sort the items by type. (ISRs, eforms, etc.)

15. R/3 Inbox We’ll next click on the “Change selection period” icon as shown.

16. R/3 Inbox You can narrow the focus by the choices shown – today, last 7 days and last 30 days. But you can also define a period, which is what we’ll do here.

17. R/3 Inbox The way this works is from a past date to the present, so you’ll enter a “From Selection Date” in the menu and hit the green check

18. R/3 Inbox You can narrow or expand the search. In this example, we’ve expanded the search range.

19. R/3 Finance—Researching Transactions • Uploading a string of document numbers into R/3

20. Multiple Document Numbers FB03—Financial Accounting Document DisplayThis is a useful transaction to research work items, but most users use it by entering one transaction or document number at a time. But today…we’re going to show you how to get a series of transaction numbers and upload them in bulk to FB03 to make your researching easier. Please Note: This is going to be relevant for FI documents such online payment, petty cash, accounts receivable, etc.

21. Multiple Document Numbers In our example, we’re going to look at the Sponsored Revenue-Expense Detail – Single Period Report. We’ll use it to generate a report with document numbers that we’ll import into FB03. We’ll start at the JHU Controller’s web site (www.controller.jhu.edu) and go to the H1 Knowledge Portal tab. Click on BW Report Formats

22. Multiple Document Numbers Using a booked marked formatted report. Click on “Formatted Report”

23. Multiple Document Numbers If you’re not already logged in to SAP, you’ll be prompted to do so and after you’ve logged in, you’ll be taken to the variable screen for the Sponsored Revenue-Expense Detail – Single Period Report. Enter an account number (in our case, an Internal Order) and a date period. Then “Check” and “Execute” the report. Once you’ve entered an account number and period, click Execute.

24. Multiple Document Numbers For this tip, we’re interested in the FI Document numbers column. We want to grab a range of these numbers to import into R/3. We can do this a couple of ways. One is to highlight them in the BW results screen and do “Control C” to copy; another is to export the results into Excel, and then select the range from Excel.

25. Multiple Document Numbers Here we’ve exported to Excel and gone down into the rows to select a range of transaction numbers we want to research. In this example, we’ve selected travel transactions. Highlight the range of numbers and hit Control C to copy them to your clipboard.

26. Multiple Document Numbers Now we’ve opened R/3 and entered the T-code FB03. We could enter a single document number here to research. But we want to enter our list of multiple document numbers, so click on “Document list”

27. Multiple Document Numbers On this screen, first click the yellow arrow to the right of the “Document number” field. When you do, you’ll get the error message below.

28. Multiple Document Numbers Now enter the Fiscal Year and the Posting date range. The form needs two additional search terms and we’re suggesting these two for our example. You could select others, depending on your circumstances.

29. Multiple Document Numbers We’ve entered the additional data search terms. Click on the green check icon.

30. Multiple Document Numbers From this screen – and knowing we have the document numbers we want to insert in our (Control C) clipboard, click on the clipboard icon below.

31. Multiple Document Numbers The numbers we copied from our Excel file are now loaded into FB03. Now click on the clock-green check.

32. Multiple Document Numbers Now click the clock-green check to run this.

33. Multiple Document Numbers Here are our transactions all loaded into FB03. From this report screen, you can click on any of the items to get more detail.

34. Conclusion • Hopefully these tips can help some of you with your work using R/3. Any tip that saves time is valuable. • Thanks for this material goes to the members of the user group known as the R/3 Club. Since our first R/3 Club FastFacts several weeks ago, we’ve grown from about 10 to about 60 members. • If you use R/3 and would like to share what you’ve learned, or simply learn from your colleagues, consider joining us. • To join the R/3 Club e-mail list, click on this link:Join the R/3 Club.

35. Q&A • We’re going to open the phone lines now! • There will be a slight pause, and then a recorded voice will provide instructions on how to ask questions over this conference call line. • We’ll be answering questions in the order that we receive them. • We’ll also be answering the questions that were emailed to us during the presentation. • If there’s a question that we can’t answer, we’ll do some research after this session, and then email the answer to all participants.

36. Thank You! • Thank you for participating! • We would love to hear from you. • Are there certain topics that you would like us to cover in future FastFacts sessions? • Would you like to be a FastFacts presenter? • Please email us at: fastfacts@jhu.edu

37. Survey • Before we close, please take the time to complete a short survey. • Your feedback will help us as we plan future FastFacts sessions. • Click this link to access the survey http://connect.johnshopkins.edu/fastfactssurvey/ Thanks again!