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

SALDOCLASS(Account,CostC,Item,VlClass,Date,Currency,TypeBalance,WhichBalance)

It returns Balance of a Ledger Account + Cost Center + Accounting Item + Value Class (CTI) on date and currency informed.

Parameters

Account

Code of Ledger Account

CostC

Code of Cost Center

Item

Code of Accounting Item

VlClass

Code of Value Class

Date

Date in which balances are obtained.

Currency

Currency related to balances.

TypeBalance

Balance Type

WhichBalance

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:

SALDOCLASS("41101","1010", "100","10","12/31/04","01", "1",1)

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