Specifying Information for One Cell
The Financial Reporter lets you insert account record information or fiscal set values anywhere on a financial statement using special spreadsheet functions.
Account information
For example:
FRACCT("ACCTDESC","1000-333")
gets the account description (for example, "Cost of goods sold") from account 1000-333 and places it in the current cell.
FRAMT("ABALP.1998","1000-333")
gets the actual balance of account 1000-333 for the current fiscal period for the year 1998.
Note that the easiest way to enter Sage ERP Accpac financial functions is to use FR Paste.
Specifying the fiscal set
You can specify "PBALP" for provisional balance, "QABALP" for actual quantity, "QPBALP" for provisional quantity, or (in Sage ERP Accpac 500) the numbers 2 to 5 for the budget sets (for example, 1BALP or 2BALP). For Sage ERP Accpac 100, you can specify budget sets 1 and 2; for Sage ERP Accpac 200, you can specify budget sets 1, 2, and 3.
If BALP is specified without an "A" or "P" prefix for actual or provisional amounts, it will default to the report setting chosen at print time.
Company information
You can also extract company information for financial reports, as in the following example:
FR("Coname")
The FR function provides company information from the currently open company, in this case, the company name, and places it in the cell.
You can create report specs that identify each item
As you can see from the previous examples, you can construct your financial statements by placing a Financial Reporter function at each point where you want to print financial information. However, this is a time-consuming and rigid way to define your statements.
A better way to create statements is to create a statement specification. In a specification, you set up default formulas for each column, then indicate the group of accounts to which the column formulas will apply.
See also