It returns the sum of transactions in code interval of one of the entities (Account, Cost Center, Accounting Item or Value Class) and an interval of dates.
Parameters
Code_From | Code of initial entity through which transactions are obtained. |
Code_To | Code of final entity through which transactions are obtained. |
Initial Date | Initial date from which transactions are obtained. |
Final Date | Final date from which transactions are obtained. |
Currency | Currency in which transactions are obtained. |
TypeBalance | Balance type in which transactions are obtained. |
WhichBalance | Return estimated (refer to table Return below) |
Entity | Entity to be calculated (refer to table Entities below) |
Return
When passing parameters, indicate which return you want by using one of the following numbers:
1 | Previous balance |
2 | Final Balance |
3 | Transaction in the Period |
Entities
When passing parameters, indicate which entity you want by using one of the strings below:
CT1 | Entity to be calculated is Ledger Accounts. |
CTT | Entity to be calculated is Cost Centers. |
CTD | Entity to be calculated is Ledger Accounts. |
CTH | Entity to be calculated is Value Classes. |
Example:
CTSMENTMOV("0001","3001","1/1/04","12/31/04","01","1","CTT")
It returns sum of performed transactions (Balance Type = 1) of cost centers of range from "0001" to "3001", currency "01," date between "1/1/04" and "12/31/04."
