Delve more deeply into your R/3 financial reports with SAP R/3 Drill-Down reporting.

• See how this little-known and often underutilized tool allows you to slice and dice a vast array of General Ledger, Treasury, A/R, A/P, and other financial information from just a single report.
• Find out how Drill-Down reporting reduces the drain on your IT resources by allowing developers to build a single report that satisfies the requirements of several reporting requests.
• Gain insight into how you can use Drill-Down reporting to overcome common financial reporting pain points, such as reporting off multiple characteristics in a single report.
• Identify the areas within FI/CO where you can access Drill-Down reporting. Learn how to build a Drill-Down report from either A/P or A/R.

• Releases covered: SAP R/3 4.6c | SAP ECC 6.0
• Sessions presented by: Quentin Hurst, Virtuoso

Explore techniques that will help you overcome common pain points associated with building A/P and A/R subledger reports in your R/3 system.
•    Acquire expert tips for how to include master data characteristics in A/P and A/R reports, as well as how to freely define aging buckets.
•    Identify the reporting tools that will best help you with these reports, including SAP Query, Drill-Down Reporting, and Evaluations, and learn which tool to use for the job at hand.
•    View detailed demos of techniques for building A/P and A/R reports using drill-down reporting.
•    Step through examples of how to simplify the creation of commonly requested reports, such as Actual A/R Aging, from invoice data.
•    Learn how to customize evaluations to meet your A/R and A/P reporting needs.

• Releases covered: SAP R/3 4.6c | SAP ECC 6.
• Sessions presented by: Quentin Hurst, Virtuoso

Learn how to do fixed asset reporting with approaches successfully used by other companies but not generally well explained or documented. Watch this session to:
•    Get expert guidance on how to modify standard reports to include additional asset fields that are not readily available.
•    Learn about advanced ALV features such as ABC Analysis and how they can be best utilized in asset reporting.
•    Uncover several powerful but little-known reports not officially found on the reporting tree.
•    Step through an example of how to use cost center reports to identify blocked cost centers that may prevent you from posting month-end asset depreciations, which can result in costly accounting errors and unnecessary rework.
•    Leverage the asset class change report to see if any configuration changes made to the system could be causing errors in your fixed asset reports.
•    Find out how to easily configure asset history reports so that asset acquisitions are correctly displayed according to GAAP standards.
•    Review functions of SAP Query and better understand how to use it as part of a successful ad hoc reporting strategy for fixed assets.
•    See examples of ways that you perform better master data reporting using search helps.
•    Understand the advantages and capabilities of BW and how it can be used for successful fixed asset reporting.
 

•    Releases covered: SAP R/3 4.6c | SAP ECC 6.0
•    Session presented by: Nathan Genez, TekLink International

SAP offers a variety of options for building, customizing, generating, formatting, and distributing financial reports in both SAP R/3 and BW (BI). This session offers a comprehensive guide to these options and the features, requirements, and trade-offs of each. Watch this session to:
•    Weigh the strengths and weaknesses of core R/3 reporting options including Report Painter, SAP Query, and ad hoc reporting capabilities.
•    Understand the array of SAP pre-built financial reports available in R/3 and your options for customizing them.
•    Explore the benefits and reasons to utilize SAP NetWeaver BI (formerly BW) for financial reporting.
•    Drill into the key capabilities of the BEx reporting tool to generate core financial reports.
•    Explore the pros and cons of utilizing the Information Broadcaster to more efficiently distribute your reports.
•    Understand ways you can more effectively Web-enable reports and offer your analysts and managers more self-service reporting options.
 

•    Releases covered: SAP R/3 4.6c | SAP ECC 6.0
•    Session presented by: Jeff LaRusso, Sapient

In contrast to basic lists (traditional reports), the data in statistic and ranked lists is output in a compressed, summarized format.
•    Get complete step-by-step instructions and examples for how to create statistic and ranked lists using SAP Query.
•    See how statistic lists are similar to Microsoft Excel pivot tables and how they allow you to produce summary analyses of data, including totals and averages.
•    Discover how you can leverage summarized data reports to make more meaningful business decisions. Find out which syntax to use within calculated fields and how you can use calculated fields in conjunction with statistics to provide a summarized statistic report.
•    Learn how to create ascending and descending ranked lists.
 

•    Releases covered: SAP R/3 4.6c | SAP ECC 6.0
•    Session presented by: Danielle Larocca, Compass Group

Obtain detailed instruction on how to perform basic and advanced calculations in SAP Query reports for any application area in SAP - no coding required.
•    Discover how to create calculated fields in SAP Query to perform basic calculations.
•    Gain expert advice to perform more complex "if-then" statements, such as: "If the cost center is = to X, multiply the annual salary by 3% to project future increase costs."
•    Unleash the power of how using local fields and entries on selection screens allows you to perform calculations in SAP Query that most people think are only available using ABAP programming.
•    Learn how to add symbols and color icons to your report to highlight certain entries (e.g., red flag any vendor overdue for payment).
•    Understand all your options when using SAP Query's report output, and discover the various options for your SAP Query output via the toolbar.
 

•    Releases covered: SAP R/3 4.6c | SAP ECC 6.0
•    Session presented by: Danielle Larocca, Compass Group

Discover how to successfully meet your HR reporting requirements by optimizing your use of SAP Query.
•    Get expert advice for how to include Personnel Administration (PA) and Personnel Development (PD) data in the same report.
•    Obtain an easy-to-use solution for single-line reporting based on Infotypes, such as Infotype 41, and eliminate duplicate line reporting.
•    Learn how to use SAP Query to monitor compliance with the Department of Labor's FairPay initiative.
•    Tap into best practices to create custom organizational charts.
•    See how to add tables or fields to existing InfoSets.
•    Find out how to perform calculations, including "what-if" statements, in your HR reports.
•    Learn how to properly configure your HR events to optimize HR reporting.
 

•    Releases covered: SAP R/3 4.6c | SAP ECC 6.0
•    Session presented by: Danielle Larocca, Compass Group

This session provides expert advice for leveraging SAP Sales Information System (SIS) for robust and cost effective sales reporting.
•    Explore ways in which SIS can help you generate more meaningful reports and analyses if you have not yet made the leap to SAP BW, as well as how to use SIS as a complement to SAP BW.
•    Step through an example of an ABAP-free way of using SIS to determine monthly sales bookings.
•    See how to populate and activate custom information structures to fill your reports with more detailed information, such as individual customers' sales orders, shipments, and invoices.
•    Get step-by-step instruction on how to configure SIS to run sales reports that include specific order details.
•    Find out how user-defined info structures in SIS affect your reporting strategy.
 

•    Releases covered: SAP R/3 4.6c | SAP ECC 6.0
•    Session presented by: Mitresh Kundalia, Quality Systems & Software

Watch this session to determine when Report Painter is preferable to custom ABAP reporting in terms of cost, time, and maintenance.
•    Get illustrated, step-by-step instructions for building complex financial reports with Report Painter.
•    Learn how to set up currency translations to run and view single reports in multiple currencies while controlling the exchange rate.
•    Get tips to properly maintain your reporting libraries, currency exchange rate tables, and FI/CO currency settings, and find out why this is key to running multicurrency reports.
•    Find out how to include a calculated key figure (CKF) section in your report when standard row/column functionality isn't sufficient to complete intricate formulas.
•    Identify (and avoid) maintenance challenges that can occur in reports with CKF sections.
•    See how your counterparts leverage Report Painter within their R/3 and SAP BW reporting landscapes and take a detailed look at the techniques that have proven to be most valuable.
 

•    Releases covered: SAP R/3, SAP BW 3.5 | SAP NetWeaver 2004 | SAP NetWeaver 7.0
•    Session presented by: David Nowak, Virtuoso

This session delivers comprehensive guidance to leverage SAP Query and related tools, including InfoSet Query and QuickViewer, to create your own reports. Part 1 provides best practices to configure R/3 to successfully deploy SAP Query. Part 2 provides detailed, train-the-trainer style instruction for how to use SAP Query to create meaningful, comprehensive reports in all application areas of R/3.
•    Learn how to configure InfoSets and properly use logical databases.
•    Explore important dos and don'ts for transport maintenance and client deployment of these tools.
•    Tap into SAP Query enhancements that help you minimize reporting performance problems.
•    Obtain best practices for how to monitor random users to ensure that they are using the tool properly and cataloging reports correctly to prevent the creation of duplicate queries.
•    Learn the right way to use basic and advanced screens.
•    Gain insight into how to leverage seven advanced screens to add subtotals, alter column widths, add colors, create custom headers and footers, and incorporate graphics into your reports.
•    Find out how far you can take SAP Query in creating your own reports and when you need the professional assistance of an ABAP developer.
 

•    Releases covered: SAP R/3 4.6c | SAP ECC 6.0
•    Session presented by: Danielle Larocca, Compass Group