In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   On Demand  |   Home  |   qad.com




Financial Report Writer
Financial Report Analysis
The new Report Tree Drill Down functionality enables you to investigate totals and balances in a financial report. You can view any report tree and drill down into the hierarchy right down to transaction level. This makes Report Tree Drill Down a powerful analysis tool.
To use Report Tree Drill Down, you must first create a view of the relevant report tree using Report Tree View Create (25.16.7.1). Each field on this screen corresponds to a dimension of the report cube.
Report Tree Drill Down
After you create a report tree view, it is available for you to drill into using Report Tree Drill Down (25.16.7.4). Each column in the Report Tree View grid corresponds to a field in Report Tree View Create. In addition to these columns, the first column in the grid—the Chart column—enables you to see the views related to a particular chart of accounts.
When you double-click the report tree view row you want to view, the tree is displayed in the Report Tree Drill Down area in the same hierarchy as in the financial report. You can then explore elements in the hierarchy step-by-step. By default, the report tree is displayed with all nodes expanded, except for the deepest level. The deepest level contains the balances as stored in the report cube.
The columns in the Report Tree Drill Down area give you a consolidated view of the report tree. To make it easier for you to organize the data, you can drag and drop the columns into different positions on the screen.
When you right-click a line in the Report Tree Drill Down area, you can display a context menu that enables you to perform a variety of operations on the report tree hierarchy. For example, you can group the data to suit your needs, drill down to transaction level, and export a snapshot of the report to Excel.
At the deepest levels in the tree, you can group the data to make totals or subtotals for any of the dimensions. When there are no totals on the tree and you right-click a line that has activity in the displayed period, you can select GL Summarized Transactions. This enables you to drill deeper than the balances displayed in the report tree hierarchy.
You can also export the whole tree to Excel. The tree is exported exactly as you have it displayed in the Report Tree Drill Down. In Excel, you can also conduct further analysis by expanding and collapsing nodes with one click.

New Programs for Financial Report Writer
 
Menu
Label
Program
25.16.7.1
Report Tree View Create
BFRWTreeView.Create
25.16.7.2
Report Tree View Modify
BFRWTreeView.Modify
25.16.7.3
Report Tree View Delete
BFRWTreeView.Delete
25.16.7.4
Report Tree Drill Down
BFRWTreeView.FRWDrillDown
Conversion to BLF
A number of Financial Report Writer screens were converted from Progress .p programs to the Business Logic Foundation framework.

New BLF Programs for Financial Report Writer
 
Menu
Label
Program
25.16.10.1
Report Analysis Code Create
BFRWAnalysisCode.Create
25.16.10.2
Report Analysis Code Modify
BFRWAnalysisCode.Modify
25.16.10.3
Report Analysis Code View
BFRWAnalysisCode.View
25.16.10.4
Report Analysis Code Delete
BFRWAnalysisCode.Delete
25.16.12.1
Report Column Group Create
BFRWColumnGroup.Create
25.16.12.2
Report Column Group Modify
BFRWColumnGroup.Modify
25.16.12.3
Report Column Group View
BFRWColumnGroup.View
25.16.12.4
Report Column Group Delete
BFRWColumnGroup.Delete
25.16.11.1
Report Master Create
BFRWReportMaster.Create
25.16.11.2
Report Master Modify
BFRWReportMaster.Modify
25.16.11.3
Report Master View
BFRWReportMaster.View
25.16.11.4
Report Master Delete
BFRWReportMaster.Delete
As a result of the conversion to BLF, the following Progress Financial Report Writer programs are obsolete in QAD 2013 EE:

Obsolete Programs for Financial Report Writer
 
Menu
Label
Program
25.16.10
Report Analysis Code Maintenance
francdmt.p
25.16.11
Report Analysis Code Browse
frbr007.p
25.16.12
Report Column Group Maintenance
frcolmt.p
25.16.15
Report Master Maintenance
frmsmt.p
Calculations using a Report Analysis Code
You can now add a calculation that references a report analysis code to a Financial Report Writer column. To do this, create a report tree that contains individual report analysis codes and a parent node that sums the child analysis codes (for example, Total Sales).
Then, create a report column group. Ensure that the first column references the actual business value (for example, sales or cost). Create a second column with a type of Calculated, specify the required formula in the Formula field, and in the Analysis Code field, specify the analysis code that is the parent node of the report tree you created (for example, Total Sales).
Finally, create a report master record that uses the new column and run the report in Financial Report Run.