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:

Net change in balance last year:

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

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

Budget net change in balance during complete:

Account balance as of:

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

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

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