CTSMCUSTO(CostC,Date,Currency,TypeBalance,WhichBalance,Synt)
It returns balance of a Cost Center group on date and currency informed.
Parameters
CostC | Code of Cost Centers, separated by comma "," or colon ":". |
Date | Date in which balances are obtained. |
Currency | Date in which balances are obtained. |
TypeBalance | Balance Type |
WhichBalance | Return estimated (refer to following table) |
Synt | Indication of summarized or detailed |
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 |
In order to indicate an interval of Cost Centers, use colon ":" and to indicate a new Cost Center, use comma ",". |
Example:
CTSMCUSTO("0001:0200,2000,3001","6/5/04","01","1",1.0)
It returns sum of performed balances (Balance Type = 1) of all cost centers from interval "0001" to "0200" and only cost centers "2000" and "3001", currency "01", on date "6/5/04", current balance (with sign) with detailed balance.
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas