How to include department description in spreadsheet

Entry Type: Informational

Product: Sage BusinessWorks Accounting

Application: F9

Version Reported: 4.1

Subject:

How to include department description in spreadsheet.

Possible Resolution:

Use the SDESC() parameter supplied by F9 to get the description of multi-segment account numbers. The account specifier must have more than one segment and must not include a complete account specifier. Sage BusinessWorks Accounting uses SDESC() for one segment, not both.

The following is an example of using the SDESC() parameter to get the description of the department:

SDESC(Account, section) or  SDESC("A1", 2)  where A1 is a cell that contains an account number with the department. The 2 returns the description of the second segment or the department portion of the account.

See also how to use F9 with BusinessWorks.