FR Paste
In the Statement Designer, FR Paste is on the FR Menu.
FR Paste lets you paste the following items into spreadsheet cells:
-
Account selection criteria (query-by-example expressions)
-
Rolled Up Amounts (for FRAMT, FRAMTA, FRCREDIT, FRDEBIT only)
|
G/L option & company data, and statement print options |
|
|
account data |
|
|
fiscal set data |
|
|
fiscal set data |
|
|
fiscal calendar dates |
|
|
exchange rates |
|
|
segment code descriptions |
|
|
retrieves G/L posted transaction and account optional fields details |
|
|
retrieves data from transaction details |
|
|
transaction data for stated fiscal period |
When you choose a function, FR Paste displays fields where you select all the function parameters. For the FRAMT, FRAMTA, FRDEBIT, FRCREDIT, FRTRN, FRTRNA, FRTRNCR, and FRTRNDR functions, this includes account numbers, account ranges, selection criteria and currency type. You can also include defined names as parameters.
If you choose account numbers, you can select individual account numbers, or choose a range of account numbers.
When you click the Selection Criteria button, FR Paste opens the form in which you can build an account selection criteria. A selection criteria expression applies a filter to a given account or account range. You would normally paste the expression into column B of a statement -- immediately to the right of the account number.
Using FR Paste
-
From the FR menu, select FR Paste.
-
In the FR Paste form, choose a function, account reference or expression from the Function list.
In the bottom left corner of the form, the function builds as you select options.
-
Select from a list of options for the function, account reference or expression you have chosen.
Refer to the functions individually for details about each of the option fields:
-
Go to the cell where you want to paste your currently-constructed function, account number, or expression, by pressing the Next Row, Prev Row, Next Column or Prev Column button. If you don’
t choose one of these buttons, the function, account number, or expression will be pasted into the cell listed in the bottom left corner of the form. -
Click Paste.
For details on using the Finder and on specifying record selection criteria, see the System Manager Online Help. The record selection dialog box is the same as the one used by the Finder.
Pasting Single Values and Default Column Specifications
These are typical single values you will paste in a Financial Report:
-
Company name
-
Period-end date (or today's date)
-
Division or department for which the report is printed
-
A single account balance
For each of the above items, you will paste a complete formula and will probably not have to edit the result.
Pasting Column Formulas
If you are pasting a formula to use as a default column specification, do not enter an account reference (because you will be supplying that in column A of each line that uses the default column specification).
For example, a single cell has a formula like this:
=FRAMT("BALP","1000")
But a default column formula looks like this:
=FRAMT("BALP").
See also