...
To use this function through Excel, use the SIGA function, in accordance with the TDN link:
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) |
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 |
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. |
CTSMENTMOV(\"0001\",\"3001\",\"01/01/2004\",\"12/31/04\",\"01\",\"1\",\"CTT\")
...