Wider List of values form in Release 3.59

Feature Description: Made the list of values form column widths wider to accommodate value sets with more characters. In future these forms will be resizable by the user.

Feature Benefit: Easier to read segment values that contain many characters

Undo and refresh Expand new feature in Release 3.55.0

Feature Description: You are now able to undo the last Expand operation at the click of a button. The new Refresh Expand functionality allows you to highlight a range that was previously expanded and GL Wand will retrieve the latest values from Oracle and refresh the Expand results. Feature Benefit: Undo an Expand operation at the click of a button rather than needing to remove the inserted lines manually.

Refresh the Expand with the latest information from Oracle.

Rolling period and offset reporting new feature in Release 3.55

Feature Description: The period name function has been extended to allow you to return the period name for an offset e.g. Period Name 2008, 3 offset by -2 will return the name for Period 1 of 2008.

A new function was added called Period Offset. You can enter a period and offset e.g. Mar-02 offset -2 will return "Jan-02". This function can also return the period as a range e.g. "Jan-02-Mar-02" which can be used in conjunction with the custom to date (CTD) balance type to create a rolling period type report.

Feature Benefit: More flexible period reporting.

New calculation option available in Get Balance after upgrade to Oracle R12

After upgrading to Oracle release 12 your Get Balance formulas will have a new calculation option available. In the past you could report on "Entered" or "Translated" balances. In R12 you can report on "Entered", "Translated" or "Total".

GL Wand supports this new "Total" option. For all Get Balance calculations where you want to see the full balance on the account you should now use the "Total" option. You can do a find and replace on your reports to replace "E" with "Total" to fix the Get Balance formulas in existing reports. More Solutions

Explode a report into one sheet per child segment value new feature in Release 3.55.0

Feature Description: The Explode report feature allows you to duplicate the current sheet for each child segment value that rolls up to the selected criteria. Start with a complete GL Wand report and select a cell that drives the Get Balance formula e.g. a cell containing a parent department value. Clicking the Explode report button will create a new sheet for each child value of the selected parent department. Feature Benefit: Duplicate your GL Wand report to create one sheet per child value for the selected criteria at the click of a button.

Undo option for hide zeros in Release 3.55.0

Feature Description: The new Undo Hide Zeros option will automatically undo the last hide zeros operation. Feature Benefit: No longer necessary to manually unhide rows that where hidden by the hide zeros operation.

Nett value on journal report for entered and accounted in Release 3.55.0

Feature Description: Two new fields have been added to the journal drill down report. They are Accounted Nett and Entered Nett. Feature Benefit: The journal drill down report can be used for further manipulation in Excel without needing to first add a nett column manually each time.

Extended support for Excel 2007 file format (.xlsx) in Release 3.55.0

Feature Description: By default GL Wand would always save files and prompt to open files that were in .xls format. The Excel 2007 format has now been included when GL Wand prompts to open a file and will be used when saving files on Excel 2007. Feature Benefit: Extended support for Excel 2007 file format.