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,320 Moderator on at

Like (0)

Report
Copy link

Link copied!

In which field are you putting these values?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,242 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,817 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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