GRPDESC Function
The GRPDESC function links a group number description from the accounting database in Working Papers to an alphanumeric cell in CaseView. To link a group number description automatically, create a new alphanumeric cell (the description being linked is alphanumeric) and enter the calculation.
Working Papers provides 4 custom groupings, which can be used to group accounts on leadsheets or grouping schedules. Each account can be assigned to one group number from each grouping. Grouping 1 (L/S) contains leadsheet numbers, Grouping 2 contains group numbers, Grouping 3 contains another set of group numbers, and Grouping 4 contains a final set of group numbers.
Syntax
GRPDESC(Group,"Group Number",<argument>, <language identifier>)
Where
Group represents the custom grouping, which can be 1 (L/S), 2 (Grouping 2), 3 (Grouping 3), 4 (Grouping 4).
Group Number represents the leadsheet or group number from the custom grouping (A, AA, B, etc.).
The argument is optional and controls the type of description that appears in the cell.
| Value | Description |
|---|---|
|
0 |
Returns the Group Name. |
|
1 |
Returns the Extended Description from the Working Trial Balance Groupings tab. |
|
2 |
Returns the Extended Description from the Working Trial Balance Groupings tab. If no Extended Description is present, the Report Heading will appear in the cell. |
|
3 |
Returns the Extended Description from the Working Trial Balance Groupings tab. |
|
4 |
Returns the Extended Description from the Working Trial Balance Groupings tab. If no Extended Description is present, the Report Heading will appear in the cell. |
If you do not provide an argument, CaseView returns the group number Name to the cell.
Example 1
GRPDESC("2","5000")
Returns the Name of group number 5000 from grouping 2. If group number 5000 has the Name Bank Balance, the words Bank Balance will appear in the cell.
Example 2
GRPDESC("2","5000","0","FRE")
In Working Papers, under Tools | Options | Languages, it is possible to specify multiple global languages. Please refer to the Working Papers help for more information on multiple language support.
Each language will have an applicable Identifier which can be used to draw group names and extended descriptions into CaseView. This example would link to the French version of group 5000's name.
Notes
- Line breaks in the extended description are preserved when linking in CaseView.
