Altova Work in Process XBRL Add-in for Excel, Version 2023

Validating Data

Home Prev Top Next

Validation ensures that the XBRL data you are filing conforms to the XBRL specification. It is essential that you validate your report data before exporting it. To validate data, click the Validate button in the add-in tab of the Excel ribbon. When the validation of the instance finishes, a validation report similar to the one below is displayed.

 

When the validation fails, the Validation Report window may display links to the cell where the error occurred. To quickly find a cell with the error, click the underlined text, and the cursor will be positioned automatically on the required cell. Note that there are cases where multiple cells are involved in a single validation check. In such cases, clicking on the error link will select one of the affected cells.

inc-xa-wip-validate2

 

Validation results

The validation result can contain any of the following validation messages:

 

Message type

Meaning

_ic_status_ok

The instance data is valid.

_ic_validator_warning

The instance data is valid but has inconsistencies or warnings.

_ic_status_error

The instance data is not valid.

 

Information messages, warnings, and errors

The Validation Report dialog box may additionally display any of the following message types: information messages, warnings, and errors.

 

Message type

Meaning

_ic_validator_info

This is an information message. Information messages do not make the XBRL instance invalid.

_ic_validator_warning

This is a warning message or an inconsistency. Warnings and inconsistencies do not make the XBRL instance invalid.

 

In some cases, you may choose to ignore inconsistency messages. As stated in the XBRL US Work In Process Taxonomy 2016 Preparers Guide, some validation messages may be ignored under certain circumstances (see the section Calculation).

_ic_validator_error

Indicates an error. If there are validation errors, the XBRL instance is not valid. In this case, you will need to edit the report data to correct each error before exporting to XBRL.

 

During validation, the add-in checks XBRL formula assertions and reports them as errors. If you are using Altova RaptorXML+XBRL Server for validation, XBRL formula assertions may be optionally configured not to be reported as errors.

 

Note:By default, the add-in treats invalid cell values as errors. If necessary, you can configure the add-in to treat invalid cell values as warnings instead. For more information, see .

 

Copy, save, clear

To copy the contents of the validation report to the clipboard, click _ic_addin_valrep_copy and paste it into a target file (e.g., an email). Alternatively, right-click inside the Validation Report window and select Copy All Messages from the context menu.

To save the validation report as text or HTML, click _ic_addin_valrep_save. Alternatively, right-click inside the Validation Report window and select Save Validation Report from the context menu.

To clear the validation report, click _ic_addin_valrep_delete. Alternatively, right-click inside the Validation Report window and select Clear from the context menu.

 

© 2016-2022 Altova GmbH