FR
Syntax
FR("option", formatted)
Description
The FR function provides information stored by the Common Services Company form, the Calendar form, and the G/L Options form.
Arguments
option
The name of a field from the Company Profile, a runtime parameter, or a print option (listed below).
formatted
Optional. Indicates that the return value should be formatted according to the presentation defined in the view. The default if omitted is formatted.
"FORMATTED", "F", or "FMT"
"UNFORMATTED", "U", or "UNFMT"
The Option can be one of the following:
General Ledger Options information
|
Name |
Contents of the field |
|
"Orgid" |
The 6-character organization ID (e.g. UNICO) |
|
"Coname" |
The company name. |
|
"Address1" |
The 1st address line. |
|
"Address2" |
The 2nd address line. |
|
"Address3" |
The 3rd address line. |
|
"Address4" |
The 4th address line. |
|
"City" |
The city. |
|
"Province" |
The province or state. |
|
"State" |
The province or state. |
|
"Zip" |
The zip code or postal code. |
|
"Postal" |
The zip code or postal code. |
|
"Country" |
The country. |
|
"Phone" |
The phone number. |
|
"Fax" |
The fax number. |
|
"Contact" |
The ledger contact name. |
|
"FuncCurr" |
The ledger functional currency. |
|
"RPCurr" |
The reporting currency code when the Euro is the functional currency. |
|
"RPACCT" |
The rounding account defined in G/L Options for the reporting currency when the Euro is the functional currency. |
Financial Reporter runtime fields
|
Name |
Contents of the field |
|
"SessionDate" |
The date entered at signon. |
|
"Year" |
The fiscal year. |
|
"Period" |
The fiscal period number. |
|
"Start" |
The period start date. |
|
"End" |
The period end date. |
|
"QStart" |
The quarter start date. |
|
"QEnd" |
The quarter end date. |
|
"ReportType" |
Unformatted: "1" for actual and "2" for provisional report. If formatted, it will return "Actual" or "Provisional". |
|
"ReportAs" |
Unformatted: "1" for consolidated, "2" for separate. If formatted, it will return "Consolidated" or "Separate". |
|
"SortBy" |
Unformatted: "1" for Account ID, "2" for Segment ID, "3" for Account Group. If formatted, it will return "AccountID," “SegmentID," or "Account Group." |
|
"SortByAcSeg" |
The number of the segment (unformatted) or the name of the segment (formatted) by which you are sorting. |
|
"From AcctID" |
The starting AcctId in the print range. |
|
"To AcctID" |
The ending AcctId in the print range. |
|
"From AcctGroup" |
The starting AcctGroup in the print range. |
|
"To AcctGroup" |
The ending AcctGroup in the print range. |
|
"AcSegNamen" |
The name of the nth acct segment (e.g. Division or Dept.) |
|
"AcSegReportAsn" |
If ReportAs = 2 (separate), this is the consolidation setting of the nth segment. |
|
"FromAcSegn" |
The starting value of the nth segment in the print range. |
|
"ToAcSegn" |
The ending value of the nth segment in the print range. |
|
"CurAcSegValn" |
The current value of the segment for the current report. This value is only appropriate when the report type is separate (AcSegReportAsn = 2). |
|
"Acctgroupsort" |
Sorting by account-sorted group. |
|
"acctgroup" |
Sorting by account group. |
Examples
|
This statement |
Returns this |
|
=FR("CONAME") |
The Garden Inc. |
|
=FR("END") |
4/30/02 |
Date formats
The date formats in some versions of Excel are set to jj/mmm/aa instead of dd/mmm/yy if you choose Canada[English] for the country setting in the Windows Control Panel. If you have problems with dates in your statements, choose the International icon from the Control Panel, and select US or Other Country instead of Canada.
See also