• Linkage Functions
  • ACT Function
  • BALDESC Function
  • CLASS Function
  • CLASSDESC Function
  • CURLANG Function
  • CVEXCEL Function
  • DESC Function
  • DMDESC Function
  • DOCNUM Function
  • ENTABBR Function
  • ENTCLP Function
  • ENTDESC Function
  • Entity Function
  • GRP Function
  • GRPDESC Function
  • GRPENT Function
  • ISINGRP Function
  • Linkage Functions
  • LS Function
  • LSDESC Function
  • M3TAX Function
  • MAP Function
  • MAPDESC Function
  • MASK Function
  • NUMTOTDID Function
  • RATE Function
  • RAWENT Function
  • TAX Function
  • TDIDTONUM 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.

Related Topics

• Linkage Functions