Skip to main content

Notifications

Announcements

No record found.

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

How to get current year data into a monthly income statement

(0) ShareShare
ReportReport
Posted on by 10

I have  tried everything I have read on this topic and nothing brings in current monthly data, only prior year.

I've tried FY[1] FY[2] routine,  I've tried -1P  -2P  all it does is bring in prior year...  how do you get the program to show current year data?

There must be a way.....    And you can't use CP, you get an error message.

pastedimage1684512854302v1.png

The above gave me Dec as period -1P and Nov as -2P and so forth all of prior year.

  • Lynn G. Profile Picture
    Lynn G. 10 on at
    RE: How to get current year data into a monthly income statement

    I closed the last year correctly and am in the new accounting year (2023) yet it keeps giving me last year's data.

    So far no one seems to be able to solve this issue.  I would be glad to screen share with you to let you see it...

    it really is frustrating.

  • TWBlaisdell Profile Picture
    TWBlaisdell on at
    RE: How to get current year data into a monthly income statement

    Hello Lynn,

    Thank you for posting on the Community Forum.

    Did you set up your Accounting Periods by creating the New Fiscal Year for January 1, 2023 through December 31, 2023? 

    That is the one thing I can think of that may lead to challenges here. To report on a period, the Period must be defined in the Accounting Periods Table.

    I hope this helps.

    Thank you!

    Tom

  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,440 Super User 2024 Season 2 on at
    RE: How to get current year data into a monthly income statement

    if you are trying to get the monthly net change, the formula doesn't seem to be correct. Try the below. It will give you net change of Jan, feb, mar, and apr. of 2023. FY means current financial year 

    pastedimage1684528806968v1.png

  • Jun Wang Profile Picture
    Jun Wang 7,440 Super User 2024 Season 2 on at
    RE: How to get current year data into a monthly income statement

    what do you try to achieve using -4p, -3p, -2p, -1p?

    from the title, it seems you want to get the monthly income, so I guess you need net change of income Jan, Feb, Mar, Apr of 2023?

  • Lynn G. Profile Picture
    Lynn G. 10 on at
    RE: How to get current year data into a monthly income statement

    Yes.  I set the date filter in the print from 1/1/2023 to 4/30/2023

    Sent you a screen shot via email

  • Jun Wang Profile Picture
    Jun Wang 7,440 Super User 2024 Season 2 on at
    RE: How to get current year data into a monthly income statement

    did you check if the date filter is correct ?

    pastedimage1684518587987v1.png

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans