Fiscal Set Field Names

The following chart provides the names of all balance and net change fields that you can print with the Financial Reporter.

After the chart of field names are two small charts listing the fiscal set prefixes and fiscal year suffixes that can be added to the field names.

Note in the following codes that n is a number that can refer to the fiscal period (from 1 to 13) or to the quarter (from 1 to 4).

In addition, you can print year-end adjustments and transactions to close income accounts to retained earnings with NETADJ and print closing figures with NETCLOSE and BALCLOSE.

Prefixes to NET and BAL indicate the fiscal set (for example, "QNETP")

NET and BAL can have a prefix A, P, Q, QA, QP, 1*, 2*, 3*, 4 or 5 to indicate actual, provisional, quantity, quantity actual, quantity provisional, or any of the five budget sets. (*Budget sets 1 and 2 are only available in Sage ERP Accpac 100, while budget sets 1, 2, and 3 are available in Sage ERP Accpac 200. Budget sets 4 and 5 only apply to Sage ERP Accpac 500.)

If no prefix is specified, the default is either actual or provisional depending on the type of the report. Similarly, "Q" by itself is either actual or provisional quantities depending on the type of report.

For example, "BALP" provides the actual or provisional balance at the current fiscal period "ABALP" always provides the actual balance; and "1BALP" provides the balance from budget set 1 for the current fiscal period.

Field description	Reporter code suffix	BAL (balance)	NET (net changes)
Period balance and net change
Current period	P	BALP*	NETP*
Last period	LP	BALLP	NETLP
nth period	nP	BALnP	NETnP
n periods ago	nPA	BALnPA	NETnPA
Quarter balance and net change
Current quarter (to end)	Q	BALQ	NETQ
Current quarter to date	QTD	BALQTD	NETQTD
Last quarter	LQ	BALLQ	NETLQ
Last quarter to date	LQTD	BALLQTD	NETLQTD
nth quarter	nQ	BALnQ	NETnQ
nth quarter to date*	nQTD	BALnQTD	NETnQTD
n quarters ago	nQA	BALnQA	NETnQA
n quarters ago to date*	nQATD	BALnQATD	NETnQATD
Preceding quarter (3 prds*)	PQ	BALPQ	NETPQ*
Preceding qrtr. n prd. ago	PQnPA	BALPQnPA	NETPQnPA
Half year balance and net chg.
Current half year (to end)	S	BALS	NETS
Current half year to date	STD	BALSTD	NETSTD
Last half year	LS	BALLS	NETLS
Last half year to date	LSTD	BALLSTD	NETLSTD
nth half year	nS	BALnS	NETnS
nth half year to date*	nSTD	BALnSTD	NETnSTD
n half years ago	nSA	BALnSA	NETnSA
n half years ago to date*	nSATD	BALnSATD	NETnSATD
Preceding half yr (6 prds*)	PS	BALPS	NETPS
Preceding half yr. n prd ago	PSnPA	BALPSnPA	NETPSnPA
Total year balance and net chg.
Total year	Y	BALY	NETY
Year to date	YTD	BALYTD	NETYTD
Preceding yr (12 or 13 prds)	PY	BALPY	NETPY
Preceding year. n prd. ago	PYnPA	BALPYnPA	NETPYnPA
Beginning of year.	OPEN	BALOPEN
End of year*	CLOSE	BALCLOSE	NETCLOSE
Period 14 adjustments	ADJ		NETADJ*

Figures are computed relative to the report period

All fiscal set field values are computed relative to the fiscal period set for the report, except for BALOPEN, NETADJ, BALCLOSE, NETCLOSE, and fields referencing a specific time period.

BALOPEN is the opening balance of the account for the year,

NETADJ is the amount posted to the adjustment period,

BALCLOSE is the closing balance of the account, and

NETCLOSE is the amount posted to the closing period.

References to future periods return zeros as if the transactions had not yet been posted.

Fiscal Set Prefix

Code	Fiscal Set
Blank	Defaults to report setting -- either actual or provisionally-posted amounts
A	Actual monetary figures
P	Provisionally-posted monetary figures
Q	Quantities (either actual or provisional depending on the report setting)
QA	Posted quantities
QP	Provisionally-posted quantities
1,2,3,4,5	Budget sets 1*,2*,3*,4*, and 5*
R	To retrieve the rollup amount. The R must be the first character and can be used in conjunction with other prefixes.

*Budget sets 1 and 2 are available if you are using the Sage ERP Accpac 100 edition; budget sets 1, 2, and 3 are available in the 200 edition, while all five budget sets are available in the 500 edition.

For FRTRN, FRTRNA, FRTRNCR, and FRTRNDR commands, the fiscal set designators available are A, Q, and QA.

Fiscal Year Suffix

The fiscal year suffix is the last part of the field name parameter, and is separated from the field name by a period. For example, in the following formula, "ABALP" is the actual current balance, and "2008" is the fiscal year suffix.

FRAMT("ABALP.2008","1000%","(ACCTTYPE="B")")

Code	Fiscal Set
Blank	Defaults to current year
2008, 2009, etc.	Specific year identification
L1, L2, L3 etc.	Last year, the year before, etc.
N1, N2, etc.	Next year, the year after next, etc.

References to non-existent data will return "#ERROR."

Currency Code and Currency Type

The currency code reference has two parts: currency code and currency type, which are separated by a period. For example, in the following formula, "DEM" is the currency code, and "R" is the type (reporting currency).

FRAMT("PBALP.L1","1000-33-248"; "DEM.S")

Currency Code	Fiscal Set
Blank	Defaults to functional (home) currency
xxx	A three character currency code (such as CAD for Canadian dollars, USD for US dollars).

Currency Type	Fiscal Set
Blank	Defaults to home (functional) currency
S	Source currency
E	Equivalent amount in the functional currency
F	Functional currency total (including functional equivalents of all source amounts)
R	Reporting currency (only available if you selected the euro as your functional currency and specified a reporting currency in the Company Profile form in Common Services)

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

FR

FRAMT

FRAMTA

FRCREDIT

FRFISCAL

FRPOST

FRRATE

FRSDESC

FRTRN

FRTRNA

FRTRNCR

FRTRNDR