Using Formulas to Specify General Ledger Information in Columns and Cells

You gain access to account data -- and all other data in the General Ledger -- with Financial Reporter functions.

The Financial Reporter functions are:

Financial Reporter functions	Information they provide
FR	G/L option & company data, and statement print options
FRACCT	account data
FRAMTFRDEBIT , FRCREDIT ,FRAMTA ,	fiscal set data
FRFISCAL	fiscal calendar dates
FRRATE	exchange rates
FRSDESC	segment code descriptions
FRTRN	net totals and net quantities from transaction history
FRTRNA	net amounts and net quantities from posted transactions for a specified period
FRTRNCR	net credit totals and net quantities from transactions
FRTRNDR	net debit totals and net quantities from transactions
FRPOST	account and transaction records, including optional fields from posted transactions

Because you can use them in conjunction with other spreadsheet functions, Financial Reporter functions provide a very powerful way of getting data out of the general ledger and placing them in a report.

You use Financial Reporter functions in two main ways:

• To place one piece of information in one particular cell of a report.

• In a default row (or single row) of a report specification to define the information that will appear in each column of a financial report.

Use FR Paste to create formulas

Each of the above functions can be pasted into a financial statement using the FR Paste command on the FR menu bar in Financial Statement Designer.

The FR Paste command inserts a function into the current cell, and prompts you for each parameter of the function (so you don't have to memorize them). See FR Paste.

For a detailed description of each function used by Financial Reporter, see FR Functions.

See also

 

FR Paste

Sample Column Specifications

Setting Default Column Specifications

Specifying Columns

Specifying Information for a Single Cell