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

MOVCLASS(Account,CostC,Item,VlClass,Date_From,Date_To,Currency,TypeBalance,WhichBalance)

It returns Transaction of a Ledger Account + Cost Center + Accounting Item + Value Class (CTI) for dates and currencies informed.

Parameters

Account

Code of Ledger Account

CostC

Cost Center

Item

Accounting Item

VlClass

Value Class

Date_From

Initial date in which transaction value is obtained.

Date_To

Initial date in which transaction value is obtained.

Currency

Initial date in which transaction value is obtained.

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

Period Transactions

4

Final balance in period informed


Example:

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

It returns transaction performed (Type of Balance = 1) in ledger account "41101," cost center "1010," accounting item "100," and value class "10," in period from "1/1/04" to "12/31/04," currency "01."