FR Function

Learn more

Sample Financial Statements

FR Menu Commands

This function can retrieve G/L Option, company, and fiscal calendar data; runtime parameter values; and statement print options.

Syntax

FR(option, formatted)

Arguments

Argument Description
option The name of a field from the Company Profile, Fiscal Calendar, or G/L Options screens; or a specified runtime parameter or print option.
formatted (Optional)

Indicates whether the return value should be formatted according to the presentation defined in the view. If omitted, the default is "Formatted." Use one of the following constructs:

  • "FORMATTED", "F", or "FMT"
  • "UNFORMATTED", "U", or "UNFMT"

Option can be one of the following:

Field name Description
Orgid 6-character database ID for the company (for example, SAMINC)
Coname Company name
Address1 First address line
Address2 Second address line
Address3 Third address line
Address4 Fourth address line
City City
Province Province
State State
Zip Zip code
Postal Postal code
Country Country
Phone Telephone number
Fax Fax number
Contact Ledger contact name
FuncCurr Ledger functional currency
RPCurr Reporting currency code, when the Euro is the functional currency
RPACCT Rounding account defined in G/L Options for the reporting currency, when the Euro is the functional currency

Name

Contents of the field

SessionDate

 Date entered at signon
Year

Fiscal year
Period Fiscal period number
Start Period start date
End Period end date
QStart Quarter start date
QEnd Quarter end date
ReportType
  • If unformatted, returns "1" for actual, "2" for provisional report
  • If formatted, returns "Actual" or "Provisional"
ReportAs
  • If unformatted, returns "1" for consolidated, "2" for separate
  • If formatted, returns "Consolidated" or "Separate"
SortBy
  • If unformatted, returns "1" for Account ID, "2" for Segment ID, "3" for Account Sorted Group
  • If formatted, returns "AccountID," “SegmentID," or "Account Sorted Group"
SortByAcSeg
  • If unformatted, returns the number of the segment by which you are sorting
  • If formatted, returns the name of the segment by which you are sorting
From AcctID Starting Account ID in the print range
To AcctID Ending Account ID in the print range
From AcctGroup Starting Account Group in the print range
To AcctGroup Ending Account Group in the print range
AcSegNamen Name of the nth account segment (for example, Division or Department)
AcSegReportAsn If ReportAs = 2 (separate), this is the consolidation setting of the nth segment
FromAcSegn Starting value of the nth segment in the print range
ToAcSegn 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 "ReportAs" = 2 (separate).
Acctgroupsort Sorting by Account Sorted Group
Acctgroup Sorting by Account Group

Examples

Statement Return Value
=FR("Coname") The Garden Inc.
=FR("End") 4/30/02