FRPOST

The FRPOST function allows you to retrieve detail optional fields from G/L posted transactions and account optional field data for the account specified in the transaction record.

Details can be consolidated or not consolidated. That is, if the result of an FR command (that is, the FRACCT or FRPOST commands) is derived from more than one transaction, and if these results are from the Integer, Number, or Amount type optional fields, you can print a consolidated total that sums up all values from the retrieved optional fields or print the optional field value of the first retrieved record that has optional field values. If you do not choose the option to consolidate (that is, when you clear the default checkmark from the “Consolidate Optional Field” option), the value of the first retrieved record will be printed.

• A consolidated total will be printed if the first parameter is not appended by anything, or is appended by [C].

• Only the first optional field value will be reported when the specified field name is appended with “[U].”  

Syntax

FRPOST(field name, account reference, criteria, formatted)

Arguments

fieldname

The name of a field from the G/L account view.

account reference

A string specifying the account number reference. This can be a single account or a range of accounts.

criteria

An expression that imposes selection criteria on the accounts. The account reference and expression together determine the accounts that will be included in the calculation.

formatted

Optional. Indicates that the return value should be formatted or unformatted. The default is "Formatted". If you leave the default, no indicator appears in the formula. If you clear the default, a "U" appears in the formula (for "unformatted").

Results

FRPOST returns data retrieved from transaction records, G/L account data from the account specified in the transaction record, transaction optional fields, as well as G/L account optional fields data from the account specified in the transaction record.

Examples

Note that the account number is usually set in Column A, and other criteria (such as the transaction date), is set in Column B. The above examples placed account numbers and transaction dates in the formula, but it is not a requirement.

The FR Post command includes all account record fields defined in FRACCT, including account optional fields, all transaction optional fields defined in G/L setup, plus the following transaction fields:

Account optional fields begin with the prefix A. (Add a period between the A and the field name, for example, A.ACCTCLASS.) Transaction optional fields begin with the prefix T. (Add a period between the T and the field name, for example, T.QUANTITY.)

See also

FRACCT