Vous êtes ici: Help Topics > Customization > Calculation > CLASS Function

CLASS Function

The CLASS function links a ratio class balance from the accounting database to a cell in CaseView. Ratio class balances can be added together or one account subtracted from another. CaseView's linkage worksheet is the quickest way to link ratio class balances using the CLASS function. The exact syntax will be added automatically using the linkage worksheet.

Syntax

CLASS("Value","ratio class")

Where

The Value is the type of balance.

The ratio class represents the abbreviation for the ratio class referenced to accounts in the Working Trial Balance. The following table describes the available ratio classes and their descriptions:

Class	Description
TR	Assets - Current - trade receivable
QA	Assets - Current - other quick
IN	Assets - Current - inventory
CA	Assets - Current – other
FD	Assets - Capital - amortized cost
FN	Assets - Capital non-amortized cost
FA	Assets - Capital - accumulated amortization
IA	Assets - Capital asset
OA	Assets - Other asset
TP	Liabilities - Current - trade payable
CL	Liabilities - Current - other
LL	Liabilities - Long term
DI	Equity – Dividend
RE	Equity - Retained earnings
EQ	Equity – Other
SA	Revenue - Credit sales
SO	Revenue - Other sales
RO	Revenue – Other
CD	Expense - cost of sales - amortization
CN	Expense - cost of sales - non-cash
CI	Expense - cost of sales - interest
PU	Expense - cost of sales - purchase
CR	Expense - cost of sales - repair and maintenance
CS	Expense - cost of sales - other cost of sales
OD	Expenses - other - amortization
ON	Expenses - other - non-cash
IT	Expenses - other - income tax expense
OI	Expenses - other - interest
OR	Expenses - other - repairs and maintenance
OE	Expenses - other - other expenses

Example

CLASS("BA","CL")

Returns the current year to date balance plus normal adjustments of all accounts referenced to the Current Liabilities ratio.

Note

In the Report tab, the print column is used to restrict the conditions under which the balance of an account can print or display. For example, selecting credit allows the account to print only if it is in a credit balance. When displaying balances, the CLASS function uses these options set in the report tab to determine whether to include or exclude a balance in the total calculation.

CLASS Function

Cookie Notice