Check with Sage Support as 2024 FR related hot fix were released.

Thank you, Krishneil, for your prompt and awesome reply. I did locate the hotfix .dll file. This solved half the problem. The suppress zero issue is solved but unfortunately the #Value errors persist. I did not locate another hotfix to address this.

As mentioned, the formulas are  just working on variances between years (numbers that FR is pulling correctly). The simple E5-C5 calculation returns #value.

The date on the hotfix is pretty recent. Is it possible that Sage does not know about this issue and that this is a new bug?

Any additional help here is much appreciated.

Michael

Thank you, Krishneil, for your prompt and awesome reply. I did locate the hotfix .dll file. This solved half the problem. The suppress zero issue is solved but unfortunately the #Value errors persist. I did not locate another hotfix to address this.

As mentioned, the formulas are  just working on variances between years (numbers that FR is pulling correctly). The simple E5-C5 calculation returns #value.

The date on the hotfix is pretty recent. Is it possible that Sage does not know about this issue and that this is a new bug?

Any additional help here is much appreciated.

Michael

Did you reach out to sage support or your business partner to  raise with sage support team for a resolution.

I reached out to Sage directly to avoid the VAR getting in the middle. No resolution yet. I was asked to upgrade from 2024 PU3 to 2024 PU8 but that is a lot of work when there is no guarantee that this will actually work. As far as I know there is no documented issue with this that the upgrade will fix for sure. The previous hotfix was a single DLL file. I am thinking that I should be able to get a single DLL file to fix this. If 2024 is a supported version, upgrading should not be necessary at this time.