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

Versões comparadas

Chave

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

CTSMMOV(Date From, Date To, Currency,TypeBalance,WhichBalance, Account From, Account To, Cost Center From, Cost Center To, Accounting Item From, Accounting Item To, Value Class From, Value Class To)

It returns the sum of transactions of an interval and/or set of entities (Account and/or Cost Center and/or Accounting Item and/or Value Class) in a given interval of dates, with free combination of entities. You can inform the interval of one of the entities (likewise in function CtSmEntMov) or even combine, freely, more than one entity to obtain the transaction in a date interval.

Parameters

Date From

Initial date from which transactions balances are obtained.

Date To

Code of final entity from which balances are obtained.

Currency

Currency in which balances are obtained.

Type of Balance

Balance Type

Which Balance

Return estimated (refer to table Return below).

Account From

Code of initial Ledger Account to be considered.

Account To

Code of final Ledger Account to be considered.

Cost Center From

Code of initial Cost Center to be considered.

Cost Center To

Code of final Cost Center to be considered.

Accounting Item From

Code of initial Accounting Item to be considered.

Accounting Item To

Code of final Accounting Item to be considered.

Value Class From

Code of initial Value Class to be considered.

Value Class To

Code of final Value Class to be considered.


Return

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

1

Debit transaction

2

Credit transaction

3

Transaction of the period (with sign)

4

Final Balance

 Example:

CTSMMOV("1/1/04","12/31/04","01","1",3,"41101","41110","1000","2000","100","200","10","20")

It returns sum of performed transactions (Balance Type = 1) of ledger accounts (interval: "41101" to "41110"), cost centers (interval: "1000" to "2000"), accounting items (interval: "100" to "200") and value classes (interval: "10" to "20"), currency "01," in period from "1/1/04" to "12/31/04."