DESC Function
The DESC function returns the account description for the specified account. CaseView's linkage worksheet is the quickest way to link account descriptions using the DESC function. The exact syntax will be added automatically using the linkage worksheet.
Syntax
DESC(<account number>,<argument>,<language identifier>)
Where
The argument is optional and controls the type of description that appears in the cell.
Value | Description |
---|---|
0 |
Returns the account name as shown in the Working Trial Balance. |
1 |
Returns the Extended Description from the account properties. |
2 |
Returns the Extended Description from the account properties. If no Extended Description is present, the account name will appear in the cell. |
If you do not provide an argument, CaseView returns the account name as show in the Working Trial Balance.
Example 1
DESC("108")
Where 108 is the account number with a description of Accounts Receivable. Therefore, the cell with this function displays Accounts Receivable.
Example 2
DESC("101","0","FRE")
In Working Papers, under Tools | Options | Language, 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 account names and extended descriptions into CaseView. This example would link to the French version of the Account Name for account 101.
Notes
- Line breaks in the extended description are preserved when linking in CaseView.