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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Date formula error in Finance reports in version 27.0

(7) ShareShare
ReportReport
Posted on by 34
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 (2)
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,732 Super User 2026 Season 1 on at
  • Verified answer
    OussamaSabbouh Profile Picture
    12,808 Super User 2026 Season 1 on at
    Hello Cristian,
     
    Valid formulas like -1FY suddenly fail even though they worked in 25.5.
    Changing language doesn’t fix preview.
    Nothing in your setup is wrong — Microsoft needs to patch it.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    David Moline Profile Picture
    2 on at
    Cristian, a mi también me dio ese error. 
    Al final, y a través de Copilot, he encontrado la solución, y es sustituir 1[FY] por 1P, y -1[FY] por -1P.

    Espero que te funcione.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans