...
To use this function through Excel, use the SIGA function, in accordance with the TDN link:
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. |
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 |
CTSMMOV(\"01/01/2004\",\"31/12/04\",\"01\",\"1\",3,\"41101\",\"41110\",\"1000\",\"2000\",\"100\",\"200\",\"10\",\"20\")
...