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

Versões comparadas

Chave

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

CTSMITEM(Items,Date,Currency,TypeBalance,WhichBalance,Synt)

It returns balance of an Accounting Item group for date and currency informed.

Parameters

Items

Code of Accounting Items separated by comma "," or colon ":".

Date

Date in which you want balances.

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 or Accounting Items, use colon ":" and to indicate a new Accounting Item, use comma ",".


Example:

CTSMITEM("0001:0200.2000,3001","6/5/04","01","1",1.0)

...