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.
To use this function through Excel, use the SIGA function, in accordance with the TDN link:
Parameters
Code_From | Code of initial entity through which transactions are obtained. |
Code_To | Code of final entity through which transactions are obtained. |
Start Date | Initial date from which transactions are obtained. |
End 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 | The calculation entity is the Ledger Accounts. |
CTT | The calculation entity is the Cost Centers. |
CTD | The calculation entity is the Ledger Items. |
CTH | The calculation entity is the Value Classes. |
Example:
CTSMENTMOV(\"0001\",\"3001\",\"01/01/2004\",\"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\".
Example of use in Excel:
=Siga("CTSMENTMOV";"1320101";"1320101";"01/01/2015";"12/31/2022";"01";"1";1;"CTT")
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas