Páginas filhas
  • SALDOCONTA (Worksheet Functions - SIGACTB)

SALDOCONTA(Account,Date,Currency,TypeBalance,WhichBalance)

It returns balance from a Ledger Account (CT7) for date and currency informed.

Parameters

Account

Code of Ledger Account

Date

Date in which balance are obtained.

Currency

Currency related to balances.

Type of Balance

Balance Type

Which Balance

Return estimated (refer to following table)

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

Example:

SALDOCONTA("41101","12/31/04","01","1",1)

It return current balance performed (Type of Balance = 1) of ledger account "41101," currency "01," on "12/31/04."