It returns balance of a Ledger Account group for date and currency informed.
Accounts | Code of Ledger Accounts separated by comma "," or colon ":". |
Date | Date in which balances are obtained |
Currency | Currency in which balances are obtained |
TypeBalance | Balance Type |
WhichBalance | Return estimated (refer to following table) |
Sint | Indication of summarized or detailed |
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 |
Informações | ||
---|---|---|
| ||
In order to indicate an interval of Accounts, use colon \":\" and to indicate a new Account, use comma \",\". |
Example:
CTSMCONTA(\"11101:12101,2101,31101\",\"6/5/2004\",\"01\",\"1\",1,0)
It returns the sum of performed balances (Balance Type = 1) of all ledger accounts of range from \"11101\" to \"12101\" and only accounts \"2101\" and \"31101\", currency \"01\", on date \"6/5/04\", current balance (with sign) and with detailed balance.