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

SALDOCCUS(Account,CostC,Date,Currency,TypeBalance,WhichBalance)

It returns Balance of a Ledger Account + Cost Center (CT3) on dates and currencies informed.

Parameters

Account

Code of Ledger Account

CostC

Code of Cost Center

Date

Date in which balances 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:

SALDOCCUS("41101","1010","12/31/04","01", "1",1)

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