The GL Wand functions work in a similar way to any other Excel worksheet function. You provide the required parameters and the results of the function are returned to the Excel cell. The difference being that GL Wand functions retrieve information from your Oracle Applications system
GL Wand currently has the following functions.
- Segment Descriptive Flexfield
You can enter a function into an Excel cell in a number of ways.
Click the applicable button on the GL Wand toolbar (or on the GL Wand menu)
Type the function name into the cell manually prefixed by an = sign
You can select the function from the list that Excel provides when you choose the Insert Function menu item. The GL Wand functions are listed under the special GL Wand category (Prior to Excel 2007 they are listed in the User Defined category).
If you click the applicable function button on the toolbar and the cell you are in contains that function, the Excel formula wizard window will open. If you click a function button in a cell that contains other data, GL Wand will warn you that it is going to replace the contents of the cell with the chosen formula and will give you the option of cancelling the action.
All parameters must be entered as text values i.e. enclosed in double quotes e.g. enter “USD” when entering the currency code or enter “001” when entering a segment value.
See “Discovering versus Functions” for a comparison extracting information using the discover tools or the functions.