Financial Reporter Functions

Sage ERP Accpac General Ledger 6.0

previous page next page

Financial Reporter Functions

Accounts in General Ledger contain two main types of data:

  • Account master information, which includes the account name, account type, and other defining information concerning the account.

  • Fiscal set values, which are balances and net amounts stored with each General Ledger account.

In the Financial Reporter functions, you gain access to this data -- and all other data in the General Ledger.

Use FR Paste to create formulas

Each of the functions described in this section can be pasted into a financial statement using the FR Paste command on the Financial Statement Designer menu bar (under the FR menu). See FR Paste.

The FR Paste command inserts a function into the current cell, and prompts you for each parameter of the function (so you don't have to memorize parameters).

Information provided by Financial Reporter functions include:

FR

G/L option & company data, and statement print options

FRACCT

account data, including optional fields

FRAMTFRAMTA ,

fiscal set data

FRCREDITFRDEBIT ,

fiscal set data

FRFISCAL

fiscal calendar dates

FRPOST

transactions detail data, including optional fields

FRRATE

exchange rates

FRSDESC

segment code descriptions

FRTRNFRTRNA ,

transactions detail data

FRTRNCRFRTRNDR ,

transactions detail data

Typographic Conventions 

This table shows the notational conventions used for functions.

UPPERCASE

Words appearing in uppercase letters are function names.

( )

Function arguments are surrounded by parentheses.

,

Function arguments are separated by a comma.

,

Optional arguments are separated by a comma.

For example, the following function illustrates each of the features defined in the table:

FRACCT(fieldname.account number)

or

FRACCT(fieldname.account number.criteria, format)

The optional criteria and format arguments are separated by commas.

Most Function Parameters are Text

Unless otherwise noted with the individual Financial Reporter functions, all function parameters are text.

This means that parameters are either:

  • In quotation marks.

Or

  • A reference to a cell that contains a text value or a text-valued formula.

Errors in Financial Reporter Functions

All Financial Reporter functions return ERROR if the parameters of the function are wrong or if the referenced values are not defined. (In other words, they display the word "ERROR" as the value of the financial reporter function.)

The FRACCT function returns a blank if the account reference is missing or the account cannot be found.

The FRAMT, FRAMTA, FRDEBIT, and FRCREDIT functions return "0" if the account reference is missing or if a specific account cannot be found.

Financial Reporter treats the hyphen like zeros for line suppression if you use the "Z" option.

previous page start next page