ACT Function

The ACT function returns the current account balance for the specified account. Account numbers can be added together or one account subtracted from another. CaseView's linkage worksheet is the quickest way to link accounts using the ACT function. The exact syntax will be added automatically using the linkage worksheet.

Syntax

ACT(<"sign">,"Value" "Account Number")

The sign is optional and defaults 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 an account as a positive balance.

D

Returns the debit balance for an account.

CO (Credit only)

Functions as an accumulator of all credit balances for an account.

DO (Debit only)

Functions as an accumulator of all debit balances for an account.

More information on the Value property may be found here.

Example 1

ACT("D","BA","102")

Returns the debit current year to date balance for account number 102.

Example 2

The example below deals with calculating the prior year net book value of fixed assets in the financial statements. Assume that account 143 is accumulated depreciation and that 142 is the cost. The calculation below subtracts the accumulated depreciation from the cost for the prior year:

ACT("BA:YR1","142")-ACT("BA:YR1","143")

Example 3

ACT("BR","500")

Returns the actual year to date report balance for account 500.

Example 4

ACT("BR:YR1,"200")

Returns the prior year to date report balance for account 200.

Example 5

The following example uses a wildcard in the form of the question mark (?) to link multiple group numbers using the specified number format.

ACT("BR","23??")

Returns the total current year-to-date report balance for all accounts which are four digits long and begin with 23.

Example 6

The ACT function may also make use of an optional value parameter to ensure the account's sign property is honored (the opposite of the RAW value parameter).

ACT("BC:PAR:USESIGN","299")

Returns the consolidated parent-level balance with the correct sign for account 299.

Related Topics