FRTRN

The FRTRN command retrieves net amounts and net quantities from posted transactions for the period that you specify. FRTRN provides net amounts only, it does not calculate balances or include provisionally posted transactions.

FRTRN formulas are similar to FRAMT, but FRTRN retrieves totals from transaction history, whereas FRAMT retrieves totals from account history.

Syntax

FRTRN(field name, account reference, criteria, currency)

Description

The FRTRN function provides data from transaction detail records.

Arguments

field name

The name of a field from the General Ledger with an optional fiscal designator prefix and optional year suffix.

Fiscal designator prefixes are restricted to:

account reference

A string specifying a single account or a range of accounts. (See Specifying Account Numbers.)

criteria

A string containing an expression that imposes selection criteria on the accounts and on transaction fields (for example, optional fields). The account reference and expression together determine the accounts that will be included in the calculation. See Using Selection Criteria.

currency

A string containing the currency reference. A currency reference is on the form "CCC.T," where CCC is the currency code, and T is "S" for source currency, "E" is the functional equivalent of the source amount, and "F" is the functional currency total. (Note: For reporting currency, the currency reference is simply "CCC," without an extension.)

Result

Retrieves net totals, actual values (not provisional values), and summary totals (by both account and transaction fields).

Examples

See also

FRAMT

FRTRNA

FRTRNCR

FRTRNDR