Validation of Excel send formulas

When data is transmitted to AARO, a dialog box appears informing the user whether the data has been successfully transmitted.

If data cannot be sent from Excel to AARO, a dialog box appears showing validation errors. The content of this dialog box will depend on the errors returned from the AARO application.

When you send data to AARO, the information is grouped by period/company combinations. It is recommended that one period/company combination does not contain more than 10000 entries when sending to AARO.

If you get a validation error, all of the records against the period/company combination in the error message do not get sent.

For data to be sent successfully to AARO, these errors must be fixed before the process of sending data is completed.

An example below contains validation error: