Child pages
  • MOVITEM (Worksheet Functions - SIGACTB)

MOVITEM(Account,CostC,Item,Date_From,Date_To,Currency,TypeBalance,WhichBalance)

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

Parameters

Account

Code of Ledger Account

CostC

Code of Cost Center

Item

Code of Accounting Item

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

Month Transaction

4

Final balance in period informed


Example:

MOVITEM("41101","1010","100","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," in period from "1/1/04" to "12/31/04," currency "01."