web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Account Schedule by month

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

Answered

Account Schedule by month

(0) Share

Report

Report

Posted on by hyattmjh

80

I am trying to create an income statement by month In col layouts i can create 12 columns Jan,Feb, Mar ... to hold the values and by using FY[1]. FY[2] get the correct values.

My question is, I want to be able to use this report up to a certain month -

So for example Run this report on 12/5 up to 11/30. This means that the Dec col should show zeros even though there may have been dec transaction already posted. Currently FY[12] will ignore the date filter and show the dec transactions.

Any help would b greatly appreciated

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Happy New Year,

Yes this is true. The Date Filter will not restrict the values from appearing in future periods, regardless if your Date does not include the month. I have solved this issue by creating a report in Jet Reports.

Thanks,

Steve

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 740 Super User 2026 Season 2

#2

YUN ZHU 531 Super User 2026 Season 2

#3

Grigorios Mavrogeorgis 310 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans