FR Function

Sage 300 ERP

Home > Financial Reporter > Designing Financial Statements > Financial Reporter Functions > FR Function

FR Function

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"

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:

G/L Options fields

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

Runtime parameters and print options

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