It returns balance of an entity group, in a given date.
Parameters
Code_From | Initial entity code to obtain balances. |
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) |
Return
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 |
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:
CTSMSALDOS("0001","3001","6/5/04","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."
