Integral Accounting Enterprise Help System

Report Guide

Overview

Integral Accounting Enterprise includes four types of reports:

Pre-Defined GAAP Financial Statements

There are many financial reports that are available in by clicking the "GAAP Financial Statements" link from the reports tab in the main application. Since there are so many different financial reports available (over 120 Different variations), we provide the financial statement selection screen in table format. Selecting the options that you want and clicking on the printer execute the financial report.

When a financial report is selected for execution, the system is running an ASPX Formatted Report Page against a pre-defined stored procedure to option the result. Both the ASPX Report Page and the stored procedure that drive the reports are completely customizable to meet your needs.

Pre-Defined IFRS Financial Statements

There are many financial reports that are available in by clicking the "IFRS Financial Statements" link from the reports tab in the main application. Since there are so many different financial reports available (over 120 Different variations), we provide the financial statement selection screen in table format. Selecting the options that you want and clicking on the printer execute the financial report.

Transaction Documents

Documents in the system refer to reports that usually print a single page of specific information, like an Order, and Invoice, a Purchase Order, etc. These are usually run by clicking a printer icon somewhere on a particular page. A document is typically implemented as a stand-alone ASPX program, that takes as input a document number, and outputs a formatted page for that document number. For example, to print an order, you would call the "DocOrder.aspx" page, pass it the order number, and it will display the order as a formatted aspx page that can then be printed, faxed, emailed, etc.

These are easily customizable, you can simple make a copy of the entire ASPX Page and change whatever you like very easily.

ASPX Report Engine

Integral Accounting Enterprise also includes a dynamic report generator that we call the ASPX Report Engine. This reports engine builds a report dynamically based upon a pre-defined stored procedure in the database back-end. This works as follows:

1) The user selects a report from the menu, and presses the "Get Criteria and Parameters" button.

2) If the report has parameters, the parameter table will be populated and the user can enter the information that the report needs to run.

3) The user can now select one of the three displaying options at the bottom of the window:

A) Screen - This will display the report on the screen in a browse-able data grid that supports sorting on any of the fields and paging through large amounts of data.

B) Printer - This will display the report in a format suitable for printing.

C) Excel - This will export the contents of the report directly into excel and load excel so you can work with the results immediately. Once in Excel, you can emancipate the data, export it to various formats, make charts and graphs, and save it separately. You need to have Microsoft Office 2000 or greater for this function to properly work.

D) You can also export the results to a text or xml file, and chart the results if they are numeric.

The Integral Accounting Enterprise system already includes over a hundred standard reports in ASPX Reports Engine format ready to run out of the box. Anyone that can understand simple stored procedures can customize and / or build new stored procedure report formats for use with the reports engine.

Report Design

If you need to create a new report in the system, the simplest thing to do would be to find a report in the system that is already close to want you want (This should be an easy task since there are hundreds of reports in the system), make a copy of it, make the modifications that you want, and display the result using the ASPX Report Engine. New reports in the Integral Accounting Enterprise system are this easy.