CTSMENTMOV(Code_From,Code_To,Date From,Date To,Currency,TypeBalance,WhichBalance,Entity)
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."
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas