Expand Account Combination
The Expand Account Combination feature allows you to extract a list of account combinations that roll up to a particular segment selection. In order to expand an account combination you would do the following:
- Ensure that the correct Ledger 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 Expand. 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 combination 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.