Comparison of ACCPAC Plus and Sage ERP Accpac Specification Codes

The following set of charts lists all of the ACCPAC Plus for DOS Financial Reporter codes that extract data from the General Ledger accounts, and provides the equivalent codes in the Windows version of the Financial Reporter.

You may find these charts useful when checking financial report specifications that have been converted to the Sage ERP Accpac format.

Net change in balance during:

	DOS	Windows
Selected fiscal period	M	NETP
Selected quarter to date	Q	NETQ
Selected half year to date	S	NETS
Selected year to date	Y	NETYTD
nth fiscal period of current year	nM	NETnP
nth quarter of current year	nQ	NETnQ
nth half of current year	nS	NETnS
Last (previous) fiscal period	LM	NETLP
Last quarter	LQ	NETLQ
Last half year	LS	NETLS
Last year (total year)	LY	NETY.L1
Preceding quarter (3 periods)	PQ	NETPQ
Preceding half year (6 periods)	PS	NETPS
Preceding year (12 or 13 periods)	PY	NETPY

Net change in balance last year:

	DOS	Windows
nth fiscal period	LYnM	NETnP.L1
nth quarter	LYnQ	NETnQ.L1
nth half year	LYnS	NETnS.L1
Previous period last year	LYLM	NETLP.L1
Previous quarter last year	LYLQ	NETLQ.L1
Previous half year last year	LYLS	NETLS.L1
Preceding quarter last year	LYPQ	NETPQ.L1
Preceding 6 periods last year	LYPS	NETPS.L1

Net change in balance to date, relative to report date:

	DOS	Windows
nth half year to date	nSS	NETnSTD
nth quarter to date	nQQ	NETnQTD
Same period last year	LYM	NETP.L1
Same quarter last year	LYQ	NETQ.L1
Same half year last year	LYS	NETS.L1
Last year to date	LYY	NETYTD.L1
nth quarter to date last year	LYnQQ	NETnQTD.L1
nth half year to date last year	LYnSS	NETnSTD.L1

Budget net change in balance to date, relative to report date:

	DOS	Windows
Selected fiscal period	BM	1NETP
Selected quarter	BQ	1NETQ
Selected half-year	BS	1NETS
Current year	BY	1NETYTD
nth quarter	BnQQ	1NETnQTD
nth half-year	BnSS	1NETnSTD

Budget net change in balance during complete:

	DOS	Windows
Current year	B	1NETY
Last period	BLM	1NETLP
Last quarter	BLQ	1NETLQ
Last half year	BLS	1NETLS
Preceding quarter	BPQ	1NETPQ
Preceding half year	BPS	1NETPS
nth period	BnM	1NETnP
nth quarter	BnQ	1NETnQ
nth half year	BnS	1NETnS

Account balance as of:

	DOS	Windows
Selected fiscal period	BAL	BALP
Beginning of selected period	BAL-M	BALLP
n periods ago	BAL-nM	BALnPA
Beginning of selected quarter	BAL-Q	BALLQ
Beginning of selected half year	BAL-S	BALLS
3 periods ago	BAL-PQ	BALP-NETPQ
6 periods ago	BAL-PS	BALP-NETPS
12 or 13 periods ago	BAL-PY	BALP-NETPY
Opening balance previous year	O	BALOPEN.L1

As with the DOS version of the Financial Reporter, all balances or nets are computed relative to the fiscal period set for the report, except for BALOPEN, NETADJ, BALCLOSE, NETCLOSE, and fields referencing a specific time period.

Fiscal Set Prefix

The codes listed in the chart above provide access to actual data and budget data only. However, Sage ERP Accpac can store more financial data than listed above.

The next table lists the prefixes you can add to specification codes to gain access to the various fiscal sets provided.

Fiscal set designator

Code	Fiscal Set
Blank	Defaults to report setting
A	Actual
P	Provisional
Q	Quantities
QA	Actual Quantities
QP	Provisional Quantities
1,2,3,4,5	Budget sets 1,2,3,4, and 5

For example:

NETP Net amount for the current period (provisional or actual, depending on the report setting).

ANETP Actual net amount for the current period

QNETP Net quantity for the current period (provisional or actual, depending on the report setting)

NETR Net amount for the current period in the reporting currency (provisional or actual, depending on the report setting).

1NETP Budget set 1 amount for the current period

2NETP Budget set 2 amount for the current period

Fiscal Year Suffix

Sage ERP Accpac lets you enter codes for specific years or use codes relative to the current year. Years are identified by the following suffixes.

Fiscal year

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

For example:

NETP Actual net amount for the current period

NETP.L1 Actual net amount for this period last year

NETP.1996 Actual net amount for this period in 1996

1NETP.N1 Budget set 1 amount for this period next year

For more help on Financial Reporter functions, choose one of these key words:

 

Financial Reporter functions

Fiscal Set Field Names

FR

FRAMT

FRAMTA

FRCREDIT

FRDEBIT

FRFISCAL

FRPOST

FRRATE

FRSDESC

FRTRN

FRTRNA

FRTRNCR

FRTRNDR

See also

 

Differences Between ACCPAC Plus for DOS and Sage ERP Accpac Financial Reporters