LS Function

The LS function links a leadsheet balance from the accounting database. CaseView's linkage worksheet is the quickest way to link leadsheet balances using the LS function. The exact syntax will be added automatically using the linkage worksheet.

Syntax

LS(<"sign">,"Value","Leadsheet")

Where

The Sign is optional and is set by default to debit if not supplied. Refer to the following chart for information on the sign parameter.

Sign What it does

C

Returns the credit balance for a leadsheet as a positive balance.

D

Returns the debit balance for a leadsheet.

CO (Credit only)

Functions as an accumulator of all credit balances for a leadsheet.

DO (Debit only)

Functions as an accumulator of all debit balances for a leadsheet.

Example 1

LS("D","BA:YR0","A")

Returns the debit current year to date adjusted balance for leadsheet A.

Example 2

The following example uses a wildcard in the form of a question mark (?) to link multiple leadsheets with similar numbers.

LS("D","BA:YR0","10.??")

Returns year to date leadsheet adjusted balances using the number format of 10.??. The wildcard locates both numbers and letters. This function links balances from leadsheets 10.01, 10.02, 10.03 and so on.

Example 3

There is support for the balance identifier "SUB". Using this includes the children of a leadsheet in a total.

LS("BA:SUB", "A") returns the final balance for leadsheets A, A.10, A.20,….

Related Topics