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
- How to create a preparer start time
- Task Generation
- Administrative tasks
- Release notes
- Maintenance Schedule
- Support Alerts
Calendars and Workdays
Modified on Fri, 12 May 2023 at 02:09 PM
Calendars in System manager are most typically used to calculate workdays and periods. For example, if you want to calculate how many work days or hours a journal has been waiting for approval.
You can set up a calendar in Aico and then use a formula which references that calendar when calculating workdays or hours. The calendar can be marked with holiday days which are then skipped in the calculation as well as setting a working day in hours, such as 09:00 - 17:00 CET.
If you are using a non-calendar period, for example, the 4,4,5 periods, then the Aico calendar is used to set non-calendar start and end dates to each period in order to set correct periods for associated posting dates.
Note that calendars in System manager are completely independent of holiday calendars in Automation manager which are used to calculate due dates and times for tasks.
This article looks at:
How to set up a calendar using value sets.
Set up an Aico calendar using a Value set type "Calendar"
1. Value Sets
2. Create New
In the details view, give your calendar a name, set the type as calendar and enter the time zone and office hours (if required) and Save.
Time zones can be found here. Examples include "W. Europe Standard Time", "Central Europe Standard Time", "Eastern Standard Time", "Central Standard Time", "FLE Standard Time" and "GMT Standard Time".
The resulting calendar will look as follows:
Marking holidays and period start and end dates
By default, all weekends are marked as holidays.
Click on a date and a dialogue box will allow you to set that day as a holiday, workday or period start or end date.
These are then used (together with the working hours) in the formulas below.
Period Start and Period End are only needed if you are using a non-calendar period which can both be for a fiscal year. For example, if a fiscal year starts on 1st April and runs to 31st March in which case April is Period 1 and March is Period 12. You may have periods which do not follow the exact calendar days e.g. period 4 start on Monday 4th April and ends on Sunday 2nd May.
Using formula together with the calendar.
Here, we will cover some common examples in which formulas and calendars are used together.
Calculating the number of workdays a document has been waiting for approval.
=IF(approvedAt=NULL(),CALENDARDIF(createdAt,NOW,"D","Holiday Calendar"),CALENDARDIF(createdAt,approvedAt,"D","Holiday Calendar"))
This formula first checks to see if the approvedAt date header is set, if not then it calculates the difference in days between "Now" and when the document was sent for approval (createdAt) based on the Holiday Calendar. If the approvedAt date is set meaning the date the document was approved then it will set the difference in days between the createdAt and approvedAt headers based on the Holiday Calendar. The formula will exclude any days you have marked as holidays.
Calculating a period from a posting date when using a non-standard calendar
=PERIOD(accountingDate, "Holiday Calendar")
This formula will return the period e.g. 2022-12 from an accounting (posting) date of a document (journal). If you have set the period start in the holiday calendar as 3rd December then a document posted on 2nd December will return a period 2022-11 whereas a document posted on 3rd December will return 2022-12.
Calculating a real date for a workday e.g. what "real" date is workday 5 of the period
=WORKDAY(5, period, "Holiday Calendar")
This formula will return the 5th workday of the period set in the period header based on the Holiday Calendar i.e. if the period is set as 2022-12, it returns 7th December 2022 as the 3rd and 4th are a Saturday and Sunday so are skipped in the formula.
This formula returns next month’s 5th workday of the next period set in the period header based on the Holiday Calendar. The DATEADD part is adding 1 month to the current period.
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