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  |   Cloud ERP  |   Home  |

  •     QAD Glossary

  • 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 ( 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 ( 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
    Report Tree View Create
    Report Tree View Modify
    Report Tree View Delete
    Report Tree Drill Down
    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
    Report Analysis Code Create
    Report Analysis Code Modify
    Report Analysis Code View
    Report Analysis Code Delete
    Report Column Group Create
    Report Column Group Modify
    Report Column Group View
    Report Column Group Delete
    Report Master Create
    Report Master Modify
    Report Master View
    Report Master 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
    Report Analysis Code Maintenance
    Report Analysis Code Browse
    Report Column Group Maintenance
    Report Master Maintenance
    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.