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.

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

*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")")

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")

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