Small and medium business | Business Central, N...

Problems with the preparation of financial reports

(0) Share

Report

Posted on by Community member

Unfortunately, I cannot solve a problem with the design of the column setting of a report.

My plan is to have a report with the months (January - December) in the horizontal columns.

Our Instand is set to /German/. Unfortunately, the formulas given do not work:
- M1 (the first month of the current year).
- J1 (the first month of the current year)
- FY1
- FY[1]

Strangely, the command /p1/ (period 1) does not work.

How can I address the individual months from January to December?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

NAV_with_Narang 2,294 Moderator on at

Like (0)

Report

In which field are you putting these values?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,321 Super User 2025 Season 2 on at

Like (0)

Report

Hi, First you need to display the following field (Comparison Period Formula) on the page.

Then, just use FY[x]. For example,

Done

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
KasparsSemjonovs 4,762 Super User 2025 Season 2 on at

Like (0)

Report

Also make sure that Accounting periods are set up in your company. those shortcuts P1, FY[1] will not work if there are no accounting periods.

Was this reply helpful? Yes No