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 |
Information they provide |
|
G/L option & company data, and statement print options |
|
|
account data |
|
|
fiscal set data |
|
|
fiscal calendar dates |
|
|
exchange rates |
|
|
segment code descriptions |
|
|
net totals and net quantities from transaction history |
|
|
net amounts and net quantities from posted transactions for a specified period |
|
|
net credit totals and net quantities from transactions |
|
|
net debit totals and net quantities from transactions |
|
|
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