Configuration Sheet
When you click the “Configuration Sheet” button, GL Wand inserts a new worksheet into the current workbook that contains a variety of information about the configuration of your Ledger. The Configuration Sheet includes:
- Chart of accounts layout showing each segment’s details.
- Example period names.
- Valid balance types.
- Available currency codes.
- Valid actual flags.
- Budget names and encumbrance types.
- Definition of the segment values descriptive flexfield as configured in your system.
The information on the Configuration Sheet can be useful when constructing GL Wand functions. The period names will show you how the accounting period has been configured in Oracle e.g. the period names may be in the format:
- Apr-03.
- Or they might be April-03.
This is very important, because when you populate the Period parameter of the “Get Balance” function you must enter it in:
- The correct format.
- The correct case.
Otherwise GL Wand will not find the data you have requested. The Period Name function will return the period name in the correct format and can be used as an input into the Get Balance function. The budget and encumbrance names are also very useful, as these must also be entered in the correct case and with the correct spelling in order to successfully extract a budget or encumbrance balance.