You need no programming skills to use the ARM for modifying existing financial reports and developing new ones, such as Balance Sheet and Income Statement. You also need no knowledge about the structure of the Acumatica ERP database.
Report designers can design and run custom analytical reports by using advanced data selection criteria, data calculation rules, and customizable report layout design features. By using the Analytical Report Manager, you can perform the following tasks:
You can use the ARM toolkit rather than Acumatica Report Designer to create the following types of reports:
To create a report in ARM, do the following:
The structure of the analytical report determines the content to be presented and its appearance. To configure the report structure, you specify the units of the report and identify the rows and columns to be displayed. You define the report headers, and the headers for the individual columns and rows or for the specific groups of columns and rows. The formatting options can be defined for the entire report and for any particular row or column. By using formatting options, you can set up the report page layout, select font attributes, and visually emphasize rows or columns in the report.
The report in the following screenshot consists of a row set, a column set, and a unit set.
For details about the particular structure elements, see Row Sets, Column Sets, and Unit Sets.
For details about the design process, see Report Structure Design.
For details about the formatting settings on every particular level, see Row Sets and Column Sets
For details about the formatting settings, see Printing Style.
Data source options specify how the data will be selected for the report. Depending on the report structure, the data source can be defined for the whole report, and different data selection criteria can be used for the rows and columns in the data source editor. For detailed information about data source elements, see Data Source and Data Source Editor
To calculate the values in the report, you use formulas. Formulas describe data transformations and other operations performed with the data selected from the data source. The formulas can use the data selected from the data source as parameters. Depending on the report structure, formulas can be defined at the unit, row, or column level.
In Formulas, you can find detailed descriptions of the formulas.
You can use a unit set to organize the report structure when the groups of rows and columns included in the report use data from different data sources. For example, a unit set can include one unit or multiple units that specify how the data is selected, calculated, and displayed in reports. In the report, you can view data for each individual unit, which could be a branch or a cost center, as well as data consolidated for all the units. To define the data that should be included in the unit set and set up the formatting for the rows and columns, you can specify the values of the units in the unit set. For details about the unit sets, see Unit Sets.
When a report is published, the users who will generate the report must be granted access rights to this report.
In Acumatica ERP, you can customize the access rights of users to work with analytical reports. You can control their access to forms and operations based on each user’s job responsibilities.
You can set up access to analytical reports by using the Access Rights by Screen (SM201020) form; on this form, you select the Site Map Location of the published report form and then select the relevant level of access for a user role in Access Rights column. For more information on access rights, see User Roles: General Information.