It returns balance of an entity group, in a given date.
To use this function through Excel, use the SIGA function, in accordance with the TDN link:
Code_From | Code of initial Entity from which balances are obtained. |
Code_To | Code of final Entity from which balances are obtained. |
Date | Date in which balances are obtained. |
Currency | Currency in which balances are obtained. |
TypeBalance | Balance Type |
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 | Current balance (with sign) |
2 | Debit on date (transaction) |
3 | Credit on date (transaction) |
4 | Current debt balance |
5 | Current credit balance |
6 | Previous balance (with sign) |
7 | Previous debt balance |
8 | Previous credit balance |
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. |
CTSMSALDOS(\"0001\",\"3001\",\"6/5/2004\",\"01\",\"1\",\"CTT\")
It returns sum of performed balances (Balance Type = 1) of cost centers from interval \"0001\" to \"3001\", currency \"01\", on date \"6/5/04\".
Example of use in Excel:
=Siga("CTSMENTMOV";"1320101";"1320101";"01/01/2015";"31/12/2022";"01";"1";1;"CTT")