I am aware of the "start date" and "end date" arguments for the various Velixo functions, but have you guys given any thought to introducing a turnover function where you only need to provide the end date and then it calculates the beginning of the period automatically instead of having to use Excel for this.
I am from the Sage 100 and F9 world, and they used the following:
MTD or PTD (month to date) or (period to date)
QTD (quarter to date)
YTD (year to date)
Just a thought.
1 Votes
3 Comments
Sorted by
Damien Zwillingerposted
3 months ago
Admin
Hi Patrick
I can see a short-term usability solution, and medium-term ideas that we will consider.
Essentially what we want to solve here is to make it easier to generate dates, and being able to easily select and use a "Relative Time" metric, as most of our Measure functions require a Start date and an End date.
The short-term solution is something we implemented in this Acumatica Report Template but haven't yet ported to Sage Intacct (this is planned in a few days, good timing!)
It involves a list of "Relative Time" items/metrics maintained in an "Options" sheet, with Start and End date calculations for each of those items, which can then easily get looked up (XLOOKUP) and used in functions.
You could also use a Data Validation List to list them and/or reference the Relative Time metric in a hidden row (typically first rows of the sheet, same column as the report's measure).
A medium-term idea could be to productize this further, having the product generate such Relative Time list, and optionally allowing to reference the Relative Time metric in functions.
I will leave this idea open and for consideration for now, and will email you directly once we have come up with this Relative Time List for Sage Intacct!
Hope this helps. Thanks!!
0 Votes
P
Patrick Youngposted
3 months ago
Thank you for the reply and sharing.
I would add LTM (last twelve months) to the list as well.
Also, the corresponding budget functions to match.
0 Votes
N
Nasrin Jamaliposted
3 months ago
Admin
Hi Patrick,
Thank you for your suggestion. We will share this idea with our Dev team. Thanks.
1 Votes
Hello,
I am aware of the "start date" and "end date" arguments for the various Velixo functions, but have you guys given any thought to introducing a turnover function where you only need to provide the end date and then it calculates the beginning of the period automatically instead of having to use Excel for this.
I am from the Sage 100 and F9 world, and they used the following:
Just a thought.
1 Votes
3 Comments
Damien Zwillinger posted 3 months ago Admin
Hi Patrick
I can see a short-term usability solution, and medium-term ideas that we will consider.
Essentially what we want to solve here is to make it easier to generate dates, and being able to easily select and use a "Relative Time" metric, as most of our Measure functions require a Start date and an End date.
The short-term solution is something we implemented in this Acumatica Report Template but haven't yet ported to Sage Intacct (this is planned in a few days, good timing!)
It involves a list of "Relative Time" items/metrics maintained in an "Options" sheet, with Start and End date calculations for each of those items, which can then easily get looked up (XLOOKUP) and used in functions.
You could also use a Data Validation List to list them and/or reference the Relative Time metric in a hidden row (typically first rows of the sheet, same column as the report's measure).
A medium-term idea could be to productize this further, having the product generate such Relative Time list, and optionally allowing to reference the Relative Time metric in functions.
I will leave this idea open and for consideration for now, and will email you directly once we have come up with this Relative Time List for Sage Intacct!
Hope this helps. Thanks!!
0 Votes
Patrick Young posted 3 months ago
Thank you for the reply and sharing.
I would add LTM (last twelve months) to the list as well.
Also, the corresponding budget functions to match.
0 Votes
Nasrin Jamali posted 3 months ago Admin
Hi Patrick,
Thank you for your suggestion. We will share this idea with our Dev team. Thanks.
0 Votes
Login or Sign up to post a comment