Get Balance now supports converted amount (Release 3.85.0)

Feature Description: The Get Balance formula now contains a new option for the translated flag, namely "C" for converted. When using this option GL Wand will return the converted amount in functional currency for a particular entered currency. Feature Benefit: This amount type was previously not available in GL Wand.

New calculation option for Get Balance in Release 3.85.0

Feature Description: The GL Wand logon screen now has a new check box which allows you to select an alternative method for processing Get Balance formulas. You can select this option at each logon and vary it to suit which ever method provides you with the best performance for particular GL Wand reports. Feature Benefit: In certain situations this alternate Get Balance processing method can result in a significant performance improvement. When selecting this option, the initial GL Wand logon may be slower.

We recommend testing your slower GL Wand reports using the old and the new method to determine which method is better for your environment.

Change in the Get Balance “all values” parameter (Release 3.85.0)

Feature Description: Previously when leaving a particular Get Balance segment parameter empty, GL Wand would assume that you want all values for that segment. You had the option to either specify a "%" to denote all values or simply leave the segment parameter blank.

This functionality has however caused problems in certain situations. For example a user copies and pastes a Get Balance formula onto a new row. The Get Balance formula is linked in the segment 3 parameter to column A, however on this new row the value in column A is blank. If your GL Wand calculation is it set to "On" this calculation will start and may take a long time to complete as GL Wand is assuming you want all values for segment 3.

Feature Benefit: You must now specifically enter a "%"to denote all values. This gives GL Wand the ability to know whether you are specifically requesting all values or that you have simply not completed entering the formula yet.

This change also prevents GL Wand from duplicating the calculations which can result in certain cases when Excel does not initially get the calculation dependencies correct. This can happen when you derive the segment values using an Excel formula like Mid or the GL Wand Split_Text.

Explode using the parent hierarchy (Release 3.85.0)

Feature Description: You can now perform an explode using the Oracle defined parent hierarchy. Previously GL Wand would perform and explode on a summary report by splitting it down to the lowest level children only.

You can now explode a report down one level of the hierarchy or down the full hierarchy for all levels. Feature Benefit: More flexibility when exploding reports into their detail. You are now able to see the detail one level down the hierarchy (or for the full hierarchy) rather than only seeing the lowest level children.

Expand using the parent hierarchy (Release 3.85.0)

Feature Description: You can now perform an expand using the Oracle defined parent hierarchy per level of the hierachy. Previously GL Wand would perform and expand down to the lowest level children only.

You can expand down one level of the hierarchy or down the full hierarchy for all levels. Feature Benefit: More flexibility when expanding values into their detail. You are now able to see the detail one level down the hierarchy (or for the full hierarchy) rather than only seeing the lowest level children.

Discover parent hierarchy (Release 3.85.0)

Feature Description: You now have the option of extracting the hierarchy for a segment into an Excel sheet. Starting with a parent value GL Wand will extract the full hierarchy for that parent value and display it indented in an Excel sheet.

Feature Benefit: Previously GL Wand only extracted the segment values in alphabetical order, you now have the option to extract this information in the hierarchy sequence and view the full hierarchy.