web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Date formula error in Finance reports in version 27.0

(1) ShareShare
ReportReport
Posted on by 12
Hi,
 
All the financial reports started giving formula errores when trying to preview them:
I've compared the configuration with a sandbox envoirement that was a backup and the configuration was the same but in the backup was working. The only difference is that the backup is in version 25.5 and the one in production was updated this week to version 2.7.
When I entered to the column definition of one of the reports when date formulas that were already written now if I try enter the same formula it gives me an error. Since FY stands for "Fiscal year" and the installation and the usual working language is Spanish i've tried also with AF but I still got the error (in the back up FY worked but AF didn't). 
 
After that i've tried changing my language and region from Spanish (international) to English (United States) and it let me enter the formula as FY without error:
 
But when launching the preview of that financial error I still got a formula error, but since the error is in Spanish it may still have errors with the language.
 
I've tested it on 27.0 'ES' installation with no extensions and I'm having the same issue. Could anyone tell me if the are having the same problem or if I'm doing something wrong with the formulas*?
*Since they were working fine until now and they are following the guidelines from here; https://learn.microsoft.com/es-es/dynamics365/business-central/bi-column-definitions I guess they are correct.
 
Regads and Thanks in advance,
 
Cristian
 
I have the same question (1)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,343

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,556 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,098 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans