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

 

This statement	Returns this
FRPOST("TRANSAMT", "1000","(POSTINGSEQ = 100)","U")	Retrieves unformatted transaction amounts for Account 1000 that have a posting sequence number of 100.
FRPOST("TRANSAMT", "1000","(JRNLDATE = 20100110)","U")	Retrieves the unformatted transaction amount from Account 1000 from January 10, 2010.
FRPOST("ACCTDESC","1000")	Retrieves the account description from Account 1000.
FRPOST("T.QTY","4000")	Retrieves the transaction optional value for QTY for Account 4000 for the inquired period.

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:

 

 

Field Name	Meaning
FISCALYR	Fiscal Year
FISCALPERD	Fiscal Period
SRCECURN	Source Currency Code
SRCELEDGER	Source Ledger Code
SRCETYPE	Source Type Code
POSTINGSEQ	Posting Sequence Number
CNTDETAIL	Detail Count
JRNLDATE	Journal Date
BATCHNBR	Batch Number
ENTRYNBR	Journal Entry Number
TRANSNBR	Journal Transaction. Number
CONSOLIDAT	Consolidation Occurred on Post
JNLDTLDESC	Journal Detail Description
JNLDTLREF	Journal Detail Reference
TRANSAMT	Journal Transaction Amount (functional amount)
TRANSQTY	Journal Transaction Quantity
SCURNAMT	Journal Source Amount
RATETYPE	Currency Rate Table Type
RATEDATE	Date of Currency Rate Selected
CONVRATE	Currency Rate for Conversion
RATEOPER	Currency Rate Operator
RPTAMT	Report Currency Amount

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