Using the Include section of the Financial Statement Designer
You can include the following four options when printing financial statements from the G/L Financial Statement Designer (click FR on the menu bar, then select FR View):
Report Options and Drilldown Information can also be selected when you open the G/L Print Financial Statements form from the Financial Reporter folder (in General Ledger on the Sage ERP Accpac desktop).
Note: To select Drilldown Information, you must first choose File or E-Mail in the Print Destination area of the form.
The recipient of an e-mailed report must be using the same database, with G/L installed, if they expect to drill down to underlying transactions in the report.
Report Options
When you chose Report Options in the Include section, the first page of the report displays the following:
-
Statement name
-
Fiscal year and period
-
Report type (actual or provisional)
-
Account processing and sorting order
-
Account selection ranges
This is what the options page looks like on the report:
|
Company: |
Sample Company Ltd. |
|
Date: |
11/22/2010 4:41:58 |
|
Financial Statement: |
quikbal1.xls |
|
|
|
|
Report Options: |
|
|
Year: |
2010 |
|
Period: |
6 |
|
Report Type: |
Actual |
|
Report As: |
Consolidated |
|
Sort by: |
Account Number |
|
From Account |
[1000] |
|
To Account |
[ZZZZZZZZZZZZ] |
|
|
|
|
Account Selections: |
|
|
From Account Group |
[ ] |
|
To Account Group |
[ZZZZZZZZZZZZ] |
|
From Account |
[ ] |
|
To Account |
[ZZZZ ] - Consolidated |
|
From Division |
[ ] |
|
To Division |
[ZZZ ] - Consolidated |
|
From Region |
[ ] |
|
To Region |
[ZZ] - Consolidated |
Audit Information
This option is available only when using FR View in the Financial Report Designer. When you choose Audit Information, FR View lists the information from the control information columns of the spreadsheet (columns A through D), as well as the report columns that are usually printed.
Formulas
This option is also only available when you use FR View in the Financial Statement Designer.
Usually, when you generate a report from a financial report specification, the Financial Reporter performs database lookups and inserts balances and net amounts from the database into the generated financial report.
However, if you choose Formulas, the Financial Reporter will create a financial report from the specification with a formula for each general ledger balance or net that appears in the final report.
You can then update that financial report with current database values by recalculating the spreadsheet (pressing F9). Manual calculation is set in Excel.
Hint:To keep the hot-linked spreadsheet, save the file under another name, then remove the report specification from the renamed spreadsheet.
Financial Reporter automatically refreshes General Ledger data the next time you load the hot-linked spreadsheet in the Financial Statement Designer. The sheet will also be recalculated and printed if you choose the Print Financial Statements icon.
If you want to change the report, for example, add new accounts in the chart, you need to regenerate the report to have the changes incorporated in your statement.
Note:Spreadsheets with formulas are much larger than standard report specifications — and they are less flexible.
Keep financial ratios in a formula sheet
The most common type of report that is composed only of formulas is one that keeps financial ratios.
DRILLDOWN INFORMATION
You can include a DrillDown link in a spreadsheet, when using the transaction functions: FRTRN, FRTRNA, FRTRNCR, FRTRNDR.
NOTE: A spreadsheet containing a large number of drilldown link comments may not be able to open in FR Excel nor in the regular Excel program.
See also