Create a Template
New Quick Start templates can be added by clicking the ‘Add New’ button on the ‘Manage Criteria Templates’ dialog in the ‘Other’ menu on the GL Wand toolbar. They can also be uploaded in bulk by using the Excel template provided in the Wands install zip file. This workbook includes tabs for each of the Quick Start Template Types and an SQL Query to load the values captured in the workbook.
Template Type
Select the appropriate Template Type from the list. Balance and Period Templates are used for the Inquiry Wizard and Report Wizard Columns are used in Report Wizard.
Criteria
Populate the relevant parameters on the Criteria tab to suit your requirement.
Tip: Both Template Name and Description are used when searching templates from the Quick Start Wizards. Ensure that both the Name and Description are detailed and contain words that users are likely to search for.
Period Template
Parameter | Description |
---|---|
Template Name | The Name assigned to the template. Visible in the selection lists of the Quick Start Wizards and included in searches in these lists. |
Template Description | A description of what the template relates to in more detail than the name. Visible in the selection lists of the Quick Start Wizards and included in searches in these lists. |
Fiscal Year & Fiscal Year Type | The value in the Fiscal Year can use one of two approaches depending on the Fiscal Year Type Field:
|
Accounting Period & Accounting Period Type | The value in the Accounting Period can use one of two approaches depending on the Accounting Period Type Field:
|
Balance Type | Used in conjunction with the Accounting Period and Fiscal Year to determine the period of time to include in the Balance returned.
|
Sharing | Allows templates to be shared with all GL Wand users on the system (PUBLIC) or only available and visible to the user who loaded the template.
Note: System Administrators will be able to view, edit and delete Private templates of all users. |
Balance Template
Parameter | Description |
---|---|
Template Name | The Name assigned to the template. Visible in the selection lists of the Quick Start Wizards and included in searches in these lists. |
Template Description | A description of what the template relates to in more detail than the name. Visible in the selection lists of the Quick Start Wizards and included in searches in these lists. |
Business Unit | The Business Unit or Business Unit Tree Node as configured in PeopleSoft. The available Business Unit Trees will be displayed in this selection. To change the Business Units available to select, use the Change Business Unit function in the GL Wand toolbar.
Note:
If your Business Units do not meet these criteria, you can build separate templates and add them in different columns and Sum them using Excel functions The Configuration Sheet function available in version 1.2.6 will provide useful information to assess which Business Units can be used concurrently. |
Ledger | The Ledger as configured in PeopleSoft. The list of ledgers available for selection will be limited to those linked to the value selected in the Business Unit field. |
Currency Type & Currency Code | Currency Type: Enter BASE or TRN all in upper case.Currency Code: The currency code as configured in PeopleSoft all in upper case e.g. “USD”.
Examples:
Where BASE is used along with multiple Business Units, the defined Ledger must share the same Base Currency. |
ChartFields | The ChartField values as configured in PeopleSoft. Enter the ChartField value here. You must enter it as a text value including any leading zeros e.g. enter ChartField value “10” as “0010” if this ChartField is configured as four characters with leading zeros in PeopleSoft. You may enter your ChartField values in a variety of flexible ways including Tree Nodes, ChartField values, ranges, wildcards, excludes etc. To include all values simply enter “%”.
When creating Get Balance formulas always use “%” to denote all values as this allows more efficient SQL to be generated. Do not use a range like “000-ZZZ” as they will require unnecessary processing. The segment value parameters can be entered as:
The GetBalance will only show the ChartFields that are set as active in PeopleSoft. The wizard will only show the ChartField values for the selected Business Unit and Ledger. |
Budget Period | Optionally, enter the Budget Period as configured in PeopleSoft. This field will only become available when selecting a budget ledger. |
Scenario | The scenario as configured in PeopleSoft. This field will only become available when selecting a budget ledger. |
Multiply | Use this parameter to switch the sign of the balance by multiplying by -1. Also useful to show the number in a factor e.g. thousands by multiplying by 0.001.
Note: Using this parameter, rather than equivalent Excel functionality, ensures that when the Get Balance function is returning a message, this message will be displayed in the cell. For example, if you capture your Get Balance function as =GLW_PSFT_Get_Balance(…) * -1 and the Get Balance result is Error (Period) due to an invalid period being entered, the cell will display #VALUE. If you use this parameter to multiply the balance by -1, the cell will return the Error (Period) message. |
Decimal Places | Round the balance to the specified number of decimal places. Useful to use in conjunction with the Multiply parameter to show the number in a factor e.g. thousands by multiplying by 0.001 and then round to zero decimals. See the Multiply parameter for an explanation of why it is recommended to use this parameter rather than Excel functionality to round the balance. |
Sharing | Allows templates to be shared with all GL Wand users on the system (PUBLIC) or only available and visible to the user who loaded the template.
Note: System Administrators will be able to view, edit and delete Private templates of all users. |
Report Wizard Column Template
Parameter | Description |
---|---|
Template Name | The Name assigned to the template. Visible in the selection lists of the Quick Start Wizards and included in searches in these lists. |
Template Description | A description of what the template relates to in more detail than the name. Visible in the selection lists of the Quick Start Wizards and included in searches in these lists. |
Balance Type | Used in conjunction with the Accounting Period and Fiscal Year to determine the period of time to include in the Balance returned.
|
Fiscal Year & Fiscal Year Type | The value in the Fiscal Year can use one of two approaches depending on the Fiscal Year Type Field:
|
Accounting Period & Accounting Period Type | The value in the Accounting Period can use one of two approaches depending on the Accounting Period Type Field:
|
Ledger | The Ledger as configured in PeopleSoft. The list of ledgers available for selection will be limited to those linked to the value selected in the Business Unit field. |
Currency Type & Currency Code | Currency Type: Enter BASE or TRN all in upper case. Currency Code: The currency code as configured in PeopleSoft all in upper case e.g. “USD”.
Examples:
Where BASE is used along with multiple Business Units, the defined Ledger must share the same Base Currency. |
Sharing | Allows templates to be shared with all GL Wand users on the system (PUBLIC) or only available and visible to the user who loaded the template.
Note: System Administrators will be able to view, edit and delete Private templates of all users. |