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."
