Child pages
  • CTSMCLVL (Worksheet Functions - SIGACTB)

CTSMCLVL(ClVlS,Date,Currency,TypeBalance,WhichBalance,Synt)

It returns balance of a group of Value Classes for date and currency informed.

Parameters

ClVls

Code of Value Classes separated by comma "," or colon ":".

Date

Date in which balances are obtained.

Currency

Date in which balances are obtained.

TypeBalance

Balance Type

WhichBalance

Return estimated (refer to following table)

Synt

Indication of summarized or detailed


Return

When passing parameters, indicate which return you want by using one of the following numbers:

1

Current balance (with sign)

2

Debit on date (transaction)

3

Credit on date (transaction)

4

Current debt balance

5

Current credit balance

6

Previous balance (with sign)

7

Previous debt balance

8

Previous credit balance

Important:

In order to indicate an interval of Value Classes, use ":" and to indicate a new Value Class use ",".


 Example:

CTSMCLVL("0001:0200,2000,3001","6/5/04","01","1",1.0)

It returns sum of performed balances (Balance Type = 1) of all value classes from interval "0001" to "0200" and only value classes "2000" and "3001", in currency "01", on date "6/5/04", current balance (with sign), with detailed balance.