The expand feature allows you to extract all the detailed child segment values that roll up to the criteria that the user specifies. The expand feature has been extended to support account combinations.

In order to expand an account combination you would do the following:

·         Ensure that the correct set of books is selected in the drop down list on the GL Wand toolbar

·         Select the cell containing the account combination criteria e.g. “100.7000”

·         Click the expand button

GL Wand will now identify that the selected cell contains an account combination rather than a single segment value. You will now be presented with a window to identify which segments from your chart of accounts are represented in the account combination.

Select the correct segments and click “OK”. GL Wand will now extract all the child combinations that roll up to the criteria that you entered and insert them into the Excel sheet.

The other options are as follows:

·         Fix – if you tick this option for a segment, GL Wand will “peg” that segment using the selected value (this option only makes sense for a parent segment value). You might for example want to expand all the account combinations used in a particular parent cost centre. Simply “Fix” the cost centre segment and GL Wand will return all the account combinations used within that parent cost centre.

·         Exclude disabled account combination – tick this option to only return account combinations that are currently enabled and have not been end dated.

The expand account combinations feature can be used as a normal GL Wand “Expand” in order to extract the detail behind a total, but it is also very useful to extract existing account combinations from your Oracle system.

This feature can be used very effectively with the Split Text and Combine Text functions.