Child pages
  • MOVCONTA (Worksheet Functions - SIGACTB)

MOVCONTA(Account,Date_From,Date_To,Currency,TypeBalance,WhichBalance)

It returns Balance of a Ledger Account (CT7) for date and currency informed.

Parameters

Account

Code of Ledger Account

Date_From

Initial date in which transaction value is obtained.

Date_To

Initial date in which transaction value is obtained.

Currency

Currency referring to transaction value.

TypeBalance

Balance type in which transaction value is obtained.

WhichBalance

Return estimated (refer to following table)


Return

When passing parameters, indicate which return you want by using one of the following numbers:

1

Debt Transaction

2

Credit Transaction

3

Month Transaction


Example:

MOVCONTA("41101","1/1/04","12/31/04","01","1",3)

It returns transaction performed (Type of Balance = 1) in ledger account "41101," in period from "1/1/04" to "12/31/04," currency "01."