Getting started with Aico
- Logging into Aico for the First Time
- Creating your first journal
- Creating your first request
- Creating your first payment
- Creating your first Intercompany Invoice
- Working with Closing Tasks
Working with Journals
- An overview of Aico journals
- How to create a manual journal
- Create a journal by copying existing journals
- Import new journals from Excel
- How to import multiple journals from one Excel spreadsheet
- What are recurring journal entries?
- How to create Recurring Duplicate Journal entries
- How to create Recurring Allocation journal entries
- Create recurring journals with automatic reversals
- Reversing documents
- Import data to existing journals
- Export journals to e-binder
- Working with Reconciliations
- Basic settings in Aico documents
- Excel Support
- An overview of Aico Dashboards and Lists
- How to use lists in Aico
- How to use dashboards in Aico
- How to use charts in a dashboard
- Dashboards: Advanced Settings
- Manual closing tasks
Users and User Groups
- Overview of Users and User Groups
- Add user accounts
- Edit user account data
- Manage user groups
- Manage user roles
- Copying roles at the company level
- Copy user roles from individual users
- Create a user report
- Manage administrative user rights
- Super user mode
- Additional super user global admin rights
- User and User group export and import
- Value sets
- Currency Amount Groups
- Mail notifications
- Tax codes
- Users and User Groups
- Introducing Automation Manager
- Core Set Up
- Introducing task templates
- Creating task template details
- The Aico Document
- Aico document headers
- Preparer and Approver workflow settings
- Overriding parameters at a company level
- Master data export and import
- Set a custom schedule
- Dependent tasks in Aico
- How to use Smart tags in Aico
- How to add an attachment to a task template
- Task Generation
- Administrative tasks
- Release notes
- Maintenance Schedule
- Support Alerts
Using a group to validate header values
Modified on Wed, 21 Jun 2023 at 12:54 PM
This task will check if a numeric/decimal value in a header is above a minimum or below a maximum value. It can be set up to check against specific values, regardless of currency. Or you can link it to a currency amount group, and it will check against the value set for the given currency in the table.
The most common use case is to check the value of the unreconciled balance in an account reconciliation. If you simply want to make sure the unreconciled balance is zero, this can be set as "0" in the task.
If you want to allow a threshold for the unreconciled balance, then this requires links to currency amount groups.
This task will check if a numeric/decimal value in a header is above a minimum or below a maximum value. It is not mandatory to set both. The validation and given error will vary based on which (or both) are given.
A valid configuration can also have both minimum and maximum parameters set to the same value, which means that the header requires this specific value. Checked values can vary by currency by connecting the parameter to a currency amount group.
Set the task against the required action events, for example, Send to Approver 1, User initiated validation etc.
Set the rangeMin and rangeMax - you do not have to set both. For example, you may only want a minimum if you want to prevent users from posting journals below a certain value.
You can set a specific number, for example, rangeMin: -500, rangeMax: 500 would check for values between -500 to +500 and ignore what currency is being used. No quotes are needed around the number.
Alternatively, you can set a currency group such as rangeMin: "Reconciliation min", rangeMax: "Reconciliation max". This would then refer to these tables. Quotes are needed if you are setting a currency group name.
If you do not set a currencyCodeHeader parameter, then it will default to check the "currencyCode" header, otherwise, you can ask the task to use a different header to look for the currency.
The group table will look like this:
The final step is to connect the task to the header.
Open the header that the validation is going to check, such as unreconciledBalance
On the advanced tab go to the Validations drop-down and tick the validation task set up for each of your chosen actions
If the validation fails, the resulting document will look as follows. Where you have used a currency group the error message will show the currency otherwise it will simply show the number:
Was this article helpful?
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
We appreciate your effort and will try to fix the article