ADFS Designer

Advanced Financial Statements (ADFS) allow complete customization of financial presentations with control over both rows and columns. Each Gravity statement allows user selection of entities to be included.

Columns are used to filter financial information by date range, entity, and segment or dimensions. This allows the selection of filters going left to right across the report.

Rows are used to define the top to bottom presentation of financial information primarily based on GL Account numbers.

Access the ADFS report designer from the reports menu. From the designer menu you can edit or create new reports.

The report designer is made up of 4 main sections (Note: the report preview is not used)

Choosing either icon displays an advanced reporting screen. A report action menu controls how reports are handled.

Use these functions to save the results of the report layout under an existing or new name. The report name is defined in the upper right corner.

Use the run report option to run the existing report format in a new window as a complete report with report headers and labels. A report can also be run from the ADFS report portal by clicking on the report name.

Clicking on the add column option adds a new column to the report following the last previously defined column.

Use the delete option to delete the report format. All aspects of the report will be deleted except row definitions that have been saved.

This option is not used

Use this date to define how the report columns are referenced using relative dates. For example a column with "This Year" will be defined as the beginning of the fiscal year to the Run Report as of date. Column options like this month and this year use this date to determine column contents.

Report run date can be selected in the ADFS portal when selecting the report.

The companies selected in this field will be used to validate accounts used in the rows. It is often a good practice to select all companies here so any account can be included in a row selection.

Select from No Rounding to Whole Dollars, Hundreds or Thousands. Report numbers are automatically rounded as defined.

By default, when all numbers in a row are zero, the row is not printed. To view zero value rows on the report, check this option.

Upon selection, the completed report will provide the option to download a report containing the list of missing accounts. The exception report displays the accounts that are missing between the first and last account used. This report can be useful in identifying any newly added accounts that have not been included in the main report.

If select the left most column of the report will show the account numbers as defined in the report rows.

Use this field to control the width of the report row descriptions.

Enter header and footer labels to print on the report. The labels will print left, center or right on the report header or footer. Enter static text using report slugs as follows:

When creating reports you have the option of creating report parameters that allow users to select certain information at run time. This avoids having to create multiple reports to allow for different entities or dates.

Report Parameters can be created for:

To create a parameter, in the selected dialog you can identify the new parameter requirement. A new dialog will allow you to create a parameter name that can be used in the existing column or in another column.

For example a date parameter called "Quarter" can be created and used in multiple columns.

Parameters are maintained under the Parameters button on the report definition screen.

Each column is defined as C# where the # equals the column number. Column names are used in column calculations.

Enter column header labels to print when the report is run. The labels print above the columns when the report is run. Enter static text using report slugs as follows:

Each column can have a defined width. The width is measured in pixels. You can adjust the width for report formatting.

To include on a percentage of  the column's values in your report, you can enter it here. Example 30 will include 30% of the column values in the report.

Each column can be defined to show values or a calculation.

Calculation examples:

Addition/Subtraction - C1+C2+C3 or C1 + C2 - C3

Percentage of Sales - C3%90 (Calculate percentages for column C3, use row 90 as the Total Income divisor)

 Select the column time frame for reporting. Time frames can be set as relative or absolute.

A relative time frame uses the report date as its reference. For example, Month-1 would be the prior month to the report date. Absolute dates are fixed start and end dates. Choose custom dates - open the start and end date options.

 Options:

You can select one or more entities to be included in the column. Alternatively  Entity Group can be selected  or a runtime company parameter (See 11 below).

You can select the the entities home currency or the the organizations consolidation currency.

A column can be defined as an actual number or budget number for the column period. If budgets are selected, the budget selection field opens to allow selection of the appropriate budget.

Each column can optionally have a segment filter or a dimension filter. If no filter is selected, the value will be calculated exclusively from the row value.

When a row is selected to show a currency symbol it will be reflected in each column unless it is overwritten. Options:

The column will not print on the report but can be used in calculation.

If selected no entity will be embedded in the column. The Company Parameter definition will be inserted and used to select the company a

A group of rows can be saved as a row definition. Row definitions can be loaded into new or existing report definitions.

Tip: Row layouts can take time to define. Saving the row definitions for re-use can save significant time in creating other reports.

Row definitions are independent of the reports layout. A row definition can be loaded into a report and then edited with out changing the underlying definition

Rows can be added by selecting the add row at the top row control, or by right clicking on an existing row.

Right clicking on a row allows you to add a row above or below the existing row. An existing row can be edited by right clicking on it, or by highlighting the row and clicking on the left edit icon.

To delete a row, right click on the row and choose the delete option or by highlighting the row and clicking on the left delete icon.

Using the ADD MULTIPLE option you can add multiple accounts at one time, saving time in building templates.

Use load existing row definition to search for and insert an existing row definition. When completing a row definition use save row definitions to name and save the definition for future use.

Gravity automatically maintains row numbers as rows are added or deleted. Row numbers are used in Calculation and Total rows.

Use row type to define how the row is used in the report. Select the type from the field's drop down list.

Account-Account Range (Example)

Depending on the type selected additional fields may be displayed to define additional controls. In this example, the account row type has been selected. Account row type fields are described below:

Description- Label - Print this label only. No numbers print in this row.       

Retained Earnings- Using this row type prints the value of retained earnings. Use this option for Balance Sheet reports.

Current Earnings- Using this row type prints the value of Current Earnings. Use this option for creating Balance Sheet reports.

Underscore- Using this row type prints a single underscore on all the report columns.

Double Underscore- Using this row type prints a double underscore on all the report columns.   

Total- Using this row type allows the calculations on row values. Options are:

Calculations

A calculating row can be used to create complex calculations. To use a row in a calculation it wan have an "R" then the row number. For Example calculating Gross Marin would look like:

R100/R40*100 - Row 100 divided by R 60 time 100

One of the most powerful properties of the advanced financial statements is the ability to use filters to determine row values.

Wild Cards

* = whole segment filter  ? = character filter. The "-" is used to define the segment structure

Row and Column filters can be combined to create complex reports. Column filters override row filters. Column filters do not override full account values.

Syntax = XXXX-XXXX-* Where X is a character or ? wild card, "-" is the segment definition and "*" is the segment wild card.

Examples:

 Is Row Expandable

Selecting this option on a row allow the auto expansion of individual rows by the dimension value.

This is useful so that each individual dimension value does not have to created as a separate row.