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

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to get Current Mon...
Small and medium business | Business Central, N...
Suggested Answer

How to get Current Monthly Data in Account Schedules

(0) ShareShare
ReportReport
Posted on by Nathanp 12

I have created the Accounting Schedule Column Layout according to all the instructions available but still do not get the correct current monthly data to show on an Income Statement.   Dynamics365 does not accept the formula "CY" or any formula containing the "C" for Current in the Comparison Period Formula column.  The only formula it accepts is "FY" but that seems to return the LAST Fiscal Year data instead of the Current year data.  Below is my Column Layout:    Can anyone advise on how to get current month-to-month data to show?

pastedimage1619545487940v1.png

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello,

    There is no need to enter a CY as you have created a 12 month Net Change column layout, for the Fiscal (Accounting) Year. In my case, if I run the Account Schedule it will show me January thru Dec 2021:

    pastedimage1619547759936v1.png

    Are you looking for the report to be more Current Period, CP -1, CP -2, etc... This one shows the Current Period in the left column and each period in the past. Like a Running 12 month column layout.

    pastedimage1619547904991v2.png

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    Lynn G. Profile Picture
    Lynn G. 10 on at

    I tried using the the -1P and -2P and that didn't work either.

    The -1P gave me December of the prior year and -2P gave me November of prior year and so forth.

    Its still all prior year not current year.

    Does anyone else have an answer to getting current year monthly data into a monthly income statement?

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,334 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,717 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,470

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans