Missing Historical Rate Average (HA)

I have a client that recently migrated his Financial Consolidation model to v12 and was using the historical rate average (HA) type for certain account codes within other reserves.

However, we've noticed that HA no longer exists as an option in v12 and using just H calculates the wrong rate because it is based on closing rate rather than average rate for periodic movements.

Is there another way to achieve the same result? Or am I looking at creating my own bespoke APE script to restore the lost functionality?!!!

Find more posts tagged with

Infor EPM Discussions

Comments

mark-raynham

I think I've found what the alternative is but it is not very pretty or very convenient.

I changed the rate type to HS and then when running "Mass Adopt", I had to change the equity schedule codes to use average rate.

However, this only got my 75% of the way there.

I then had to manually add the historical rate in for the opening balance schedule.

This is a massive inconvenience in v12 compared to v11 where all the user had to do was click the "Automatic" option and change nothing in that popup box. Now the user will have to change all the equity schedule codes to "A" and then manually copy the opening balance rate from period 12 of the prior financial year.

Legacy Contributor

Also for the opening balance schedule you can use the mass adopt. There you check in the section period type "base period". This will copy the previous year historical rate to the opening balance element. But if you simply want one automation button you have to create your own APE script.

2011-10-27_CH-Stammtisch_2.pdf

mark-raynham

Unfortunately for my client (who needs this functionality back urgently) using the mass adopt functionality doesn't quite work because by changing the accounts to use "HS" then it requires the base period to have rates entered for each schedule code. That task in itself is time consuming.

For now my client will have to manually calculate and enter the rates but I have also raised this with Infor support/development to understand why this functionality was removed and are there any plans to reinstate it.

Otherwise, as you said, I'll have to create the functionality using an APE script and it'll be another step for my client to execute (which isn't a good UX).

Adolf Staudigl

Have you already created an enhancement request? If so, we can ask all customers to endorse it, which will give our product management an idea of the priority.

Copyright © 2025 Infor. All rights reserved.