New Reports Wand module for Oracle E-Business Suite wide reporting (Release 4.05)

Feature Description: Run Excel based reports based on your own custom SQL queries. This new module provides incredible flexibility in terms of filtering, sorting, formatting and refreshing real-time data from any area in Oracle in an Excel reporting environment. Link reports to each other for multi-level drill to detail, drill to anywhere type reporting. Please read the data sheet on our web site for the details or watch a demo on http://www.youtube.com/excel4apps

Feature Benefit: Flexible reporting from any area in Oracle e-Business Suite. Reports Wand is available as a cost plus option. Please contact your sales representative for details and for a free trial.

Calculated formulas on GL Wand drill down reports (Release 4.05)

Feature Description: You can now add calculated formulas to the GL Wand drill down reports as user defined columns. Please see the user guide for more details.

Feature Benefit: More flexibility added to the drill down report layouts. Also facilitates including a Run Report formula in an existing GL Wand drill down report which will allow you to drill to additional detail which is not provided in the standard drill down layouts. The Run Report functionality is part of the new Reports Wand Module available as a cost plus option.

Get Exchange Rate Function (Release 4.05)

Feature Description: Ability to fetch daily exchange rates out of Oracle using a GL Wand function.

Feature Benefit: Exchange rates can be fetched directly from Oracle using a function, therefore users don't have to manually fetch these out of Oracle for use in what-if analysis using GL Wand reports.

Get Balance and drill down by journal source and category (GL Wand 4.05)

Feature Description: A new parameter has been added to the Get Balance function which allows you to specify a journal source and category. The returned balance will then only include journal lines having that source and category. The drill down to detail will then also only return journals having that source and category.

Feature Benefit: Enables you to get balances on an account at a more detailed level than the overall account balance. The functionality can also be used to extract journals based on a particular source and category.

Drill down performance improvement in release 4.05

Feature Description: The drill down logic has been enhanced to improve performance. Where possible GL Wand will batch the drill down calls and fetch the results from Oracle in batches. The user also has the option to cancel the process.

This option will be enabled by default but can be disabled under the advanced GL Wand options. Feature Benefit: Faster drill downs, quicker population of the results into Excel and the ability to stop the process.

Reports Wand coming in version 4.0

Reports Wand for realtime reporting from any area in Oracle will be available as an add on from GL Wand 4.0. Download the Reports Wand datasheet or see the demo

Audit Get Balance feature helps identify glwNoAccess reasons in release 3.89.0

A new option on the tools menu - "Audit Get Balance" - can assist in determining why a Get Balance formula returns an error. It can specifically assist with providing information as to why a Get Balance formula returns glwNoAccess by identifying the segment and segment value which contains security rules.