GL Wand 4.15 released

An updated version of GL Wand is available. This version includes support for Excel 2010 64 bit as well as supporting the "&" character in a segment value which was previous not allowed. Also included is a new operator for Get Balance segment parameters which will return only the intersection of two sets of criteria. A number of smaller bug fixes are also included.

GL Wand performance optimisation update

Check out the latest tips and tricks for maximising GL Wand performance. Relevant for customers running on Oracle E-Business suite.

Download GL Wand performance optimisation PDF or
See all available GL Wand collateral

Reports Wand Seeded Reports Listing from 4.05 - requires seperate download

Listing of currently available seeded reports querying Oracle Projects, System Administration, Assets, Payables, Receivables, HR & Payroll. Reports Wand Seeded Reports Listing

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.