Páginas filhas
  • CTSMCONTA (Worksheet Functions - SIGACTB)

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

CTSMCONTA(Accounts,Date,Currency,TypeBalance,WhichBalance,Synt)

It returns balance of a Ledger Account group for date and currency informed.

Parameters

Accounts

Code of Ledger Accounts 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

Image ModifiedImportant:

In order to indicate an interval of Accounts, use colon ":" and to indicate a new Account, use comma ",".


Example:

CTSMCONTA("11101:12101,2101,31101","6/5/04","01","1",1.0)

...