FRTRN

Sage ERP Accpac General Ledger 6.0

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:

 

A

for actual account set

Q

for quantities

QA

for actual quantities

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

This statement

Returns this

FRTRN("NETLQ","1000")

Net transactions for the last quarter for account 1000.

FRTRN("NET#P","1000")

Net transactions for inquired period for account 1000.

FRTRN("NETQTD","1000")

Net transactions for the quarter to date for account 1000.

See also