Extend the number of future years

bradley.sisson

For the purpose of calculating lease contracts in IFRS 16 it's sometimes needed to have wide time ranges in the model. Currently, the amount of future years is limited up to 50 years and past years up to 20 years (link). This means you have a maximum time range of 70 years. We experience that some lease contracts extend 70 years and therefor require a wider time range to do certain calculations without work arounds. It would be succesfully solved if time ranges are either unlimited or extended up to a maximum of 100 future and past years.

matt.brady

Great suggestion!

---

@bradley.sisson wrote:

There is already an "Idea" out there called Relabel the time dimension; however, it's a little complex given Time doesn't contain properties, etc.  Majority of our retail customers use different types of calendars so it's important to distinguish the calendar type by allowing aliases on time so it's customizable to their business.  For example, when NIKE sees FY they think Fiscal Years and in Quarters.  When they see BY they think Business Year and in Seasons.  Two completely different meanings based on the calendars (see below for example) and their aliases / labels.  

 

Fiscal Year (FY19) - July - June = Financial Calendar
Q1-19 - July August September
Q2-19 - October November December
Q3-19 - January February March
Q4-19 - April May June

 

Business Year (BY18) - January - December = Planning Calendar
SP-18 - January February March
SU-18 - April May June
FA-18 - July August September
HO-18 - October November December

 

All we're asking for is an Alias Tab on Time that could be manually maintained to create the necessary aliases.  The time-based calc functions and the YTD/YTG functionality would still work as intended because it would be reading the current time-based structure.  Below is an example:

 

Current	Alias
Jan 18	Jan 18
Feb 18	Feb 18
Mar 18	Mar 18
Q1 FY18	SP 18
Apr 18	Apr 18
May 18	May 18
Jun 18	Jun 18
Q2 FY18	SU 18
Jul 18	Jul 18
Aug 18	Aug 18
Sep 18	Sep 18
Q3 FY18	FA 18
Oct 18	Oct 18
Nov 18	Nov 18
Dec 18	Dec 18
Q4 FY18	HO 18
FY18	BY18

---