Entering, Validating, and Approving Data

When a form is first created, it has the status New and is displayed in read-only mode.

Once a form is in In Progress status, Collectors can enter data manually or import it from an external source.

To import data instead of entering it manually, click More actions | Import data and choose from Excel, Consolidation & Financial Planning, or Lucanet.Financial Warehouse. See Importing Data for details.

To enter data manually:

When drill down is configured for a row or column, the cell in the main table is read-only. Its value is automatically calculated as the sum of all drill down entries. To enter or edit values, click the drill down icon () in the cell.

Drill down can be configured at row level or column level, but not both on the same pivot table. Each level can have one or two drill down levels. The following sections describe what happens when you click the drill down icon, depending on how many levels are configured.

Single-level drill down

A dialog with a table opens, showing one row per dimension element. The table contains the following columns:

Two-level drill down

A dialog with two tables stacked vertically opens:

Adding entries

Click + Add [dimension type] to open a dimension selector and add a new entry.

Deleting entries

Click the delete icon at the end of a row and confirm the deletion. When all entries are deleted, the parent cell value becomes empty.

Saving changes

Changes in the drill down modal are saved automatically when you leave a cell, for example by pressing Enter, or Tab, or by clicking elsewhere. Pressing Escape while editing a cell cancels that edit without saving. There is no Save button – close the dialog using the X button, by pressing Escape when no cell is active, or by clicking outside the dialog.

To execute validation rules, click Execute validation rules in the top right of a form. The system executes all active validation rules that apply to the form and displays a summary when complete.

After validation rules are executed, a results panel displays:

To view details for a specific rule, expand the rule row.

The expanded view can include:

Form elements referenced by failed validation rules are highlighted directly in the form.

If intercompany validation is enabled for the reporting package, Collectors can execute intercompany validation at the reporting entity level. Intercompany validation checks that transactions between related reporting entities match — for example, that the total financial amount that Reporting entity A reports against Reporting entity B must equal the total amount that Reporting entity B reports against Reporting entity A — but with opposite signs (one positive, one negative).

To execute intercompany validation, navigate to Data Collection | Data collection, and select Execute IC validation from the three-dot context menu at the end of the reporting entity row.

After intercompany validation has been completed, a second notification appears and a View IC validation results option becomes available in the context menu.

To view the results, select View IC validation results from the context menu. A results panel is displayed, showing each intercompany rule that was executed with its status:

For each rule, you can see the rule name, the difference (if any), and when the validation was last executed. You can execute all rules again at once using Execute validation again at the top of the results panel, or execute a single rule individually.